B
Bob Reynolds
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
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