scripting

  1. T

    Script/VBA, other possible solution to automating report bursting and copy to folder/directories?

    Hello All, This is my first post here. Is there a way in Access VBA (or any other way (really)) to split Access Reports (by group change) into individual reports and send them to a directory based on the group? In other words, if I have a report for each professor within the report and I want...
  2. C

    Timestamping formula for drop down box in Google Docs Spreadsheet

    I am stuck. I am trying to add a multiple time stamps to a google doc spreadsheet. I have figured out how to add a time stamp formula to a blank column. I created the script below: function timestamp() { return new Date() } And added the formula: =IF(ISBLANK(F3),,TIMESTAMP(F3)) to the column I...
  3. J

    Using Marcos to create financial statements from journal entries.

    I'm completely new with macros. I was wondering what you would need so that the information will automatically update itself onto a summary page. For example for entries on one worksheet to create a statement on another worksheet? Example: <tbody> Asset Type Description Date Amount OA Bonds...
  4. J

    Recursive search in nested folders/subfolders and then open file

    Hello, I have been searching for a solution to a problem for quite some times now, and I was hoping one of you have a great idea in this forum. I first like to appreciate any help and any reply to my problem. My problem is, I have an excel macro that does multiple thing for a report purpose...
  5. Chaz6

    Removing rows with VBA

    I wish to compare two worksheets and remove all the rows from worksheet 1 where there is no corresponding row in worksheet 2. I wish to compare column C in worksheet 2 starting at row 8 with column B in worksheet 2 starting at row 2. I have almost got it working, except that I have to run the...

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