Excel and VBA - Data Query and Sage Line 50

[axl2derv]

Hi

I have used Excel to create a data query for Sage Line 50. From this data, I created a P&L and Balance Sheet using all of the nominal information.

The problem I have is that I have a massive P&L and Balance Sheet due to all of the nominal codes being listed even though they do not have values.

My spreadsheets have the months of the year across the top and the nominal codes down the side and I use Vlookup to pull the data from the table.

I need to find away to only pull the nominal codes through that have values attached to them and when I refresh my table, it will add any new codes to my P&L or Balance Sheet.

I think I may need to use VBA for this but I am not familiar with this part of excel.

Thanks.