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

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top