Exclude Specific Columns from Range in VBA

[alpha_xero]

Hello,
I have a code that returns unique rows from one sheet to another.
I want to exclude specific columns from the range from B5:P1048576 and show them in Sheets("Item-Wise Summary").Range("A5:O5")

Sub RemoveDuplicates()

Dim rngDatabase As Range

'define the database

   Set rngDatabase = Sheets("Transaction Entry").Range("B5:P1048576")

'filter the database to a new range with a unique set to true

rngDatabase.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Sheets("Item-Wise Summary").Range("A5:O5"), Unique:=True

End Sub

 

[alpha_xero]

Yes that's the thing! If I put 11 columns on the output I'm getting this error message.
I tried the code you gave me but its not working either. This has nothing to do with the actions.

Anyways this is giving me a lot of pain and I guess I'll have to try a different approach.

 

[Alex Blakenburg]

Yes that's the thing! If I put 11 columns on the output I'm getting this error message.
I tried the code you gave me but its not working either. This has nothing to do with the actions.

Anyways this is giving me a lot of pain and I guess I'll have to try a different approach.

1) Like I said your code won't work because Advanced Filter won't work on non-contiguous range (skipping columns in your filter range)

2) Not working doesn't tell me anything.
The only thing the Actions code is doing is working out the Qty figures, it should not stop the code working at worst should give you the Qty column when you don't want it yet.
In terms of the Qty the code is trying to work out whether a transaction Qty should be treated as Stock In (positive) or Stock Out (negative). Just ignore that if you don't want it and tell me what "not working" means.
Do you get an error message, if so show me the message and which line is highlighted when you click on debug ?
If the results are wrong show me what you are getting and what you were expecting.

 

[alpha_xero]

Hey Alex,
If Advanced Filter won't work on non-contiguous range, that answers my question.
Thank you so much for your time and support. You've really helped so much.
Also, do you know how I can delete this whole thread? There seems to be no option for that.

 

[Alex Blakenburg]

You can't delete the thread but don't worry about it.
Glad it was of some help.