Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Any Excel experts about?

  • 09-10-2007 03:39PM
    #1
    SouperComputer
    Registered Users, Registered Users 2 Posts: 6,946 ✭✭✭


    Not sure if this should go under the Windows board as its more M$-centric, but anyway......

    One of the girls at work has a customer spreadsheet which is about 800 rows and 15 columns wide. Now I know it really should be a database, but thats another story :)

    Basically she frequently needs to print the info for a given customer (each customer has a row) but only from certain columns and have it print in this format:

    Name Surname
    Address 1
    Address 2
    Tel no

    Is there a way to do this with Excel? I've just told her to highlight he row, C&P to notepad and manually reformat as needed for now.

    Any ideas?


Comments

  • #2
    Anti
    Closed Accounts Posts: 12,401 ✭✭✭✭Anti


    I found a website a few months ago, where you can post what your looking for and some guy will get back to you. I cant remember the site, but i will have a look around.


  • #3
    jabberwock
    Registered Users, Registered Users 2 Posts: 928 ✭✭✭jabberwock


    you could do it with a vlookup query quite easily.

    the basics of the formula would be like this =vlookup(A2, list, 2, FALSE)

    where
    A2 = a cell where you put in the memberid
    list = the name given to the entire sheet of customers
    2 = the column that you want to bring back
    False = makes it find an exact make to A2 (memberid)

    she can then just have the formating done in the couple of boxes and the data is dynamic depending on the memberid she puts into A2.

    have a look here for some nice pictures excel_help.html


    I've made up a little example workbook if ya want to me to send it to you.


Advertisement