+ Reply to Thread
Results 1 to 3 of 3

Making a bill in excel

  1. #1
    Registered User
    Join Date
    10-04-2011
    Location
    Cape Town
    MS-Off Ver
    Excel 2003
    Posts
    1

    Making a bill in excel

    Dear all

    My first post so hi to all, I know the very basics of excel so any help welcome.

    I have a small business that over a period of time people build up a bill with me, So I have started an excel spreadsheet with headings along the top of the expenditure and names down the side to which in the cells I add the amount.

    I want to print a bill, so I set up a second sheet with the graphics etc on and have brought the information across by using the =Sheet1!C1 formula.

    The above doesn't work due to not knowing how to change the bill as a whole on the second sheet. I move the cells and the whole formula changes etc

    However what I want to do is add the name off the customer to the second sheet and the bill come across.

    Am I doing this correctly is this the easiest way? Any advice greatly received

    Thank you

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127

    Re: Making a bill in excel

    Could you post a sample of the workbook you're working with? This can help us to better assist you. (Obviously, change any sensitive data with fake information.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Making a bill in excel

    Probably VLOOKUP & a Data Validation list. Read these & look at the example workbook
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

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