Results 1 to 2 of 2

Thread: Create a template for importing changing Quickbooks reports

  1. #1

    Create a template for importing changing Quickbooks reports



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    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
    Hope that helps

    Roy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •