| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to call data from a one worksheet list and insert into anothe
Using a combo box, the user choses a part number from a drop down list. That
choice is inserted into the proper cell of the worksheet. I would also like the program to find and insert a block of data (3 rows by 1 column) and insert it in the proper column on my main worksheet. Any suggestions would be appreicated. (Excel 2003) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need to call data from a one worksheet list and insert into anothe
creed,
If it is always the same 3 cells, then simply use VLOOKUP or HLOOKUP or INDEX/MATCH formulas keyed to the 'proper cell' HTH, Bernie MS Excel MVP "creed" wrote in message ... Using a combo box, the user choses a part number from a drop down list. That choice is inserted into the proper cell of the worksheet. I would also like the program to find and insert a block of data (3 rows by 1 column) and insert it in the proper column on my main worksheet. Any suggestions would be appreicated. (Excel 2003) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i copy data from the top cell of a filtered list to anothe. | Excel Worksheet Functions | |||
| Call up worksheet based on validated list | Excel Discussion (Misc queries) | |||
| Call a macro in anothe file | Excel Programming | |||
| How do I copy page set up attributes from one worksheet to anothe. | Excel Worksheet Functions | |||
| I want to be able to insert 1 Excel Wkbk (w mult tabs) into anothe | Excel Worksheet Functions | |||
Linear Mode
