Hi,
I have data in a sheet as follows
Column A Column B
US Shift Employee 1
UK Shift Employee 2
IST Shift Employee 3
UK Shift Employee 4
IST Shift Employee 5
US Shift Employee 6
.... ....
.... ....
.... ....
.... ....
What I am currently doing is, fetching data of US shift and pasting it in next sheet using 'for' loop
I have around 5000 employees data, it takes much time if we are fetching and pasting data using for loop (similiary we are getting data for UK, IST and some other filters)
Instead of copying and pasting one by one, is it possible to copy all 'US Shift' at a time and paste it all at a time?.
Bookmarks