linking sheets to summary Excel 2003

D

Dave

please help. I have a set of worksheets circa 100 from which I want to link
certain cells [same cells from each sheet] to a summary page in the same
workbook into seperate columns. The cells I want to link from are not next to
each other.

eg cell E8 sheet 100 to summary sheet D4, cell E16 sheet 100 to summary
sheet E4, cell E8 sheet 99 to summary sheet D5, cell E16 sheet 99 to summary
sheet E5

is there an easy way other then to insert the links manually?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for transferring data in rows to columns on two different Worksheets 1
Populate Data from Summary Sheet 5
Multiple worksheet summary 4
linking cells 1
extract data from multple worksheets to a summary worksheet 1
Summary Worksheet. 1
PLEASE HELP - Link Data from Different Sheets to Summary Page 3
Summary from multiple sheets 1

Top