Hi,
Been trying to create data validation in cell D3 which looks at cell C3 and then displays the relevant data validation options ignoring blanks if any.
Also is there a macro that can run when any information in cells A2 is changed then cells B2, C2 and D2 are deleted. If information in cells B2 is changed then cells C2 and D2 are deleted. If information in cells C2 is changed then cell D2 is deleted.
Please see the sample sheet, any help is much appreciated.
Thanks
Been trying to create data validation in cell D3 which looks at cell C3 and then displays the relevant data validation options ignoring blanks if any.
Also is there a macro that can run when any information in cells A2 is changed then cells B2, C2 and D2 are deleted. If information in cells B2 is changed then cells C2 and D2 are deleted. If information in cells C2 is changed then cell D2 is deleted.
Please see the sample sheet, any help is much appreciated.
Thanks