Dear Forum Members,
I need some help from a VBA expert.
I have a summary sheet with the sheet names in Column B starting B2 and down
I have the seller names in each sheet in column B starting B2
I need a VBA code that can check the column B of every sheet mentioned in the Summary sheet and paste me a list of the Unique Suppliers starting in Cell R3 downwards of each sheet
Presently I am using Data Adbaced Filter and have to do it manually for each sheet, by the sheet are increasing after few days and is becoming very tedious.
Hope some VBA expert can help me with this
I have used the macro recorder and it gave me this code
Thanks in advance
I need some help from a VBA expert.
I have a summary sheet with the sheet names in Column B starting B2 and down
I have the seller names in each sheet in column B starting B2
I need a VBA code that can check the column B of every sheet mentioned in the Summary sheet and paste me a list of the Unique Suppliers starting in Cell R3 downwards of each sheet
Presently I am using Data Adbaced Filter and have to do it manually for each sheet, by the sheet are increasing after few days and is becoming very tedious.
Hope some VBA expert can help me with this
I have used the macro recorder and it gave me this code
VBA Code:
Range("D1").Select
Range(Selection, Selection.End(xlDown)).Select
Application.CutCopyMode = False
Application.CutCopyMode = False
Range("D2:D111").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _
"R2"), Unique:=True
Thanks in advance