Hi,
I have a table on sheet 1 that gets updated when I choose 3 options – opp1, opp2, opp3. I am trying to pull this table onto sheet 2 – where 3 tables of data flow one below the other and get populated when opp1, 2 or 3 are selected. I am trying to write the following macro to achieve that...
Thanks Luke! this was really helpful
Would you be able to help me with the macro - where am trying to say
If a cell in Sheet 2 = ABC then copy paste (as described earlier)
Thanks Again!
Hi,
On Sheet 1 - I have data in a tabular form and have 3 drop downs to select the scenarios. Based on each scenario selected the table gets populated (9rows and 5 columns)
On Sheet 2 - i am trying to replicate the table from sheet 1 for each of the scenarios. the issue is that i want to be...