LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
KP KP is offline
external usenet poster
 
Posts: 13
Default Forms - pick up info from one worksheet to another

Hi,

I am using Excl 2007. I'm not sure Excel can do what I need so I figured I
would come to the experts:

*Worksheet #1: Database of about 2000 names, addresses, etc.
*Worksheet #2: A form I created to pull in names from Worksheet #1

Example: The form has the same fields as the database. If I were to start
typing in the last name of someone in the database on the other worksheet, is
there anyway I can get all of that person's information to appear on the form?

I've also been practicing in Access but am more familiar with Excel.

Thanks.
--
KP
 
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
pick list from another worksheet oldLearner57 Excel Discussion (Misc queries) 2 May 12th 07 04:36 PM
Help: reference info from master spreadsheet to individual forms Tia Excel Worksheet Functions 1 March 6th 07 09:41 PM
Forms toolbar Worksheet [email protected] Excel Discussion (Misc queries) 2 February 22nd 07 10:22 PM
Automaticall pick up info from a cell from a shet t oanither sheet , in the same cell, same book [email protected] Excel Worksheet Functions 6 December 22nd 06 03:39 AM
create a userform to populate a diagram with the forms info Mic Excel Discussion (Misc queries) 0 July 22nd 05 08:07 PM


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