Further to my database problem ..... Here i...

[Mary_Jane_Pende]

Further to my database problem …

Here is what I tried to do: 1)

Used column B in sheet 1 to ref that column in sheet 2. - worked

Used column B as a deref in sheet 1 to pull in values from sheet 2 - worked

Requested to filter the contents of column B in sheet 1 by Category.

Added a Category column to sheet 1 just before column B in the spreadsheet.

I did this and it worked beautifully.

HOWEVER … the deref’s no longer worked.

Was I putting too much on the Column B?