Hi, I'm still a novice on VBA. I'm trying to create a macro but failing miserably, if anyone could help please.
I have a moving value (e.g.Mar 14, Apr 14, May 14, etc). Then I have columns with headers matching those values. I need to create a macro to insert a column where that value is found, basically this inserted column would be used to sum numbers in that row. For e.g. If the criteria is 'Find May 14', then a column would be inserted after that column in which Heading May 14 is found. This inserted column would then sum the values from Mar 14, Apr 14 and May 14. If The criteria is set to Apr 14, then I need to be able to delete the previously inserted column (in this case colunm which was insterted after May 14) and move it to after the column in which Heading Apr 14 is found.
I have a spreadsheet where i'm constantly required to perform this task and it is not coming to a point where its unbearable to keep on inserting, deleting and formulating the cells. A a macro to do this would improve my time considerably.
Attached spreadsheet shows what I'm trying to automate. Any help would be great, thank you!
Bookmarks