Inserting Rows based on a cell value and populating them.

Hello and PLEASE HELP!!!

I would like to insert a number of rows x (the value in cell B32), directly below row Row 32. I want Column A to read "Enter the name of Room #(1,2,3...x)" In Column B I want it to say "Room (1,2,3....x). This is all on the same sheet.

After this is working on operator will input values into column C. Then I will want to insert rows on another page based on the operators input. BUT one step at a time. I'm okay at excel, but not so good at Macros.

Thanks you for your help!!

Thanks HaHoBe!!!

First the routine worked well!!!! However I must have been slightly unclear in the auto fill portion. What I was looking for was to have the a column say "Enter the name of Room #1", the next row would say "Enter the Name of Room #2", followed by "Enter the name of Room #3", And so forth until all of the new rows (based on the value in cell B32) are full. Column B would be similar, except it would be Room #1, Room #2, Room #3 and so forth. Is this possible???

Secondly, I also have no idea what a worksheet change event command is or where/how to use it. When I get to this stage of the project, there will be some simple column formulations that will need to be adjusted as the number of rows change. Need to fix the auto fill portion first!!!!

Thanks again for your help!!

Oh...just noticed this too....

When I change the value in B32, it pushes data to the right. I need to have all of the data deleted, even if the value will be smaller.

Thanks again!!