Combine data in different sheets into one sheet

[wew044]

Hi All,
I have data different excel sheets and I would like to put all the data into one single sheet. I dont want the data to combine and fill the rows, which came up alot in google search. But rather I would like the data (regardless whether header is the same or different) to combine into different columns.

For example:
Sheet 1 - I have data in column A and B
Sheet 2 - I have data in column A and B

After combining, Sheet 1 data is in column A,B, and sheet 2 data is in column C, D.

Is there anyway to modify this code to have the combined data to show across the columns? (this code combines the data and puts them in rows）

--------------------------------------------------------

Please Login or Register  to view this content.

-------------------------------------------------------
Thank you!

[alansidman]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[alansidman]

Please read the yellow banner at the top of this page and supply the needed information.

[jolivanes]

Re: "Combine data in different sheets into one sheet"
This implies one workbook and multiple sheets.

Re: "I have data different excel sheets and I would like to put all the data into one single sheet"
This implies one workbook and multiple sheets.

However, your code shows opening different workbooks.

Please explain properly what you want.

If it is to combine all sheets from one workbook, why would you even mentioning the path of a workbook to open.

Or don't you know the difference between sheets and workbooks?

[wew044]

Thank you for the clarification, i think i got it.

[wew044]

Hi Jol,

My mistake, I posted the wrong code.

this is exactly what I want:
Sheet 1 - I have data in column A and B
Sheet 2 - I have data in column A and B

After combining, a new sheet will contain data from sheet 1 and sheet 2, and so on. Sheet 1 data is in column A,B, and sheet 2 data is in column C, D, and so on.

The code I was using is this, which takes data from all sheets and puts them in rows format. Is there a way to modify the results mentioned above?

Please Login or Register  to view this content.

[jolivanes]

Please Login or Register  to view this content.

[wew044]

Thank you so much. The code works really nicely. Much appreciated!