Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying and pasting a worksheet to a blank and removing blank rows
I have a worksheet that utilizes two rows per entry. The first row contains
calculations for wages paid and the second one will calculate overtime due. The second one appears blank most of the time, but is used occasionally. My problem is I have one workshett with 208 rows that is used to calculate an employees wages for 104 workweeks or two years. Each entry uses two rows as above. There are many times that the whole 208 rows are not needed and I may end up with one or two completely blank pages. The final sheet has the Grand totals for wages due, interest due and Total monies due. I need to be able to remove the blank double rows and save this document with no blanks and the bottom row showing totals. I thought a macro or vb to copy all the cells that i use for a header and cells with data in them and paste them into another blank worksheet. Also we could copy and paste or just remove the blank lines and add the total line back in. I have the worksheet protected, but with no password. I hope this is clear and I don't know how to accomplish this. Any help would be appreciated and I have no problem in emailing the workbook to anyone if they need it. Thanks BOB REYNOLDS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing blank columns and rows from worksheet | Excel Discussion (Misc queries) | |||
Removing Blank Rows ? | New Users to Excel | |||
skip blank rows when pasting formulas | Excel Worksheet Functions | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Removing Blank Rows? | Excel Programming |