Hi All,

I need an excel sheet with a built in macro for which time has to be captured automatically. If I click a cell (A1), then in the cell (B2) current time should get captured. The thing is, whichever cell I click on, the time should get captured only in that corresponding next cell. For eg. if I click on A1, time should get captured only in B1. If I click on A10, then in B10. Since this is a shared sheet, multiple users would be using this. Kindly assist.