|
Hey WG,
I can't find a way to auto copy the contents of two columns and put them into one column.
But if you're using the latest version of Excel there is a way to remove duplicate entries.
Highlight the column you want to have checked
Click on Data tab (main menu tabs along top)
Under 'Data Tools' you'll see 'Remove duplicates'
Click that and make sure it shows the column you have selected as 'checked'.
Then hit OK and it will go through that column and remove any duplicates it finds (deletes them permanently)
That's using Excel with Vista O/S
You may just have to get someone to copy/paste those two columns together for you each day. I can't find a formula or macro for that at all.
__________________
Send & Receive Mass Global Payments - Mass P2P/Wire/EFT/SEPA - Adult Industry Friendly - Award Winning Payment Service - Fast, Reliable & Secure!
Paxum ...... Paxum Bank
Email: [email protected] ~ Telegram: PaxumRuth
|