Create a template for importing changing Quickbooks reports

quickestyet

New member
Joined
Jun 7, 2013
Messages
1
Reaction score
0
Points
0
I need to create a template in Excel 2010 that I can use when exporting Quickbooks reports to Excel.
The data exported changes monthly & the number of cells populated by the data are increased & decreased accordingly, thus the formulas tied to those cells are ineffective.
Is there a way to setup a template that self adjusts the formulas to include new cells & adjust to less cells as the report changes. Currently I'm importing the report from Quickbooks to a new worksheet, opening a saved old worksheet with the formulas & editing the formula to adjust to the correct cell letter/number. It sure would be great if I cound just export the data to a template that would automatically apply the formulas to the appropiate cells.

Thanks for some help
 

royUK

New member
Joined
Mar 22, 2011
Messages
155
Reaction score
0
Points
0
Location
Derbyshire, UK
Website
www.excel-it.com
Excel Version(s)
most versions
I can't see you getting much help. You give no information on the layout of the data or what formulas you are using.

A sample workbook would help
 
Top