hokie4christ
New Member
- Joined
- Apr 29, 2010
- Messages
- 11
I am a slightly above beginner user of Excel, so this problem is beyond my abilities.
I have been given a master sheet that needs to pull selected data from several other sheets in the file. The master is a calendar. The other sheets (currently up to 16 other sheets) all have 2 main columns (and some other columns i don't care about), the first is a date, the second is text. Users will fill in date/text on the other sheets, while the master needs to automatically pull that text from the other sheets when the date corresponding to the text matches the date on the master calendar. I've created the basic look of each sheet below, first the Master with what it should look like when filled in, then the other sheets with their data that will (hopefully) automatically go to the master sheet. I thought about combining all the other sheets into 1, i think that would be easier, but my friend i'm doing this for said the other data on the sheets needs to be there too, just not pulled into the calendar, so merging all the other sheets is not possible. At this point I honestly don't even know where to start. Any help/suggestions would be great!
Master:
August 2013
<tbody>
</tbody>
Other sheets (up to 16 currently):
<tbody>
</tbody>
I have been given a master sheet that needs to pull selected data from several other sheets in the file. The master is a calendar. The other sheets (currently up to 16 other sheets) all have 2 main columns (and some other columns i don't care about), the first is a date, the second is text. Users will fill in date/text on the other sheets, while the master needs to automatically pull that text from the other sheets when the date corresponding to the text matches the date on the master calendar. I've created the basic look of each sheet below, first the Master with what it should look like when filled in, then the other sheets with their data that will (hopefully) automatically go to the master sheet. I thought about combining all the other sheets into 1, i think that would be easier, but my friend i'm doing this for said the other data on the sheets needs to be there too, just not pulled into the calendar, so merging all the other sheets is not possible. At this point I honestly don't even know where to start. Any help/suggestions would be great!
Master:
August 2013
1 | 2 | 3 | ||||
Storyline | ||||||
4 | 5 | 6 | 7 | 8 | 9 | 10 |
Climax | Summary |
<tbody>
</tbody>
Other sheets (up to 16 currently):
Date | Text |
8/1/2013 | Storyline |
8/6/2013 | Climax |
8/9/2013 | Summary |
<tbody>
</tbody>