Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: invoice

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,038
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    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?


  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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


  4. #4
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.
    ~Anne Troy

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,038
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    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

  6. #6
    New Member
    Join Date
    Mar 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  7. #7
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,038
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    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.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •