Combining Selected Sheets into One Sheet

[ElishaRoxanne]

I need to combine selected selected sheets from my workbook into one sheet. Let's call the Stock Sheet 1, Stock Sheet 2 and Master Sheet. I want to list all the rows from Stock Sheet 1 and Stock Sheet 2 in one long list on the Master Sheet. The column headings are all the same, but the number of rows will change from time to time. There are other sheets in the workbook that I do not want to copy into the Master Sheet, so I will have to define which sheets to copy. Can anyone help me with this?

[Mumps1]

Are the column headers also the same in the Master sheet?

[Arkadi]

ElishaRoxanne,

Absolutely we can help with this

Would the "combined" sheet be a new sheet? or do you want to add the data from 2 of your sheets to the 3rd one? Ideally, upload a sample workbook:

Attach 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.

[ElishaRoxanne]

Yes, I will have the same headers in the master sheet. I would be incredibly grateful for any assistance with this one!

[Mumps1]

Cross-posted: https://www.ozgrid.com/forum/forum/h...elected-sheets
Please read Rule #8 at this link: https://www.excelforum.com/forum-rul...rum-rules.html

[Mumps1]

Try:

Please Login or Register  to view this content.

Add the additional sheets you want to copy in the array.

[ElishaRoxanne]

Thanks Arkadi. I have created a sample of what I am after but the attachments icon does not seem to be working for me. I'll keep trying.

Mumps1, thank you for pointing out the rules. I'll remove my post from Ozgrid.

[Arkadi]

Please Login or Register  to view this content.

[ElishaRoxanne]

Thanks Arkadi and Mumps1. Unfortunately neither of these are working for me. I have attached a sample of what I am trying to achieve. I have just copied and pasted the sections of the sheets I need into the summary page, but I would like this to happen automatically when I hit the macro button I have inserted.

[Arkadi]

It is not clear to me what exactly isn't working, aside from the fact (as my notes said) the column needs to change. Also, instead of looking below row 1, we needeed to change that to 2, and copy from 3 down... Your example has removed the column G data from Summary... there is an optional line you can un-comment to clear that data.
Paste the code in a module, then right click your button, select "Assign Macro" and choose the macro you just put in a module:

Please Login or Register  to view this content.

I changed to pastespecial to avoid copying the formatting, and to convert the formula result in col G to a value, but we can change that if needed.

[ElishaRoxanne]

It works. Thank you very much Arkadi!

[Arkadi]

Glad I could help you

Please remember to mark the thread as solved when you have a moment! Thanks in advance