invoice

[canablitz]

can anybody suggest a way to enter a customers details into an invoice, from a sheet with all the members details on?

please and thankyou very much

BoB

[Aladin Akyurek]

On 2002-04-26 06:37, canablitz wrote:
can anybody suggest a way to enter a customers details into an invoice, from a sheet with all the members details on?

please and thankyou very much

BoB

What is the range address that houses your list?

What kind of data do you have that list?

In which cell of your invoice do you want the customer address info?

[canablitz]

hi aladin,
the data that i have in my list is like: Title First Name Last Name Address 1 Address 2 Address 3 Post Code E - Mail address

not neccesrily in that order,

the range is will change as i add more people to it, so i guess it would be: 65534R x 8C.

and i want the address to go like this:

E12 = name
e13 = address

it is the invoise template from within excel

i hope this helps you to help me, thankyou

BoB

[Anne Troy]

You can download MyInvoicing as an example file or use it as it is.

http://www.thewordexpert.com/tipwarez.htm

It contains vlookups that you'll need, etc.

[Aladin Akyurek]

On 2002-04-26 06:52, canablitz wrote:
hi aladin,
the data that i have in my list is like: Title First Name Last Name Address 1 Address 2 Address 3 Post Code E - Mail address

not neccesrily in that order,

the range is will change as i add more people to it, so i guess it would be: 65534R x 8C.

and i want the address to go like this:

E12 = name
e13 = address

it is the invoise template from within excel

i hope this helps you to help me, thankyou

BoB

Hope you're not expecting some VBA code from me! I'll attempt to propose a formula-based approach. But, I need more.

Go to the worksheet where you have these customer address data. Select an unused cell, type =, select 15 rows of data including the labels, hit F9, copy what you see, paste it in the follow up along with the info that includes the columns in A1 style.

Aladin

[canablitz]

hi, thanx for all you help, but ive got as far as copying what i see, but where do i paste it, i dont understand what you mean by "the follow up"

please could you explain what this means

BoB

[Aladin Akyurek]

On 2002-04-29 04:22, canablitz wrote:
hi, thanx for all you help, but ive got as far as copying what i see, but where do i paste it, i dont understand what you mean by "the follow up"

please could you explain what this means

BoB

Right here in your reply to this post.