excel macro to copy data ind paste into selected column depending on cell number

[goeman]

Hi there

Would really appreciate someones help please.

I have the following in a spreadsheet

Sheet 1
Col A: contains various numbers in the row e.g 23, 97, 254 etc (then Rows B to H contain various data)

A B C D E F G
1
2 23
3 97
4 254
5 588


I the need to look at the numbers in col A (e.g 23) and then copy the data cells B2:G2 and paste into row 23 in Sheet2 and then the same for the next number in col A in Sheet1 (e.g 97) copy data in cells B3:G3 and paste into row 97 in Sheet2

Thanks for your help

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

thanks for your help... and works great on large amounts of data as well