Summary: Hi, As I mentioned an alternative and more specific approach is to use a Macro. The following code can be attached to a command button on your summary...
Summary: I have an extremely simple Excel spreadsheet that I use to keep track of my running. It's columns are: Date, time to run a mile, time to run 2 miles, ...
Summary: Dear Gentleperson: I have exported data -- dates in particular -- from a source that has the date format as M/D/yyyy (e.g.. 11/12/1987) as shown in th...
Summary: Hi, From your post, I thought that you were familiar with conditional formating formulas, which is why I didn't provide any instructions for using it,...
Summary: I'm thinking (guessing) the OP wanted rows deleted where a value in a specific column isn't a multiple of 300. I changed one line of Humar's excellent...
Summary: Hi, I see that you have entered your times into cells F8 and F10 using this format: 00:00:00 which is: min:sec:hundredths. Excel treats this entry as ...
Summary: I have a Parts spreadsheet that I want to be able to fill in the first column in a row, which is the part number, and then it automatically fills in t...
Summary: Hi, If this sorting by date is not done very often then I suggest using Excel's Sort function manually. For sort to work, all the data for each indivi...
Summary: Hi, You could try Excel's database functions such as DCOUNT() and DSUM() These allow you to setup various criteria (like filters) for a database and e...
Summary: I have an Excel 2007 document with values on one sheet that I need to insert into an existing Word 2007 document into different places. I would like t...
Summary: Assuming your data is already sorted so that the duplicates follow one another as in your example, try this code: What it does is check each item in c...
Summary: I have created the excel file in excel 2003 and transfered it to excel 1997 in my 2nd computer. However when i tried to save the file in excel 1997, i...
Summary: Hi Guys - Is it possible to utilise the indirect function or a means using VBA to populate the listfill range of a combobox - this is also referred to...
Summary: Hi, I need to calculate how many times 2 specific characters appear in the same cell throughout an entire spreadsheet of about 98 columns and 98 rows,...
Summary: Hey All I hear you guys are pretty good. I need help with an excell chart being imported into a word document. I inserted it as an object and ticked t...
Summary: In column A I have a list of items that all start with an A (a1 a2 a3 etc) In column B I want to use “lookup” to generate a sales report from anot...
Summary: Excel Data Validation: The following Formula will determine if the data entered into a cell (D3) is a Capital "Y". If so it will allow it, otherwise r...
Summary: I have created a spreadsheet which has a template form so that when information is added into an input sheet it links into the relevant section within...
Summary: I have a table in excel with some calculated figures. I use the function to round the figures to 2 decimal places. However, when I merge the figures...
Summary: Hey Derby! Ok, I did exactly as you specified... In column A I have the complete list of serials. In column B, I have the list with the missing data. ...
Summary: Hi, You haven't said what values are in column B, but as you are using COUNT() which counts the number of cells containing a number (Excel help states...
Summary: Here's what I want to do: From: A B C I want it to become: A A (selected row) B B (selected row) C C (selected row) How do I do this? Here is my draft...
Summary: I am a novice excel user, I have a spreadsheet that can be updated at any time by hitting an update button. I want to capture data that was created o...
Summary: Even though you didn't ask a question, I should inform you that this forum is for MS Office realted products, such as Word, Excel & Outlook. If you ha...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
