I have a button that I only want to be active if an adjacent cell on the left
is null AND the cell on the right is not null. So basically there are 8
buttons and I only want ONE to be active at a time, the LAST one that has
data in it. I have NEVER programmed VBA in Excel. I am proficient in VBA in
Access however. Once the button is active, I want it to copy all the values
of each cell into corresponding cells in another worksheet.

I truly appreciate any help you experts can provide.

Larry
--
Never give up, the answer IS out there, it just takes a while to find it
sometimes!