Results 1 to 2 of 2

Thread: How to automate look up of id numbers in a spreadsheet from a .csv

  1. #1
    Junior Member
    Join Date
    Jan 2018
    Posts
    1
    Rep Power
    0

    How to automate look up of id numbers in a spreadsheet from a .csv

    Hi,
    I'm new to the forums. I have been tasked with using Excel to find the difference in sales week over week for certain units which are featured on our website. We have a spreadsheet of about 300 units on sale, 40 of which are featured on the website each week, this is from an exported report run weekly (I don't have access to the reporting software). The spreadsheet is formatted as follows:
    Unit#| Type (of product) | Make and Model | Stock # | Sales Total | Featured? |


    So I have a spreadsheet from week1 and a spreadsheet from week2. I can easily sort the featured column in the week2 sheet to show which 40 units were featured. What I'd like to do is quickly find all the units with "yes" in that column in the week1 sheet, to see if they were featured or not. If they weren't featured the previous week, I need to show how sales differed from the week when they were featured, from the week before when they weren't featured.

    What would be the best way to go about this or display the results?

    Could I automate the part where I look for the 40 featured units from the week2 sheet in the 300 total units of the week1 sheet by making a .csv file of those 40 unit#'s and then using a program to find each unit# in the week1 spreadsheet? If so, how would I do this and then copy each row into a new spreadsheet?

    If it makes any difference we have WinTask installed on our computers.

    I'm sure this is all simple to regular Excel users. Unfortunately, this is a weak area for me but it is something that I need to learn and do well to advance in my job. Thanks in advance for any advice or ideas!

  2. #2
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,270
    Rep Power
    10
    Hello hello hello
    Welcome to the Forum

    On the face of it does sound a task that is probably quite easy.
    But with such a requirement there are almost infinite ways of doing it, so it is very difficult to give specific help unless someone has done exactly what you want to do. I have not

    It is very easy to automate finding something in a column and there are many ways to do that.
    One way would allow you then to note the rows of where something was found and do something like copy that row , add that to a list… etc… etc… etc…

    It is difficult to know where to start.
    The best thing would be to give us some mock up reduced size data. Desensitize it if necessary ( make the data up if you like, but keep it of a representative form ). Carefully chose your data so that it can be used to test and demonstrate all possible data scenarios, but keep it to a minimum.. usually a code working on a small amount of data would work on a much larger amount with little or no modification.

    So show us on a worksheet what you might typically have
    Then either show us on another worksheet or say again what you want to have based on that specific sample data

    To Attach a File at ExcelFox:
    In the Reply window if you hit Go Advanced , then you can Add Files via the paper clip Icon

    GoAdvanced1.JPG https://imgur.com/5jtyxkE
    PaperClip2AddFiles3.JPG https://imgur.com/H2DI87d
    That should bring up the Attachment Window
    SelectFiles.JPG https://imgur.com/ml9xsNk
    UploadFiles5.JPG https://imgur.com/Ghsgiou
    Done6.JPG https://imgur.com/d5sBx5N
    If you change your mind, you can scroll down and go into Manage Attachments and delete the File from the Post
    ManageAttachments.JPG https://imgur.com/vwcKADY
    DeleteAttachment.JPG https://imgur.com/z6qqlM6
    Then close the Attachment Window


    If you do that and no one else picks the Thread up then I will take a look, possibly tomorrow.

    Alan
    Last edited by DocAElstein; 01-29-2018 at 01:11 PM.
    ….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
    If you are my enemy, we will try to kick the fucking shit out of you…..
    Winston Churchill, 1939
    Save your Forum..._
    _...KILL A MODERATOR!!

Similar Threads

  1. How to open,copy and save as .. want to automate
    By satishdu in forum Excel Help
    Replies: 2
    Last Post: 05-22-2014, 08:01 PM
  2. Replies: 2
    Last Post: 07-18-2013, 03:34 AM
  3. Replies: 4
    Last Post: 06-20-2013, 04:25 PM
  4. Automate Date Changes Within Excel Workbook
    By Danno2cu in forum Excel Help
    Replies: 9
    Last Post: 02-18-2013, 11:39 PM
  5. Automate distribution in excel spreadsheet
    By marreco in forum Excel Help
    Replies: 7
    Last Post: 12-27-2012, 10:49 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •