Hi,
I have a spreadsheet that is created new each month. It has over 1000 lines of data and several columns.
What i then need to do is create a spreadhseet that seperates the data in to new worksheets for all of my technicians (1 worksheet for each technician) then format the spreadsheet so that all matching transaction numbers are grouped together.
Then i need a way to drop the new data each month in to the existing spreadsheet and have it update.
Is there a way to do all of this? i know it is a lot to ask and i would really appreciate any help you could offer.
I have a spreadsheet that is created new each month. It has over 1000 lines of data and several columns.
What i then need to do is create a spreadhseet that seperates the data in to new worksheets for all of my technicians (1 worksheet for each technician) then format the spreadsheet so that all matching transaction numbers are grouped together.
Then i need a way to drop the new data each month in to the existing spreadsheet and have it update.
Is there a way to do all of this? i know it is a lot to ask and i would really appreciate any help you could offer.
