Been all through the search and not finding what I need -- I'ma VBA virgin... Think the problem is so simple, I can't find an example to build from!
I have a simple tab/report (blank columns in A, headers, ... just showing data in a sample B2:I3 in this case.
This tab has values from previous week's reports.
What I want to do is copy (or fill down) the last row with data to the row underneath it. The references are set up to correctly duplicate so my other tabs will report cleanly.
Then the row I just copied (Row 3 in the above example) I would like to copy and paste-value to preserve the data. I've got the rest of the simple macro to clear contents on the other tabs and save the file under a new name -- but this is driving me crazy.
Any suggestions?
Thanks, Martin in NH
I have a simple tab/report (blank columns in A, headers, ... just showing data in a sample B2:I3 in this case.
7/16 | 81 | 2300.15 | 156 | 158 | 2400 | 0 | 1800 | ||
7/23 | 69 | 1500 | 200 | 220 | 2600 | 200 | 2000 |
This tab has values from previous week's reports.
What I want to do is copy (or fill down) the last row with data to the row underneath it. The references are set up to correctly duplicate so my other tabs will report cleanly.
Then the row I just copied (Row 3 in the above example) I would like to copy and paste-value to preserve the data. I've got the rest of the simple macro to clear contents on the other tabs and save the file under a new name -- but this is driving me crazy.
Any suggestions?
Thanks, Martin in NH