the date columns actually never end... but I need to only see 10 day out...i just delete the rest of the blank columns.
Th rows can vary, in each worksheet am given. sometimes there are 6000 rows.