Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Gomer Pyle
 
Posts: n/a
Default Can I auto fill a cell in one worksheet by typing a code number

I want to be able to autofill a cell by typing a number and having the next
cell autofilled with information from another worksheet.
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Maybe =vlookup() or =index(match()) would be what you want.

You could look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html

Gomer Pyle wrote:

I want to be able to autofill a cell by typing a number and having the next
cell autofilled with information from another worksheet.


--

Dave Peterson
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
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
SQL - Auto Refresh Upon Cell Value Change Elliot J Excel Worksheet Functions 1 May 12th 05 10:22 AM
In MS Excel, how do I fill in a column with the same cell from se. krempin Excel Worksheet Functions 2 February 9th 05 09:43 PM
Refrencing another cell in a worksheet that "could" exist KimberlyC Excel Worksheet Functions 1 February 7th 05 08:09 PM
name of another worksheet in cell for reference Tom A Johnson Excel Worksheet Functions 2 November 12th 04 12:28 AM


All times are GMT +1. The time now is 02:57 PM.

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"