
August 14th, 2003, 07:37 PM
|
|
Junior Member
|
|
Join Date: Aug 2003
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
VB Excel help needed: building a table via a macro
My problem is: I do not know how to program in VBA for excel , (I only can record a macro) and unfortunately I do not have the time and IQ to change this . So I hope I will achieve my goal via this great forum.
Can someone help me with making a table with a macro in Excel?
I have an excel file which I use to printout invoices. When the invoice is ready I click on the "Print" macro button. What I also like to see is that when I click on the button, the macro should copy certain cells to a table which allows me to store revenue data.
Suppose it’s like this
Date: 12-jun (Cell A2)
Customer: CustA (cell B2)
Invoice amount: 1200,- (Cell C2)
The macro should create a Revenue-list table to the sheet “revenue” which looks like this
12-jun CustA 1200,-
etc. etc. etc.
etc. etc. etc.
Can someone Help me with this e.g. by sending an example script? you’re help is mostly appreciated.
Jim
The Netherlands
|