Results 1 to 5 of 5

Asset history in excel

Threaded View

  1. #1
    Registered User
    Join Date
    01-29-2014
    Location
    swindon, england
    MS-Off Ver
    Excel 2013
    Posts
    38

    Asset history in excel

    Hi everyone,

    I have a question which im strugling with.

    I want to make a data sheet where i can pull the history of a curtain asset. its as follow, attached a file as i call it airs lookup tool
    The top part is made to view the current data from a hidden csv sheet inside the file which will be updated daily.
    Prefferable no changes must be made on this sheet cause its copy paste as it is.

    In the main sheet called showlist below the first part there are some cells which i like to see the history of a asset pulled from the csv sheet, these must contain al history of this asset which is entered in C4. How do i accomplishe this. ive tried vlookup but it doesnt do it.

    any help would be appreciated. ps the original csv containes 82000 assets, so ive shortened the file a bit
    The history of an asset can contain 10 til 20 lines and several dates are there from 2014 till 2008

    who can help me and explain things to me how it works best
    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. A brief history of Excel Time!
    By craigproudfoot in forum Excel General
    Replies: 5
    Last Post: 02-18-2014, 11:04 AM
  2. Asset Maintenance Plan in Excel 2010
    By ballie in forum Excel General
    Replies: 1
    Last Post: 07-13-2012, 02:51 PM
  3. Help: Excel Printing History
    By qdoom in forum Excel General
    Replies: 1
    Last Post: 12-18-2006, 02:12 PM
  4. EXCEL HISTORY
    By Wayne in forum Excel General
    Replies: 5
    Last Post: 10-17-2005, 05:05 PM
  5. [SOLVED] Excel Should Have a History Function.
    By Ray M. in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-23-2005, 04:05 AM

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