Covert Current Formula based Sheet to Macro Based

[Tyrion16]

Hi All,

I was using the attached formula based sheet IBG 1 Metrics_New.xlsm - it was limited to tabs "Base_Data_Trimmed" and "Current Summary_Formula Ref".

This basically lets you see metrics of that particular month.

I used to then manually take values of every month and try and do a trend.

Off late, this is becoming a very time consuming process as the number of units and the size of the units keeps increasing.

Is there anyway to have a macro do this?

I was trying to attempt a code but not getting anywhere.

What I am trying to do now is to get data of each individual metric into separate tabs(all the green highlighted tabs).



The macro should basically update values for that month automatically(maybe on command click) once new data for that month is added to "Base_Data_Trimmed" sheet.

This way it would be much easier to trend.

Any help is appreciated !

PS: I am posting this query here because did not get any reply on another forum for a considerable period of time. Hope its fine to cross post in such cases.
Do let me know in case I am in violation of any rules. Link of the other post is : http://www.ozgrid.com/forum/showthread.php?t=190653


Thanks,

[stanleydgromjr]

A message to forum cross posters

Please read this:
http://www.excelguru.ca/node/7

[sktneer]

I think you can achieve this by Worksheet_Activate codes on the Green Sheets modules. Please find the attached sheet where once you select a green colored sheet, the data is automatically updated on that sheet based on the data present on Base_Data_Trimmed Sheet. See if this helps.

[Tyrion16]

Thanks sktneer!

Will check it out.

[Tyrion16]

Hi sktneer, this proved really helpful.

Thanks.