Pulling Data from multiple sheets to master.

[td0g906]

Hello all
I'm learning new things as I go and appreciate any help. I will have multiple sheets that are identical. I want to pull all the data from the sheets to the master at the end of the day. The sheets will be named C1 and C2, and this will be in reference to the work cell where the product is being scrapped, and "master" will be where I want all the data pulled too. I used the record button and saw the code that it generated and simply copied it and changed the relevant information, row, sheet name to pull the data. I got it to work but it pulls all the data including blank cells. This makes the master copy have blank spaces because some days the sheet will use 10 rows and others it will only use a couple, but when recording the script I had to include all potential cells. Any recommendations would be helpful.

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach screenshots (not pictures) of your two sheets. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Do you want to copy all the data from each sheet or only some of the data? Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).