G
Gita at CASTLE
Hi,
I have a workbook with multiple worksheets. The first 2 worksheets are the
data source sheets; they are very similar and look something like this:
Mon Tue Wed Thu
Fri
Area 1
Emp 1
Emp 2
Area 2
Emp 3
Emp 1
etc. Approximately 15 different areas, and over 30 employees located
throughout.
What I have is a separate worksheet for each employee, and I would like them
to look at the 2 data sheets and pull the data for that employee only.
The source sheets cannot be sorted by employee - they have to stay arranged
by 'area'. Therefore, HLookup won't work.
I currently have an IF statement, a separate one for each row, which does
bring the data over correctly, but I have over 150 rows of data in the 2
source sheets, therefore over 150 rows in the separate employee sheets, but
maybe with only 5 rows of actual figures.
So then I thought I'd group the worksheets and sort on them all at once, but
Excel won't let me do that.
Please help... Is there someway I can achieve this?
Thank you!
I have a workbook with multiple worksheets. The first 2 worksheets are the
data source sheets; they are very similar and look something like this:
Mon Tue Wed Thu
Fri
Area 1
Emp 1
Emp 2
Area 2
Emp 3
Emp 1
etc. Approximately 15 different areas, and over 30 employees located
throughout.
What I have is a separate worksheet for each employee, and I would like them
to look at the 2 data sheets and pull the data for that employee only.
The source sheets cannot be sorted by employee - they have to stay arranged
by 'area'. Therefore, HLookup won't work.
I currently have an IF statement, a separate one for each row, which does
bring the data over correctly, but I have over 150 rows of data in the 2
source sheets, therefore over 150 rows in the separate employee sheets, but
maybe with only 5 rows of actual figures.
So then I thought I'd group the worksheets and sort on them all at once, but
Excel won't let me do that.
Please help... Is there someway I can achieve this?
Thank you!