I’m using IF formulas based on a drop down list to pull data from various tabs
I.e. monthly P&L reports. When the period is selected from the drop down list the specific data I’m looking for populates in the sheet
In this sheet I want the user to be able to add comments in the cells next to the data
When the period is altered via the drop down list, I want the comments to change too so they are relevant to the corresponding periods.
Could anyone help with the vba script suggestions?
I.e. monthly P&L reports. When the period is selected from the drop down list the specific data I’m looking for populates in the sheet
In this sheet I want the user to be able to add comments in the cells next to the data
When the period is altered via the drop down list, I want the comments to change too so they are relevant to the corresponding periods.
Could anyone help with the vba script suggestions?
