AUTOMATICALLY POPULATE CELLS ON ONE PAGE (tab) FROM INFORMATION ON ANOTHER PAGE (tab)

I want to be able to enter details on a page (tab) and then, as I type in details on another page, have them automatically populate as soon as it recognises that the information is on the other page (TAB)

It would help if you attached a sample Excel workbook, so we could have a clear idea of how your data is laid out and what you want to copy over to the second sheet..

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Do NOT try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

OK, so I have shown a page with details of members on it (all made up, not real for this purpose).

Now, I want to be able to start to type the name on SHEET 1, or any other sheet in the workbook, and have it auto-populate all the details once it recognises a match.

Example should be attached.

If you mean that you want to start typing F and it will immediately recognise Fred, then Debra Dalgleish shows how you can do that with Data Validation using a Combo box - here's the link:

https://www.contextures.com/xlDataVal10.html

Hope this helps.

Pete

Hi Pete, thanks for trying to help me.
However, either I am misunderstanding you or you are misunderstanding.

You know when you type something in Excel and it will autocomplete the cell if that entry is elsewhere on the page?
Well, I want that to happen when the information is on a different page.

So, first of all I type in the details of my members on to a page, This will be name, phone number. email address etc. etc.

I then open another page to sign them in when they arrive for a meeting.

So that I don't have to type their details in again, because I already have them on another page, I want to be able to start to type in their name and for excel to recognise the entry on my Members Page list and enter it for me; does that make sense?

You can't have AutoComplete from another sheet (unless you use a combo box with a named range, as described by that article), which is what I thought you were asking for, so if you are prepared to enter the name, then allowing for headers in row 1, and using column A for the names (from A2 down), you can use this formula in B2:

=IFERROR(VLOOKUP($A2,'MEMBERS DATABASE'!$A:$D,COLUMNS($A:B),0)&"","")

Copy this across into C2 and D2, then copy all three formulae down as far as you like.

Enter a name in A2, A3, A4 etc., and the other details will be displayed.

Hope this helps.

Pete

BRILLIANT!!! Now that is exactly what I wanted. Thank You so much.