100 + tabs need to pull data if criteria is met

[Neall]

I have 100 + worksheets which are all the same (except for the tab name they
are different per customer), one cell (the same cell for every sheet) has the
date that the customer is going to be renewed another cell has the customer
names and one cell has the amount paid for the products

I have a tally sheet that I want to break out per year to show which
customer will be renewed in 07 - 08 .... etc and their renewal date and what
they paid the previous year.

Any suggestions?

Thanks in advance

 

[Ron de Bruin]

Hi Neall

You can create a new sheet with links to the cells you want in every sheet with this code example
http://www.rondebruin.nl/summary.htm

You can filter that sheet then to get the results you want

 

[Neall]

Perfect, but any suggestion on how I can skip the first X number of sheets?

Thanks

 

[Neall]

That worked, now another few follow up questions

How can I format the entire sheet to be center,center and shade the header
cells a light grey and bold them?

Another thing I want to add is a the filter option at the top with an
automatic filter for a column ascending.




Any suggestions?

Thanks in advance

 

[Ron de Bruin]

Hi Neall
..
Record a macro when you do it manual.

Post back if you need more help


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

That worked, now another few follow up questions

How can I format the entire sheet to be center,center and shade the header
cells a light grey and bold them?

Another thing I want to add is a the filter option at the top with an
automatic filter for a column ascending.




Any suggestions?

Thanks in advance