Combine multiple ranges into one worksheet
 

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.

Combine multiple ranges into one worksheet
 

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.

--
Thanks,
Shane Devenshire


"Troy Man" wrote:

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.