Hi,
I have created a macro in a sheet named " Invoice" where the details once entered and saved gets saved in separate workbooks enabling me to view it later. But i need to be able to create a report for them in another workbook named "Reports" summarized by the categories in the invoices set. The forms are attached.
I have a question for you - Once you fill in the data in Invoice.xlsm and you report the data in Report.xlsm, if you want to create a new invoice, where would that info go in Report.xlsm? Below the existing data?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Once the data is filled in the invoice workbook and saved, the details gets saved in separate workbooks. i want to be able to prepare a report which the details category wise can get saved in the next available column in the Report Sheet. Please refer the attachment. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks