macro to copy data to specific columns in same workbooks

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

Originally Posted by sintek

Hi Jean1972

This should get you started:

Please Login or Register  to view this content.

Hi

Tried but not getting expected results as in upload_1 sample


DATA BE 1 17049000
DATA AD 2 UPLOAD 1 18063100
DATA FF 3 18063200
DATA ZA 4 19011000
DATA FFF 5 19012000
DATA ZA 6 19041000
DATA SS 7 19051000
DATA ZA 8 19053100
DATA ZA 9 19054090
DATA BE 10 19059090
DATA AD 11 19059090
DATA FF 12 20021000
DATA ZA 13 20051000
DATA FFF 14 20051000
DATA ZA 15 20057000
DATA SS 16 20059900

Hi sinetek

thanks ,on right track, need to adjust B1 and C1 on the upload sheet (highlight cells in yellow )

jean

Hi Sintek & Bakerman2

Works a charm now , save me from a daily copy paste chore

Thank you both for assistance