Hello.
I need help from VBA programmers out here with a macro that can copy data from various sheets into a summary sheet based on criteria. Applying a logic seems to be difficult because there are merged cells in raw data, the count of sheets can increase, count of items can increase and client name needs to be picked up from sheet name. Its getting too difficult for me. Appreciate if someone can help. I have attached the file with this question.
1. Every client would have two sheets. One for Stock and One for Sale. In this file, there are only two clients (20 and 50) but actual file may have more than two.
2. The quantity from both these sheets for that particular client needs to be populated in Summary sheet.
3. Data that needs to be picked up from various sheets and that needs to populated in summary sheet is marked in red color.
4. The summary sheet has monthly periods (From and To). In this file, there are five periods defined (Apr/May/Jun/Jul/Aug) and only three periods populated because in Raw sheet there is no data for Jul and Aug. The summary sheet may have more than five periods too.
5. There are 12 items given in the file. It can be more than 12 in actual file.
The macro should fill the quantities for every client mentioned in the summary sheet and for all the periods (for demo purpose, I have shown BEFORE and AFTER data in summary sheet) I want the BEFORE table to get automatically populated at a click of a button so that it looks like AFTER. In the example, there is no data for 1-Jul-2015 to 31-Jul-2015 and 1-Aug-2015 to 30-Aug-2015 because it is not available in the raw sheets. It may be available even for more periods. On the other hand, if the data is available for all periods in raw sheet and if I need to process data only for two periods, I will keep only these two dates active in row2 of summary sheet and delete other dates so that the macro should understand that I need data only for two periods.
Bookmarks