Repost of old closed thread

[ace_silver10]

Hi everyone... Not sure if this is possible but i will put it out there...

Basicly what im trying to achieve is creating an microsoft word (or simalar) invoice from my excel spread sheet.

My current excel spreadsheet is set on a monthly basis. on it it has my customer list. I provide a service for people so at the end of that month i enter what type of service and who for and make a seperate invoice based on the calculations........ C#&P ive got no idea what im talking about

Im gonna make a fake formula and hopefully somone will understand what im trying to do, everything in these brakets { } is what im trying to do

={cell F6 (customers name)}({send the info in this cell (customers name) to word temlate and insert into customers name section})

Good way to explain it is that i want excell to automaticly create a word invoice, and im guessing i need to have a word template for it.

I really hope someone understands what i am trying to do because at the end of the month it takes about 2 hrs to enter all the different info for the customers into my excel spread sheet and another 2 days to make all the invoices for each customer and it is only a matter of time before i make a simple mistake which could cost me thousands...

[VBA Noob]

Closed again for poor title

VBA Noob