Re: Prevent duplicate data in columns
Hi, i dont know why this code cant works, it still allow the same data to be updated
Posts by Shei Kee
-
-
Re: Prevent duplicate data in columns
This is the template
forum.ozgrid.com/index.php?attachment/69219/And what if i put all the data together but i have to check prevent duplicate data for Sales, Deposit and Expenses?
forum.ozgrid.com/index.php?attachment/69220/ -
Re: Prevent duplicate data in columns
Quote from sktneer;771240Screenshots are not helpful while debugging the issues.
Please upload the sample workbook with the changes you have made in the sheet layout and in the code.how do i upload? [ATTACH=CONFIG]69217[/ATTACH]
-
Re: Prevent duplicate data in columns
Quote from sktneer;771202Please find the attached and click the Update button to see if that works as per your requirement.
Hi, if my template were to be like that, i just have to change the alphabet E to G to A to C?? why it dont works?
[ATTACH=CONFIG]69208[/ATTACH] -
Re: Prevent duplicate data in columns
Thanks so much for your help!! it is exactly what i need! :thumbcoo:
-
Hello, i am currently doing a project regarding sales.
May i know how do i code in VBA such as whenever new sales is updated, the code will run and make sure that there is no repeated sales?
and there will be a pop up msgbox that says "There is duplicate data at columns X. please retyped."
i will attach my excel file for better understanding of what i am asking.
forum.ozgrid.com/index.php?attachment/69194/