Automatically transfer information from Sheet 1 to Sheet 2 [Closed]

Report
Posts
1
Registration date
Friday December 2, 2016
Status
Member
Last seen
December 2, 2016
-
Posts
15132
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
April 13, 2021
-
Hi,

How can I automatically transfer data from a cell in Column A in Sheet 1 to Column A in Sheet 2?
Once data is copied over into Column A in Sheet 2, Column B,C,D and E has VLOOKUP formulas linked to information in Sheet 1

Sheet 1 and Sheet 2 headings

Column A Column B Column C Column D Column E Column F
Stock Item "PACKAGE SIZE" UOM Items Per Case PACKAGE PRICE UNIT PRICE

Hope this makes sense.

Thanks for the assistance.
Lani1302

1 reply

Posts
15132
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
April 13, 2021
4
Suggestion : enter this formula in cell A2 of second sheet: =Sheet1!A2, then copy the content of that cell down in column A.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!