Hello,
I'm trying to
1-copy and paste the last row of data (including formulas) onto the row below (first blank row) which will change each time I run the macro, weekly, then
2-copy the new last row of data and paste only values onto the previous row of data.
Example: if last row of data is row 85...copy formulas in row 85, paste in row 86; then copy row 86 and paste values to row 85, where rows 85 and 86 will need to have dynamic variables.
Please advise. Thanks so much.
Configuration: Windows XP Internet Explorer 6.0
Acer aspire one blank screen fix Copy and pasting cell in 2007 formulas gone problem Copy from one sheet paste to another based on cell value Copy paste files does not work mac Copy paste rows based on colours in vba Copy paste vi linux Copy pasting photo pc Copytrans 3.29 activation code Excel formula: copy data from other sheets and paste on summary sheet Excel macro to open pdf copy text and paste to notepad Format all cells based on format of first row excel How to copy and paste using apple keyboard How to copy files from a drive and paste in another drive using vb.net Notepad copy paste not working This copy of windows did not pass genuine windows validation Vba copy current row to col a Vba copy row Windows 7 installation blank screen