Announcement

Collapse
No announcement yet.

$40 - Count/Add multiple company records and write to new row - Need ASAP

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • $40 - Count/Add multiple company records and write to new row - Need ASAP

    $40. 10% paid to OZGrid PayPal. Need within a few hours of accepting (By 1PM EST at latest)

    Tasks

    1) For each unique "Vendor" name on "Bills" tab, count the number of records for the "Vendor"and write to "No. of Orders" column on "List" sheet in addition to the "Vendor" name in the "Vendor" column.
    2) For each unique "Vendor" on "Bills" tab, lookup all dates in the "Date" column and write the first and last date associated to the "First Order Date" and "Last Order Date" columns on the "List" tab.
    3) For each unique "Vendor" on the "Bills" tab, add all the values from the "Amount" column and write the total to the "Total Order Value" column on the "List" tab.
    4) For each unique "Vendor" on the "List" tab, find and write the values from "Contacts" tab and write to "List" tab. (Contacts/List) A) "Mr./Ms./..." to "Contact Name" B) "Main Phone to Telephone Number" C) "Main Email to Email Address" D) "Bill From to Address"

    Sheet should be able to accommodate later runs if records are added

    I've provided an example of Vendor's final record with the above tasks on the "List" tab for reference.

    Once accepted, will PM link to download file.

    Thanks,

    Dustin

  • GCExcel
    replied
    Funds received. Thanks !!

    Leave a comment:


  • GCExcel
    replied
    File received. Macro will be ready in 5 minutes. Sent payment details via PM.

    Leave a comment:


  • oldcellphone
    replied
    Sent PM with link.

    Leave a comment:


  • GCExcel
    replied
    Hi,
    I can try to help but can't guarantee it will be done by 1PM (less than 2 hours).

    If you're interested send me the link via PM else open to other developpers.

    Leave a comment:

Working...
X