company

I have a formula that i use to pull out clients names that state "yes" if they are new. The formula has been working for a while and now it is not. On my very first cell, where I have the formula...

I am stuck. My dilemma is that I have some shapes on a worksheet, which when clicked bring up a user form for each individual shape clicked. I've changed from having 15 individual user forms, to a single user form with a combobox which when a value is selected will save the data to the...

I am trying to recreate a multi-page invoice. I have it working as a single page but I think I need to abandon what I have already done use an array to cycle thru the data. Here is my data. <tbody> A B C Customer Invoice Payment 2 John K Company 3060453 $1 3 John K Company 3060453 $7...

I have tried variations of index matches with if statements and SUMPRODUCT with multiple arrays all ending in errors. Can someone please help? I need to SUM the Value Column in the Source Table by matching the COMPANY NAME, PURCH TYPE, AND CATEGORY. In the example below the correct results...

Good morning I'm sure this is basic but I'm stumped researching this task. I'm sending emails to about a dozen and a half different contractors in a generic bcc email for verification of payment on hundreds of projects. As the image attachment will show, I want to paste the list of email...

Hello, I need help please. Say I have 3 identically formatted data workbooks with different data in each, but all located in the same folder. Data Workbook1: <tbody> Name: Company A Location: Texas Task 1: Yes Task 2: Yes Task 3: No Task 4: No </tbody> Data Workbook2: <tbody>...

Is this possible in Excel? Callan Associates, among others, has for many years published a year-by-year listing of what investment returns were by asset class. The point is to demonstrate the importance of diversifying, because no asset class outperforms others from year to year. See...

The format of Application.UserName for people at my company is "Last, First". As a result, I've written a few lines that translate this to "First Last" and called it "FirstLast". I've used FirstLast throughout my code, but I'm now using the sheet with folks at another company whose UserName is...

If I have a list of telephone numbers on excel is there a way for it to look each number up online and return what company each number belongs to. I am sure I have seen someone do this but not sure how.

I've been really frustrated trying to look up (oh god no pun intended) how to do this. I'm trying to do something so simple to understand but I'm having such a hard time trying to get Excel to understand what I want. Basically, I have 2 excel sheets. What I need to do is fill a contact list of...

I am trying to write a macro that will advance to the next unique criteria in an autofilter list. I have roughly 2500 rows of data, but only need to filter by one criteria: The company name. Using the Macro recorder to switch from Company A to Company B, I get this...

hi guys, not sure if the subject is correct in short: i want to scrape the following data from this website "Company Name" "Company Code" "Labor Office" here's the link http://eservices.mohre.gov.ae/NewMolGateway/english/Services/EQuotaStatus.aspx?Code=715280 note that i want to start the...

Hello, I am trying to provide commissions statements to my sales people. My sales report lists all levels for each account: Salesperson, Sales Manager, and Director. In some cases, the employee ID in all three columns is the same person (the department director manages a few highly important...

Hi All, I received a really good response from here before and I am hoping someone can help me again. I browsed for an answer but it does not exist so far. I'll explain what I am trying to do and also what I have so far. I have a large table with a lot of data. I have some dropdowns in B2:B9...

Hello, Is it possible to extract the address and phone number from google using macro? I have excel where, column A has company name, column B has company location and we need company address in column C and company phone number in column D. How to do? Please help PFB table for reference...

Hi All, I received a really good response from here before and I am hoping someone can help me again. I browsed for an answer but it does not exist so far. I'll explain what I am trying to do and also what I have so far. I have a large table with a lot of data. I have some dropdowns in B2:B9...

Hi, Can advise which formula should I use if I want to seek the answer as below criteria? If I need to purchase pen/paper: 1. Company A will be always the priority, 2. Company B will be the 2nd choice if Company A did not sell this item, 3. Company C will be the last choice if both Company...

Hello, I'm trying to develop a macro that updates/generates the footer/header of excel files for my company. The first version of this macro uses a sheet to store the required info (pics, text) and it works. I want to go one step further and eliminate the sheet where the macro info is stored...

I have a data that is in raw form i want to extract 3 rows and convert them to the columns. Row are E-mail, company name which is always below member id and rep. I have also bold the rows which need to be converted to columns. I have about 10000 rows of data <tbody> <tbody> 1. MEMBER ID...

I seem to be a bit stuck and any help would be great. I am trying to track 2 items. The first is the number of times a person is sick or late to work. For that it was a simple: =SUM(COUNTIFS(D22:D29,{"SICK","LATE"})). Then I need to count how many different occurrences there were. In my company...