salesman

I'd like to unhide columns based on clicking the a button that I have created. When the user clicks the button, columns F-I would unhide. When the button is clicked again it moves to unhide the next group of columns J-M and so on. I'd like to use the same button to keep this quoting worksheet...

so..... this seems to be pretty straightforward but for the life of me i can't seem to think of a formula that could work with this.... i have a list of salesmen who well.... made sales... and i need to count the amount of sales per salesman, however, the salesman nema only shows up once per...

I have data in each cell below Column A Column B Column C continues till Column J. In 1 Column B i have Salesman Names (Ravi, Rinto, Abhishek, Vaseem and Naleem). I have made spreadsheets for each salesman and i have summary sheet in which i will be posting data regularly, so as soon as i post...

Dear Friends, Calculating Commission: Main sheet: Cells A1 to H5 <tbody> SALESMAN SALESMAN NO BILL NO BILL DATE SOLD AMOUNT PAYMENT RCVD BALANCE DAYS JOHN 20 AF-001 02-04-2018 1000 1000 0 10 JOHN 20 AF-042 14-04-2018 2000 2000 0 20 JOHN 20 AF-050 29-04-2018 3000 2500 500 12 JOHN 20...

sheet1 data: column C (material #) ; column F (salesman name) ; column G (Salesman count per material) = ? ; column H (salesman name) = ? sheet2 data: column B (salesman name) ; column F (material #) need: sheet1 , column G answer formula =COUNTIFS('New Materials'!B:B,Materials!E7,'New...

I have a code module that calculates monthly commission values. Some of the salesmen have shared accounts where 2 salesmen service a common account. In the database this is indicated by the SLS code (Column B) having 2 salesmen's initials separated by "/". When this happens each salesman...

I have a table rows: salesman sales date (mm/dd/yyyy) for many years of sales I am trying to isolate total number of sales of each salesman by month and day (excluding year) excel dates are giving me fits example: salesman sales date man1 2 5/1/2018 man 2 3 5/2/2018...

Hi All I've seen this before but am unable to find the function to do what I require. let me explain. In Column B, I have the number of sales a salesman has made to a customer in Column D, I have the corresponding salesman,s name in Column K, I have a list of salesmen i'd like to total all...

<tbody> S.No Year Name / Number Rationcard Number Application_id Caste Village Applied Area(Ha) Irrigation Type MI Company 1 2017-2018 Jem 521037 00878539-2017-18 Other Caste Srirangarajapuram 0.7 Drip EPC Industries Ltd., 2 2017-2018 Ketty 571480 00905816-2017-18 Other Caste Theiyar 0.88...

can anyone help with a formula to calculate rank based on dates? I have 3 fields, Column A Salesman, Column B Customer, and Column C DateSold. I want to rank each sold date (oldest to newest), by Salesman. So Salesman Joe Smith's 1st sale was the oldest datesold, and his 2nd is the next...

Hello everyone, Before you read this post know that I am not very skilled at all at excel and access. I made this account at work today because my boss wants me to create this tool but I don't have the slightest clue how. I probably am going to sound like an idiot so bare with me here. I...

Hello everyone, Before you read this post know that I am not very skilled at all at excel. I made this account at work today because my boss wants me to create this tool but I don't have the slightest clue how. I probably am going to sound like an idiot so bare with me here. I apologize in...

I have a table of customers with an allocated sales lead - I have a table of transactions for customers. I've the relationship set up in power pivot and the salesman flows through no problem. The issue I have is when the allocated sales lead changes. The pivots give amounts by salesman for...

I am currently trying to use a formula to identify the top 25 sales man per region in a national list. There are 2 criteria, i.e. target must be met and no red flags which i check using an IF statement. The issue Im having is that i need to limit the results to 25 salesman per region and...

Hi guys, I am trying to create sales projections by customer over the next few years and I am currently stuck. Example Data below: <tbody> Client name Salesman name Revenue per month Contract open Contract Close Customer A Salesman A 2,000 March 2018 December 2018 Customer B Salesman A...

Hi, I have a Work book in excel which uses macros to filter a master set of invoice data and draw 4 separate documents based on the client chosen. I then have a macro to create PDF copies of 3 of the sheets, and an excel workbook containing the invoice line details. The Source sheet used...

Hi All, I am struggling with getting hyperlinks to work in VBA using vlookup. Any help would be appreciated I have 2 sheets. Sheet 1 has a salesman # in cell A1. To keep it simple, the salesman # is 101. no hyperlink exist yet. Sheet 2 has a list of salesman #s in column A and salesman...

Hello, I have a table whose data looks like this: <tbody> Salesman Name Tables Ladders Chairs John 5 John 10 John 9 </tbody> I would like to flatten it so that the table reads like the below and remove the repetition of the key column. <tbody> Salesman Name Tables Ladders...

I wanna present Sales achieved against the Target for each Salesman & show the percentage achieved. When i try to present it on pivot chart i am not able to get the correct percentage on Bar graph <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> SalesMan Sales...