Greetings to all and thank you in advance for any help with my problem. In this post I am primarily looking for some reading material to see if I can crack my problem before I burden others. I am not very well versed in VBA, but I am an eager learner. Here is the problem: I have a master sheet with monthly data that includes the date, the hours of the day, the product, and the quantity. Following this master sheet I have an sheet for every day of the month. In each sheet I have the hours of the day listed in 24 rows and the names of the products on one header row. I would like to create a macro that would look at the product in the raw data and match it to the same product by date and by hour. The problem is that not all products have quantities for all the hours of the day so I can not match the product and blindly copy 24 rows. Can some one point me in the right direction and I will promise not to take anyone's time with unecessary questions. Thank you so much for your help!
Oakman