copy data in a given sheet from another sheet according to criteria

[amarjeet.it]

I have a excel file having two sheets("SRV Format" & "Data Register Sheet"). what i want is when I put SRV No. in cell "H6", it do fills all required data in the colored cells. for more understanding i have colored cell in "SRV Format" sheet with same color to column in "Data Register Sheet" from which data to be filled. i think this can be done with vlookup formulla but main problem is how i can copy all the items of a SRV no. in "Item Code" column as each SRV has different no of items.



thanx in advnce

[Pete_UK]

Take a look at this thread for earlier today:

http://www.excelforum.com/excel-form...-criteria.html

There are two proposed solutions, one formula-based and the other macro-based.

Hope this helps.

Pete