I have a macro in workbook "A" that goes to workbook "B" and copies a worksheet and pastes it into "A". It works fine on my laptop but when I transfer the...

=AVERAGE(F2,H2,J2,L2,N2,P2) All of the above cells may or may-not have a value in them. The formula has been placed on approximately 10k lines of that...

Is it possible in Excel 97 for Windows to format a worksheet so that, for example, columns A-F print on the top half of a page, and columsn G-Z print...

I am currently working in a large data base in excel 97. When I go to sort data by heading rows it is coming back with an incomplete sort. How do I work...

To All, I have found and removed the xf/Sic.gen macro virus from several spreadsheets (with McAfee VirusScan 7 and the latest virus definitions) but the...

I know this may seem like an easy topic for you pros....but. Id like to share a workbook within my company. Id like to edit the entire work book on a...

In Quatro pro I could hold down the control key and select non adj. cells and then after they were highlighted I could copy them and then paste them anywhere I...

I cannot figure out(if at all possible) how to continue to add columns past IV. IV is as far as I can go. Is it possible to expand and maybe go to ZZ or...

I read Cell C5 from C2 The question is what formula can do the following? If Cell C5 is W then a 1 is entered into Cell C2. If Cell C5 is L then a 0 is...

I have created a macro in a workbook that has multiply worksheets (tabs). The macro works great on the worksheet where the macro was created. However, when I...

I have the following in the cells in column S: s3 3 wks s4 12 wks s5 4 wks s6 stk s7 stk s8 29 wks s9 7 wks s10 32 wks and on.....

I'm doing a reporting application that matches rows over several tables. Each has a key column - a three character designator called 'CDC'. I have a 'master'...

I AM WORKING ON A FORMULA SO THAT IF J2 IS BETWEEN 0 AND 10 THEN I WANT J3 TO DISPLAY 0.10 BUT IF J2 IS BETWEEN 10.01 AND 24.99 THEN J3 = 0.55 PLEASE...

I have the following table: A B C D E F Department D Chargable=1 Rate Mon Tue non=0 1 Projects AA ...

When we start a new spreadsheet, the columns are numbered 1, 2, 3... and the rows are numbered 1, 2, 3... I am used to the columns being lettered A, B, C. Does...

Hi, Is there a way to load a csv file (comma seperated text file) into Excel with macro attached to color certain fields and Bold the first column...

I have a combox box for a long list of names. I'd like to be able to type the first letter of a name and automatically go to that part of the list. I don't...

I have an Excel Application that contains multiple columns of 15 cells vertically all these cells are linked and need to be updated every month to a new data...

I'm currently devising a sheet to work out company oncall. We have 3 people on call at one time ( from a group of10 ), 2 do a 1 in 2, I am using the ISEVEN...