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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
I think I need a macro
- Thread starter elvezrulz
- Start date
sheetspread
Well-known Member
- Joined
- Sep 19, 2005
- Messages
- 5,161
Can you just copy the sheet? Or is it a column portion that you wish to repeatedly paste?
Upvote
0
jbeaucaire
Well-known Member
- Joined
- May 8, 2002
- Messages
- 6,012
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?
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?
Upvote
0
Similar threads
- Solved
