Maintan copy of cells between worksheet with different relative rows RRS feed

  • Question

  • Hi everyone,
    I am Design Engineer and sending email from Norway.
    I am making Excel spreadsheet for design of members, and using both Macro and Indirect function. I want to write the initial data input in main page, where I want these data should have link to nest worksheet. Worksheet 2 has more info and calculates accordingly, and again some cells are back link to worksheet 1 from worksheet 2, and when I see the final result in worksheet 1, then I proceed with next member.
    How can I solve the problem to copy the table in worksheet 1 and worksheet 2 each time I need without any problems?
    The problem is actually two different relative distance between cells/table (4 and 8) in worksheet 1 and worksheet 2, therefore the relative distance does not match at all.
    Do you have another way to do it/alternative or another option?
    Thanks in advance,
    • Moved by litdev Thursday, March 12, 2015 2:58 PM not a Small Basic question
    Thursday, March 12, 2015 2:20 PM