Using excel to take customer's profile data then save it in a chronological order?

[jjin]

Hi guys,

I am currently using an excel to take customer's raw data (profile and etc) and now I am trying to find a way to store the data obtained in sheet 1 into another worksheet (Sheet2) - what i want to achieve is that by clicking a button in sheet 1, it copies the raw data into sheet 2 in a chronological order

Please see attached the sample excel file below for your understanding.

Any help will be highly appreciated.

Cheers,

[Mallycat]

What you are asking can of course be done, but I don't know why you would bother. Better to format the table in sheet 2 as a "table" and then just sort it how you want.

[jaslake]

Hi jjin

Try this

Please Login or Register  to view this content.