Hey everyone,
What formula can give me the column number of where the enter key has been pressed after editing the cell's value. My workbook is set on automatic calculations. Please note that the formula will be residing in the sheet named = Hosting , whereas it should be detecting the Enter pressed in other Sheets and thus output the column No. in numerals. perhaps a VBA to do the job?
Demonstration of the requirement:
Workbook = Project Glass
Worksheet = ABCName
Cell ref = E6
E6 = 23
User edits the above and Enter key is pressed:
Workbook = Project Glass
Worksheet = ABCName
Cell ref = E6
E6 = 50
Requirement /Output:
Workbook = Project Glass
Worksheet = Hosting
Cell ref = A1
A1 = 5
In the above example the cell A1 had the formula for extracting column which in this case was column no. 5 (for example E6)
Thank you and will appreciate any help.
What formula can give me the column number of where the enter key has been pressed after editing the cell's value. My workbook is set on automatic calculations. Please note that the formula will be residing in the sheet named = Hosting , whereas it should be detecting the Enter pressed in other Sheets and thus output the column No. in numerals. perhaps a VBA to do the job?
Demonstration of the requirement:
Workbook = Project Glass
Worksheet = ABCName
Cell ref = E6
E6 = 23
User edits the above and Enter key is pressed:
Workbook = Project Glass
Worksheet = ABCName
Cell ref = E6
E6 = 50
Requirement /Output:
Workbook = Project Glass
Worksheet = Hosting
Cell ref = A1
A1 = 5
In the above example the cell A1 had the formula for extracting column which in this case was column no. 5 (for example E6)
Thank you and will appreciate any help.
Last edited: