Hi All,

First time posting here - spent many hours scouring the forums for my answer but I can't seem to find it, and thought it might be easier to ask the direct question. Still very new to VBA and having spent some time on YouTube/internet trying to learn this stuff I realize it might be easier to work off a template that is somewhat customized to what I'm trying to do.

I need to find a way to set up a macro (or series of macros) that enable me to take a sheet with 29 columns (A:AC) and a variable number of rows, sort it to exclude a field in Column F, and then copy+paste those values into a new sheet. I've tried using the record function but for some reason Excel can't handle variable rows - and I can't find a way to simply exclude the variable as opposed to including everything else.

From there I just can format it the way I want, but the next part is tricky again where I need to check for duplicate values against an existing set of data and then identify the unique ones. The way I did this manually was by copying the unique identifiers, pasting it below existing set and then using conditional formatting + filter.

If anyone could help me out with part (or all!) of this it would be greatly appreciated. Unfortunately since I'm dealing with confidential data I cant post a spreadsheet, but I can clarify if I've been unclear.

Thanks in advance!