Hi,
Really having issues copying data to another sheet, i have tried copy/paste, copy dest, value = value, array etc. i have also tried all the manual calculation, nodisplayalerts and all the other usual things. When running on a non shared workbook with others, it works perfect no issues can run as many times as you wanted instantly, soon i share the workbook with others, thats when the fun begins, usually the first time it will run fine and fairly quick, the second time onwards, i could go and make myself a cup of tea/coffee before it completes. the status bar shows filling cells and the turtle with a pencil comes out writing out the cells. i have spent the last week pulling my hair out and searching all over the web and cannot find anything.
I have tried creating a new sheet incase there was an issue with the old still the same, tried disabling track history, on the local HDD, on the network, original i was copying from another workbook, so i have tried in the same workbook, all the same. below is the latest code im trying, i dont fully understand it as not used arrays before, but seems to work no shared. i will eventually have this putting data on multiple sheets, on a for loop somehow, but at the moment i need to get it working on one sheet. What am i missing ? seems like its not closing of previous run.
![]()
Please Login or Register to view this content.
Sample data
Site Emp # FirstName LastName InTimestamp OutTimestamp ScheduledShiftID
1234 987654321 Joe Bloggs 26/09/2023 10:00 26/09/2023 16:00 11456259
1234 876543210 Jane Doe 29/09/2023 10:00 29/09/2023 16:00 11456261
1234 765432109 Captin America 03/10/2023 10:00 03/10/2023 16:00 11485315
Bookmarks