client

Hello All Problem: The Excel I have has some pictures embeded at start (A1:H10) which can vary in different templates below this there is header, below which is a table (headers for column names start from A12) Since column number can change , I need a way to extract whatever data is there...

What I am trying to do is to send multiple emails to multiple clients with a click of a button, with each client has a different attachment. I can already send an email with an attachment, however, the second recipient also received the previous attached file sent to the first client prior to...

I have an extremely large data set by day for the last 6 months. I want to count the number of consecutive days where there was an increase in bill volume for the purpose of identifying the largest streak. For example, we continuously increased bill counts from January 1st through January 5th...

Hi I need a macro/formula to pull through names of people if they have a value against a client onto the master spreadsheet I have separate client tabs, with people putting values against an activity. I have a master sheet which lists the clients under each column. I would like to pull...

Hi, I'm wondering if anyone can help me with the below? I have 2 files (Client X & Client B). They are saved in the following folder: I:\Content & Creative\Design Admin\_Revenue Additionally, I have my summary file (which does not yet have a macro - but this is where I'm wanting the macro to...

Is this possible with Excel? Automatically e-mail a client when a value is typed in a certain cell. And as you see on the picture, there must be 3 or more e-mail templates. [1]: https://drive.google.com/file/d/1NGo1aQHffubZ-ptiQ8QGUh3Zi1OP2ctL/view?usp=sharing Please share some...

hi, i am trying to do some macro on an existing report in excel - its a client account statement - if the client has multiple accounts it will seperate them out into sheets and name each sheet for example John, John 1, John 2, John 3, john 4. depending on the client there could be 2 sheets or...

I'm sure I knew how to do this once :eeek: Ok so I need to take the date from workbook 1 column G to workbook 2 column c based on matching I.D'S in column A In workbook 1; Client ID is in Column A, between 40-60 records at any one time. Date of next meeting is in column G. <tbody> A B C D...

Morning, I have a workbook with multiple sheets. Sheet one is a list of instructions downloaded from an website. The instructions are from clients. each row represents an instruction and the orders are not all together for each client so row 2 could be an order from client A row two could be...

Hello - I have the code below and would like the dialog box to take the value of the current selected cell. Example: cell A1 (selected, active) says "Price Sheet Client 1" that sheet name ("Price Sheet Client 1") would auto fill into the pop up box and then the user can just hit OK to go to...

Hi, Does anyone know a formula that match Client ID & weight and return correct Weight Range? <tbody> Client ID Weight Weight Range Home 21.05 ?? Local 28.50 ?? Weight Range Lower Weight Range Upper Client ID Weight Range 1.0000 26.9900 Local Up to 27kg 22.9901 42.9900...

I want to preface this by saying that I am VERY much a novice Excel user (using Excel 2016). I am trying to create a client tracking list and one of the columns I have is "Date(s) of service". Every client will have a different number of services dates, which I would like to keep in the same...

Hello All!! I have an application which I am trying to connect via an IP address and port number. I have been trying to use WINSOCK control, but when I get to createobject I get an error "429:ACtive X component can't create object." I have been working with Igor's sample from...

First: Thank you for reading. My issue, I have a formula on a waterfall type report that uses a lot of countif functions to determine if a site is forecasted/actualized, and counts it if it is. I bring in data to the workbook through a series of queries, and unfortunately, the client changes...

Hi I have this formula but stuck on the last condition. I want to count based on Client Name in current table where it finds a match to: table1 client name & is not OOS/Lost AND if the country is listed both on table1 matching a table in another sheet which is called 'Prority 1' this last...

Hi Everyone, I have 2 sheets 1 is "Data" 2 is "Cale" Data has a list of my appointments with my cliennts and their departments Cale is a calendar Showing dates in row10 one day at a time Starting 01/03/2019 in column S10 Column D holds the client names In "Data" I have A Client Name B...

Hi I'm confusing myself I have a 2 tables. Table 1 is where I want to say Yes or No as end result. Table 1 & 2 match is based on the 'Client Name' In Table 2, there is a column against the client which shows 'Compleat' within the text value. I.e. it may say: Compleat Only =...

<tbody> A B C D 1 BRANCH CLIENT FILECNT RANK 2 12 ABRE01 50 1 3 12 AEVA01 45 2 4 12 NIEX01 46 5 12 NIEX02 47 6 12 CAI00 29 3 7 32 ABRE02 15 3 8 32 AEVA01 45 1 9 32 NIEX05 9 10 32 NIEX07 47 11 32 CAVI00 40 2...

client ID Accounts 12c3 4.3 12c3 6.5 12c3 9.1 14d4 2.2 14d4 5.3 Okay, so I have a spreadsheet with about 30,000 rows of data. I need to first run a pivot table that will give me the client ID #s and a count a accounts. Then I want to...

Hi Everyone, I need a macro not conditional formation for this please. I have a range of data in sheet "Cals" Range S11:BX and lastrow. Now Column S holds the clients name and all clients are sorted to be together. what I need is a macro that can give me two Greys (pref with RGB numbers so I...