Results 1 to 19 of 19

Help to create forumla that automatically fills a row of info when conditions match

Threaded View

  1. #1
    Registered User
    Join Date
    09-21-2011
    Location
    London
    MS-Off Ver
    365
    Posts
    71

    Help to create forumla that automatically fills a row of info when conditions match

    Hi Guys,

    I have attached the sheet I am working on with a description of what I am trying to do.

    When I enter an invoice number on sheet 2, I want the information on sheet 1 that has the same invoice number next to it to transfer onto sheet 1 in a list, bringing across the information that relates to that same invoice number. i.e. floor, house type, plot, stage, amount.

    It's difficult to explain without looking at it, and I have explained more clearly on the spreadsheet attached (I hope).

    I'm not sure if this can even be done, or if Im asking too much from excel...

    Any help would be very much appreciated as I have only basic skills at writing formula and I'm really stuck

    Thank you in advance to anyone who can help.

    Kate
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need a table, which fills in numbers automatically depending on text in column
    By Hotsoup666 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-20-2013, 03:13 AM
  2. Replies: 1
    Last Post: 10-04-2012, 03:24 PM
  3. How to Create a Time Sheet that Fills Out Dates Automatically
    By qualityoflife in forum Excel General
    Replies: 2
    Last Post: 12-10-2010, 06:57 AM
  4. Create new row on new sheet IF conditions match
    By jjkroell in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-28-2008, 01:04 AM
  5. when using InStr function, it fills the target cell repeating info
    By durandal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-06-2008, 12:01 PM

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