adjust

  1. W

    Default Number Format

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

    Additional code required to save document to PDF and to automatically adjust with row macro code

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

    Auto column width adjustment

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

    Macro to adjust a textbox to the size of the text

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

    'Indexing' (?) time series

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

    Hide rows, auto sum adjust atomatically?

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

    Use formula for multiple cells

    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?
  8. B

    Sumif help!

    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!
  9. T

    Adjust Formulas for multiple ranges on multiple pages

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

    Conditional Sumproduct Formula Error

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

    Locking Certain Cells

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

    VBA help on file location

    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:= _...
  13. Y

    Adjust IF Formula

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

    How to lock a textbox in one direction?

    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?
  15. V

    Adjust Calculation based on 2x conditions in multiple cells?

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

    Adjust Sumproduct construction with Dropdowns

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

    auto adjust row hieght

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

    Dealing with number ranges 11-16;21-26; 31-36

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

    Variable Pricing Formula

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

    How to extend a dataset

    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

Some videos you may like

This Week's Hot Topics

Top