Hi All
I have a workbook with several sheets, sheets breakdown contains data with formula
however need a macro to automate it insert upload sheet in same workbook
That is
breakdown sheet row 2 column B2 and C2 are copied to upload_1 sheet column C and D staring at row 2 still to last data row paste special values only
breakdown sheet row 2 columns D2 are copied to upload sheet_1 columns I2 starting at row 2 still to last data row paste special values
breakdown sheet row 2 column G2 and H2 are copied to upload_1 sheet column L2 and M2 AT ROW 2 still to last data row paste special values
breakdown sheet row 2 column I2 are copied to upload_1 sheet column B2 AT ROW 2 still to last data row paste special values
breakdown sheet N2 to O2 COPIED to upload_1 sheet A1
breakdown sheet R2 COPIED to upload_1 sheet E1
breakdown sheet S2 to T2 COPIED to upload_1 sheet J2 TO K2 and autofill to last data row
breakdown sheet U2 COPIED TO upload sheet A2 AUTOFILL TO LAST DATA ROW
The data reads more than 5000 rows.
Thanks for assistance
Bookmarks