Canadianexcel
New Member
- Joined
- Dec 23, 2010
- Messages
- 39
Good Morning,
Need a bit of help to get my thinking straight. I have been working on a small project and need a little help to work through the logic. This is what I want to accomplish
- Sheet 1 I have a few Data validation list range D1:D5
- Sheet 2 I want to copy the values from D1:D5 but the ability to do an override through a data validation list which I have.
I know I can do a =Sheet1!D1 on Sheet 2 D1 however that formula will disappear once the override is done.
Any ideas would help.
Need a bit of help to get my thinking straight. I have been working on a small project and need a little help to work through the logic. This is what I want to accomplish
- Sheet 1 I have a few Data validation list range D1:D5
- Sheet 2 I want to copy the values from D1:D5 but the ability to do an override through a data validation list which I have.
I know I can do a =Sheet1!D1 on Sheet 2 D1 however that formula will disappear once the override is done.
Any ideas would help.