| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL DATA
I have a spread sheet full of codes, descrpitions and prices saved on excel.
At the moment when I do a job sheet, I have to open up the saved one and a new one and copy and paste the codes in need. I would like to know if the is a way i could type the code is want in a new spread sheet and it bring up the information i need, with out having to copy and paste from one sheet to another sheet. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXCEL DATA
When you say "Bring up" the information do you want it in a box of its own or on one row opposite the code number? how do you want it displayed and do you want the information to change when the source info changes? -- The Code Cage Team Regards, The Code Cage Team http://www.thecodecage.com ------------------------------------------------------------------------ The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30448 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXCEL DATA
Hi,
I have the codes, descriptions, units, and price in they own column all saved on one spread sheet. I want to be able to open a new sheet and type in a code and for it to them bring up the rest of column relateing to that code next to it. Any ideas Thank's "The Code Cage Team" wrote: When you say "Bring up" the information do you want it in a box of its own or on one row opposite the code number? how do you want it displayed and do you want the information to change when the source info changes? -- The Code Cage Team Regards, The Code Cage Team http://www.thecodecage.com ------------------------------------------------------------------------ The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30448 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
| Email (LDAP) data download into a single Excel cell - data separat | Excel Worksheet Functions | |||
| excel 2007, how to select a data point and cycle through data points | Charts and Charting in Excel | |||
| I want to convert word column data to excel row data to sort addre | Excel Discussion (Misc queries) | |||
| how to Import data in excel office2003 with data more 65000 rows | Excel Worksheet Functions | |||
Linear Mode
