Hello, I really need some help on a thing.


I have a all-data sheet called btc and a temporary storage data sheet called btc trans.

On the main sheet, I need to select a range of cells within a row, say b:h, if the value on Bi is the same as the A1 value on the sheet called btc trans.
When selected, I need to clear the values.
And do it until there is no more Bi's with the same valeu as the A1 value of the btc trans sheet.

Was I clear?

Thanks a lot in advance!!