Move data to a specific row in another sheet

[bhenlee]

Hi Experts,

I need to Copy the data in Sheet1 A1:C1 to Sheet2 but based on the row number indicated in Sheet1 A1.

So if A1 has 10 then the data on Sheet1 A1:C1 should be copied on Row 10 of Sheet2.

Thank you for all your help!!!

[alansidman]

try this

Please Login or Register  to view this content.

[bhenlee]

Thanks alansidman.

The script is working; however, i failed to indicate that A1:C1 contains a formula and their values are derived from another cell within the same sheet.

So for example A1 =k14


When I run the macro the command sometimes copy the formula (=K14) and not the value.

[alansidman]

If that is the case, then you need to change the paste to paste special. The following line needs to change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[bhenlee]

Awesome!!!

i didn't know that putting the PasteSpecial command on the 2nd line makes all the difference.

Thanks man for all the help. Appreciate it!!!

[alansidman]

Every day is a learning experience on this forum for everyone.