Forum

Notifications
Clear all

Automatic filtering for different files that will save a lot of work time

2 Posts
2 Users
0 Reactions
68 Views
(@usb)
Posts: 244
Honorable Member
Topic starter
 
Hi, I have a manual action that repeats itself over and over again
and want to check a way to shorten the process.


The manual operation is like this -
Every day I screen a salesperson copying and pasting the information into a separate file
This should be done 100 times for 100 salespeople
Also every day there is a different list of salespeople.
How can you shorten the process and make it automatic????
Thanks!! This will help and save me a lot of unnecessary time and effort
Leah
 
Posted : 26/04/2023 6:25 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Leah,

Really difficult to give you anything other than generic advice without seeing an example of the data, and specific instructions on what data is copied/pasted, and what your end result should look like.

You could maybe use Power Query.

Regards

Phil

 
Posted : 26/04/2023 8:37 pm
Share: