Adding Set number of rows according to cell value

Hi Guys

Sorry my knowedge is very patchy around Excel and was wondering if there was a simple soultion. Basically I want to build a project testing tracker, with each row starting on day number (ie day 1, day 2 etc).

Is there an easy way to copy down a set number of rows ie if the number of days for testing is set to 10 (Cell B4), is there any simple way of making my table automatically copy down for ten rows, including the formuales, as soon as I type in a number for Cell B4? I dont want to have to run a macro command if i can avoid it.

Thanks in advance for helping

Regards

Mike

Hi and thanks for your reply.

Basically I just want to enter a number into one cell, and whatever that number is created the number of lines. Ie Row 5 has the data in, if I have 10 days to fill down, I want to copy row 5 down for ten rows to create the table. Does this make sense?

Regards

Mike

Thank you very much for your response. However it does not seem to work. Incidentally, Cell B4 is kind of a highlight but will drive the table. At the moment the table header starts on A6 to H6, and the values start in A7 to H7. If I say that the project will last 4 days (ie 4 is put in cell B4), i will need row 7 copied down an additional three times (so row 7, 8, 9 and 10 giving the four days). My spreadsheet is called dailystatreport.

I have tried playing with the code but to no avail. Any help is of course appreciated. I know im trying to run before i can walk, but sometimes in excel its just the way it is!

Thanks all,