Hi,
I have a very basic working knowledge of Excel, but currently a bit stumped as to where to go to find out how to a) insert a drop down menu and b) transfer information from one worksheet cell onto another eg Sheet 4 A104 to Sheet 7 B18. I have tried a couple of formulas but they just flash up #value, so I don't think I'm applying them correctly.
If someone could point me in the right direction for an article on the site, or just let me know how to do either, I'd be really grateful. I am on an administrator controlled computer, so can't download any extras.
Thanks again for all your help!
I have a very basic working knowledge of Excel, but currently a bit stumped as to where to go to find out how to a) insert a drop down menu and b) transfer information from one worksheet cell onto another eg Sheet 4 A104 to Sheet 7 B18. I have tried a couple of formulas but they just flash up #value, so I don't think I'm applying them correctly.
If someone could point me in the right direction for an article on the site, or just let me know how to do either, I'd be really grateful. I am on an administrator controlled computer, so can't download any extras.
Thanks again for all your help!