I would like to learn how to write a macros that will take a set of cells with the names of hospital units and copy them down with the next corresponding month. Please see attachment for example. The macros code doesn't repeat the action for the next months. Here is my code:
Please Login or Register to view this content.
Used it the marcos recorder.
Last edited by Leith Ross; 07-10-2011 at 06:05 PM. Reason: Added Code Tags
THis should do it, it will ask you how many new months you want to add, then it will extend the range that many months incrementing from the last date in column B. Formatting is preserved as well. Any data you may have entered into the table in the existing months will not be transferred if it exists.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you! The code works like a charm.
TheCloud
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks