Forum Discussion
How do I auto-populate information from one tab to another in sheets?
INDIRECT could work, yes. But I need to ask a couple more questions:
- How many sheets are there with this $D$2 reference?
- Are they all named SheetX! or are the names varied in nature?
250 sheets
Yes, they are all named SheetX!, where X is the sheet number.
Thank you so much!!
Use VLOOKUP, as shown in the attached file (and the image below).
Here, too, is a helpful on-line resource that can explain in greater depth how to use VLOOKUP as well as some of the other variants that Excel offers to retrieve information from a separate table of data.
https://exceljet.net/search?query=lookup
By the way, in the future it would make sense to start your inquiry here as a totally new thread. What you're asking isn't really the same as the prior exchanges on this one, and your inquiry could easily get buried.
- I'm leaving on a two week trip tomorrow and getting ready today.
Your problem sounds like it deserves an altogether new thread, in part because the brief description makes it appear that a macro might be involved in the solution (as well as it appear that this is already being a macro enabled file), I don'r work with macros---there are others here on this site who do. Also, when you start a new thread, please post a copy of your workbook so those who try to help can work with the real thing. - Boss...I need your kind help...I want to use Unit of something (As like KG, PCs, LBs MT) in reference to another cell data on its same row & automatically send it in a specific column on another sheet. How to do it in micro enable excel file..??
- OMGOSH THANK YOU SO MUCH! I never would have figured that out on my own. Much gratitude!
An example is attached. Here's a screen grab that shows the formula, but you can see the actual in the attached file.
