thanks very much for your help and assistance
Posts by leap-out
-
-
this is exactly what I want thanks so much
just I 'm asking if I decide highlighting the new data are existed in first sheet but not existed in second sheet by red color and the new data are existed in second sheet but not existed in first sheet by blue color , may you guide me how add this in your code ?
-
hi
I have data in two sheets I would match data between two sheets the standard should COL B,C,D together because COL B,C are similar the different in COL D so it should bring all of data in sheet SUMMARY and show the values in COL F,G if values in first sheet bigger than second sheet then the value show in COL F and tick mark wrong in COL E and if values in first sheet smaller than second sheet then the value show in COL G and tick mark wrong in COL E and if values in first sheet are matched with second sheet then tick mark right in COL E
note: if there are new data in first sheet but not existed in second sheet it also show in sheet summary and the values show in COL F and if there are new data in second sheet but not existed in first sheet it also show in sheet summary and the values show in COL G
thanks
-
royUK also your answer is very impressive many thanks for your assistance
-
Carim your code is astonishing this is the best answer
many thanks
-
Carim your code doesn't disable it just changes the font color
-
royUK that's great but I note when link the button with the macro even disabled still run the macro it doesn't seem to success with this type button not like ActiveX commandbutton
-
royUK thanks but honestly I would disable not hide
-
thanks guys but why I have to use Using an ActiveX commandbutton?
as you know this your way uses in userform but what I'M asking when run the macro in sheet I use normal button , isn't possible?
-
hello
I try designing a simple macro to enable and disable the button if I write ok in A1 then enable the button and if the A1 is empty or other value it should disable
this is my try
Code
Display MorePrivate Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("a1")) Is Nothing Then Dim b1 As Button If Target.Value = "ok" Then Set b1 = ActiveSheet.Buttons("Button 1") b1.Font.ColorIndex = 15 b1.Enabled = True Else b1.Enabled = False End If End If End Sub
thanks
-
Glad to hear that your like it ...
The formula you are asking about only allows to differentiate your brands among the two types ...
thanks very much for your assistance
-
Carim wow !! it's so great just I want to understand this line
the value 9 and "2" ?
-
royUK thanks but your file it applies from sheet to another I try amending to make in the same sheet but it gives me error in the formula
-
take your time buddy !
-
I mean data validation not by tool combobox as you did it because data validation linked with cell but the combobox it doesn't link with cell I don't know how deal with it
check my file you will understand what I want
-
wow ! it's very impressive but I have a question , so this is not possible do that by dropdown ?
-
hello
I search way to link multiple dropdowns depend on each other of them so if I choose from col a should show the correspond value in column B without showing the others value and if I choose from col B it should show the correspond value in column C without showing the others value I put some explaining inside the file
thanks in advance
-
Brilliant ! awesome ! well-done ! what I can say you honestly you are legend , thanks is not enough for your right
many thanks for your codes and time and patience and everything
best regards,
leap-out
-
first of all thanks for your time and feedback what I meant should e8 is empty , I do not fill it at all it fills automatically when I fill in e5 bring customer id and fill in e8 for instance if I only fill in e5 "1004 then automatically fill in e8 "CUS1012" and the rests of data from row 16
-
nothing happened in e8 it supposes showing number of customer when write in e5