Hello,
I currently have a sheet that has the following columns: Primary, Address, Tenant, (Other columns)… Task1, Task1 vendor, Task1 Fee, Task1 paid via, Task2, Task2 vendor, Task2 Fee, Task2 paid via, Task3, Task3 vendor, Task3 Fee, Task3 paid via,…Task7, Task7 vendor, Task7 Fee, Task7 paid via.
I'd like to copy the rows to another sheet based on the Task Vendor* names where each task is on a seperate line or can be grouped together in a summary sheet to get totals for that vendor.
If Task1, Task3 and Task 7 were performed by Joe, I'd like the rows to be either copied to that vendors sheet or use a summary sheet but I need each task listed as a seperate line under Joe. Task2 and Task5 are done by Pat.
Joe (Tasks in Summary sheet or copied to Joe's sheet)
Primary, Address, Tenant,… Task1, Task1 vendor, Task1 Fee, Task1 paid via
Primary, Address, Tenant,… Task3, Task3 vendor, Task3 Fee, Task3 paid via
Primary, Address, Tenant,… Task7, Task7 vendor, Task7 Fee, Task7 paid via
Pat (Tasks in Summary sheet or copied to Pat's sheet)
Primary, Address, Tenant,… Task2, Task2 vendor, Task2 Fee, Task2 paid via
Primary, Address, Tenant,… Task5, Task5 vendor, Task5 Fee, Task5 paid via
The goals is to be able to easily get a list with totals for a certain vendor for all tasks performed where each address is separated. I need help with how to approach this as I am going nowhere with what I have tried.
Thanks in advance!
Lisakay
