• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. V

    Creating auto-populating workbooks

    =INDIRECT("Original!R"&ROW(Original!A19)&"C"&COLUMN(A1),FALSE) Is the second Original what is causing the problem? Testing without now. Edit - Seems to be working properly, must have gotten that inserted incorrectly. Will adjust the spreadsheet and update accordingly. Thanks!
  2. V

    Creating auto-populating workbooks

    So the formulas still link to the original. Ex - when I insert a new row, the formula adjusts accordingly. Is there a way to set it to NOT update and stay static? I believe it has to do with $ signs in the formula but I can't get it to work right. I guess, let me try and explain it this way...
  3. V

    Creating auto-populating workbooks

    Re: Luke Thanks! Ill start playing with those formulas and get back to you
  4. V

    Creating auto-populating workbooks

    Hey all, So I've been googling for a few hours and can't find anything, thought I'd come here to ask. I am trying to build two sheets, lets call them Original and Distribution. The end goal is to have the Distribution sheet pull out relevant data from the original so as to present it in a...
Back
Top