Results 1 to 2 of 2

I need info to search and enter data.

Threaded View

AeroTheManiac I need info to search and... 02-06-2014, 01:11 PM
AeroTheManiac Re: I need info to search and... 02-06-2014, 01:54 PM
  1. #1
    Registered User
    Join Date
    01-17-2014
    Location
    America
    MS-Off Ver
    Excel 2007
    Posts
    27

    I need info to search and enter data.

    Attached is a sample of what I need completed.
    Monthly, I have to do a chart just like this except slightly more complicated.

    In the Sample download, there are three charts, "Sample Chart", "Sample Input", and "Desired Result".
    "Sample Chart" has a list of accounts from different companies, The first column being their number, the second being their name, and the third being the money they spent.
    The "Money Spent" Column is always blank when I start for ALL companies.

    I have another chart, "Sample Input", which contains the prices that I'm supposed to put in "Sample Chart, Money Spent" column.
    The thing is, "Sample Input" only has the companies with prices listed.. Not all companies have prices, so this means the "Sample Input" is always a shorter list than "Sample Chart".

    What I need help with is the prices from "Sample Input" to be put in the correct position in "Sample Chart". The "Desired Result" chart is what I want it to look like.. exactly like that!

    When I do this monthly, I have to scroll through several thousand accounts doing this, and it kills the eyes, hahaha. I have some suggested ideas if interested:

    Suggestions:
    - Possibly have a macro or formula take the Account # in "Sample Input".. Sample it in "Sample Chart", then copy the price and paste it in the right location.
    - Possibly make "Sample Input" have blank rows inserted in the places where it should have the account with no prices.

    Thanks a ton for reading this essay of a post!
    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. match data in two columns, enter info in certain cell
    By mslavick in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-15-2012, 03:10 PM
  2. Replies: 4
    Last Post: 09-12-2012, 05:52 PM
  3. Search and find info, if correct info found copy into new worksheet
    By JnrParki in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-13-2011, 11:36 AM
  4. Enter Cell Info, Retrieve Info from Website, Record Results
    By DrSues02 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-17-2009, 09:03 AM
  5. search data set, then put in all info base on one critera
    By senior blanco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-20-2006, 11:30 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