exel spreadsheet formula

Microsoft Excel 2000/visual basic for ap...
July 24, 2009 at 10:15:03
Specs: Windows XP
I have a workbook with 6 sheets. I am pulling data with a pivot tables in 5 sheets. each month I want to change the informtion so the columns change. How can I make sure I pull the data on the Summary sheet for the data example Month 4,5,6 is in one quarter but in period 7 is in antoher quarter one month then I want to pull Month 5,6,7 and 8 but the inforamtion changes because of the quarter 5&6 are in one quarter & 7&8 are in another so my columns change can I lock down a formula in any why to say "use this for "Month"?

See More: exel spreadsheet formula

Report •


#1
July 24, 2009 at 11:25:57
For a real chance of an answer, post your question in the "Office Software" forum.

http://www.computing.net/forum/offi...

Skip


Report •
Related Solutions


Ask Question