Hi everybody, nice to be here! This forum is a great place and I hope I can get some help here and also help someone!
I would appreciate some assistance with the following problem:
I have to program the command button to be able to copy value entered in text box to a cell in another sheet, based on two conditions. Basically, this is supposed to be used for updating some information for customer's database, but for three business segments. Formula should check business segment and customer code (because there are same customers in different business segment). Customer's database is on another sheet. Something like this:
1.Enter value in text box
2.Click command button
3.Formula should check if the two conditions are fulfilled:
a) check business segment by name: "A", "B" or "C"
b) check customer code
4.When two conditions are met, code should copy value from text box to a appropriate cell in same row (for example H3,H4,H5, etc) where are these conditions.
5.If no condition is met, code should ignore entered value.
Till now, I've managed only to make this button copy the value to a desired cell, but not based on condition.
Thanks in advance
Bookmarks