Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 11th 09, 10:30 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 10
Default Linking 2 spreadsheet using data from 1st spreadsheet

I am using MS Excel 2003. I have 2 spreadsheet, spreadsheet 1 is updated daily
with NEW DATA NEXT TO THE EXISTING rows OF INFO.
Spreadsheet 2 needs to READ/extract data from THE ADDITIONAL DATA from
spreadsheet 1. How do I link spreadsheet 2 to spreadsheet 1
so that it will always get the data from spreadsheet 1 automatically? the
data added are usually not in order of the row, hence i would want
spreadsheet 2 created in order of the data added in spreadsheet 1

VENNESSE

  #2   Report Post  
Old February 11th 09, 10:43 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,480
Default Linking 2 spreadsheet using data from 1st spreadsheet

See reply to your earlier posting

--
Regards
Roger Govier

"vennesse" wrote in message
...
I am using MS Excel 2003. I have 2 spreadsheet, spreadsheet 1 is updated
daily
with NEW DATA NEXT TO THE EXISTING rows OF INFO.
Spreadsheet 2 needs to READ/extract data from THE ADDITIONAL DATA from
spreadsheet 1. How do I link spreadsheet 2 to spreadsheet 1
so that it will always get the data from spreadsheet 1 automatically? the
data added are usually not in order of the row, hence i would want
spreadsheet 2 created in order of the data added in spreadsheet 1

VENNESSE




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
Linking 2 spreadsheet using data from the last row of spreadsheet Mike Excel Discussion (Misc queries) 13 February 11th 09 10:48 AM
linking data from sharepoint to excel spreadsheet? phrog164 Excel Worksheet Functions 0 June 12th 08 09:03 PM
Linking two spreadsheet, pulling data from one cell to another, data is being truncated Ben Excel Worksheet Functions 0 September 13th 07 11:41 PM
How do I copy spreadsheet data as shown to another spreadsheet? trainer07 Excel Discussion (Misc queries) 2 August 7th 06 09:39 PM
Linking Data in Access to a Spreadsheet carrol Links and Linking in Excel 4 July 21st 05 11:12 PM


All times are GMT +1. The time now is 05:53 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017