wondering

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

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

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

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

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?

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

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

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

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.

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

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

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="",""...

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")

I was wondering how to attach an email to an Excel program?

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?

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

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

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

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

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