have you had experience with vlookups and hlookups. This may be what you want.

"Freddie" wrote:

Hi, is there anyway I can use the aoutofiler with a reference to a different
sheet in a workbook.
I would like to use a macro, if I put in this valu here and push the button,
that value shows i a list in two other seprate sheets in the same workbook.

/Freddie