automatically fill data from sheet1 to sheet2 based on date in sheet 1

[glent]

Hi

I am trying to find a way to automatically fill data from sheet1 to sheet2 for trip details from one place to another.
On sheet1, there is data entered daily. I want all data to be transferred to sheet2 as its entered.
when data for a new date is entered in sheet1 , all data is to be transferred to a new row in sheet2.

Basically all data is entered to sheet1 for each day. sheet 2 is keeping daily record of all data for the whole year or as long as I continue entering sheet1
I want a formula to do this as I use my phone excel app to enter data and view all records in sheet2.



hope its clear.

any help appreciated!

[AliGW]

Welcome to the forum.

You will need VBA coding for this - shall I move the thread for you?

[glent]

hi Ali

thanks for taking time to help.

i wonder if vba would work on phone,if so its very helpful

if not, what changes to my requirements would make possible to use it on the phone.i need it as close as possible to the posted requirement.

Regards