contracts

  1. D

    Using a date range and data from another sheet but using a from and to date cell in the new sheet to manipulate the data

    I am using the formula below successfully on a workbook at (sheet 3) which gives me the number of contracts by the person named at E3 between the dates I enter a C8 & C10. =SUMIFS(Test,Daterange,">="&$C4,Daterange,"<="&$C6,Manager,$E$3) I now want to use the same base information on a...
  2. T

    Sumifs

    Workbook has two worksheets, "Contractor Names and ID code" and list of all contracts with requirements i.e. type of contracts = "A, B, C or Blank", schedule dates and other items on second worksheet label "Contracts". On the first worksheet need to have the number of type contracts each...
  3. P

    VBA - Pop alert for list of dates

    Hello all, First of all, I tried to find a similar thread but without much success (as I'm new) for my question. So sorry, if there is already a similar thread and if yes and you have it, just point me to the right direction. Thank you. So I have a list of client contracts and I would like...
  4. O

    Hyperlink to cell that contain hyperlink

    Dear all, I have a sheet with 2 columns: 1. column with a customer name 2. column of contracts, the cells in the Contracts column are hyperlinks. I would like to create a different sheet using data validation list with the names of customers - so if I choose a particular customer name the...
  5. B

    Cant find the error: how to make the listbox work in my form and populate the textboxes on click.

    Hey How can i fix this problem in my new project? I have the following. Tables: Address_Table = contains addresses to staff Phone_Table = contains phonenumbers to staff Email_Table = contain email to staff Personal_Table = contain staff names and social sec number Anstallning_Table = contracts...
  6. D

    Excel VBA Help with dynamic forms!

    Hello everyone and thanks in advance for all attention and help provided! I'm crawling my way to understand Excel and now I'm facing a challenge: I need to create a dynamic form! Here's the issue: I have a list of contracts and some workers of a team who work with them. They're having problems...
  7. A

    Forumla/ LookUp to find preceding ID

    Hello everybody :), I got a little excel task to do, however I really cannot get my head around how to solve it, so I hope you guys can help me out. The problem: I have a list of contracts with contract IDs in column A. However, not all of the contracts are completely different ones. Some of...
  8. E

    Insert data on a new row to a tab on matching column when ID matches

    Hello, I have a database that tracks a list of contracts on one tab and contract modifications on another tab. Both tabs have different columns, but also have some matching column names. What I'm trying to accomplish is to consolidate the information into one tab. For every "Contract ID"...
  9. O

    Vlookup On Duplicate Contract Numbers & Return Price From All Contracts?

    Hi, I have a spreadsheet where I have duplicate contract numbers with different prices and I'm trying to get the sum price of all these contracts. I used a Vlookup which worked properly but it only returned the amount for 1 of contracts; is there another method I can use to return the sum of...
  10. D

    Legally Binding Electronic Signatures for Invoices created in Excel

    We are trying to move away from Paper and Pen.... I've created our new invoice in Excel, but need a way to insert an Electronic Signature, for the Customer to "sign", making the Invoice / Contract legally binding. Trying to find a way to do this without having to pay for a third party plug in...

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
Back
Top