I have some data in the following format
.........Column..Column
.........A..........B
Row 1 income1 CHANGE
Row 2 income2 CHANGE
Row 3 income3 CHANGE
Row 4 income4 CHANGE
when a user click on the cell labelled CHANGE it runs a macro called macro1, I need to be able to ascertain which CHANGE was selected and then follow a series of instructions in cells on the same row.
for example if I select the change next to income3 then the instructions to follow apply to row 3 only
any ideas
.........Column..Column
.........A..........B
Row 1 income1 CHANGE
Row 2 income2 CHANGE
Row 3 income3 CHANGE
Row 4 income4 CHANGE
when a user click on the cell labelled CHANGE it runs a macro called macro1, I need to be able to ascertain which CHANGE was selected and then follow a series of instructions in cells on the same row.
for example if I select the change next to income3 then the instructions to follow apply to row 3 only
any ideas