jwestover1
New Member
- Joined
- Dec 24, 2012
- Messages
- 7
I am 1 week into learning VBA and am really enjoying myself but this project I have is a little over my head for my skill set as of today so any help is much appreciated!
I have an Excel workbook with two sheets 1. Summary and 2. Data. In Data I have data broken down by Category (down Rows) and Months (across Columns). I am basically taking complex data in many categories and summarizing it down into a more high level report by combining categories.
When this WorkBook is opened I would like VBA to search the category titles found in Column A (beginning in Row 3) on Worksheet1 "Summary" and find the data in the Data Worksheet that matches that category and total all of those entries together and place them in the correct space by Month. Hopefully that makes sense if not I am happy to clarify.
I am stuck on using two variables AND getting the multiple values to add together in the target cell. I know I could write the code to find the values and place them in rows under the category but this time I need them added and placed according to Month.
Happy New Year and thank you in advance
I have an Excel workbook with two sheets 1. Summary and 2. Data. In Data I have data broken down by Category (down Rows) and Months (across Columns). I am basically taking complex data in many categories and summarizing it down into a more high level report by combining categories.
When this WorkBook is opened I would like VBA to search the category titles found in Column A (beginning in Row 3) on Worksheet1 "Summary" and find the data in the Data Worksheet that matches that category and total all of those entries together and place them in the correct space by Month. Hopefully that makes sense if not I am happy to clarify.
I am stuck on using two variables AND getting the multiple values to add together in the target cell. I know I could write the code to find the values and place them in rows under the category but this time I need them added and placed according to Month.
Happy New Year and thank you in advance