Moving cells down when row above is automatically populated.

Me again.......

Been trying to solve this myself but for the life of me cant get it to work right.

I have a workbook that contains 5 sheets. Sheets 2-4 contain data that when a time is added to a cell, it copies that row into sheet 1.

On sheet 1 the list will be generated based on the entries into sheets 1-4.

On sheet one I have a totals cell which calculates the total hours. At the moment when the rows automaticall insert from sheet 2-4 the cell with the total does not move and eventually gets copied over.

How can i set this up so as new rows are inserted into sheet 1, the totals cells always moves down one,

I have attached the workbook as it currently stands. Design Time Calc.xlsm

Thanks for your help once again

Hi (Again )
I have modified the code to include a running grand total on your Totals Worksheet.
Hope this helps.
Tony

Thanks again Tony

Just a quick question so I can understand in my own head how it all works.

In the Movetotalrowdown code there is this line

Application.Goto Reference:="GRANDTOTAL"

II presume this references the row with the grand total calculation on. How does this do that. ie how have you linked "GRANDTOTAL" to that row


Chris

Hi Chris
I have created a Named Range called "GRANDTOTAL" so that when the total row is moved the code can still locate it.
Tony