| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to auto-populate worksheet based on cell entry?
Thanks you! Worked like a charm.
"tgcali" wrote: I appreciate your answer and that would work, but unfortunately they're just named sheet 1, sheet 2, etc. up to sheet 250. The ID# is located in cell B2 on each sheet. I apologize, I should have specified that from the beginning. I'm choosing to look based on ID# because I needed an easy way to call up the specific data needed for any individual. We need to set it up to be able to email specific data but not the entire individual worksheet. So I chose to create a new workbook to be used just for the email puposes. I am creating this sheet in the current workbook to call up the necessary data, add additional data and then export to the new workbook to be emailed. I can take care of the rest easily enough, I just seem to draw a blank on how to call up the necessary block of data from A1:H32. Thanks again for your help. "KC Rippstein" wrote: I assume each sheet tab's name is the ID#. In that case, in cell A1 use the following formula: =INDIRECT("'"&$I$2&"'!A1") Copy that formula to H32 using the auto-fill handle. -- Please remember to indicate when the post is answered so others can benefit from it later. "tgcali" wrote: Hello, If I enter an ID# in cell I2 I need the data from cells A1 to H32 from that individual's worksheet to auto-populate in the same place on the current worksheet. Is this possible? There are numerous worksheets, each representing a specific person. I would need to be able to have the data from A1 to H32 brought up for any individual based on the ID# entered. Thank you in advance for your assistance. I appreciate any help. tgcali |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto populate this cell based on what's typed in this cell | Excel Discussion (Misc queries) | |||
| Auto populate a cell based off a look up table | Excel Discussion (Misc queries) | |||
| How to Auto-populate cell based on selection of a list item | Excel Discussion (Misc queries) | |||
| How do I Auto Populate a cell with a chart based on a value | Excel Worksheet Functions | |||
| auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
Hybrid Mode
