make

All, Is there anyway to make sure that a client cannot see any track changes/previous versions of an excel? I don't think track changes were on when the file was created but we want to make sure the edits/changes cannot be viewed by the client. Thanks, J

I have a Timeline and some Slicers connected to a pivot table. The pivot table uses data obtained via Power Query and loaded to the data model via a connection only (I'm probably not saying this entirely correctly). Whenever I change the Timeline, the changes are reflected in the pivot table...

Hello All, I have the following formula: =SUMPRODUCT(--SUBTOTAL(3,OFFSET(Audit!$F$2:$F$57,ROW(Audit!$F$2:$F$57)-MIN(ROW(Audit!$F$2:$F$57)),,1)),--(LEFT(Audit!$A$2:$A$57,(FIND("-",Audit!$A$2:$A$57))-1)=F$11)) The formula does do what is intended, but I would like to use this formula in other...

I'm looking to change cells to blank if their content is greater than 30 using VBA anyone know how to do this please

https://1drv.ms/x/s!Aq3WqOz73fYygYUinBF1m9sbdkyMaw?e=c78rMA I have created the above file, but I am trying to modify it, so I can record goal scorers, for each game. I want to see how to make it better, any ideas please. Regards Stephen

Hi, I am looking for any geniuses that can help me make a TreeView in Userform. There are barely any tutorials online, and I still have no idea on how to make them. I provided a picture below of what kind of TreeView that I want and the table database sample. Also, I would like to have the...

Hello, I want to make a countdown timer with counting to a date in the future in format "dd hh:mm:ss" or similar. F.e. how many days, hours, minutes and seconds left till "21/10/2019 15:00:00". I have newly found the timer function, but can not make it count backwards. All help and ideas...

Cell B1 in Sheet 3 =A(MATCH('Sheet1'!A55,'Sheet2'!A1:A28,0)) Suppose the MATCH formula produces the number 8 How do I make it so that the whole formula points to cell A8 Want to be able to use it in other formulas and point to cell A8

Hello, I have tried to modify code that I have that works with single criteria to double criteria, however my range is not correct. Could someone point me in the right direction. I'm a truck driver trying to make my life easy for day to day operations of my business and only new to vba Code...

I have 1000 rows of text which includes the Province, weight classes, prices, etc. All the text looks like this: <tbody> ON_XY_DOH|PARCEL|30|40.99 </tbody> In this case the last two numbers are what matter. This means that if shipping weights are up to 30 pounds we charge 40.99 So there's...

I posted on here before regarding a sumifs formula and I appreciate the help that I received. Now I am finding out that it is not picking up all the data that I need and my boss wants to make this into a macro after I figure out how to make the formula work since this formula is so cumbersome. I...

I am currently looking for a formula that i can sum up the all the numbers under one persons name. So if John name on he work sheet 5 times need to calculate all the numbers that john has. I have attached a sheet to make it more understandable a bit...

https://1drv.ms/x/s!AvjBsEPEq12ngTsi8XTPb5NMJ1_h?e=YIGtSL I wish to add the total for B and C in the Pivot Table like in cell D6. Suppose I update my PV and more data is added. How do I make it such that I can calculate the total for Company B and C and get $300? Hope that makes sense. Thanks :)

I am using a sub I got from the internet that randomly highlights cells. what I need is to have the counter reference a cell instead of being set in the code (see below). I want to be able to put a value in cell H1 and that replace the 150 in the formula. This would make it easier as my sheets...

hi I'm driving myself mad trying to make this formula reference a cell value instead of the "83" in the text =INDEX('[workbook.xlsx]MCPOS'!$F$83:$ZZ$158,MATCH(LEFT(C7616,34),'[workbook.xlsx]MCPOS'!$E$83:$E$158,0),MATCH(A7616,'[workbook.xlsx]MCPOS'!$F$4:$ZZ$4,0)) the "83" should be replaced...

Hello all I'm looking for a little help with a formula I'm working on <colgroup><col width="64" style="width:48pt" span="18"> </colgroup><tbody>...

Good Morning , We are using Office 2013. We connected to Oracle DB , make query and make Power Pivot query -> All working ok Now whenever we need to get the updated data - we are doing manually -Data -> Refresh All. But we need to have 'Refresh Automatically' - For example say by 10 AM...

Hello Excellers! How can I make a cell values appear in all caps? I have the following formula in several cells: =DATE($U$1,COLUMN()-2,1). The cell is formatted to show just the month abbreviation: "mmm". Basically the cell just shows the month (Jan, Feb, etc.) but other cells reference...

Hello, May i seek help for the formula I can use to make a list of activities from the given calendar setting? https://www.dropbox.com/s/tgzz9815ma95cdq/making%20list%20from%20calendar.jpg?dl=0

Hello I'm looking for a macro that will search column L in a sheet for number 2 and if it finds it then make that 2 bold, red and 18 point. Thanks