May 18 2023 09:38 AM
I have created a fairly large IF formula as a source for Data Validation. I want to copy and paste that formula into the source in Data Validation. Any ideas on how I can do this?
May 18 2023 09:53 AM
Select the cell with the formula.
Select the formula in the formula bar and press Ctrl+C to copy it.
Select the cell or cells for the Data Validation rule.
On the Data tab of the ribbon, click Data Validation.
Select List from the Allow drop down.
Click in the Source box.
Press Ctrl+V to paste the formula.
Set up an input message and error alert if you wish.
Click OK.
May 18 2023 10:14 AM
That is weird - it's the way I always do it...