Invoice sheet using some vba codes

[naga]

Hi,

Am developing an Invoice sheet for my customers who are hiring Taxi from my company.
I need to save some of the datas to another sheet in a single row.
Once the Invoice is made it should be saved and the contents should be cleared.

I have attached my sample file with explanations.

Please help.Invoice file.xlsx

[IgorSharov]

May be something in this kind?Invoice file2.xlsm

[naga]

Yeah this is what I was looking for.

Now I need to copy the cell values to another sheet based on the vehicle number.

Suppose if the vehicle number is " TN 33 AR 4174" the details should be copied to the worksheet named "AR 4174".

Can this be made?

[IgorSharov]

Catch it! I hope it was all you need Invoice file2.xlsm

[naga]

I Caught it IgorSharov.

This is what I need actually.

Thanks for the help.

[naga]

I have made some modifications to the file as per my requirements.
The data from the main sheet are copied to the next sheet according to the vehicle number.
Now the data Ranges from A to O.
I have other datas in the Range from P to AF.

TheLastRow = Worksheets(VN_Sheet).UsedRange.SpecialCells(xlCellTypeLastCell).Row + 1

This code checks the last usedRange.
Now I want to modify it to Range(A:O).
What is the coding for this?

Can somebody help me?

File attached for reference

[IgorSharov]

I can't open macros in your book. Can you save the book as Excel 2007 workbook and attach this one again?

[naga]

Hi,

IgorSharov I sorted out the problem.
Its saved in 2007 format only.

[IgorSharov]

I was glad to help you a bit.