coping a range into the next available empty cell in column "A"

[joe dech]

Hi

I need help with a macro/vba. By clicking the "Add Another Project!" button, I require the macro to copy a range ("A8:S11") into the next available empty cell, Column "A". I want it to copy the formulas but clear the contents. If I click button again, to add another project,I require it to go to the last available empty cell.

attached is my workbook, I'm referring to worksheet labelled "Weekly Time Sheet".

any help would be greatly appreciated!
Thanks in advance
Joe.

[ConneXionLost]

Hi Joe and Welcome to the forum!

I'm going to assume this is actually an Excel question (and not an Access database question), and move your thread for you.

Cheers,

[kvsrinivasamurthy]

Pl see the attached file.Any clarifications welcome.

[joe dech]

Thank you very much for your help!
Awesome!

Joe.