Transfer Data between sheets

Hi Im new to VBA so im struggling

I have a Time sheet that has 2 sheets and I need to transfer data from sheet 1 to sheet 2. when i delete data from sheet 1 im wanting the data on sheet 2 to stay there and on the next entry move down the colums.
Sheet 2 has 3 colums: E7 to E32, G7 to G32 and I7 to I32 then theres a gap where the colums start again: E41 to E66, G41 to G66 and I41 to I66.
Sheet 1 has 3 cells P90, P92 and U99.

Sheet 1 P90 to transfer to Sheet 2 E7 then when i delete data on P90 the next entry from P90 would move down to next row which would be E8 etc.

Ive attachached sample data sheets...

Thanks

At what stage do you want the data to transfer to Sheet2?
What you do want to trigger that?

BSB

When I finished entering data on sheet 1. I thought Id add a command button or just use a VBA short cut to transfer data...

Can I just check that all three cells (P90, P91 & U99) will have a value each time Sheet2 is to be updated?

BSB

Yes, sheet 1 (Time Sheet) has 3 cells that will all contain data, P90 (Total Hours), P92 (Worked Hours) and U99 (Holidays).
Sheet 2 (Working Time Directive) Has 3 cells but in colums, (Total Hours) E7 to E32, ( Worked Hours) G7 to G32 and (Holidays) I7 to I32 but threes a break in the colums, E7 colum stops at E32 and starts again at E41 to E66, same with cells G7 and I7. What Im wanting is when the data is transfered to sheet 2 to E7, G7 and I7 and i delete sheet 1 data the next time i add data to sheet 1 the data is transfered to sheet 2 to the next row down. Iknow this sounds complicated so i added an attached workbook....
Thanks

Very basic coding, but should be easy to follow for a beginner.

Please Login or Register  to view this content.

BSB

Thank you very much, it works perfect...

Happy to help.
Don't forget to mark the thread as SOLVED if you're happy you have a working solution.

Have a good day.

BSB