Copy multiple sheet into one sheet(few row selected from multiple sheet)

If you could upload a sample workbook showing how the data is currently set out and how the worksheet should appear once all the data is collated into one worksheet it would be much easier to give you an answer. Without a sample workbook it is almost impossible to give you an answer. What you require sounds feasible however without a sample workbook it is very hard to help you. Make sure there is no sensitive data in the sample workbook. To upload a sample workbook select Go Advanced, Manage Attachments and upload a sample workbook.

Though this has been answered numerous times before, see how this goes:

Please Login or Register  to view this content.

Robert

Hi smuzoen,
here the example for the excel file.
Some column in the sheet5 left blank due to need manual key in.

Trebor76,

This was not the things i want in my worksheet please kindly check my excel sheet provide

Use the following

Please Login or Register  to view this content.

I left the previous code in attached workbook - the above code is in module 2 - Run macro called combWS

No wonder it does not suit as it is completely different to the sample workbook you provided. My code that I gave you EXACTLY replicated your sample file however this new file is completely different. When I asked for a sample file I needed to know how the data was laid out and this new file bears no resemblance to the sample file.
I will take a look later today and post back a solution unless someone gives you an answer prior. Please try to provide sample files that match your requirements as providing solutions requires time on the behalf of people trying to help.

I cannot workout what has to be copied from Sheet 1,2,3,4 to Output - You highlighted some column headers in Sheets 1-4 Red but I cannot match it to the sample Output sheet. Column A,B,D,F,G,K,L,O are highlighted red in sheets 1-4 -> I can see some matches e.g. POL, POO, Dischvessel in Sheets 1-4 and in output however there are 200+ rows in Sheets 1-4 but only 13 rows in the Output sheet. Could you please explain very clearly the rules/logic on what to copy from data sheets to output. Please be very specific and perhaps provide a small sample showing EXACTLY how the data is shown in Sheets 1-4 and Exactly how the data would appear in the Output sheet. It is obviously clear in your mind however I need to know the rules so I can write the code for you. I am happy to help you however you need to explain what you require very clearly for me please.
Try to supply a small sample workbook so I can see every bit of data that needs to get copied. I can also add in the calculations for you as well (the totals) if you show how they should appear as this can be done automatically. I hope I have explained what I need from you clearly enough.