Need a formulas urgently
Hi,
I have a worksheet with lots of Data, i want a formula to validate data of a cell from another cell. for example if 1 is assigned to a,b,c,d and 2 is assigned to a,b,e, If In Col A i need to input number and Col B Alphabetic, i want a formula to check if either i input 1 the system will input the assigned alphabetic in col B. or if there is some alphabetic missing the system automatic detect the error an correct it.
So can someone help me please/
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks