Work with two cells simultaneously

[Vic Schoeman]

Hi there. Thank you for all your help, I've got one more problem.

When I work anywhere on a sheet, say coloring D10 to F10. I want to ad a figure to
D36,E36 and F36 at the same time.

My Active cell is E10 and i'm ofsetting and coloring the cells to F10, but as I go along
Row 10, I want to add a figure to Row 36 in the same column.

Because the active cell could be anywhere, the row I want to add a value to will always be 36.

Wow, I hope you can understand that,

Thankyou

Vic

[TMS]

As an example:

Please Login or Register  to view this content.

Regards