Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike
 
Posts: n/a
Default Consolidate Spreadsheets

I am trying to merge/consolidate two spreadsheets into a third spreadsheet.
See example below.

<List 1
Name Info
Mike Good Guy

<List 2
Name Info
John Bad Guy

I am trying to merge the above lists into a single list that looks like:

<List 3
Name Info
Mike Good Guy
John Bad Guy

What is the easiest way to do this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham
 
Posts: n/a
Default Consolidate Spreadsheets

The easiest way is probably with simple copy and paste. Choose all of the
information on one of the worksheets and use Edit | Copy and then go to the
end of the list on the other worksheet and use Edit | Paste.

You can then, if you want, choose all of the data and use Data Sort to truly
merge the lists aphabetically.

If you want to preserve both of the original lists, just copy both lists to
an empty sheet.

"Mike" wrote:

I am trying to merge/consolidate two spreadsheets into a third spreadsheet.
See example below.

<List 1
Name Info
Mike Good Guy

<List 2
Name Info
John Bad Guy

I am trying to merge the above lists into a single list that looks like:

<List 3
Name Info
Mike Good Guy
John Bad Guy

What is the easiest way to do this?

  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike
 
Posts: n/a
Default Consolidate Spreadsheets

Copy/Paste is last resort as the sheets will be updated on a regular basis.
I will also have six spreadsheets with over 100 rows of data in each. I was
hoping to find an automatic way to accomplish this.

"JLatham" wrote:

The easiest way is probably with simple copy and paste. Choose all of the
information on one of the worksheets and use Edit | Copy and then go to the
end of the list on the other worksheet and use Edit | Paste.

You can then, if you want, choose all of the data and use Data Sort to truly
merge the lists aphabetically.

If you want to preserve both of the original lists, just copy both lists to
an empty sheet.

"Mike" wrote:

I am trying to merge/consolidate two spreadsheets into a third spreadsheet.
See example below.

<List 1
Name Info
Mike Good Guy

<List 2
Name Info
John Bad Guy

I am trying to merge the above lists into a single list that looks like:

<List 3
Name Info
Mike Good Guy
John Bad Guy

What is the easiest way to do this?

  #4   Report Post  
Posted to microsoft.public.excel.misc
steven1001
 
Posts: n/a
Default Consolidate Spreadsheets


http://www.excelforum.com/showthread.php?t=538191 seems related


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=540112

  #5   Report Post  
Posted to microsoft.public.excel.misc
JLatham
 
Posts: n/a
Default Consolidate Spreadsheets

Let us know if steven1001's lead gives you a solution. There are other
options available, including pretty much being able to record a macro to
accomplish it.

"Mike" wrote:

Copy/Paste is last resort as the sheets will be updated on a regular basis.
I will also have six spreadsheets with over 100 rows of data in each. I was
hoping to find an automatic way to accomplish this.

"JLatham" wrote:

The easiest way is probably with simple copy and paste. Choose all of the
information on one of the worksheets and use Edit | Copy and then go to the
end of the list on the other worksheet and use Edit | Paste.

You can then, if you want, choose all of the data and use Data Sort to truly
merge the lists aphabetically.

If you want to preserve both of the original lists, just copy both lists to
an empty sheet.

"Mike" wrote:

I am trying to merge/consolidate two spreadsheets into a third spreadsheet.
See example below.

<List 1
Name Info
Mike Good Guy

<List 2
Name Info
John Bad Guy

I am trying to merge the above lists into a single list that looks like:

<List 3
Name Info
Mike Good Guy
John Bad Guy

What is the easiest way to do this?



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default Consolidate Spreadsheets

I want to use this link but it is unaccessible.
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan


"steven1001" wrote:


http://www.excelforum.com/showthread.php?t=538191 seems related


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=540112


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 loses the links to other excel spreadsheets on a server Mark at SMS Excel Discussion (Misc queries) 0 May 1st 06 03:55 PM
Consolidate multiple spreadsheets into a single workbook Andy T Excel Discussion (Misc queries) 0 April 24th 06 02:13 PM
More problems linking spreadsheets dgg9879 Excel Discussion (Misc queries) 2 April 19th 06 02:00 PM
Spreadsheets are cut off when you paste and link? Clint Lovell Excel Worksheet Functions 1 November 25th 05 07:10 PM
Excel Charts Linked to Spreadsheets Rich Charts and Charting in Excel 1 July 4th 05 05:36 PM


All times are GMT +1. The time now is 07:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"