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
I have to workbooks
1) monthly workbook users ( the users in column C start row 18 ) with date of days
like this;
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