accomplished

  1. P

    Save As already populated based on Cell(s) information

    I need to send out a general template. What I would like in return if for the end user to need to change the name of the file. When they do a save as, to look at certain cells to create the new file name. How can this be accomplished? Thank you
  2. M

    Subtracting to Produce a Year, from Dates

    Hi all, I have 3 dates that I am working with. A date that I need to find the number of years from today (this is a date someone started with our company)....This I have accomplished by using the following =DATEDIF(D21,NOW(),"Y")&"years,"&DATEDIF(D21,NOW(),"ym")&"months" Then I have 2 more...
  3. C

    Date Subtraction from Blank Cells

    Greetings, I have =Today() in cell C2 which is working fine. In column Z I have the dates of when a task has been accomplished. In column AA I have it calculating how many days it has been since the task was accomplished. So if cell Z6 has an accomplished date then cell A6 is =Z6-C2 which has...
  4. A

    VBA to Copy last 3 Spreadsheets to a new Workbook

    Hello, I am trying to create a macro which copies and pastes the last 3 Spreadsheets of a Workbook into a new one. Anyone has any ideas of how this can be accomplished? What I've tried so far does not work. Thank you in advance!

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