Hello...
I'm writing a macro that creates a summary worksheet that references data from other worksheets. I want the summary page to be dynamic so that if the user changes drop downs on other pages, the cells update accordingly.
For example cell G2 = "=worksheet2!A2" which equals "Tree"
User makes a change to a dropdown menu on worksheet2 and A2 now equals "Flower" The cell G2 on summary page should now = "Flower"
In RC notation it would look something like this:
Range("G2").Select
ActiveCell.FormulaR1C1 = "=worksheet2!R[-7]C"
Wondering if there were other ways to write this...
I'm writing a macro that creates a summary worksheet that references data from other worksheets. I want the summary page to be dynamic so that if the user changes drop downs on other pages, the cells update accordingly.
For example cell G2 = "=worksheet2!A2" which equals "Tree"
User makes a change to a dropdown menu on worksheet2 and A2 now equals "Flower" The cell G2 on summary page should now = "Flower"
In RC notation it would look something like this:
Range("G2").Select
ActiveCell.FormulaR1C1 = "=worksheet2!R[-7]C"
Wondering if there were other ways to write this...
