how to combine multiple worksheets into 1

**eeps24** · 03-09-2018, 01:39 PM

I have 1 workbook that contains about 20 worksheets.

worksheet 1 contains:

column headers
data

all other worksheets contain:

data

The data is formatted the same on all worksheets, meaning for example, column A = fruits, column B = city etc...

How can I combine all worksheets to fit on 1 sheet?

Thank you

**eeps24** · 03-09-2018, 01:40 PM

I looked at the "consolidate" function in excel but it looks like its made for numerical values. My data is mixed (words,numbers, dates).

how to combine multiple worksheets into 1

LinkBack

Thread Tools

Rate This Thread

Display

how to combine multiple worksheets into 1

Re: how to combine multiple worksheets into 1

Thread Information

Users Browsing this Thread

Similar Threads

Combine Data from Multiple Worksheets and Multiple Files into one master table in workbook

Required Macro for combine multiple workbooks which contains multiple worksheets

Need to combine data from multiple worksheets in multiple workbooks into 1 worksheet

[SOLVED] Macro to combine multiple cells from multiple worksheets into one worksheet

How to combine multiple worksheets in multiple workbooks into one workbook

[SOLVED] Using Combine macro to combine multiple worksheets - need to modify to paste formulas

[SOLVED] Combine multiple workbooks into 1 workbook w/ multiple worksheets

Bookmarks

Bookmarks

Posting Permissions