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

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

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