VBA Yearly Figures Dependent On Column Headings

[hobbiton73]

Hi, I wonder whether someone may be able to help me please.

I recently made a post here: http://www.excelforum.com/excel-prog...-headings.html where I was fortunate to recive some excellent help from members of this forum.

As you will see in the later posts, one of the solutions was provided by @Leith Ross, which I decided to use, but unfortunately I've across a small problem whilst I've continued to work with the code.

In my message no. 13 on the post I've highlighted the problem below.

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.

I've tried to rectify this over that day or so, but I've been unable to do so. I just wondered whether you could possibly take a look at this please.

To help I've re-attached the last file you post with the code and highlighted the row on the "All Data" and "Desired Output" sheets.

I appreciate that people are very busy and I'm very sorry to take people away from their daily business, but I just wondered whether someone could possibly look at this please and offer some guidance on how I may overcome this.

I've attached the file to highlight the issue.

Many thanks and kind regards

Chris

[hobbiton73]

Hi all, I was unable to contact the original author of the code so I made a post here:http://www.vbaexpress.com/forum/show...act&highlight= where you will see I received that little bit of help I needed.

Many thanks and kind regards

Chris