this is a tricky one

Originally Posted by cjohnsen

ok here is my dilemma i have a master sheet that contains huge amounts of data pertaining to media and stations across the country. i would like to buid a formula that would search out specific stations and their stats each time it runs or each time i upload the master sheet from our agent. i think an array would have to be in the solutions somewhere.. i have attached a sample file to show what i am working with. instead of a "sumproduct" function i would need to show each individual airing of the station....... i dont think each formula could be the same or it would pull the same data over and over again. so here is the question.... given the sheet attached how can i have the corresponding sheets search through the master and pull each row of stats that = that specific station???? email me at cjohnsen@nmrdirect.com if you need more info.

thanks so much in advance for everything!

c

You could have both.

A summary sheet with Stations (per row) and dates (or periods) per column together with a Worksheet-per-station of extracted lines for detail purposes.

The macro could then run row-by-row through the Master and add figures to the correct summary cell(row=station, column=date) and copy the row to the related Station sheet.

If you do not know VB I'm sure someone would give you a quote for such a project.

hth
---

Maybe try this? See attachment.

Just a thought, would Autofilter do what you need to do?


Good luck

Hi

Here is a different flavor. I believe a pivot table would be more beneficial to you see attached document

Denis