I dont know if this is in the right section but heres what I am trying to do, let me know if you can help.
I have a list in one column on sheet A
I need to take the first cell in the list and link it to cell say A2 on sheet B
Then take the next cell from the list and link it to cell A2 on sheet C
Is there a way to get excel to grab the next cell from the list and continue linking it through the rest of the sheets?
It is a rather long list and dont want to have to manually link each item.
Thanks for any help.
Bookmarks