collate data from 3 worksheets to summary

[prabhuduraraj09]

Hi all,

could somebody help to achieve the below

collating data from 3 different worksheets to summary sheet, along with the data i need to know the sheet name

Output should be like below

[Winon]

Hello prabhuduraraj09,

What would you want to do if there happens to be any duplicates. Do you want the Sheet Names to be in sequential order, or the Products.

Please give us more details of your desired outcome by attaching a sample workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

[prabhuduraraj09]

Hi winon,

Thanks for looking into this, i have now here by attached sample workbook.

if there is duplicates i want as it is, duplicates should not be disturbed.
the sheet name should be sequential.

The expected results are in summary sheet.

Let me know for any further information.

[Winon]

Hi prabhuduraraj09,

Thank you for the extra information.

Place the Code below in a Standard Module;

Please Login or Register  to view this content.

Please try the attached sample.

Regards.

[sintek]

Another possibility....

Please Login or Register  to view this content.

[mike7952]

Another way

Please Login or Register  to view this content.

[Winon]

Thank you for your contributions guys,

@ sintek,

You could change your Code as shown below, to be more complete;

Please Login or Register  to view this content.

@ mike7952,

Your Code also goes begging for completeness;

Please Login or Register  to view this content.

With that said, and since you guys don't seem to like my first attempt, I shall still fly my kite, without using any looping;

Yet another approach:

Please Login or Register  to view this content.

Try the revised sample Workbook now.

Kind Regards.

[sintek]

@ Winon...Thanks for feedback.

With that said, and since you guys don't seem to like my first attempt

Not the case at all. I know from experience that when I was OP, I appreciated all alternatives suggested. It made learning easier and more complete.
Currently, it seems the norm for members to share their alternate solutions. Was only trying to contribute.

[Winon]

@ sintek,

As I have stated in my reply to you guys: "

Thank you for your contributions guys,

Yes, it is the norm for members to share their alternate solutions, and I appreciate all contributions, which explains my comments. Sorry if it came over wrong or offending. It is not my intention at all.

Best Regards.

[mike7952]

@Winon 

Just checking if your paying attention.

Please Login or Register  to view this content.

[Winon]

Hello prabhuduraraj09,

I notice that you visited the Forum a couple of times, after some additional solutions were offered in this Thread, without any comment?

With the Code in the above attached sample Workbook, you may change Sheet Names, without having to touch the Code.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thank you.

[prabhuduraraj09]

hi all,

Winon, mike, sintek thank you so much for your contribution and alternative suggestions.

The solution provided by winon and mike suits more precisely. Thank you guys.

[Winon]

Hello prabhuduraraj09,

You are welcome.

Thank you for your response by marking this thread as solved and for the Rep points. It is much appreciated!

Regards.