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
Copy and paste row makro vba Copy every row and insert excel Copy multiple cells and paste into one cell column format Copy paste loop bat file script Copy whole row excel vba Copy, paste and cut in ubuntu Disable copy paste option in ms excel using vb6 code Disable cut copy paste in excel using vb6 Export to excel remove first blank column Firefox copy paste not working How do i copy paste values automatically How to prevent copy paste of data from my web page Macro excel open file copy paste row Macro that will copy a formula from one cell and paste it into blank cells in the rows Select cells based on criteria and copy paste them into another sheet in excel Slow copy and paste text xp Vba excel copy into blank cell row loop Word 2007 copy paste problem