Transposing Data Macro

  • I created a calendar with a lot of data fields that need to be entered daily. This data gets copied to a master schedule, but occasionally needs to be edited. I created a macro that simply copies and pastes the master calendar data back into the editable calendar so users don't have to start over, however I'm wondering if a better way to do this is possible as it takes several minutes to use the copy/paste macro I recorded to complete. Here's a snippet of the macro:

  • Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

    All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.

    How to use code tags

    Just highlight all of the code and press the <> in the post menu above button to add the code tags.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!