Here is what I need the Search Loop to do.
In Column B cell "B2" is a changing value depending on the person selected. This is basically a EmployeeID column.
Starring In Column H cell "H2:JZ2" are changing values. These values could be nothing (empty), or contain data.
Here is what I need it to do.
I need it to hunt across the 2nd row again starting at "H2" for the first cell with data, if it finds it, copy that value, and then move down to the employee record that matches the value in "B2". Paste it into whatever cell is at that location.
Then move onto the next cell and hunt for the next value, and repeat. If the cell is blank it should skip it, and not copy and paste as to not overwrite previous data.
EXAMPLE: "B2" cell has a value of 652065489 in it, indicating the EmployeeID of that person. It starts looking at "H2" and finds information at cell "J2" copies that information, moves down to row with the employee record and pastes it in the J column, in the row that matches the EmployeeID (652065489). Then starts over at "K2" and looks for data, then "L2" and looks for data, so on and so forth until it reaches "JZ2" and then stops.
This should eliminate if the employee row changes over time as new employee's come in and leave. Yes? Am I thinking correctly?
This will also be triggered manually by a person pushing an button to "save or update" the record.
Thank you so so much in advance, and if you have questions please ask.
I hope that all makes sense.
In Column B cell "B2" is a changing value depending on the person selected. This is basically a EmployeeID column.
Starring In Column H cell "H2:JZ2" are changing values. These values could be nothing (empty), or contain data.
Here is what I need it to do.
I need it to hunt across the 2nd row again starting at "H2" for the first cell with data, if it finds it, copy that value, and then move down to the employee record that matches the value in "B2". Paste it into whatever cell is at that location.
Then move onto the next cell and hunt for the next value, and repeat. If the cell is blank it should skip it, and not copy and paste as to not overwrite previous data.
EXAMPLE: "B2" cell has a value of 652065489 in it, indicating the EmployeeID of that person. It starts looking at "H2" and finds information at cell "J2" copies that information, moves down to row with the employee record and pastes it in the J column, in the row that matches the EmployeeID (652065489). Then starts over at "K2" and looks for data, then "L2" and looks for data, so on and so forth until it reaches "JZ2" and then stops.
This should eliminate if the employee row changes over time as new employee's come in and leave. Yes? Am I thinking correctly?
This will also be triggered manually by a person pushing an button to "save or update" the record.
Thank you so so much in advance, and if you have questions please ask.
I hope that all makes sense.