I think I need a macro

[elvezrulz]

I have a problem that I thought was easy but it's not. On one sheet I have information that gets populated by Vlookups referencing cell A1. The same set of information gets populated by another product whos info is in A20. On another sheet I have, all in column A, 15,000 SKU numbers. I need to be able to cut and past the first sheets data over and over and have the corresponding A1 and A20 cells, whatever they are, A40, A60 you get the idea, with the next SKU in line on the other page. If I can't cut and paste the first sheet's data over and over (remember I have 15,000 skus to look up) then I will have to enter all the skus manually. Is this possible?

 

[sheetspread]

Can you just copy the sheet? Or is it a column portion that you wish to repeatedly paste?

 

[jbeaucaire]

You want to:

1) enter the value from sheet2 A1 into sheet1 A1
2) enter the value from sheet2 A2 into sheet1 A20
3) Copy the sheet1 results in a range of cells A1:B39 and paste the "values" into a new sheet
(what is the correct range of results?)

4) enter the value from sheet2 A3 into sheet1 A1
5) enter the value from sheet2 A4 into sheet1 A20
6) Copy the same range to the new sheet BELOW the already saved data

7) Repeat ad nauseum


Sound right?