Summary: Hi All, I am trying to reference an excel workbook that is on a LAN (at work). The idea is to copy the contents that is on sheet1 and paste it on shee...
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 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 all! i have 2 spreadsheets, one of which has a colmn wit hall the serial #'s in need on the other spreadsheet, i ahve all bUT 2 of the serials #'s ...
Summary: I would like to have a macro to run a save as command using the contents of an excel cell as the name. I have generated this cell by combining 3 ce...
Summary: Hi I'm creating a workbook to generate invoices, with an "input" worksheet for people to enter data and an "invoice" worksheet which will be protecte...
Summary: I'm trying very hard to figure this out. I have a workbook with about 8-9 different worksheets at any given time. Two of the sheets (which are not n...
Summary: Hi, I have time in as 10am and time out as 7.30pm. Our work schedule is 8 and 1/2 hours. When I calculate the difference of time it shows 1.30hrs, bu...
Summary: I'm trying to copy cells in SheetA to SheetB but they are split across two or more rows. I need to detect a null (or empty) cell in sheet A and th...
Summary: I have a client that needs a formula to calculate the total cost of meals on monday thru friday... easy enuff =(a2+b2+c2+d2+e2) however, on certain da...
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: 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 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 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: 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...
![[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
