Hi all,
This is my first post (of probably many!)
I have created a Macro that copies and expands rows in Sheet 2 based on a value enter in a column in Sheet 1
(see attached example)
It works but I need some help fine tuning what I want to achieve:
-After expanding the rows I want to enter data manually in the next column (Room Type),however each time I run the Macro it deletes the info I entered and creates a blank cell. In other words I do not want the Macro to populate column K. I've tried not entering column K on sheet one, but again if I create column K manually after the Macro is run - it dissapears on every running of the Macro - if that makes sense.
-As you can see I also have a problem copying the Headers into from Sheet 1 into Sheet 2, when the Macro is run the first line populates where the headers should be, how do I get the headers?
-Then one last question (for when the Macro runs as i want it to)
If the value in Sheet 1 is reduces, what will happen to Sheet 2 where the K column should be constant.
For example:
Original value in Sheet 1 for number of rooms is 3
In Sheet 2 it will populate 3 seperate lines
I manually update Sheet 2 Column K for 3 Lines (Line 1:Standard,Line 2:Superior,Line 3:Deluxe)
I then change the value in Sheet 1 to number of rooms 2
Will the Macro keep Line 3 without data besides the manual input (Deluxe) or will it delete the entire row?
Many thanks in advance!!
Bookmarks