I'm trying to learn VBA and I know it would probably be easier to do manually but I would like to learn how to program this as a macro for the sake of the exercise and so that I will better understand how VBA works. Thank you for your time in reading the following:
The attached excel file has monthly data I would like to be able to press a button that will basically start with the data on worksheet 'INF (start)' and after selecting the text from B2:F25 and running the macro you will end up with the data shown on 'INF (desired end)'
Please critique my thought process thus far and then give whatever advice you may have on how to continue.
I figured it would be easiest to start by converting column A to YYYYMMDD format and then 1) generating the figures in 'INF (desired end)' I2:I9 by using the MID() function to grab the 08... and also using that to pull the months and using a ROUNDUP() to get which quarter is relevant but I have no idea how to sum the cells in columns B through F based on criteria defined by the first cell in the row (which obviously becomes one column further each column)
Thank you for your help. This is an exercise I am doing as I am writing an economics thesis that will involve very significant volumes of data and I need to learn VBA in order to be able to handle it (as well as my planned career in economic research). I really appreciate your help and attention.
Bookmarks