get data from entry made in invoice sheet and save it to seperate sheet

[snehaljp]

hello users,

I m new to this forum and need some help of yours,

I AM RUNNING A DISTRIBUTION BUSINESS OF HOME APPLIANCES, I HAVE TO MAKE SEVERAL INVOICES PER MONTH WHICH I AM DOING MANUALLY TILL NOW. NOW I AM PLANNING TO MAKE IT COMPUTERISED SO I have make and invoice format AS I NEEDED TO LOOK LIKE NOW I WANT TO GET THAT DATA ENTERED IN INVOICE SHEET TO A SEPERATE WORKSHEET i.e. DATE, INVOICE NO, BUYER NAME, PURCHASE PRODUCT, QTY, RATE, AND NET AMOUNT. AND ALSO WANT TO SAVE EACH AND EVERY INVOICE ENTRY MADE IN WORKBOOK TO NEW WORKBOOK WITH FILE NAME USING INVOICE NO AND DATE.

REGARDS,

SNEHAL PATEL

[xladept]

Hi Snehal,

Try this:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Open a macro-enabled Workbook or save your Workbook As Macro-Enabled

Select “Module” from the Insert menu

Type "Option Explicit" then paste the code under it

And, you should be ready to go

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name