Results 1 to 6 of 6

Thread: Syncing a Worksheet

  1. #1

    Syncing a Worksheet



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

    I've got a Rental Summary that I fill out when taking an order from a customer and within my template I've got a separate worksheet that I would hand to the technician to prepare the rental order.

    I'd like to be able to have the Rental Summary I fill out auto-populate the worksheet I hand to the technician. Is this possible?

    Thanks in advance.

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    718
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Mountains, the answer to your question is... yes it's possible.




    Achieving what you want requires knowing what you're starting with and what you're wanting to end up with.
    Posting a sample workbook with the Rental Summary filled out and the worksheet you give the technician would go a long way to increase chances of assistance.

  3. #3
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    You need to attach the workbook for a proper answer.

    This formula will copy the entry from Sheet1, cell A1 to the cell containing the formula

    =Sheet1!A1
    Hope that helps

    Roy

  4. #4
    Hopefully my attachment works.

    If so, I'm trying to have the info I enter into the "Client Rental Summary" worksheet (quantity and respective pricing formulas) to auto populate the "Drop-Off Take down Checklist" which I would give to whomever is assigned to setting up and taking down the rental equipment. Make sense?
    Attached Files Attached Files

  5. #5
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    718
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Mountains, follow Roy's suggestion.

    Start with the quantities of rental items so you see it works.
    Maybe the order of the items in the quantities sections are different for a reason, but if the layouts were the same then you would be able to set the formula in cell A21 of the checklist and just drag it down for the rest of the items.

    The date, name, location section will be more challenging because of the merged cells.
    You may want to do away with merged cells and use horizontal alignment of 'center across selection' instead.

    Good Luck with the project.

  6. #6
    Thanks for the pointers, I've got my workbook ironed out that way I need it and have implemented. Done and done!

Posting Permissions

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