COPY PASTE USING VBA CODE

[JomarFrogoso]

I have this problem. I want to create another workbook and paste the values of specific starting cell and select down to the end. Then, I want to copy the values starting at cell AP41.
the sample output was shown in the picture output1. in my source file, I have 100 sheets, I want to loop on the sheets, and copy paste the values to the new workbook.

 

[OaklandJim]

This SEEMS pretty doable. I can't promise that I can do this but I'll try.

If you want assistance you are more likely to get help if you help the helper so they do not need to guess about or recreate your data.

Pictures are not very helpful. If the data is not confidential post a link to your workbook. If necessary you can enter fake-but-realistic data before providing the link. Put the file on Dropbox, Box, 1Drive, Google Drive etc. Use the link icon above the message area. Make sure that other people can access the file!

You say that there are 100 worksheets with data. If you can provide a link to a workbook with fake data provide at least three data sheets to work with for testing.

Regarding "serial number entered into F3"...is the list of serial numbers that user may enter into F3 S/Ns from all worksheets or just in worksheet In? It seems that the list of S/Ns that user may enter contains all S/Ns from all worksheets: In, WIP, Bad and Good. Will there be other worksheets? If so what are their names?

Regarding sheet names...I'm interested to know if there will be other worksheets that do NOT contain a table of S/Ns in their data or other worksheet that WILL contain a table of S/Ns?