I need to enter the values in next row if values are entered in row.

Im generating the report daily. using everyday report i need to prepare the graph.
so every day same field are getting updated. Instead i need to update the values in next row.

for eg.

there is data in c5 to h5. next day while running the macro the values should be updated from c6 to h6

please help me ASAP.....

i have attached the excel ... please verify...



thanks in advance .

Typically, find the first available empty cell at the bottom on your table, so add this

Please Login or Register  to view this content.

then change all instance of code like this

Please Login or Register  to view this content.

to code like this

Please Login or Register  to view this content.