Link to home
Start Free TrialLog in
Avatar of contrain
contrainFlag for United States of America

asked on

Need to add extra room to conference room xls

This is an xl 2010 doc running in 2003 compatibility mode, I believe due to a macro that was created in 2003. I have an xl workbook with the sheets reflecting each month of 2014 and for each day of the year on each sheet, I am listing our conference rooms to schedule reservations. I need to add a room, named 18 East to each day of the year. It must be located two cells below the extention number of room 18 Central, so for instance on January 1, I will need the words "18 East" (without the quotes) to be in cell A23 and for January 2, I will need the same thing in cell A64 etc. for each day of the year. All sheets are formatted so that the words 18 East will always be two cells below the extension of 18 Central (4152).

Thanks,
Conference-Rooms-2014.xls
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of contrain

ASKER

YES!!!!!!! This is exactly what I needed and worked perfectly. The Expert was able to solve my issue with the information and in all of the correct places. Fantastic solution!!!!!