wondering

  1. D

    How to get 1 vba code to run on all sheets in my workbook when active?

    Hi, Please can someone help me? I would like to run my code via a double click on the activesheet in my workbook. I know I can put the code in the sheets individually to run but because I have 20 plus sheets I was wondering if there was a way of having just 1 code in a workbook event instead...
  2. T

    Has anyone got examples of VBA code for API's

    Hi Everyone, I have to pull data from a site called Harvest. the data i want is employees time logs I understand this can be done and was told when we got the software that its easy but i stuck knowing where to start. I'm quite good at working things out and following instructions and was...
  3. B

    combining a sumif statement with a filtered list?

    I'm wondering if I can combine a sumifs statement with a filter I've applied? In the case of totals for example, I know to find the sum of all visible rows I have to use the subtotal formula rather than the sum formula. Similarly I'm wondering if there's something I can do for a sumifs? I want...
  4. S

    conditional format to change alignment in a cell if a number is entered

    Hi Column B is formatted to align left. Sometimes i enter a number instead of a text. I then click on a button on the ribbon to change the ailgnment I got to wondering....... Is there a way to have conditional format change it? mike
  5. E

    Adding 7 address fields to one row

    I have a list with single rows, each having name and other details but need to add / link up to 7 addresses for each person. I'm wondering what would be the best way to organize this without hopefully going into new linked excel files for each entry. Any ideas?
  6. K

    Using Titles of rows to sum date in columns.....

    Hi I have a spreadsheet, with a lot more data than below spanning quite a few years. I want to add a summary page to show the totals by individual by year. As it's a moving piece i didn't want to put a YTD total on and use a sumif, i was wondering if there is a way of looking across a row and...
  7. A

    Change Color of Range After Data Have Been Posted

    Hello. I am wondering if it's possible to have conditional formatting work to change the color of a range of data after an elapsed period of time. For example, I want to be able to paste data into cells in Excel. Then, after 30 seconds, the cells that I just posted to will change from no...
  8. B

    Is it possible to tell if another user has a file opened as read only?

    Hi, I have a shared excel workbook that has a bunch of macros in it. I have it set to open up in read only so users can't modify the information in it but I want to be able to know who has it open. So I was wondering if there is a way to check what users have the file open in read only. Is this...
  9. C

    Excel 2019 Performance vs Excel 2010

    I have been using Excel 2010 to build some large workbook for almost a decade. The workbooks are getting so large that they become very slow. I am wondering if Excel 2019 performs faster than Excel 2010, so that I can try upgrading Office to get faster calculation speeds. Any opinions? Thanks.
  10. T

    Looking for a faster way to find and replace

    Hello there, I have a worksheet with about 120,000 lines with probably 50 columns and I run the following code to change all the #'s to blank cells. I was wondering if there is a faster way to do this, because this takes a long time to complete. Sub NtoBlank() Cells.Replace...
  11. N

    Sum Identical Sheets - Faster Formula?

    I am using this formula to sum between dates for a particular code number. The four sheets are identical in structure (with different table dimensions). I was wondering if there is a better option of doing this, as I believe this formula slows down my spreadsheet significantly...
  12. E

    Help simplifying formula (if possible)

    Hello All, I have a large spreadsheet which I am working off (20+K rows) The following is a formula which I wrote, but when I fill down, it takes a long time to process, so just wondering if there is a way to simplify it. Any help would be greatly appreciated. =IF(A1="",""...
  13. M

    Help with an "if" function pls

    Hi I'm trying to work out the formula for this function & was wondering if anyone can help me:) if(A1:A2 ="","",)if(A1="",A2=X,"O")if(A1=X,A2=X,"X")
  14. A

    How to attach an email on EXCEL?

    I was wondering how to attach an email to an Excel program?
  15. H

    Formulas

    this is what I’m trying to do (If A1>0,1,)+(if A1>60,1,)+(if A1>120,1,)+(if A1>180,1,)and so on down the line I was wondering if there is an easier way to write this so I don’t have to add 100 if statements to a cell?
  16. S

    Sumproduct or alternative

    Hi, I have been using a sumproduct formula for some years, and although it works fine I was wondering if there was an alternative way of getting the same result. In C8 copied down =SUMPRODUCT(($A8>=$A$3:$A$4)*1,($B8<=$B$3:$B$4)*1,($C$3:$C$4)) to show how many are in each hour <tbody> Start...
  17. C

    Change Reference to Another Sheet on Cell A, based on value of Cell B

    Hi Team, I'm wondering if you can assist.. i'm wondering if you can advise on the below. Let's say I have a cell that is basing it's result on a reference to another cell in another workbook.. such as this.. ='L:\Documents\[Main Sheet.xlsm]KPI'!$B$5 How would I change it where the 'Main...
  18. J

    Combo of ISBLANK and MIN formula

    Hello, I used the below formula to pull in the earliest date found in different cells...
  19. J

    How would i get this intended output in a cell?

    <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> 8:00 60 8:30 79 9:00 79 9:30 100 10:00 100 10:30 50 11:00 50 11:30 50 12:00 100 12:30 100 13:00 100 13:30 50 14:00 50...
  20. K

    simplify a vlookup formula

    Hi just wondering if anyone would have any ideas on simplifying this formula...

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