R
rz6657
Need help with the following –
1. I have 12 sheets, 1 per each month (Jan, Feb, Mar, and so on)
2. Each of these 12 tabs has different data, based on the month
3. A unique sheet (let’s say Program1) will retrieve data from Ja
sheet. Once month of Jan is over, than this same sheet will need t
retrieve data from Feb sheet (and so on throughout the year).
4. The location of the cells will be static, but the source of the dat
will be dynamic.
I was thinking that maybe a “trigger” in a master sheet would dictat
when the Program1 sheet will know if to look for the data in Jan, Feb
Mar, and so on. For example, I would have a cell with number 1 in th
Master sheet. When the cell has this number, the Program1 shee
formulas know to retrieve from Jan sheet. If it has a 2, retrieve fro
Feb sheet, and so on.
Is this possible? If so, how? Thanks
1. I have 12 sheets, 1 per each month (Jan, Feb, Mar, and so on)
2. Each of these 12 tabs has different data, based on the month
3. A unique sheet (let’s say Program1) will retrieve data from Ja
sheet. Once month of Jan is over, than this same sheet will need t
retrieve data from Feb sheet (and so on throughout the year).
4. The location of the cells will be static, but the source of the dat
will be dynamic.
I was thinking that maybe a “trigger” in a master sheet would dictat
when the Program1 sheet will know if to look for the data in Jan, Feb
Mar, and so on. For example, I would have a cell with number 1 in th
Master sheet. When the cell has this number, the Program1 shee
formulas know to retrieve from Jan sheet. If it has a 2, retrieve fro
Feb sheet, and so on.
Is this possible? If so, how? Thanks