push

  1. D

    make them push a button on exit

    HI ALL i this code to save my sheet as a pdf using info from cell c2 Private Sub CommandButton1_Click() ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, _ filename:="C:\release" & Range("C2") & ".pdf", _ OpenAfterPublish:=False, _ IncludeDocProperties:=True, _...
  2. M

    Combining If THEN and VLOOKUP

    I am in desperate need of help. I am a novice at excel formulas. I need to write a formula that will pull from a set of data the separates between a Male or Female, Number of Push Ups and then provides a score...so for example: <colgroup><col style="width:48pt" width="64" span="4">...
  3. H

    Add new last row to table

    Hi, I have table ranging from A1 to J5. A1 to J1 are headers. A6 to J6 are totals. I need a button that adds new last row to table. For example first I need to add row 6 and push totals to row 7 and so on. Thank you
  4. C

    Pushing a date to the next monday or tuesday

    If I calculate a Due date and it's a Sunday is there a formula to push it to the next Monday, if it's a holiday can I push it to the next Tuesday?
  5. B

    Formula Problem

    I have made a table that allows me to manually input a number of repititions and the next cell gives me the score that is associated with number by using INDEX MATCH. As long as the score is for each exercise is "100" and over, the next exercise score does not populate and stays white until...
  6. A

    Automating data range for excel graphs.

    Hello, I have a huge excel document of quarterly business reports. Each company having 4 rows of data i want to present in a graph. Quarterly reports. https://imgur.com/a/TjQYn Graphs from data. https://imgur.com/a/QLCro The data for the next company is always 9 rows below. Right now i have...
  7. A

    Percentile with Several Conditionals

    Hi all experts. I have some data in the following way for which I'd need to get some percentiles: I'd like a formula which could help me get the .5 percentile of the Rates (Column F) only of those which meet the following criteria: Process = Lift (Column B), Day = Tuesday, I know I have to...
  8. concreteinterface

    Aggregate, Min, Exclude 0's

    Hi. I am trying to use the aggregate to find the minimum fantasy football player score for a single game. I am using the function as shown in this video https://youtu.be/Oxj-wMGjAW0?t=340 . My code as of this point is: =AGGREGATE(15,6,ActData!$Q1:$Q20000/(ActData!$B1:$B20000=[@Player]),1)...
  9. D

    Transfering/Duplicating Course Information to a seperate tab using VBA

    I work in EMS and organize the training for everyone in our service. I'm working on a realistic way to track main categories and sub categories for each of our service members so that I know what they are needing to re-certify. I have a worksheet with 3 tabs, 'Training Log', ' Course List'...
  10. W

    Excel to word field fill

    Hello, I am looking for someone to write code to push information in a single cell on an excel document to multiple locations on a word document. so the info is a job number and i would like it to be entered the one time in the excel document ant then placed in the word document on the cover...
  11. Q

    How to 'push' or 'send' data from Data Entry Form cells to correct cells in underlying 'data sheet'

    (N.B. I'm trying to do this without VBA, which I don't know. I'm not sure it's possible, even with VBA...) I'm trying to create a 'data entry form' (i.e. a sheet that looks like a data entry form, complete with Form Control checkboxes, text boxes, maybe some data validation drop down and/or...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top