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

Thanks

--
Neall


"Ron de Bruin" wrote:

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


--

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




"Neall" wrote in message ...
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



--
Neall