auto populate between tabs

**smatt26** · 02-08-2013, 07:58 PM

How do I make data that I put in the first tab auto populate into other tabs? Example, a row of names that will appear in the other tabs.

**jeffreybrown** · 02-08-2013, 08:01 PM

Hello & Welcome to the Forum,

You can just set up a link...

=Sheet1!A1

...and drag down.

**smatt26** · 02-09-2013, 11:22 PM

sorry but i am very clueless about excel. could you be more specific about what and where to enter the formula?

**jeffreybrown** · 02-10-2013, 12:48 AM

Let's say you have info in cells A1:A10 of Sheet1...

On Sheet 2 in A1 (or any other cell), enter =Sheet1!A1 and drag down...

If this does not do it for you then maybe a sample workbook?

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic