but the macro still doesn't write the next input to the next row, any trick to do so? by the way, anyway to make excel to recognise repeatative input and prompt warning message when input is repeated? I'm new in visual basic, so help anyone?
Is there a way to write a macro to prompt user to key in...say the project title and its client's name and automatically puts the answer to cell A1 and B1 respectively? If the cell A1 and B1 is already filled, the macro automatically writes the answer to the following cell (i.e A2 and B2). I'd...
