felpslima
10-31-2010, 04:35 PM
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!!
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!!