Code for Inserting & Deleting lines

Hello everyone

I'm fairly new to vba so I need help!

Request 1:

I'm trying to create a macro that will automatically copy and insert/or delete rows based on a number that I put into a certain cell, say A1 or whatever cell I designate.

The spreadsheet is a tenant list for a building. I will always have a 'master' row with formula's etc in it, but based on the number placed in A1, I want the macro to insert & copy/delete the number of rows matching the input. For eg. if A1 has 5 in it, I want the macro to copy the 'master' row so that there are a total of 5 rows, including the master. If I then change the input to 3, the macro must delete 2 rows, always keeping the master row at the top of the table.

A second request:
Similar to 1, but I will create the tenant table on sheet 1, I then want the macro to do the same inserting & copying/deleting in another sheet, say sheet 2. ie. the master row is on sheet 2 called, say cash flow. The number of rows that it inserts/deletes should be based on the number of rows it counts in the tenant table in sheet 1

Is this too much to ask of the forum - I know you guys are whizzs at this stuff

Thanks

Hi Pike
Thanks very much for your guidance - I will work through the code as best I can
Regards,