Search results for query: *

I have a workbook that contains six or seven sheets. I have a Pivot Chart on Sheet5 whose source data comes from a Pivot Table on Sheet2. I've created a button on the Pivot Chart sheet that when clicked will hide the sheet. Once clicked, I would like the Worksheet that the Pivot Chart source...

I have a UserForm which enters data into a structured table. I need to prevent duplicate records from being entered based on three criteria: date, shift and time. Ideally, the user would be prompted with a Msgbox alerting them that there is a duplicate record. They would have the option to...

I'm trying to populate a ComboBox with a named range. For example, I have a named range called currentMonth. This range contains the name of a month. I have named ranges for all of the months. So if currentMonth contains October, then the ComboBox would be populated with the named range...

Using Excel 2010, I have a table on Sheet1 with column headers: date, time, shift, manager and notes. Each day my managers enter a separate record for any issues they may have encountered throughout the day. On a separate sheet (Sheet4) I have a dynamic calendar setup. I would like to click...

I have the following formula that works as expected; however, I need to modify the formula to work for a change in the first array. Currently, A1:AE1 has dates of the month (8/1/2011, 8/2/2011, etc). C1 has a specific date. So for all dates less than or equal to the date in C1, sum the product...

I have an Excel workbook that has a has a protected worksheet whose formulas refer to a table on a separate worksheet. The problem I am encountering is that when data is added to the table, the formulas do not update to include the expanded table range. However, when the worksheet is...

I am trying to look down Column A and find all the cells whose value begins with the number two, and then sum the corresponding value in Column B. All of the values in Column A are three digit numbers. Below is the formula I am using; however, it returns a value of zero. C1 refers to a value of...

I'm stuck on what would normally seem to be a simple formula. I have a table: column A contains minimum values: 0, 2.4, 2.8, 3.8, and 4.5. Column B contains maximum values of 2.39, 2.79, 3.79, 4.49 and 5 respectively. Column C contains corresponding percentages: 0.0%, 0.0%, 2.0%, 2.5% and...

I, along with some help, put this formula together some time ago to calculate employee attendance. We use a point system, and after 90 consecutive days of perfect attendance, we remove one point. I had to add the INDEX function to allow for some special circumstances: we do not give points for...

Sometime back when I was using MS Word 2007 I had some help creating the following macro. After upgrading to Word 2010, I'm now receive the following error: "Object Variable or With Block Variable not set." Any ideas? Thanks for any help anyone can provide. -edward Option Explicit Public...

I've run into a problem using Word form fields formatted as a percentage. I have a form field that is formatted as 0.0%;(0.0%. I need for the user to be able to enter 24.5 and have the field return 24.5%. Currently, the user has to enter .245. I understand that by default Word automatically...

I have a series of Form Fields in a Word document that are formatted as numbers with the format $#,##0;($#,##0). Is it possible to make these numbers red if they are a negative value? I tried using $#,##0_);[Red]($#,##0) which is the same format used in Excel; however, it did not work. I...

I have a worksheet that has multiple ranges that have to be cleared. The ranges are non consecutive and currently have to be selected by hand and be cleared. They have a pattern: every third column and every 4th and 5th row need to be skipped. So I need to begin at cell F5 and select F5:G7...

I'm new to VBA in Word. I've used it some in Excel. I am using {REF h_date \dddd, MMMM d, yyyy} in the header of a word document to get the date from a FormField Bookmarked "h_date" in the body of the document. Once the user enters the date in the formfield, it fires off the code on exit...

I have a SUMPRODUCT formula that is working fine. I need to add another array and I can't seem to get it to work. I'm trying to sum the columns limited to a specific day of the week. For example, I need to sum all Saturdays in the range. The following formula is a working example without the...

I have the following formula that is functioning correctly: OFFSET(B2,MATCH(LARGE(OFFSET(B3,0,MATCH(A1,B2:AF2, 0)-1,1000,1),1),OFFSET(B2,0,MATCH(A1,B2:AF2,0)-1,1000,1),0)-3,MATCH(A1,B2:AF2,0)-1) The formula basically finds the date in A1 in the range B2:AF2, and then finds the largest number...

I have a several strings of text; each with a variable number of spaces at the end of the string. How can I sum these spaces within my Sub? I'm very new to VBA and haven't yet learned how all the Excel function work in VBA. Thanks for any help. -ep

I currently have two data validation list referenced against the days of the month. When the main list is changed, data within the worksheet is changed to reflect that day. I need the second list to automatically default to 7 days prior when the 1st list is changed. I still need for the user...

I often need to copy and paste values from an AS400 system. They are either positive or negative integers. However, when copying and pasting into an Excel spreadsheet they are copied as strings as opposed to numeric values. I have a macro that I've been working on, but it doesn't seem to...