Hi everyone;
I have an excel spreadsheet with several different tabs. One of the tabs is a summary tab, where we input information from all the other tabs, right now we have to rummage through all the tabs and locate the information and manually enter it.
in the first column there is a stand set of information (employee names), in the first row on each tab.
What i would like to be able to do is create a drop down list of employee names on the summary tab, and based on that selection, fill in certian cells, with information from the other tabs in that workbook.
geez i hope that makes sense.
I am a bit unsure if I am looking at a vb script for this or some messed up version of HLookup and Vlookup.
I'm certianly not an excel expert, I can do some basic stuff, any help or guidance would be appreciated.
Thanks
Gary
Bookmarks