asked on

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,
Conference-Rooms-2016-Qtr-1-.xlsm

ASKER CERTIFIED SOLUTION

aflockhart

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

contrain

ASKER

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?

Thanks,

contrain

ASKER

The Expert provided the solution I was looking for and it worked just as explained. Excellent and thorough answer.

aflockhart

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,

contrain

ASKER

Thanks.