CODEWITHSUNDEEP
excel
deanventure
deanventure

Reputation: 11

Need some Excel help getting data from multiple worksheets

I need some help with Excel please

Let's say I have an Excel workbook that has a worksheet for each person in a company. Each worksheet is the name of the employee and has various information about that employee. I have an index page that has each worksheet name in column A starting on A2. I would like to know how to show the contents of cell D6 from each employees worksheet on the index page.

Thanks

Upvotes: 0

Views: 34

Answers (2)

deanventure
deanventure

Reputation: 11

If any of your worksheets use a hyphen or other special characters in the name use this instead: =INDIRECT("'"&A2&"'!D6")

This should keep you from getting #REF! errors.

Upvotes: 0

Uberzen1
Uberzen1

Reputation: 415

Like this?

=INDIRECT(A2&"!$D$6")

Upvotes: 1

Related Questions