Creating a link from sheet1 to other sheets

C

Carter

Here's my scenario

Sheet1 will be my master sheet containing category tasks by date (e.g., June 7 tasks). Sheets2 and higher each contain a specific category with dates and tasks. I want to create a way for Sheet1 to link to the date ranges in the other categories. So that it can be my master list of all categories with dates and tasks combined. Sheet1 would thus be automatically updated if I add to any of the categories. Does that make sense?

I got pretty warm in coming up w/ a solution while reading about Creating Multisheet Names. But still came up short. Either this is not doable, or it might make sense to just use cut/paste as simpler solution. Before I use cut/paste, I want to try the formula way. So if anyone can assist me, I'd greatly appreciate it

Thanks
Carter
 

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

Create A Master List From Several Lists 5
Dynamic links to other sheets 2
Summing one column based on criteria from two other columns 2
Lookup and match then return data from another sheet 6
Linking cells between sheets 0
Data in sheet1 to be put into sheets 2, 3, 4, 5, etc 2
Help with linked formulas & multiple worksheets 8
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0

Top