Results 1 to 3 of 3

Thread: Copy data from 1 excel workbook to another based on certain criteria

  1. #1
    Junior Member
    Join Date
    Sep 2013
    Posts
    1
    Rep Power
    0

    Copy data from 1 excel workbook to another based on certain criteria

    Hello all,

    I could really use the help of those much smarter than I.

    I need to create a master list of items that are coming in from many other workbooks. These other workbooks are all in the same, terrible format (Not my fault it was made before I arrived), but I cannot do much to change that. I have attached the worksheet that I need to get the data from. I need to grab the Vendor, Contact, Contact telephone, Equipment, and Req'd Date when there is a Req'd Date (So if the Req'd Date is blank, it is not being ordered and as such should be left out entirely). I also need to get the address of either the site or the warehouse (listed at the top) based on the Delivered to Site or Warehouse column.

    Then for each row that contains a req'd date, I need to paste the data above into the first unused line in a different workbook.

    Any help would be much appreciated as I have no VBA experience and not the slightest clue where to begin.

    Thanks,
    Matt

    I should also have mentioned that each of the workbooks coming in are originally the same, just blank, and then someone fills it out and sends it back. Therefore, a macro to export the data would be included in all of the incoming workbooks.
    Attached Files Attached Files

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Matt, welcome to ExcelFox

    This can be done. But the entire requirement looks more like a project request than a request for help. Maybe offering some incentive might get you going. In the meanwhile, can you clearly mention the cell address of each of the cells you require to be captured from above row 28 (the ones below are straight forward).
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    I do not think there is any way to add more than 256 columns... you probably could use keys to uniquely identify records, and split the columns in to multiple tables. You could also check if Access 2013 allows more than 256 columns.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Replies: 9
    Last Post: 07-02-2013, 10:02 PM
  2. Summing Data based on certain criteria
    By Howardc in forum Excel Help
    Replies: 7
    Last Post: 01-30-2013, 07:12 PM
  3. VBA Code to Open Workbook and copy data
    By Howardc in forum Excel Help
    Replies: 16
    Last Post: 08-15-2012, 06:58 PM
  4. VBA code to copy data from source workbook
    By Howardc in forum Excel Help
    Replies: 1
    Last Post: 07-30-2012, 09:28 AM
  5. Split data based on criteria
    By Mahesh.sreekakulam in forum Excel Help
    Replies: 3
    Last Post: 06-08-2012, 09:30 PM

Posting Permissions

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