The spreadsheet has 52 columns contain (in date format "2004 Jul" as
custom number except for the Total columnns eg"2004 Total") dat
starting at column P. In the previous columns there is product info
including country regions etc. I only need to test for data that is fo
the current year for this particular macro and the number of column
increments every month-from 1 -12.

Why i need to do this is that once I have filtered the data, I the
need to match it against the source spreadsheet to determine brand ne
product codes as these rows will need to be imported differently fro
the ones that already exist. once imported the new codes then nee
custom formatting.

With the old codes i only bring across relevant columns. with the ne
codes i need to bring across everything.

I could I guess do this from a pivot table and hide the blanks and the
match the source product code column against the pivot table. I wa
hoping to be able not to have to create a pivot table as it run
slowly.

Any ideas or is more info needed?
Thanks for your patience

--
Message posted from http://www.ExcelForum.com