Hi all,
This may sound silly (and maybe i'm just underthinking it), but i have a spreadsheet which is used as a Workflow for my team. Each row is an item, and i need to assign each item to one of the staff working on the workflow (currently 3 staff, but I see this increasing soon).
The workflow has approximately 500 rows of data at any time, but everyday there are new rows added (new tasks), and some rows removed (tasks completed).
There is a macro that imports all the information and formats etc to the new rows.
Essentially, what i'd like to do is to add to the macro (or create a new one) that will find any rows without a value in Column X (being what column i allocate the staff member in), and then populate a random staff members' name, while keeping roughly even distribution of rows (at least in the new rows on any given day).
I've had a look at the randbetween and choose functions, but every time a cell is updated, the formula resets, and a new outcome is derived.
Essentially, i'd like it to run once, and permanantly allocate that 1 task to 1 staff member, and not change.
I can see it being a very simple macro to do so, but i've been out of the macro realm for too long, and my brain hurts trying to come up with the solution. Is anyone able to assist me please?
Cheers
This may sound silly (and maybe i'm just underthinking it), but i have a spreadsheet which is used as a Workflow for my team. Each row is an item, and i need to assign each item to one of the staff working on the workflow (currently 3 staff, but I see this increasing soon).
The workflow has approximately 500 rows of data at any time, but everyday there are new rows added (new tasks), and some rows removed (tasks completed).
There is a macro that imports all the information and formats etc to the new rows.
Essentially, what i'd like to do is to add to the macro (or create a new one) that will find any rows without a value in Column X (being what column i allocate the staff member in), and then populate a random staff members' name, while keeping roughly even distribution of rows (at least in the new rows on any given day).
I've had a look at the randbetween and choose functions, but every time a cell is updated, the formula resets, and a new outcome is derived.
Essentially, i'd like it to run once, and permanantly allocate that 1 task to 1 staff member, and not change.
I can see it being a very simple macro to do so, but i've been out of the macro realm for too long, and my brain hurts trying to come up with the solution. Is anyone able to assist me please?
Cheers