How do I consolidate multiple records into one?

M

Midalia

I have a worksheet that has approx. 150 rows and 10 columns that contains
some rows with multiple duplicate data, but the cost column has different
costs that need to consolidated into one record in order to import to Access
correctly. Please assist with this work in process.


3618130823 22-Jul Equipment Tax $9.48
3618130823 22-Jul Equipment Shipping & Handling $14.95
 
B

Bernard Liengme

To add all the A1 cells in Sheet1 to Sheet10 use
=SUM(Sheet1:Sheet10!A1)
Any help?
best wishes
 

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

Help on consolidate worksheets from different workbooks into one 2
Consolidate data from worksheet (more then 65536 rows) 1
How do I consolidate data from several spreadsheets into one. 4
consolidate multiple worksheets 13
How can I append multiple sheets from mulitple xls. files. into 1 1
How do I Consolidate an EXCEL Report into a record for ACCESS impo 1
Consolidate multiple worksheets in a workbook into one 0
How do I combine data (not consolidate) from separate tabs to one? 2

Top