1. D

    Send individualized PDF to each recipient from a list

    Hello All, I use a macro that generates a PDF summary of sales made by each seller. Then, I send each individual PDF to each seller. I do it manually. :-( I would like to modify the current macro (or create another one if easier) to automatize the sending process. Each individual PDF should...
  2. V

    Conditional Formatting & VLOOKUP

    Hi, I can't seem to get this to work. Any assistance would be greatly appreciated. I am trying to use conditional formatting on sheet 1 to highlight green any sales months that the seller was over goal based on their goal data on sheet 2. Sheet two contains the seller's goal data. I need to...
  3. R

    VLOOKUP values with merged cells

    Hi, I am trying to get all the values from rows with VLOOKUP. I have data which has seller name in merged cell and Product is in differrent rows.For Example: Adam seller has Bananas,Oranges And Lemons... <tbody> Seller Product Adam Bananas Oranges Lemons Robert Apricotes Lemons...
  4. A

    Combine several sheets into a single sheet or workbook

    Hi, Pls help.. Im new to excel Have an excel with 4 sheets.. each sheet represent a seller selling quota for a day in an excel. and sales varies from seller to seller seller1 ; can have 150 sales for a day seller2 ; sales = 0 seller3 ; sales = 25 how can i use a macro or formula to output...
  5. S

    If +AND +OR Statement with multiple outcomes

    Hello, I'm trying to figure out how to write an If Statement to get the following results: If A = "" AND B = "" THEN "NEITHER" OR IF A<>"" AND B <> "" THEN "BOTH" OR IF A <> "" AND B = "" THEN "BUYER INFO" OR IF A = "" AND B <> "" THEN "SELLER INFO" Thanks!
  6. Z

    One formula to sum all lookup with different multiplication criteria

    Hi everyone, I'm trying to solve this problem in an easy way. I have a database (1000s+ lines) with lines of sellers ID's and amount of sales over a time period. Each seller has a different commission percentage. I want to calculate the total amount of commission to be paid in one formula. So...
  7. U

    Complicated Formula into VBA Macro using Compare - Maybe a Challenge for Advanced Programmer

    Hi, I have been working on this vba script for a while now and this is the piece that I need to complete it. I tried to do this myself with STRCOMP Function but it didn't work or not the correct function. Compare Colum H (Total Buy Box Price) & Column J (Seller Price) if Column H (Total Buy...
  8. A

    Getting info from HTML page source code

    Hi, I would like to ask if there is any way to retrieve information such as "sold by" which seller, and how much is the selling price...
  9. T

    VBA code for Seller offer data

    I am trying to write something in VBA to get all Seller info and Price from Amazon Seller Page, My code is given below.Sub RunNewModule() Dim ie As SHDocVw.InternetExplorer Set ie = New SHDocVw.InternetExplorer Dim html As MSHTML.HTMLDocument Set ie =...

Some videos you may like

This Week's Hot Topics