Adjust By %

Feb 3, 2008

I would like to do some calculation with percentage as it showing in the attached file.

[url]

View 9 Replies


ADVERTISEMENT

Concatenate Two Text Fields BUT Left Adjust First Field And Right Adjust Second Field

Jun 22, 2012

I want to concatenate two Cells into a single cell BUT have the first field left justified and the second cell right adjusted.

A1 = "John Williams", A2= "Single"

A3 = "John Williams Single"

View 1 Replies View Related

Automatically Adjust Row Height

Feb 6, 2010

I have a vlookup into a row of cells. Sometimes the new text is so long it has to word wrap. How can I get the ros to expand with out me manually doing each row, and then go back to one line with the data changes.

View 9 Replies View Related

How To Adjust Size Of Userform

Apr 4, 2013

I am new to Excel VBA - Normally, If u move your cursors to the corner of your userform,we will see the single-two pointed arrow pop-out and then we can adjust our own desired size of the user-form.

How to do that in EXCEL VBA?

View 8 Replies View Related

Adjust Value Automatically When Entering New Value

Dec 10, 2013

In simplicity: We want to be able to enter a value in cell A1 (and hit enter), but we want the value in A1 to be increased by the value saved in H1.

So: if H1 had 250 saved in it, if we enter 150 in A1 (and hit enter), we want the value in A1 to become 400.

View 2 Replies View Related

Using A Value To Adjust A Cell Reference

Oct 18, 2008

I have a spreadsheet set up for my son to roll up D&D characters. There's a combo box to select Race and another for Class of character. What I now need to do is automatically insert the correct set of racial and class bonuses into the relevant squares.

The Combo box points to a list of Races on Sheet 0, in cells A3 to A12. The cell reference for this returns a value between 1 and 10 depending on race selected, i.e. 'Dragonborn' yields a 1, and 'Tiefling' yields a 10. Cells H3 to H12 contain the Strength modifier for the different races.

When I select for example a Dragonborn (1) in the combo box, I want the Strength Modifier cell to pick up the value from cell H3, and if i change the selection to Tiefling (10) I want the strength modifier cell to pick up from (obviously) cell H12

How do I use a variable in the cell reference to adjust the cell data is retrieved from?

View 4 Replies View Related

Macro Adjust Row And Column

Nov 9, 2008

Is there a way to make a macro to make this true?


The WS is 300 rows,
The column width is 6.90

If LEN(B1)>147 then format ROW Height to 0.25
If LEN(B2)147 then format ROW Height to 0.25
If LEN(B300)

View 9 Replies View Related

Make Subtotals Adjust

Nov 28, 2008

I have a piece of vba code that uses the date in column D to group by month and subtotal the amounts in column E.

The problem is the subtotal in column E doesnt adjust. So if a user of the spreadsheet adds or deletes rows the subtotals (and grand total) do not up date.

Dim LastRow As Long
Dim NextMonth As String
Dim R As Long
Dim Rng As Range
Dim SubAmount As Currency
Dim ThisMonth As String
Dim TotalAmount As Currency
Dim Wks As Worksheet

View 9 Replies View Related

Automatically Adjust Row Height

Feb 15, 2010

I have a vlookup into a row of cells. Sometimes the new text is so long it has to word wrap. How can I get the ros to expand with out me manually doing each row, and then go back to one line with the data changes.

View 9 Replies View Related

Adjust Horizontal Pagebreaks

May 7, 2006

attached a sample, with the page settings, print area set, row height, etc... all set to my needs. I would like vba to adjust the horizontal pagebreaks so that a "box" is never split into two parts. in attached sample the pagebreaks should therefore go below row30, row54, row124 and row128. Setting pagebreaks is easy, but still want VBA to do it for me.

View 6 Replies View Related

Adjust The Shape Of The Chart...

Jun 9, 2006

How to adjust the shape of the chart in the worksheet? I try to write the code, but can not work.

ActiveChart.Shapes.ScaleWidth 0.87, msoFalse, msoScaleFromBottomRight
ActiveChart.Shapes.ScaleHeight 1.5, msoFalse, msoScaleFromBottomRight

View 3 Replies View Related

Adjust Date Format

Aug 3, 2006

I currently have dates in a column in the format DD.MM.YYYY. I would like to convert this into MM/DD/YYYY, with the slashes instead of the periods.

View 9 Replies View Related

Adjust Margins Of A List

Dec 19, 2006

I have a list in excel.......(see attached) In the attached you will see some empty boxes for this purpose I have only provided a dummy duplicate. In the original I have information in these boxes.

Problem:
When i go to print preview the list boxes fall half way down the page instead of at the top of the page......when I try to adjust the margins in print preview, manually, or either in page setup it doesn't rectify it.

View 7 Replies View Related

Adjust Zoom With Scroll Bar

Feb 21, 2008

I've used various "zoom" searches and can't find what I need. My users have different amounts of toolbars so the amount of screen space changes. I need to zoom so 4 graphs show. Am looking to enable the user with a scroll bar where the user could click / slide the control to change the zoom size on the screen so they can see the 4 graphs at their preferred "zoom".

I would prefer a control on the sheet and link it to a macro (or line of code if that's the proper phrase) and let the user decide (some people will want bigger zoom due to eyesight etc).

Private Sub ScrollBarZoom_Change()
ScrollBarZoom.Value = ActiveWindow.zoom.Value
End Sub

But I get Runtime error '424': Object required. Auto Merged Post Until 24 Hrs Passes;Nevermind. I found it. Answer was:

Private Sub ScrollBarZoom_Change()
ActiveWindow.zoom = ScrollBarZoom.Value
End Sub

View 2 Replies View Related

VBA Code - Adjust Column Range

Dec 19, 2013

I have this VBA (from a recorded macro) how can I amend it so that these two formulas change depending on the number of values....right now the range is to 129 only because we only have 129 cells of info but some sheets will have more some will have less. I want excel to base it based on the column I which used to be H.

VB:
Sub SLCREPORTDATA()
Cells.Select
Range("F1").Activate
Cells.EntireColumn.AutoFit
Columns("H:H").Select

[Code]....

View 2 Replies View Related

Formula To Trim And Adjust Data

May 1, 2014

In need of a formula to trim data:

Examples:

* 5 Extravagant Mak (nz) (100) Need the number plus a dot then space then the name, then minus everything after the name, so this would now read 5. Extravagant Mak thats 5dot space Extravagant Mak
*
11 Frisbee (100) This one would become 11. Frisbee thats 11dot space Frisbee

View 5 Replies View Related

Auto Adjust Print Area

Jun 4, 2009

Is there a way to set Excel to only print rows that have data in them? I have an end user spreadsheet where the number of rows they have each time differs and I don't want them to have to manually set the print area each time.

View 7 Replies View Related

How To Adjust The Font Size In A Comment

Oct 26, 2013

Is there a way to adjust the font size in a comment. The default seems way to small. All thoughts on the subject .

View 4 Replies View Related

Auto Adjust Page Area

Mar 14, 2014

On my billing/table of contents sheets, there's an imaginary thick blue line that surrounds the bottom/right side of my chart, and everything outside it is grey/non-existent. I can click and hold this blue line to expand it over other cells to make them 'appear'. I have no idea what all of this is called.

The amount of columns I use for each sheet is static, but the amount of rows varies with each job. As it stands, I have to raise/lower that blue line every time I have new data. Is there any way to force this line to move up or down depending on the existence of data in cells automatically?

View 3 Replies View Related

Adjust To Certain Size When Program Is Opened Using Vba?

Jul 29, 2014

I would like excel to adjust to a certain size when the program is opened using vba. Not to equal the computer monitor size but only the size i choose (as it is almost square).

View 3 Replies View Related

Macro To Adjust Values In Columns

Nov 2, 2007

I'll admit I know very little about creating a macro in Excel so I hope someone can help me out with creating what I consider a fairly simple macro to adjust values in a column or columns.

What I am using this worksheet for is a merchandise database that contains 3 columns of pricing values, ie. Column headers Small, Medium, Large.

The columns are approximately 2000 rows deep.

I need to change the pricing values in all 3 of these columns by a specific amount. However there are some values in the "Large" column that will not be adjusted. Those values not adjusted will be based on the contents of another cell in the same row that would only contain the data "OT,JB" or only "JB".

I've considered using find/replace but think it would be very inefficient.

Right now I am looking to lower the price values by 2 dollars. All values are numerical and formatted as Number/General. ie, 11.95, 7.95

I've considered creating another column or linked worksheet and forumla-ize it and then copy/paste my value results back, but I am hoping for something less cumbersome, something that is expandable as the worksheet grows, etc. I think a macro, but I do not have any idea what to do or how to get started.

View 14 Replies View Related

Adjust Macro Tocompare To Cell Above

Jul 22, 2008

I have been the code below in many a different form since royUK first helped me find a certain value and delete the entire row. I've used it to find values, text, multiple conditions and so on and so forth, but I cannot figure out how to compare the cell to the cell directly above.

View 10 Replies View Related

Scroll Bar Adjust Maximum Number

Mar 24, 2009

how to make vb Scroll Bar “Max” number to be equal to the next empty cell in column A in Sheet25. For example when A5000 cell is empty in Sheet25 then in Property of Scroll Bar Max setting would be 5000 and scroll bar must be at the position of max number.

View 4 Replies View Related

Adjust Print Area Macro

Jun 13, 2009

The macro below works perfectly except for one problem. I only want it
to set the print area from Column A - Column M . It currently selects data i have in Columns N and beyond and i do not need that to print. From A - M is 13 columns.

View 4 Replies View Related

Make Range Adjust As Add Or Remove Row?

Feb 22, 2012

I know there is a way to make a range adjust as you add or remove row. I just can seam to remember how to do it .I am using a countif function and later I will be adding more rows I want the countif to look at everything

View 2 Replies View Related

Adjust Report To Different Screen Sizes

Apr 19, 2012

I have a report with graphs and slicers and I have a 22 inch monitor. All of the graphs and slicers fit on my screen size but when others open it everything doesn't fit because they have a smaller monitor. Is there a way to auto adjust the report to adjust to individual screen sizes. I want the data from A36-V36 to fit on the screen at the same time. Not sure if this is possible though.

View 5 Replies View Related

How To Adjust Width Of Columns Faster

Nov 17, 2012

1. Is there a faster way to adjust the size of the columns? I had to use my mouse to stretch the column out. This can be quiet time consuming if there are 8 columns needing to adjust to the same size. ie Col A, B,I, J needs to be the same size.

2. Can Excel determine the best size for the column? Say I need a column with data saying "yes" and "no" and a column for the letter "X" only or do I have to stretch the width of the column myself?

View 1 Replies View Related

Adjust Length Of Horizontal Scroll Bar Using VBA?

Nov 19, 2012

Is there are way to adjust the horizontal scroll bar length in a workbook using vba?

View 2 Replies View Related

Adjust Column Or Row Width With Keyboard?

May 31, 2013

I want to know that can we adjust column or row width with keyboard.

View 1 Replies View Related

Adjust Simple Formula To Find Last Row

May 8, 2009

I am using this formula in Cell J12: =AVERAGE($G$12:$G$85)

It will always be $G$12 but $G$85 needs to be done so that it goes until the last empty row on the worksheet.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved