Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all,
I'm looking for a code that would do the following: - When I press whichever data entry validation key combination(((("Enter", "Ctrl+Enter", "Shift+Enter", "Tab" or "Shift+Tab")))) following data entry into a cell from either B or C columns, then if... .... the cell-with-content count (COUNTA) for the same row of these two columns (B & C) is equal to 2; .... and the result of a formula included in equivalent cell in column D is not an error; .... and the cell of the same row in column A is empty. - Then copy the value of cell D into cell A of the same row... .... and go to the cell where the elected keystroke would have gotten me by default. - If the conditions were not to be met, then just do whatever is the default (exit sub, I guess...) Is this too much asking? I hope not and wish to thank in advance anyone who will put any amount of thinking, even fruitless, into this problem, Feelu |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) |