Calculations based on export data

[fortmillers]

I run an export every month from Quickbooks - it is for accounting actuals for my company. It's a horrible format and not meant for external users. I'd like to create a more user-friendly template where, when I export the data, it automatically populates into my template as well. This would of course save me the trouble of manually moving the data over and save the potential for errors. Is this even possible and how would it work if so?

Thank you.

 

[offthelip]

That sort of task is done very easily using macros. If you haven't used macros before , try recording a macro and then move all the date manually . This will create a macro that will be very inefficient and probably won't be very reliable but is a good place to start.
Ths forum could help you improve it.