Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Randy
 
Posts: n/a
Default How do I link cells in two different spreadsheets?

I am trying to link data from a cell in one spreadsheet to a different
spreadsheet.
I want the data of a certain cell in spreadsheet 1 to show up in a certain
cell in spreadsheet 2. How is this done?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ron Coderre
 
Posts: n/a
Default How do I link cells in two different spreadsheets?

Try this exercise:

Go to a cell A1 in Sheet2
Type an equal sign (=)
Click on the Sheet1 tab (at the bottom of the screen)
Select cell A1 on Sheet1
Press the [Enter] key

Cell A1 on Sheet2 should now display:
=Sheet1!A1

There are othe options to consider, but start with that and post back with
any other questions.

Does that help?

***********
Regards,
Ron


"Randy" wrote:

I am trying to link data from a cell in one spreadsheet to a different
spreadsheet.
I want the data of a certain cell in spreadsheet 1 to show up in a certain
cell in spreadsheet 2. How is this done?

  #3   Report Post  
Posted to microsoft.public.excel.newusers
Maran
 
Posts: n/a
Default How do I link cells in two different spreadsheets?

Right click on the cell u want to copy and paste special on the spreadsheet
dat u want to copy.

"Randy" wrote:

I am trying to link data from a cell in one spreadsheet to a different
spreadsheet.
I want the data of a certain cell in spreadsheet 1 to show up in a certain
cell in spreadsheet 2. How is this done?

  #4   Report Post  
Posted to microsoft.public.excel.newusers
spardacus
 
Posts: n/a
Default How do I link cells in two different spreadsheets?


Taking this one step further ...

I have a mailing list in Execl that is rather extensive - with dozens
and dozens of columns of data for about 14,000 records (one row per
contact).

This information is great for analysis on computer. However, I can't
print the data as it is formatted.

I wish to break up my list by region and share these portions with
salespleople who can call the list for verification. However, they
don't want dozens and dozens of columns of information. They wish to
see the information as one sheet per contact, or perhaps several
contacts printed per page displaying approximately 5-7 bits of
informaton (5-7 columns worth of data) per person printed down a sheet
of paper.

Can I automatically pull information from the existing huge
spreadsheet, and have it "reflow" into this summarized version for
printing a call sheet?

Thank you for your help.


--
spardacus
------------------------------------------------------------------------
spardacus's Profile: http://www.excelforum.com/member.php...o&userid=26233
View this thread: http://www.excelforum.com/showthread...hreadid=493254

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
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 05:57 PM
How to link website data to Excel cells Tony Excel Discussion (Misc queries) 4 September 28th 05 04:16 PM
How do I link multiple cells at the same time? Juippi Excel Worksheet Functions 1 June 16th 05 06:17 PM
How do I link cells and keep the formating in excel? thanksforthehelp Excel Discussion (Misc queries) 4 April 8th 05 03:53 PM
Two spreadsheets linked - moving cells Adam Excel Discussion (Misc queries) 1 January 4th 05 01:59 PM


All times are GMT +1. The time now is 09:12 AM.

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

About Us

"It's about Microsoft Excel"