Conditional Copy With VBA

[kxt1005]

Hi there,

I have daily counts of different products that I need to report from sheets that I get in. Those sheets I have seperated on excel by day. I had recorded a macro to go through the sheets and copy and paste the numbers to where I need them reported, but the order that the products are reported in aren't always the same. Thus, I need a create a macro where, it will look for the day of the week, and then the product names and copy it into the right columns. Is there any way to do this?

It is like this below

Daily Product Count
MON TUE WED THUR FRI SAT SUN TOTAL
DATE 18 19 20 21 22 23 24
1 163 135 298
2 146 94 240
3 151 85 236
4 10 15 25
both 125 104 229
f 29 24 53
d 14 13 27
total (1-4) 470 329 0 0 0 0 0 799
Total (8-10) 146.5 122.5 0 0 0 0 0 269
% 31.17 37.23 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 33.67

Mon
Group Mix Sales
Units
Products 1 163
Products 2 146
Products 3 151
Products both 125
Products 4 10
Products f 29
Products d 14
Products cs 62
Products cm 60
TOTAL

Tues
Group Mix Sales
Units
Products 1 135
Products 2 94
Products 3 85
Products 4 15
Products b 104
Products f 24
Products d 13
Products cs 29
Products cm 27
TOTAL


It goes on until Sunday. It kinda messed up when I copied it and pasted it. I hope it helps figure this out though.

Thanks,
K