Hi everyone,
I've got a problem that's driving me crazy as I can't work out how to do it, and was wondering if any of you excel geniuses can work it out?
So..
I have a video of a mouse (see sheet 1 column A) I want to put this video of the mouse on the websites listed in Sheet 1 column B (i.e, youtube, facebook, etc)
In sheet 2 I have the websites listed in column A. Whenever I add a new video to sheet 1, i.e "cattle" and list what websites I want to put it on, I want that new video to automatically be added to column B, sheet 2 for every corresponding website.
So "cattle" should be added to myspace and Bebo, etc
I have attached a print-screen to demonstrate how i want it to look.
Please let me know if anyone knows how to do this and it would help me out so much.
Look forward to hearing from you all!
Thanks
p.s. no, I am not on drugs, just quite a hard one to explain! lol
Bookmarks