vba code to Compare two columns in diffrent workbooks

LET ME

New Member
Joined
Jan 31, 2021
Messages
2
Office Version
  1. 2019
Platform
  1. Windows
Hello

I have to workbooks

1) monthly workbook users ( the users in column C start row 18 ) with date of days
like this;
2) daily workbook users ( the users in column A start row 1 ) the date of day in C2
3) botton to import daily workbook from monthly workbook and compare users
4) if find users add value = 1 under date of day [ if can't add value in date cells, add the value in select cell]
5) if not, add value = 2
6) msgbox if empty file ( xxxx )
7) msgbox if cells in monthly workbook have value, stop and show message ( xxxxx )
8) msgbox if dont select file ( xxxxxxx )
9 msgbox if done ( xxxxx )

thank you
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Forum statistics

Threads
1,215,064
Messages
6,122,939
Members
449,094
Latest member
teemeren

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top