ExcelBanter - Matching and Consolidating records

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Matching and Consolidating records (https://www.excelbanter.com/excel-discussion-misc-queries/215463-matching-consolidating-records.html)

Matt Bennette[_2_]

Matching and Consolidating records

Hi Guys,

How can I consolidate two worksheets into one master sheet.
i.e
Worksheet A
URN Names Address Tel:

Worksheet B
URN Name Tel: Other

Consolidated Work Sheet
URN Name Address Tel: Other

Many Thanks

Eduardo

Matching and Consolidating records

Hi,
Take a look at Ron web

http://www.rondebruin.nl/copy3.htm

"Matt Bennette" wrote:

Hi Guys,

How can I consolidate two worksheets into one master sheet.
i.e
Worksheet A
URN Names Address Tel:

Worksheet B
URN Name Tel: Other

Consolidated Work Sheet
URN Name Address Tel: Other

Many Thanks

All times are GMT +1. The time now is 03:50 AM.