Is this possible? Macros, Userforms etc

X

xirokx

Hi,

I place alot of purchase orders in a day which contain the followin
info:

Order #, Date, Supplier Name, Qty, Price, Item ref, Item Desc,Shippin
date

I would like to create a userform which allows me to enter the abov
data into a template order and then save the order in the relevan
supplier folder in excel (so I would have to get a choice of where t
save the file) and then allow me to print the order.

I would also like excel to determine the next order number and ente
the date for me etc.

So I would need command buttons such as save as, print, add new file
close.....

Is this at all possible?

I am a total noob when it comes to macros etc so I think it would be
great thing to accomplish, if its possible I would really appreciat
some feed back/help???

Please advise comments

Thanks in advance...............
 
L

Leith Ross

Hello Xirokx,

To answer your first question, yes this is possible, and for the othe
questions... This is not something that lends itself to snippets o
code being posted on a newsgroup. This is a fairly involved project
especially for a beginner. I have helped quite a few people develo
these types of applications and would be willing to help you with you
project.

Sincerely,
Leith Ros
 
Top