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
|