| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Auto transfer of row
I have a list of components to be ordered in each row is a cell with a order number entered in it. What I want is to copy the row to another sheet (which is to be displayed at goods) when the order number is entered in that cell. Is this possible? many thanks for any help. -- alanled ------------------------------------------------------------------------ alanled's Profile: http://www.excelforum.com/member.php...o&userid=30949 View this thread: http://www.excelforum.com/showthread...hreadid=572975 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Auto transfer of row
this could be acheived by using VLOOKUP function. if you want a perfect solution then you should attach a sample file for imlementation of this function. alanled Wrote: I have a list of components to be ordered in each row is a cell with a order number entered in it. What I want is to copy the row to another sheet (which is to be displayed at goods) when the order number is entered in that cell. Is this possible? many thanks for any help. -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=572975 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Auto transfer of row
this could be acheived by using VLOOKUP function. if you want a perfect solution then you should attach a sample file for implementation of this function. alanled Wrote: I have a list of components to be ordered in each row is a cell with a order number entered in it. What I want is to copy the row to another sheet (which is to be displayed at goods) when the order number is entered in that cell. Is this possible? many thanks for any help. -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=572975 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Data Transfer | Excel Worksheet Functions | |||
| Auto transfer rows from 1 sheet to another by account code. | Excel Worksheet Functions | |||
| Auto Record Transfer (2) | Excel Worksheet Functions | |||
| Auto Record Transfer | Excel Worksheet Functions | |||
| Auto Data Transfer | Excel Worksheet Functions | |||
Linear Mode
