Need help with making a invoice maker

[CarlSorensen]

Hi
I need to make an invoice maker for my company. I am having problems making cell show up through-out the sheets. Here is what i need to do:

Enter P.O. #'s some existing, some new.
I want to enter basic info an a cover page. Then have it show up where i need the info through-out the sheets. That is what i am having the most problems with.

[stevebausch]

I don't know where to start here. Keep in mind I am currently working on an in-bound material-inspection document that adds barcodes to most of the cells.


So, in no particular order:

Why not use a multipart form, with a line printer? Historically, that's how invoices are created. The various copies reveal/conceal the needed informations. Yep, it's expensive, but it works.

Why the multiple worksheets in the workbook? You can manipulate the font color (set to white) in order to conceal information. I assume that you feel the need to create multiple worksheets, in an attempt to conceal/reveal information.

If need be, you can use the BeforePrint routine to manipulate and format your data, but unless you are dealing with a bunch of "been here twenty years, and I ain't changing" employees, better you have a Print Invoice button on the form. They can learn to push the button. You won't have a useful Print Preview function, however.

If you insist on using the Excel print function/icon, that can be done, but be careful with the BeforePrint routine, you can send yourself off in a loop. While your BeforePrint routine is working, you may need to set EnableEvents to False.

The Print Invoice macro would:
On the first print, print the form as keyed in.

On second print, you can conceal information by changing the font color on some columns/rows as needed.

If you need to generate markups, discounts, etc. do those, and then print the form a third time.


Of course, I am not thinking you need to keep digital copies of each 'carbon' of the invoice. Normally, companies would not keep carbons of the 'customer copy', 'shipping department copy' etc.

Okay, here's the deal: You read what I have posted, respond with questions and comments, and I will come back and try to make sense of what I just told you.

[CarlSorensen]

Let me explaine my question a little better....
I Have everything set up, but I dont know the code to put in the cell, so that i can that data show up in the rest of the sheets.

Two thing will need to be happening, i need to have a P.O. # Entered. Either in Existing, or in New. The i need to put one of them to the rest of the form. ( Ether New Or Existing)so i know that i will need to do if statments......please help me if you can.

Thank you very much