How to merge data ranges
- Thread starter prazad82
- Start date
SirJB7
Excel Rōnin
Hi, prazad82!
If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, maybe you find useful information and even the solution (if I don't remember wrongly I've seen many topics like this one). If not please advise so as people who read it could get back to you as soon as possible and consider uploading a sample file (including manual examples of desired output), it'd be very useful for those who read this and might be able to help you (or at least your workbook and worksheets structure and how do you want the data to be merged).
Give a look at the second green sticky post at this forums main page for uploading guidelines.
Regards!
If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, maybe you find useful information and even the solution (if I don't remember wrongly I've seen many topics like this one). If not please advise so as people who read it could get back to you as soon as possible and consider uploading a sample file (including manual examples of desired output), it'd be very useful for those who read this and might be able to help you (or at least your workbook and worksheets structure and how do you want the data to be merged).
Give a look at the second green sticky post at this forums main page for uploading guidelines.
Regards!
Hello SirJB7,
I tried searching in this forum before posting this, but I could not finding the right one. I have uploaded a sample file. here is the link. May be this will be helpful in understanding my question.
http://www.2shared.com/file/VCnwFGEh/SAMPLE.html
All I just need is to merge the data in the sheets 2,3 and 4 (each of these sheets contain the info of the audits done on a daily basis) to sheer 1.
Thanks in advance
I tried searching in this forum before posting this, but I could not finding the right one. I have uploaded a sample file. here is the link. May be this will be helpful in understanding my question.
http://www.2shared.com/file/VCnwFGEh/SAMPLE.html
All I just need is to merge the data in the sheets 2,3 and 4 (each of these sheets contain the info of the audits done on a daily basis) to sheer 1.
Thanks in advance
SirJB7
Excel Rōnin
Hi, prazad82!
It all depends on what do you mean by "merge". If it's summarizing or resuming the information, you can try with the built-in consolidation feature (Data tab, Data Tools group, Consolidate icon).
Otherwise, consider uploading a sample file (including manual examples of desired output), it'd be very useful for those who read this and might be able to help you.
Regards!
It all depends on what do you mean by "merge". If it's summarizing or resuming the information, you can try with the built-in consolidation feature (Data tab, Data Tools group, Consolidate icon).
Otherwise, consider uploading a sample file (including manual examples of desired output), it'd be very useful for those who read this and might be able to help you.
Regards!