Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
This one requires the Excel guru's or any one with an answer!
What I need to do is the following. I have part of it working already, but, still miss additional information. I have an application which contains data for employees names on a sheet called "EmpData". The data is listed as column and cell A2 - Employee Name, then, by month (Jan, Feb, March, Apr, May, Jun, Jul - Dec) In the columns F - Q where the month are listed are Jan - Dec row 5 (Gross Income), row 6 = Fed IncomeTax, row 7 = State IncomeTax, row 8 = Social Security, row 9 = Fica. What I want or would like to do is select the employee name from a dropdown combo box on a sheet called "Review" pull and have the selected target cells populated with the respective data from a sheet called "EmpData", is this possible? I guess that Index - Match may not be enough to pull everything I need. I also need to have any blank vertical cells between the employees names filtered out or dropped. Any ideas or samples spreadsheet providing a solution will be welcomed! I hope my explanation was clear, if not, post any questions you may have... Thanks,... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Index, Match and filters | Excel Discussion (Misc queries) | |||
VLookup or Index Match or ??? | Excel Worksheet Functions | |||
Function Vlookup, Match or Index? | Excel Worksheet Functions | |||
Need help with HLOOKUP and MATCH functions | Excel Worksheet Functions | |||
Vlookup and Hlookup | Excel Worksheet Functions |