Hi All
I have 2 sheets with almost 300k rows of data..
The columns are from A to Q
the dates, agent name and start times and times are sorted to sort each agent schedule that day
I need to have a macro that loops through every day and checks to see if an agent had any activity that say Lunch, if it does i need to cut that whole shift (that days shift and paste it into the sheet called - (Not Needed)
Date in Col A
Agent Name in F
Agent Activity in Col G
Start time of activity in H
End time of activity in I
I cant process it in the sheet straight away it takes forever to calculate hence why an array approach should be better and the paste the values in at the end but im struggling to do that
Please can someone help me
I have 2 sheets with almost 300k rows of data..
The columns are from A to Q
the dates, agent name and start times and times are sorted to sort each agent schedule that day
I need to have a macro that loops through every day and checks to see if an agent had any activity that say Lunch, if it does i need to cut that whole shift (that days shift and paste it into the sheet called - (Not Needed)
Date in Col A
Agent Name in F
Agent Activity in Col G
Start time of activity in H
End time of activity in I
I cant process it in the sheet straight away it takes forever to calculate hence why an array approach should be better and the paste the values in at the end but im struggling to do that
Please can someone help me
Last edited: