So I've got a seemingly simple problem that I haven't been able to figure out.
In column A, I have dates. Column B has a job type. Column C has payment. Here's a sample workbook to show what I mean
Sample.xlsm
Now, what I want to do has two parts:
First I want to find the first instance of Job "1" (B1), then count down until it reaches Job "2" (B6).
The second part is to copy all the cells from A1 to C5 (All of the Job 1s on 12/1). Then paste that data into the sheet "Job1".
Then continue and find the next instance of job "1" in column B and count down until it reaches the next job type, etc.
Now, I can figure out how to get the second part to work. I'm having trouble with the first - counting the cells between Job "1" and "2" in order to copy only the data pertaining to job "1"
I realize this would be easy if I just filled B2:B5 with job "1", but my boss likes the current layout.
Thanks
Bookmarks