I'm trying to create a macro to open all the Excel files in a folder and copy/paste the second line of each worksheet in a separate file already created. ...

As a relative newbie to excel formulas I'm having great difficulty creating a formula where I need to add 168 hours to a date/time. After two days of trying...

My ABC and 123 are printing, how do I get it not to print.

I think I have discovered a bug in the way Advanced Filter filters out duplicates. When I perform this function and have the results pasted to another...

-- Mike @ Contractors

I have several rows with the same formula but they are seperated, in some cases, by rows with other information to prevent me from just dragging a formula...

i want to come up with a formula where cell b1 *.00125 if its less than 100, the value must show min 100.00

Excel 2007 Tables Strain one time items. With Advanced Filter. http://www.mediafire.com/file/f0ytmnoizhd/03_13_10.xlsx

-- Mike @ Contractors

In Excel 2007 I have a workbook finished and I want to print the worksheets with and without the formulas showing. When I set up the worksheet to print...

I need a tiebreaker for a formula. Right now the formula reads: =INDEX(A$3:A$21,MATCH(D28,Y$3:Y$21,0)) which works real well But when there is a tie it shows...

Why does Excel 2007 open two workbooks when I open one of my saved workbooks? Whenever I open the workbook I want to work in, another book opens with...

1 name amount 2 Paul 200 3 John 100 4 Mary 250 5 Paul 100 6 John 300 After entering above...

I am tryinig to create a popup or other type of information sheet for users to read instructions on how to use a print macro I have created in a worksheet. ...

I have to record apt unit numbers in separate columns. I could up to 20 or 30 columns. My problem is apt unit numbers being entered multiple times. Is there...

I'm experimenting with using a pivot table as an intermediate step in a report I'm doing that has been slow. It seems to help speed up the process a bit, I...

Hi, I have a worksheet in which contact information (names/add/postcode etc) are stored in a secondary tab. I need to update the information onto the first...

Hi, I understand that Copy Paste Special Skip Blanks allows copied blanks cells not to overwrite non blank cells in the destination column. How about...