Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 13th 11, 03:48 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2011
Posts: 1
Default unfamiliar with how Excel handles data - question

I inherited a work excel spreadsheet from an employee who was fired and
has no desire to help the company.

My question:

There is a table of info, say with: name, address, phone number, fax
number, email. If you place the cursor in a box on the spreadsheet
(different page) and type a number - say 1 corresponding to line 1 on the
table - the info will then populate certain fields on the spreadsheet.
Or, if I type "1" I get Joe Smith, 1600 Pennsylvania Ave, phone, fax &
email in 5 different fields. The number 1 does not actually appear on the
spreadsheet, it simply "tells" the spreadsheet which fields to populate.

1. What is this function called?
2. How do I create a new spreadsheet? (I know how to add more data to the
original table - I am now up to over 100 entries. I just don't know how
to "transport" the data from the data page to the fields that need them.

I guess another analogy would be a fax cover sheet - type "1" for the
president, type "2" for the vice-president, type "3" for the Speaker of
the House and have the different fields on the sheet populated from the
table.

I am sure this is very simple, I just don't know what this function is
called and how the various "dummies", "bible's", "complete idiots"
categorize this.

thank you for any help / direction you can give.

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
How do I get my sizing handles back? Graph/data on same page. Dawn Charts and Charting in Excel 1 March 12th 10 01:44 PM
Excel: Expose whole window or at least top resize handles. Reinie Excel Discussion (Misc queries) 1 August 25th 09 04:11 PM
Filtering Handles Michael Link Excel Discussion (Misc queries) 0 July 26th 06 06:23 PM
Excel Auto Fill Handles RachelN Setting up and Configuration of Excel 1 July 12th 06 09:58 PM
how do I identify an unfamiliar symbol in an excel cell Yosef2 New Users to Excel 2 September 16th 05 06:15 PM


All times are GMT +1. The time now is 07:39 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