100 + tabs need to pull data if criteria is met

  • Thread starter Thread starter Neall
  • Start date Start date
N

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
 
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
 
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




Neall said:
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
Click to expand...
 
Back
Top