Home

Autopopulate from one worksheet to the next worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-343496%22%20slang%3D%22en-US%22%3EAutopopulate%20from%20one%20worksheet%20to%20the%20next%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-343496%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20working%20on%20a%20workbook%20with%20two%20worksheets.%20Worksheet%201%20is%20the%20main%20page%20where%20all%20necessary%20information%20goes%20for%20one%20department.%20Worksheet%202%20utilizes%20a%20lot%20of%20the%20same%20information%2C%20but%20there%20are%20some%20differences.%20Most%20of%20the%20information%20on%20both%20sheets%20is%20text.%20What%20function%20should%20I%20use%20so%20that%20the%20information%20from%20Worksheet%201%20auto%20populates%20on%20Worksheet%202%20so%20I%20don't%20have%20to%20retype%20the%20information%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-343496%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-354957%22%20slang%3D%22en-US%22%3ERe%3A%20Autopopulate%20from%20one%20worksheet%20to%20the%20next%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354957%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20solution%20depends%20a%20bit%20on%20what%20exactly%20you're%20doing%20and%20whether%20the%20location%20of%20the%20data%20will%20always%20be%20in%20the%20same%20place%20or%20if%20it%20will%20change.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you're%20working%20with%20data%20that%20will%20always%20appear%20in%20the%20same%20location%20on%20sheet%201%2C%20like%20an%20order%20form%20with%20a%20customer%20address%20fields%2C%20you%20could%20simply%20use%20%3D%20on%20sheet%202.%20So%20if%20the%20customer's%20name%20was%20always%20located%20in%20cell%20E4%20on%20sheet%201%2C%20you%20could%20simply%20enter%20%3DSheet1!E4%20in%20the%20proper%20location%20on%20sheet%202%20or%20just%20type%20%3D%20then%20click%20in%20the%20appropriate%20cell%20on%20sheet%201.%3C%2FP%3E%3C%2FLINGO-BODY%3E
khupp1231
Occasional Visitor

I'm working on a workbook with two worksheets. Worksheet 1 is the main page where all necessary information goes for one department. Worksheet 2 utilizes a lot of the same information, but there are some differences. Most of the information on both sheets is text. What function should I use so that the information from Worksheet 1 auto populates on Worksheet 2 so I don't have to retype the information?

 

Thank you!

1 Reply

The solution depends a bit on what exactly you're doing and whether the location of the data will always be in the same place or if it will change.

 

If you're working with data that will always appear in the same location on sheet 1, like an order form with a customer address fields, you could simply use = on sheet 2. So if the customer's name was always located in cell E4 on sheet 1, you could simply enter =Sheet1!E4 in the proper location on sheet 2 or just type = then click in the appropriate cell on sheet 1.