VBA to create new workbook from most recent user-numbers fro

Dear all,

I need to create a macro that can produce a new workbook with the list of the most recent users of my company, so that we can print their membership cards.

From my company's admin I can export the complete list of users with their name, serial number and address. Every time we export this list, the file is saved as "[url removed, login to view]", and "dd-mm-yyyy" as today

However, I would like to create a macro that would

1) open the most recent "[url removed, login to view]" workbook in the folder,

2) compare the user numbers in this file with the most recent "[url removed, login to view]" and

3) produce a new "[url removed, login to view]" workbook with the list of all new users since the last "[url removed, login to view]" ("dd-mm-yyyy" as today), based on the highest number for user number (this is a continuous list)

Note, the "[url removed, login to view]" workbook has name, serial number, address, expiration date and user number as columns.... but the extracted info to "[url removed, login to view]" is just of the name, serial number and expiration date.

Thanks a lot and let me know if my explanation is not clear

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel

Lihat lagi: vba create workbook, open workbook vba, vba open workbook, create VBA, vba with, produce workbook vba, vba time, vba open folder, vba for, vba create folder, print vba, me vba, in vba, create folder vba, vba compare, name cards data, most, Macro vba, create new c, create membership, create folder, create user admin, data processing vba, vba data processing, processing export

Tentang Majikan:
( 3 ulasan ) Copenhagen, Brazil

ID Projek: #1567347

Dianugerahkan kepada:


Hi, I am an Excel and VBA expert, and I can carry out this task for you. Please check your inbox for further information. Many thanks, Joe

$30 USD dalam 2 hari
(7 Ulasan)

7 pekerja bebas membida secara purata $56 untuk pekerjaan ini


Hello, Excel VBA expert here. Please check PM for details. Thanks!

$100 USD dalam 2 hari
(61 Ulasan)

Hello. We find your description useful to understand. Please check your inbox for details.

$90 USD dalam sehari
(21 Ulasan)

Hi, I can do it. What is you OS. Windows is different form Mac in file manipulation aspect. I also need you Excel version. Please send samples file of user list and card list. Looking forward to working with you, Lagi

$40 USD dalam sehari
(22 Ulasan)

Please see what I said.

$50 USD dalam 3 hari
(32 Ulasan)

Hi, I am sending you my questions in a sec. Kind Regards

$60 USD dalam sehari
(27 Ulasan)

Sir, Please send me details and I can start the project. Greetings

$35 USD dalam 3 hari
(2 Ulasan)

Serious and competent VBA job

$50 USD dalam 5 hari
(1 Ulasan)