I am a newbie in macro. I tried recording a macro doing copy and paste. There are around 5847 values from Sheet1 to be copied to Sheet2. The recorded macro looks like this:
I want to repeat the process but recording it will be too tedious. I hope I can loop the process but I don't know how. Can anybody help me please? I have attached the file.