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: 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: 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: Yes - I agree. If I had Dbase II Plus on here, I could do it in 2 minutes flat. The reality is that... 1 - Not many people will (or can) spend a larg...
Summary: Hi, Here it is with email. There are several e-mail settings that you will have to enter yourself, including the name of the SMTP server. You will l...
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: 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: 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: 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 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: 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: hundreds of files have been converted into Terminal files presenting as grayed out and useless. Also I'm being told that I have leaky files, ...
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 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: Hi, I need to switch between 2 open excel worksheets and copy data from one to another. I cannot use the file names to say which one I want to switch ...
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: Could some one please tell me how to construct a macro, in excel, to delete rows that in a collumn aren't multiples of 300. Thanks in advance ...
![[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
