Results 1 to 10 of 10

Excel 2007 : Help to Auto-fill price on invoice spreadsheet

Threaded View

  1. #1
    Registered User
    Join Date
    02-29-2012
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Help to Auto-fill price on invoice spreadsheet

    Hi,

    I have an invoice that I use and I want to make it so that when I type in the name of an item that it would first auto-fill the name of the design after I start typing a few letters and then auto fill the price of the item.

    I have looked at a few examples in this forum so I have created a "sheet2" and made two colums "Design Name" and "Price" but I have no idea what to do to "link" this sheet up with the invoice. Because when I type in the name of the design in the invoice, the price is not auto-filling.

    I'm stumped. I google EVERYTHING and I can't find the answer to this anywhere. The closest I've found is on this forum but after following the
    instructions on a couple of posts I'm still unsuccessful. and its really bugging me and hope someone can provide me with some assistance.

    I've attached a copy of my invoice (of course I have omitted the private info)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1