Hi, thanks in advance I am making a order form and I need to add 4 to brand qty and delete the rest data for each Brand.
I have stucked with adding 4 to Qty and deleting the rest data
I have attached the sample data for with vba code.
Sorry Hui,
It is not working properly it is displaying both messages when there are birthdays in dates
PFA for your reference, I have placed the data in two separate sheets
I want to make a birthday reminder with a popup message box, the below code works perfect if the birthday is between two dates i.e. if the birthday date is between today and next 14 days, but if there is no birthday in next 15 days than the message box popup does not work.
I want the message...
Try the Code Below
Option Explicit
Private Sub Worksheet_Change(ByVal target As Range)
If Not Intersect(target, Me.Range("A1")) Is Nothing Then
Call Macro1
End If
If Not Intersect(target, Me.Range("B1")) Is Nothing Then
Call Macro2
End If
If Not Intersect(target...
I want a formula to rank a brand based on two criteria.
There is a store, brand and Net Sales Value Column.
I want to calculate what is the rank of a brand in its respective Store.
I m uploading a sample data and i have marked red what result i want.
Any help will be appreciated.