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?

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?

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?