F
FARAZ QURESHI
I have a format like the following for distribution to branches:
Code Name Amount
101-2 ABC 100,000
To alert branch manger upon incorrect data insertion I have customized the
format of Code column as 000-0 and have instructed the managers to enter data
without dashes like 1012 while the conditional formatting set to highlight
cells with code <1000 and >9999 so as to confirm only a four digit one
inserted.
The branch managers usually paste the data despite of all the instructions.
I want to have a macro applied which would upon pasting the data either by
"Ctrl+V" or "Enter" have the data automatically paste special values and
remove the dashes/hyphens.
Thanx in Advance!
Code Name Amount
101-2 ABC 100,000
To alert branch manger upon incorrect data insertion I have customized the
format of Code column as 000-0 and have instructed the managers to enter data
without dashes like 1012 while the conditional formatting set to highlight
cells with code <1000 and >9999 so as to confirm only a four digit one
inserted.
The branch managers usually paste the data despite of all the instructions.
I want to have a macro applied which would upon pasting the data either by
"Ctrl+V" or "Enter" have the data automatically paste special values and
remove the dashes/hyphens.
Thanx in Advance!