participant

  1. R

    Loop not working/crashing

    Hello everyone! I am a pretty beginner vba user and having some trouble getting a loop to work. I have a pretty extensive formatting code here, which works perfectly on a single worksheet. When I then try to have it loop through every single worksheet in the workbook except for the "Original"...
  2. S

    Weight Loss Spreadsheet: Tracking new Weight Loss Records

    Hi wonderful people, I'm working on a spreadsheet for a weight loss program where a participant receives a financial reward for every full pound of weight they lose. Not sure if that title is exactly what I'm looking for, but it was a struggle to describe it in a few short words. I am...
  3. G

    Combine Tabs on different work books to One Tab in another workbook

    I really need help with this. So here is my problem. I have 50 Case Mangers in different parts of the state --- they have 50 Participants Each participant has a separate file. That means approximately 250 separate files are sent to me monthly. Each file has approximately 10 tabs Tab 1 Tab 2...
  4. H

    Sum of Questionnaire Scores Based on a Domain Table

    I have created a questionnaire that consists of around 100 questions. These items are separated into 6 domains where. For the sake of easier understanding, let's just call them Domain 1 - 6. I have them typed in one specific table called "Correspondence", with format like below: <tbody>...
  5. S

    Multiple row value-based if/end issue

    Dear reader, I'm having an issue with a formula. I'm trying to accomplish the following: <tbody> A B C 1 Value1 Value2 Result 2 0,7 10,1 Stop 3 0,7 10,1 Stop 4 0,8 9 Stop 5 0,8 9 Stop 6 1 10,5 Ok 7 1 10,5 Ok 8 1 10,5 Ok 9 1,2 11 Ok 10 1,2 11...
  6. A

    Can't find the good Formule

    Hello. I am new to Excel, I am learning it, but I can't do something. So the task is like this: I have to create 1 more collumn in right of "Comitat" named "Ecuson". In that collumn the name from "Nume participant" should be with uppercase(I guess by using function UPPER) but it should have...
  7. R

    RATING changing Values in a data block

    I have been trying to sort this one out for days now and mind you I am not an Excel power user. The problem may even be the way I am phrasing the question to myself. I would like to scan this data block for all the participants numbers an show in a summary a total value for each participant...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top