I have 3 columns
in column A product List
Product
Pen
Pencil
Scale
Eraser
in Column B invoice Value
invoice Value
5000
5600
665
4545
in Column C invoice Date
Invoice Date
13/06/2018
13/06/2018
13/06/2018
13/06/2018
My requirement is the data entry can input only in given list in column A and
the Data entry can input only in column b Numeric Format,
the Data entry can input only in column C Date Format,
(Data validation option not opt because copy paste )
Removed - Didn't get the question.
Last edited by kersplash; 06-13-2018 at 01:34 AM. Reason: removed comment
Perhaps something like this in Sheet Module?
Please Login or Register to view this content.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks