I'm making a spreadsheet to record dates and amounts
Most of the amounts will be the same. I was wondering if I start to enter an amount, excel would recognize it and finish the typing.
All amounts will be in column C
Most amounts will be 756.56
Once in a while i might enter a different amount but it wouldn't start will 75
If I start to type 75, the rest of the number comes up and I would hit enter
I'm compering it to when I type a word and if the word or part of the word is anywhere above in the column, excel finishes it for me
I mentioned that I'm not to good with macros. If that's what I have to do, I'll need to see it.