Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 9th 06, 04:04 PM posted to microsoft.public.excel.newusers
Karmen
 
Posts: n/a
Default Verification/Import of data


Hello,

I have two separate worksheets. I would like to use the first
worksheet to verify the same data on the second worksheet is correct.
For instance, in worksheet one I have a city and a number (in two
individual cells) and I would like this same data in the second
worksheet (in two individual cells). Is there a way to somehow link
(?) or import or (?) the two sheets so when the first worksheet is
updated, the second worksheet will also update. I am so very
lost.

Thanks for your help!


--
Karmen
------------------------------------------------------------------------
Karmen's Profile: http://www.excelforum.com/member.php...o&userid=30972
View this thread: http://www.excelforum.com/showthread...hreadid=510625


  #2   Report Post  
Old February 9th 06, 05:12 PM posted to microsoft.public.excel.newusers
Pete
 
Posts: n/a
Default Verification/Import of data

In your second sheet you enter a formula like:

='Sheet 1'!A1

to bring the value from cell A1 into the cell where the formula is
(assume A1 also). Whenever you change the value in the first sheet, the
second sheet's value will also change. The formula can be copied across
and/or down the second sheet to bring values from other cells on Sheet
1 - it will not copy the formats, however.

Hope this helps.

Pete



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
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Saving data in a worksheet within a workbook Homeuser Excel Discussion (Misc queries) 2 August 21st 05 10:49 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM


All times are GMT +1. The time now is 10:40 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017