LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 53
Default Creating a sheet to view rows from another sheet

I have a spreadsheet with 3000 rows of data (colums A-S). One row for data
on each contact. Each row contains a cell (field) for a unique Contact
Number and one for Contact Name among many other cells.
I want to create another worksheet that will have a field that I can enter
either the number OR name of the contact and have it get all the info for
that contact from the first sheet and display it on this second sheet in
different cell locations (all visible on one screen.

Thanks for your help.
Jon


 
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
after creating a copy of a sheet, several rows missing (not hidden dcdus Excel Discussion (Misc queries) 11 September 15th 09 10:13 PM
Creating form on sheet 1 and having info move to sheet 2 SHARON Excel Discussion (Misc queries) 4 June 1st 09 05:01 PM
Q: Creating a macro to sort and group columns in a sheet according to another sheet [email protected] Excel Programming 0 January 8th 07 09:06 PM
view excel sheet tabs in multiple rows gingerq Setting up and Configuration of Excel 2 June 27th 06 01:25 AM
Copy Rows To desinated Sheet Please. But First Creating Them. Steved Excel Programming 3 August 17th 05 04:26 AM


All times are GMT +1. The time now is 08:36 AM.

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"