Thread: How do I consolidate multiple records into one?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default How do I consolidate multiple records into one?
To add all the A1 cells in Sheet1 to Sheet10 use
=SUM(Sheet1:Sheet10!A1)
Any help?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Midalia" wrote in message
...
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



Reply With QuoteReply With Quote