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
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