adjust

I have a vba enabled workbook (Excel v2013), and now every time I add a new worksheet the number format setting has defaulted to "Date". This is causing many issues. I can't find the option to reset the default to "General". There is one macros enabled on a few sheets to adjust formatting within...

Hi wonderful people. My last enquiry is that I now have one more question. I have written a macro to automatically pdf my document, but when I had rows, I then have a to manually adjust to suit my macros for adding columns and rows. Is there anyway for this code to automatically update when I...

Hi, Due to the fixed column width the figure more than width is showing ###### and need to double click to see the figures, how column adjust itself automatically ? <colgroup><col></colgroup><tbody> </tbody>

Hi Everyone, I've been playing around with activex text boxes and have found I can adjust the height as I type. so what I would like is a bit of code that can adjust the textbox to one line bigger (or the size of the text i'm tying in I have this bit of code that will resize the text box so I...

<tbody> A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE 1 Country 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2 China 0.000003 0.000003 0.000001 0.000005 0.000002...

For example Row1 Row2 . . . Row10 I set a formula adding the value of these 10 rows. Is it possible that if I do some sorting, lets say only 1,3,5,7 rows, is there an auto sum formula that will adjust automatically only summing those 4 rows? Thanks a lot.

Hello, I am trying to figure out how to use a formula from a cell (A1) and then have it referenced in other sheets to be used. That way i can make one master sheet and adjust the formulas and it pulls through my other sheets. Any idea?

I am using the following formula: =SUMIFS($D:$D,$C:$C,Inventory!A3,$A:$A,$A$59) What i need is for the data from the inventory sheet stay constant in Column A but adjust for the row and I cannot seem to figure it out! Help!

I need to change the formulas on several pages for several ranges, by adding an if statement that says if the result is greater than 100% then show 100% or else show the normal result of the formula. I'm not quite sure how to do it without breaking my back. Ranges are the same on all the pages i...

All, I am using a conditional sumproduct formula that references another table to calculate a value. The other table has ='"" values in some of the arrays so the sumproduct formula returns #VALUE !. Is there a good way to adjust the sumproduct formula so that it will ignore the blank cells or at...

I am trying to lock/protect certain cells so that they can't accidentally be deleted or changed, yet still be able to edit the other cells. I don't want to use a password to unlock the sheet everyday, just if I need to adjust those protected cells. For example, I want B3:B34 to be locked but I...

I have a set of docs in a folder that is used as a template. Our people Copy template into a different location. Everything works but a macro that opens files. Below is my template location and name. How do I structure the Macro to adjust to new location? Workbooks.Open Filename:= _...

Hello, I need some help with this Formula, =IF(YEAR(U4)<=2014,B36*400+C36*200,0). i need to adjust it so that it will check not only Year in cell U4 but also cells V4, W4 & Y4 and do the calculation (B36*400+C36*200,0)). Thanks in advance. Best Regards. Younan

I have a textbox on a worksheet that I want to autosize, but ONLY vertically. I see in its properties the option for AutoSize, but this will adjust the box both horizontally and vertically. How can I lock its width?

Hello! This pertains to a model I am using to calculate interest rates for mortgages. Rates can be floating or fixed and the interest rate calculation method can either be Actual/360 or 30/360. There are 2x cells with dropdown choice similar to the below. (E3 & E4) which have values, and...

Hi all Is there a way to construct an AND & OR sumproduct lookup that uses Tickboxes alongside a criteria range and also a toogle to state which of the list should be used as an OR or an AND criteria to adjust the outcome...

How would one automatically adjust a rows height as the cell entry exceeds the column width.Thanks

I want to be able to adjust a range after I have a lookup that checks what the adjustment should be. Example: Lookup checks a rating that is -3 ( which is coming from another sheet. The range it now needs to adjust is 21-25. When a negative number, the beginning of the range needs to drop to...

Hello. I have a quote sheet that marks up my price by a certain percent. The way I have it set up now is for a 10% markup and I adjust it manually. C1 = .10, C2 is where I enter the cost, B2 = C1*C2, A2 = B2+C2. I would like change this to vary the markup percent based on the cost. Ie. as the...

Hello! I would need to adjust my dataset in excel, exactly as it is exposed here: https://www.statalist.org/forums/forum/general-stata-discussion/general/1471548-how-to-extend-cross-sectional-units-in-a-panel-data How can I do this in excel? Many thanks to all of you! Occ