need to create an invoice for billing

bump

Welcome to the Board!

You'll find a ton of invoice templates in the Microsoft Template Gallery.

And there's a good VLOOKUP primmer here: http://www.contextures.com/xlFunctions02.html

Once you settle on the design you want, you would just add a sheet and populate it with your customer data. Then you can add your VLOOKUPS. Generally I use a Data Validation list to populate my customer name cell, then draw everything else off of that.

Hope that helps,

Thank you so much for the reply
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

I am looking at what VLOOKUP is now, wow, have I got a lot to learn
<o></o>
I attempted data validation first but all I can make it do is display a message when cell is active.
<o></o>

??I have a similar question on another forum and was asked to post a link to this one, should I do the same here??




Just incase here it is, don't want to get in trouble here
[URL]http://www.excelforum.com/showthread.php?p=1893662&posted=1#post1893662[/URL]

To create the Data Validation list, first create a list. Goto your customer data and select the range of customer names then goto Insert-->Name-->Define and name your list. Then in the Invoice sheet where you want the drop down and goto Data-->Validation-->Allow-->List-->Source-->"=ListName" (no quotes).

Re: the cross post, that's fine as long as you let everyone know.

Re: your VLOOKUP post, you should try to stick to your original in the future, so everyone can see what has happened up until the point you created a new post.