Is there a way to check a value with the name of a tab? I have a bunc
of data in two columns. One column is the date and the other is
product number. I have sorted by date and now I would like excel t
create a tab for each date and copy the product numbers (for that date
to that tab. Is there a way to make a loop so I can check if x dat
equals 'the name of tab1', then copy product number to tab1

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