Consolidating Data with three Columns

howard

Well-known Member
Joined
Jun 26, 2006
Messages
5,652
Office Version
  1. 2019
Platform
  1. Windows
I have four spreadsheets that I want to consolidate into a sperate workfile. There are three columns

1) Account Number
2) Decription
3) Amount

I want all three to appear on the consolidated report. At present I can only get the account number and the amount to appear on the consolidated workfile.

How can I can the descriptions to appear as well.

Howard
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Watch MrExcel Video

Forum statistics

Threads
1,112,937
Messages
5,543,095
Members
410,583
Latest member
gazz57
Top