seller

  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 =...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top