chuckles1066
Banned
- Joined
- Dec 20, 2004
- Messages
- 372
Hi,
Hope someone can help, you guys haven't failed me yet
I have inherited a task at work which is currently being done manually and takes about 3 hours
I have a spreadsheet. In column A there is text stating "jobs allocated to" followed by a workman's name (e.g "jobs allocated to chuckles1066").
There then follows a list of jobs and then a row of "*" which terminates his list of jobs.
Then the sequence repeats, "jobs allocated to", a list of jobs and then a row of "*".
I have to CTRL-F, find the next instance of "jobs allocated to", highlight everything above that, cut and paste it into a new workbook and save it as the name of the workman.
Can I automate it?
TIA.
Hope someone can help, you guys haven't failed me yet
I have inherited a task at work which is currently being done manually and takes about 3 hours
I have a spreadsheet. In column A there is text stating "jobs allocated to" followed by a workman's name (e.g "jobs allocated to chuckles1066").
There then follows a list of jobs and then a row of "*" which terminates his list of jobs.
Then the sequence repeats, "jobs allocated to", a list of jobs and then a row of "*".
I have to CTRL-F, find the next instance of "jobs allocated to", highlight everything above that, cut and paste it into a new workbook and save it as the name of the workman.
Can I automate it?
TIA.