DRExcel515
Board Regular
- Joined
- Oct 20, 2017
- Messages
- 56
I have a spreadsheet that lists a set of identifiers (142182) in column "F" that every month I copy and paste into another tab labled "DISTINCT", which I then do the remove duplicates process. Is there a way to use a macro to say from these four tabs (CRO ICO SICEHY and SICCRO) take column F (disregarding the header in F1) and paste only non-duplicate values into these four tabs (CROMV ICOMV SICEHYMV and SICCROMV) in column A (starting in A2 on the tabs as to leave the header in tact)?
<tbody>
</tbody>Thank you in advance for any advice/help!
<tbody>
</tbody>