#1   Report Post  
Posted to microsoft.public.excel.misc
sunderland27
 
Posts: n/a
Default adding data

i was curious. when i input something in one excel spreadsheet, would i be
able to place the information in another excel spread sheet.

for example: A1 = spreadsheet1 info b2 = spreadsheet2 info
any time i place info in boxA1, / a1 data would be sent to fields in boxb2.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default adding data

Set a reference in B2 back to A1

='spreadsheet 1'!A1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sunderland27" wrote in message
...
i was curious. when i input something in one excel spreadsheet, would i

be
able to place the information in another excel spread sheet.

for example: A1 = spreadsheet1 info b2 = spreadsheet2 info
any time i place info in boxA1, / a1 data would be sent to fields in

boxb2.


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
Pull data from another sheet based on certain criteria steve_sr2 Excel Discussion (Misc queries) 1 February 23rd 06 10:08 AM
Adding "fixed" data to variable length data [email protected] Excel Worksheet Functions 3 February 16th 06 08:59 PM
ranking query JaimeTimbrell Excel Discussion (Misc queries) 2 February 16th 06 08:09 AM
Automatically Adding Data to Charts lhollen1 Charts and Charting in Excel 1 June 9th 05 05:43 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM


All times are GMT +1. The time now is 09:36 PM.

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"