| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can a prog fill all data on a row from one entry?
Can excel or another programme build a memory so when you enter one item it
auto fills all data on the other rows corresponding to that item? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can a prog fill all data on a row from one entry?
Yes ... (probably using VBA) .....what exacltly is your requirement? Can you
post an example? "fraggle21" wrote: Can excel or another programme build a memory so when you enter one item it auto fills all data on the other rows corresponding to that item? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can a prog fill all data on a row from one entry?
fraggle21
You would set up 'all other data' in a table on another sheet and then refer to it with a VLOOKUP function. This will then bring through the data from the other sheet for the item entered -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "fraggle21" wrote in message ... Can excel or another programme build a memory so when you enter one item it auto fills all data on the other rows corresponding to that item? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula references change when data entry sheet is modified | Excel Worksheet Functions | |||
| Complex data comparisson and entry problem | Excel Discussion (Misc queries) | |||
| One page Data Entry Sheet for Database? | Excel Discussion (Misc queries) | |||
| Protected Row-Oriented Data Entry | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Hybrid Mode
