can a prog fill all data on a row from one entry?

F

fraggle21

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?
 
T

Toppers

Yes ... (probably using VBA) .....what exacltly is your requirement? Can you
post an example?
 
N

Nick Hodge

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
[email protected]
 
Top