Hi,
I was hoping someone could tell me how i create a list depending on a value....
i.e. If cell A1 = 1, I want cells A2:A10 to be the same as cells C2:C10
BUT,
If cell A1 = 2, I want cells A2:A10 to be the same as C2:C10.
Can anyone help?
Thanks,
Joe
Bookmarks