Forum Discussion
Autopopulate from one worksheet to the next worksheet
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 ...
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.