hobbiton73
05-08-2014, 07:46 AM
Hi, I wonder whether someone may be able to help me please.
I made a post here http://www.excelforum.com/excel-programming-vba-macros/1008263-vba-create-yearly-extract-using-column-headings.html in respect of a problem I was encountering in adapting existing code.
I was very fortunate in receiving two possible solutions, with which I chose the one kindly provided by @Leith Ross.
As you will see from the link above, in particular message #13, that I've come across a problem which I've tried to engage with the author of the code, but sadly been unable to do.
I've noticed that in the case of where there is a row of data on the "All Data" sheet with a date in column J prior to my first column on the "Desired Output" sheet i.e. "April 14", although the value is correctly not paste to this sheet, the "Description", column I on the "All Data" Sheet is still shown in column B on the "Desired Output" sheet, thus creating a blank row.
As you also see I have tried over the last couple of days to find a solution, my knowledge has let me down.
I just wondered whether someone could possibly look at this and offer some guidance on how I may overcome the problem, or indeed, if you feel that there is a better solution offer guidance on how I can overcome my original problem.
I've uploaded the file here: https://www.dropbox.com/s/jfpcepzxzb0zb7u/Sum%20Categories%20Test2%20ver%201%20Re-submitted.xls
Many thanks and kind regards
Chris
I made a post here http://www.excelforum.com/excel-programming-vba-macros/1008263-vba-create-yearly-extract-using-column-headings.html in respect of a problem I was encountering in adapting existing code.
I was very fortunate in receiving two possible solutions, with which I chose the one kindly provided by @Leith Ross.
As you will see from the link above, in particular message #13, that I've come across a problem which I've tried to engage with the author of the code, but sadly been unable to do.
I've noticed that in the case of where there is a row of data on the "All Data" sheet with a date in column J prior to my first column on the "Desired Output" sheet i.e. "April 14", although the value is correctly not paste to this sheet, the "Description", column I on the "All Data" Sheet is still shown in column B on the "Desired Output" sheet, thus creating a blank row.
As you also see I have tried over the last couple of days to find a solution, my knowledge has let me down.
I just wondered whether someone could possibly look at this and offer some guidance on how I may overcome the problem, or indeed, if you feel that there is a better solution offer guidance on how I can overcome my original problem.
I've uploaded the file here: https://www.dropbox.com/s/jfpcepzxzb0zb7u/Sum%20Categories%20Test2%20ver%201%20Re-submitted.xls
Many thanks and kind regards
Chris