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
HTML Code:
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
HTML Code:
Thank you
If I have helped you in someway, use the * icon below to give reputation feedback, it is appreciated.
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.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
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.
Hi prabhuduraraj09,
Thank you for the extra information.
Place the Code below in a Standard Module;
Please try the attached sample.Please Login or Register to view this content.
Regards.
Another possibility....
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Another way
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Thank you for your contributions guys,
@ sintek,
You could change your Code as shown below, to be more complete;
@ mike7952,Please Login or Register to view this content.
Your Code also goes begging for completeness;
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;Please Login or Register to view this content.
Yet another approach:
Try the revised sample Workbook now.Please Login or Register to view this content.
Kind Regards.
@ Winon...Thanks for feedback.
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.With that said, and since you guys don't seem to like my first attempt
Currently, it seems the norm for members to share their alternate solutions. Was only trying to contribute.
@ sintek,
As I have stated in my reply to you 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.Thank you for your contributions guys,
Best Regards.
@Winon
Just checking if your paying attention.
Please Login or Register to view this content.
Last edited by mike7952; 08-12-2017 at 08:57 PM.
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.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks