Automatically change validated entries when source of validation list changes

[suchetherrah]

Hi
I am quite new to macros.

First,
At "BuildMaster" sheet, update host and IP. Automatically concatenate at column F12 onwards after doubleclick at column A of the last row

Second,
Go to "TrafficFlow" sheet, Cell B3 sand B4 will have Data Validation. When user double clicks at column A of last row automatically add with Data validation.


Error : Data validation doesn't automatically updates when the changes is done at "BuildMaster"

Can concatenate incorporate into the VBA and then appears at the Data Validation at "TrafficFlow" sheet?

Appreciate your assistance in finding a solution.

[suchetherrah]

Hi,

Would like to have your assistance for a solution.