Updating conference room spreadsheets

In the attached XL 2010 macro enabled workbook, I  have a listing of conference rooms for 2015. I need the dates and rooms with accompanying extensions updated to reflect 2016. Some of the room  names and extensions have changed from 2015 to 2016, so I have already done the January 1 2016 part of the workbook the way I would like the rest of the workbooks to look with the correct room names and extensions. I need to create 4 workbooks each comprising 3 months of the year to reflect each quarter, so if the answer is a macro I will need to be able to run it in each of the 4 workbooks. The format also needs to remain constant across all for workbooks.

Thank you,
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Here's something that can create the sheets.

I've set it up to use a SOURCE sheet which you can populate and format.  Then you can select the range that you want to duplicate, and run the macro.  That will allow you to use it for 2016 and then again for 2017 and beyond.

It's easier to create all 12 months in one workbook - you can simply copy or move them if you want three-monthly workbooks.

Feel free to mess about with the code or to ask questions about it.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
contrainAuthor Commented:
Hi aflockhart, I'm going to accept your answer and give you the points, but I'm not quite sure what the macro 2 and macro 3 do. Would you please let me know?

contrainAuthor Commented:
The Expert provided the solution I was looking for and it worked just as explained. Excellent and thorough answer.
Hi - you can ignore ( and delete, if you want) macro2 and macro3 - they are temporary macros that I recorded during the development.

It's quite a good way to check the exact syntax needed to perform a  particular action, if you're not sure - record a macro while performing the action manually, and then cut or copy the relevant command into the macro that you are writing,
contrainAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.