Previous Topic Next Topic

Automatically transfer information from Sheet 1 to Sheet 2

Closed
Lani1302 Posts 1 Registration date Friday December 2, 2016 Status Member Last seen December 2, 2016 - Dec 2, 2016 at 03:41 AM
yg_be Posts 24281 Status Contributor - Dec 2, 2016 at 01:38 PM
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
Related:

1 response

Answer 1 / 1
yg_be Posts 24281 Status Contributor 5
Dec 2, 2016 at 01:38 PM
Suggestion : enter this formula in cell A2 of second sheet: =Sheet1!A2, then copy the content of that cell down in column A.