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 |