Please I need some expert help
I have 2 sheets Sheet1 and Sheet2
I need to copy the value of a cell in Column E and have it paste into a data filter in Sheet 2 cell A5
It then needs to copy whatever the returned value in column B and whatever the row is dependent on where the value was...
I have a work book that I'm trying to use to store supplier prices for 1-15 products over certain postal codes 1-99999999? currently set out like table below
The postcodes are in the B column from 35 down, the products are in 34 C across currently stopping at L but possibly more to be added