Hi,
I'm looking for a macro that compares a list of Shop Items that compares with a Full Stock List and replaces the Shop Items list with what items are missing from the Shop Items list. I have attached an example.
Thanks in advance.
Hi,
I'm looking for a macro that compares a list of Shop Items that compares with a Full Stock List and replaces the Shop Items list with what items are missing from the Shop Items list. I have attached an example.
Thanks in advance.
Last edited by fullmetalchrono; 01-29-2020 at 07:44 PM.
As a VBA beginner starter demonstration :
PHP Code:
Sub Demo1()
Const D = ", "
Dim S$(), V
S = Split([B2], D)
For Each V In Split([A2], D): S = Filter(S, V, False): Next
MsgBox Join(S, D)
End Sub
Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !
Thanks.
Rather than a message box is there anyway for that text to appear in A2 with the text "Need" preceeding it?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks