G
Guest
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,...
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,...