Excel..
2 views
Skip to first unread message
Suchitra
Nov 15, 2007, 1:29:55 PM11/15/07
to Bay Area Legal Trainers Organization
Hi,
I have an Excel spreadsheet which contains two sheets (Sheet 1 & Sheet
2). Sheet 1 has 300 items in it and Sheet 2 has 13,000 items in it.
I need to consolidate the info from Sheet 2 to Sheet 1. However, Sheet
2 contains all the items that are in Sheet 1 but with more data. What
I need to do is come up with a solution to weed out all the items in
Sheet 2 that match Sheet 1 and consolidate the data into sheet 1 and
into different columns. Can this be done?
The data in Sheet 2 is not in the same rows as Sheet 1. Thanks.
I have an Excel spreadsheet which contains two sheets (Sheet 1 & Sheet
2). Sheet 1 has 300 items in it and Sheet 2 has 13,000 items in it.
I need to consolidate the info from Sheet 2 to Sheet 1. However, Sheet
2 contains all the items that are in Sheet 1 but with more data. What
I need to do is come up with a solution to weed out all the items in
Sheet 2 that match Sheet 1 and consolidate the data into sheet 1 and
into different columns. Can this be done?
The data in Sheet 2 is not in the same rows as Sheet 1. Thanks.
Quincy
Dec 27, 2007, 5:07:59 PM12/27/07
to Bay Area Legal Trainers Organization
Hi Suchitra, and greetings from this side of the Missippi.
I hope, given the time elapsed that you found a solution to this
query. By means of introduction to the group I am attaching one
solution. The Data, Consolidation feature of excel sounds like will
solve your scenario. I have attached an example file (with solution
illustrated) in the files section of this group.
'Consolidate_Example.xls'
I hope, given the time elapsed that you found a solution to this
query. By means of introduction to the group I am attaching one
solution. The Data, Consolidation feature of excel sounds like will
solve your scenario. I have attached an example file (with solution
illustrated) in the files section of this group.
'Consolidate_Example.xls'
Reply all
Reply to author
Forward
0 new messages