ExcelBanter - How do I set up an automatic column select

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I set up an automatic column select (https://www.excelbanter.com/excel-worksheet-functions/67268-how-do-i-set-up-automatic-column-select.html)

Snoopy

How do I set up an automatic column select

I need to set up a worksheet so that when I enter in R1CA, ABC; R1CB: 10.00;
R1CC 10.00, then if I later enter ABC in R20CA and 50.00 in R20CB
automatically the 50.00 will be entered in R20CC. (and so on with CDE and FGH
etc) Is this possible?

All times are GMT +1. The time now is 02:43 AM.