macros microsoft excel

  1. E

    How do I auto change date

    Hi, I have .csv sheet that auto daily download from staff attendance system. But some of the date is supposed to be previous day date. Is it possible to auto change the date based on condition? Suppose today date is 27/12/2016 Eg. Staff Name. Shift. Date Lala...
  2. E

    Macro to calculate total staff attendance

    Hi, I have daily data and calendar. In daily data it keep date, staffid, time, type time,etc. In calendar, it have staff shift schedule. Eg: Daily Data (21 dec) 16630 Shift A 8am exit 16630 Shift A 7.53pm in 16630 Shift A 11.04pm exit Daily Data (22 dec) 16630 Shift A 00.23am in Eg: calendar...
  3. E

    Cannot refresh table on protected sheet

    Hi, I have workbook A that connected to workbook B. Workbook B will always be update daily. I'm apply protected sheet in workbook A but when I tried to refresh the data it failed. Or is there any macro code tht can auto update every 3 hours? Thanks in advance
  4. E

    Copying data from worksheet to another worksheet using macro

    Hi, i'm beginners to excel macros. i have a system that will automatically download and update the report per hour in . csv . I want to copy all the data to another excel that already contain the previous data from the system. How to use macro to copying the data every 3 hours, paste it below...

This Week's Hot Topics

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
Top