simply

Hi All, I am trying to see if there is an easy way to create a macro that can be run within a workbook that will create a copy of the workbook without VBA. We have files with VBA internally, but want to show just a superficial copy to the clients so it will simply copy the workbook name, the...

ts1 = 43123.66667 (January 23, 2018 4:00PM) ts2 = 43123.75000 (Januray 23, 2018 6:00PM) How would I calculate the number of minutes between these two times? I have : dhrs = (t2-t1)*24 This gives me close to what I need. The answer should simply be 2.0, but I'm getting 1.99992. Solution was...

Hi All, My worksheet has close to 200 checkboxes and some hidden rows, and a couple textboxes. I believe that is what is causing this flickering/slowness I am experiencing just simply scrolling up and down the worksheet. Is there anything that can prevent this from happening?

I'm trying to nest IF functions but am not getting the results I need and am hoping I can find some (more) help. I'm trying to tell Excel that if J84= 7, 8, 11, or 12 then the value in AA2 needs to be multiplied by...

I am trying to get Excel to auto populate a cell based on the data in another. I have tried a few formulas but keep getting errors and know it's not this complicated. I need a formula that will change the data in column 1 to look like column 2. I'm simply trying to drop off the letter in...

Have the following code Range("A1").Select Set SearchRangeA = Columns("A:A") Dim HeadCoach As String HeadCoach = SearchRangeA.Find(what:="Staff Member").Offset(2, 0).Select ActiveCell.Offset(4, 0).Select What I wish to happen is to search column A to find the cell with the string "staff...

I have linked our workbook to a small workbook containing pricing data. Nothing huge, a couple of tables, Maybe a thousand pieces of data in total. (4 tables, 50 rows by 50 columns each.) I could have done this simply using direct links, index/match, etc. And in my experience the update would...

Hi tbl is one dimensional table with header. I want to get what index it has in table (dataBodyRange) tbl.DataBodyRange.Find(textToFine).row - gives me row nr in worksheet. If table is in top row, I can simply subtract 1, yet I assume there is a way to get that value without math operations...

I have a formula =COUNTIFS($HA:$HA,HM7,$HB:$HB,HM8,$C:$C,1) I want the second to last argument $C:$C to by dynamic. In other words I would like to reference a another cell which has the value C in it. By doing this I can simply drag the formulas across 1000 columns instead of manually...

Hello! I have this problem for which I have been searching a solution for some time now. This may be due to lack of knowledge in Excel or poor skill of the English language. I need the first column to look like the second column - simply move the comma by one number to the left. Help would be...

I am simply trying to go to a cell that contains the txt to a range name and use it in a formula. Say "=e4*1" where e4 is text for a range name.

Morning all, I'm playing around with the Map graphing abilities of Excel within my Office365 subscription. I've managed to get it to plot some data for major European countries but not for towns local to my area in Cumbria, UK. Do I need an add-on? Anyway. An example of the (made up) data I'm...

Hello everyone. Excel is normally a fantastic product, and allows you to do so many things and improves the quality of your life dramatically. However, it has 2 features that, in my opinion, are absolutely BS. I'd like to hear your opinion, or if you have any other feature to propose as even...

I've been doing some stuff by reading a range into memory and then looping thru it as an array and wondering if I can access ranges within the array to delete or simply stick into another array So I'd simply declare my array then get the data by say MyArray=Range("A1:C50").Value Then access...