Data Import from Financial Package wont match range

Hi,

I have a Profit and Loss that I am exporting from a Financial package into a Excel and I want to automatically update another sheet with the data in this P&L, however the P&L is sometimes missing lines of data e.g. no other income for a particular period and is therefore different in the number of lines from the P&L that it is bringing in and does not update automatically.

e.g in my excel sheet is set up as follows to link
Revenue
Tax
Surplus/Deficit

however the exported data may be

Revenue
Tax
Expenses
Surplus/Deficit

so the expenses links to Surplus deficit etc. Of course the sheet is much bigger and causes some pr0blems.

Any ideas on what I can do about this?

thanks

Brick

You can import your data to a temp sheet, run a macro like this one, and then c&p the data where it needs to go. Just fill in the right column names.

Please Login or Register  to view this content.