Combine multiple ranges into one worksheet

T

Troy Man

I have 5 data ranges on different worksheets that I need to combine into the
one worksheet for analysis purposes.

The ranges are formatted in the same columns but differing row lengths and
the row lengths may expand on a monthly basis.

Consolidation and pivot tables with multiple ranges are not working for me.

I have no knowledge of VBA at this stage.
 
S

ShaneDevenshire

Hi,

You should take a look at the Data, Consolidate command. If the first row
and first column have unique identifiers you can consolidate by using them.
Look this topic up in the help system to see if it meets your needs.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PivotTable based on multiple ranges or tables 2
pivot table multiple consolidation ranges 3
Pivot table from multiple ranges? (Revisited) 4
Linking multiple ranges and worksheets to MS Word 1
Consolidate tables/ranges with text from multiple worksheets 1
Pivot Table 2
Deleting all named ranges that have a workbook scope 3
How do I combine data (not consolidate) from separate tabs to one? 2

Top