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: 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: I need to input a negative time value into a time formatted cell in excel. I have a cutom cell format: [hh]:mm;[Red] -[hh]:mm This works perfectly for...
Summary: Can somebody please help? I have limited VB knowledge and I am stuck trying to create a macro that reads a column of data starting column A (months) a...
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: how can i increase a cell reference by one row automatically. The summary worksheet references individual worksheets. I need the summary worksheet to...
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: 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 guys, i have this problem while doing excel. im not sure if this is do able, but if anyone got the solutions, i would be greatfull I need to copy s...
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: I need to take time from a stopwatch (00:00:00 = min:sec:hundreths) and divide it into an hour. Cell F8 (load time - 04:56:10), Cell F10 (run time - ...
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 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: 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: I am using the Data-filter-Auto filter function to filter data based on 3 different criteria in Excel. Then I need to summarize one row of data. Thi...
Summary: it has to be incorrect (imo) because the parentheses are not balanced: 4x((((, 2x)) since none are in quotes or escaped. IF executes the first item (c...
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: 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: Is there any way to assign a comment to a value instead of a cell? for instance have a name from a drop down list but when you hover over the name sho...
Summary: I am pretty new to IF statements in the context of excel and have no idea how to complete the latest one I need. Basically Its like this: The are thre...
Summary: Hiya, I'm trying to colour a cell when a different cell meets a certain criteria eg. a girl is in the school house called Aidan which is yellow her na...
![[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
