how can i create back up sheet using Macro..?

[ilu333]

i made a invoice sheet for generating bills but i want to save each record that fills up in these sheet to be saved on other sheet as a database
can any one help me for these?
invoices are created at run time and at same time that entry would be
stored on a backup sheets and invoice get blanked for next entry
and after each entry records are stored in back file
that's all i wanna do with help of VBA

[AndyLitch]

Hi
Would it be possible for you to upload a copy of the file so we can get a clearer understanding?.. It will speed up the process and is more likely to achieve the best possible solution.
Just be mindful of the fact that you're not supposed to upload sensitive or secret information

1. Select Edit Message or Reply
2. Select "Go Advanced" at the bottom right of the message area
3. Select the paper clip on the menu bar
4. Follow the wizard instructions for uploading a file.

[ilu333]

hiiiii

Here i have attached file.....

[AndyLitch]

SHARDA TOURS.xlsm

I've started you off.. The macro copies all the invoice data to a table on sheet1..
You need to verify all the data is there and tidy up the display.