Hello,
I’ve tried to find out how to bring over an entire row over to another sheet if it contain the Name I want.
I think I’ve done this in Google Sheets using “Sort”
So I have content in Cells A - E. (Sheet: Employee) (Range: A6:E1000)
A: Date
B: Employee
C: Department
D: Hours
E: Notes
In a new sheet (Sheet: Bob)
The name of the employee will be in cell A1. (A1 Will be exactly the same name from the employee sheet)
If the name in A1 is located in the employee sheet, I want to display Columns, A, C, D, E. From Sheet: Employee, Range: A6:E1000 (NOT COLUMN B FROM EMPLOYEE SHEET)
Also, The Employee name will repeat through out the Employee Sheet. So Bob Could Be on row 2, 5, 10, 100 and so on.
On The Bob Sheet This formula will be located in cell A14.
From The data in The Employee Sheet Display As:
A: Date
B: Department
C: Hours
D: Notes
(We are not bringing over the employee name, located in Employee Sheet, Column B)
Each employee will have there own sheet and will bring in all the data from the employee sheet.
After the template is created, I want to be able to duplicate the sheet and place a different employee name is cell A1 and have it populate the same information.
Thanks So Much!!!
Bdenn.