Hi Roger!

Always appreciate your input. No worries on my other problem. as I know you
are very busy with your job. It is just so very nice of you to offer the
support and input you do to "newbies" like myself. This group has been of
wonderful learning for me thanks to people like you, Max, Driller and some of
the others.

Best to you,

Dan

"Dan the Man" wrote:

I have a spreadsheet with 4 tabs of quarterly data (representing four
quarters in the fiscal year-Quarter 1 July-Sept, Quarter 2 Oct-Dec, etc).
That same spreadsheet also has a tab which sums the data on a quarterly basis
(with the idea of creating 4 additional tabs reprersenting a summary of the
data for each quarter). I just finished developing the tab which will
reference the first quarters data (for requirement purposes, the summary tab
is entitled "Quarter 1 Summary", and it is referencing data on the tab
entitled: Quarter 1 July-Sept).

My question is getting help in finding a quick way to create these
"additional" summary tabs that doesn't require me to re-enter all of my data
again. For example, the first "Summary Tab" (referencing the first quarter)
has formulas such as:

=COUNTIF('Quarter 1 July-Sept'!$C$4:$C$500,"OP")

When I create the next summary tab, it will reference 'Quarter 2" data:

=COUNTIF('Quarter 2 Oct-Dec'!$C$4:$C$500,"OP")

If I had to go through each individual formula to edit the references above
(consistent with the spreadsheet they are pulling data from) it would take me
forever. There must be a quicker way. Help!

Thanks,

Dan