Visual Basic Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsProgramming Languages - MoreVisual Basic Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old August 14th, 2003, 07:37 PM
Jimfx Jimfx is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2003
Posts: 1 Jimfx User rank is Just a Lowly Private (1 - 20 Reputation Level) 
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

Reply With Quote
Reply

Viewing: Dev Shed ForumsProgramming Languages - MoreVisual Basic Programming > VB Excel help needed: building a table via a macro


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway