Hi,
I have been working with an Excel file to send automatic mail based on some criteria and change dates when the ActiveX check box is checked.
Condition:
If I check the box, 'TRUE' is displayed in the adjacent cell. If TRUE, the current date has to be added with numbers (7, 30, 120...
Hello :)
I am trying to get data from 30+ workbooks into a new workbook. The 30+ are created daily, generated via e-mail; those e-mails are pasted into a new folder each day with the date and time. I need to pull the data from each workbook into a tab titled "Raw Data" in another daily...
I have a column with dates in format yyyy/mm/dd
I copy dates from other excelfiles that has the date format yyyy-mm
When I copy the dates with the DATE format yyyy-mm, they keep that format even if the new column is set to DATE format as yyyy/mm/dd.
I would like the dates with the format...
https://spreadsheets.google.com/spreadsheet/ar?&hl=en&w=1&id=tcCRNoWSKI8tAFScOp2pHFg.00535076764060981446.5898301702373296406&action=1&tile=1&rpert=20&srow=0&erow=34&scol=0&ecol=12&fprt=false&tfe=jc_213&gsessionid=-4fQOzhCjTQ
This URL will take you to a employee timesheet I embedded in my...
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.