Adding Number To Existing Set Of Numbers

Mar 1, 2013

I want to add a number to existing set of numbers.

E.g. 10035-TSZ651-MT0A01-42004314-F01-023

and i want to add 0 to 023 so that the number will be


View 9 Replies


Adding Two Rows After Every Existing Row

Aug 7, 2009

Is there any way to automatically add two new rows after every existing row containing data?

For example

1 A B C
2 D E F
3 G H I

turn into

1 A B C
(empty row)
(empty row)
2 D E F
(empty row)
(empty row)
3 G H I

View 9 Replies View Related

Adding Second Range To Existing VBA Code?

Nov 13, 2011

adding an second range (J1089:AI1147) to the follwing code.

Sub Clear_Range()
Application.EnableEvents = False
With Range("H3:AL1058")


View 2 Replies View Related

Adding Pause To Existing Macro?

Mar 21, 2013

I would like to add a pause to the following macro so that it inserts the word CANCEL 1 second after triggering. I know I need to use the Application.Ontime function but cannot work out how to integrate it.

Sub Cancel() Application.ScreenUpdating = False
Sheets("Sheet1").Range("T5") = "CANCEL"
Application.ScreenUpdating = True
End Sub

View 3 Replies View Related

Adding Control On Existing Userform On The Fly

Jul 21, 2013

What I missed. I already added the MS VBA Extensibility 5.3 on a VBA Reference. but still got an error.

Line1: Dim objForm as object
Line2: Set objForm = ThisWorkbook.VBProject.VBComponents("UserForm1").Designer
Line3: Set Butn = objForm.Controls.Add("Forms.CommandButton.1")

The error is on Line3, "Runtime Error '91': Object Variable or With block variable not set".

View 2 Replies View Related

Adding A Not To Exceed Condition To Existing Formula?

Mar 10, 2014

I'm preparing Quarterly Evaluations, and am having an issue because an Analyst has superseded an overall percentage goal. In the attached example, it is the overall evaluation with the 'problem data' in red D19 and highlighted.

I'd like to add a condition that limits the points in D19 for 'responsibility 3' to 150.


*just a note for clarification, the other two responsibilities are a 'per hour' weekly goal, whereas the 3rd is an overall personal effort divided from the overall team effort.

View 4 Replies View Related

Adding City Field To Existing Spreadsheet

Mar 31, 2014

I have a spreadsheet of over 8000 addresses. I have the street, state and zip but not the cities.

Is there a way I can do a search and mass import of cities from a website, like USPS? I'd like to know if there is something I can do quickly rather than manually look each zip code up and enter it in one by one.

View 2 Replies View Related

Automatically Adding New Worsheets To Existing Sums

Nov 20, 2008

In the attached workbook I have 3 sheets. The first 2 with the names starting with WO are individual sheets based on a single scaffold rental. The "Standing Equipment" worksheet is adding the components from the other two worksheets. Easy enough, but I am looking for either a formula or some VBA guidance on how to have the "Standing Equipment" worksheet automatically change it's formulas to incorporate new worksheets as they are either added or deleted, thus avoiding constant formula editing as scaffolds are erected or dismantled.

View 3 Replies View Related

Continuously Adding New Cell To Existing Formula?

Jun 24, 2012

I'm currently doing a new worksheet for work

Cell's A1: Commission Per Sale Cell B1 Running total of commission

I would like the running total to continuously incorporate all of the above commissions and this has to be in the column next to the new sales commission.


Commission $5 $7 $9
Running Total $5 $12 $21

View 2 Replies View Related

Adding To Existing Formula If Cells Are Blank

Mar 21, 2013

I run the following formula down a column of records in row AR

=IF(COUNTIF(lookup!A:A,N2)>0, "Exclude", "Not In Lookup")

I want to add to this formula an additional function that if any cells in column A1 are blank, then do not perform the remainder of the equation.

View 1 Replies View Related

Assign 2 Macros To 1 Button (or Adding VBA Code To The Existing Macro)

Dec 23, 2009

I'm verrry new to editing VBA code and I've been trying to figure out how to send a column of data ("Min Data" AB3:AB21 from "Sheet1") to a worksheet ("F4" - Min) and sending another column of data ("Max Data" AC3:AC21 from "Sheet1") to a different worksheet ("F4" - Max) by using only the one button ("Record Data" from "Sheet1"

I've been trying to figure out ways to edit the VBA in "Module 1" to make this work

Can anyone help me out here? If what i'm asking for isn't clear enough, just let me know and i'll try to explain in more detail.

View 6 Replies View Related

Difficulty Adding Minimum And Maximum Values To Existing Formula?

Mar 12, 2014

I'm currently using the following formula to return values rounded down to the nearest 2.5: =FLOOR(X8*1.25,2.5)

This works fine but I would like to put in place a system where if the "X8" value is 1 the formula produces a 2.5, and if the "X8" value is 10 or greater the formula produces a 10.

View 1 Replies View Related

Name Conflicts With Existing Module, Project Or Object Library. Adding Reference

Oct 5, 2007

In a workbook made in Excel 2003, I have the following for a UserForm:

Private Sub UserForm_Activate
Me.Calendar1.Value = Date
End Sub

I copied this workbook to a computer with Excel 2007 and it bombs out at "Date"
It comes up with a compile error, "Can't find project or library"

In the references window (Tools, References) it has the "Missing: Ref Edit Control" checked and the location at the bottom of this window states "C:Program FilesMicrosoft OfficeOffice11REFEDIT.DLL".

The reference to Office11 is from the computer with Office 2003 as the computer with Office 2007 has Office12.

There is another "Ref Edit Control" in the References window and when I check it and browse to the Office12 folder, highlight REFEDIT.Dll and click on open and in the references window on OK it comes up with "Name conflicts with existing module, project or object library". I have tried to delete the "Missing: Ref Edit Control", change the priority and change the reference in the missing control to Office12 but all to no avail.

How can I change the reference to the Ref Edit Control from Office11 to Office12?

View 3 Replies View Related

Add Numbers / Text To End Of Existing Numbers

Jan 22, 2013

I have a column of numbers that may range from 7 to 8 but i need to tack on zero's at the end so that i have a total of 22 characters. What formula could i use?

View 2 Replies View Related

Format Existing Phone Numbers

Apr 25, 2013

Formatting existing phone number. I want to remove first 2 digit from the column with 11 digit phone number ?

View 1 Replies View Related

Adding Dim'd Variables: Ignoring Strings & Adding Number

Jan 13, 2007

I've got a problem involving several Dim'd Variables needing to be added up, they're all Dim'd as Variants though as they can be either strings or numbers at any time.

I need a formula (VBA) to add them up (to add their actual numeric values - not just a "1" if they contain a number) and ignore them all together if they contain string values.

View 9 Replies View Related

Adding List Of Numbers But Only Numbers With $ Infront

Aug 18, 2014

[URL] .... If you take a look at the picture, what I'm trying to do is add the list of Prices up so that I can differentiate the amount received in $ and in £.

I need to add up all the numbers that don't have a $ in front into the 1 cell, and all the ones with the $ in front into another cell.


View 2 Replies View Related

Adding Comparison Line Chart To And Existing Population Pyramid Chart

Jul 14, 2012

I have created a population pyramid and want to add another chart on the secondary axis which I can do. The part which I seem not to be able to complete is getting the line chart secondary axis to read from the primary y axis. It seems to add a new axis, even when I delete this the line chart does not read correctly.

View 1 Replies View Related

Add To Existing Cell Number With VBA?

Nov 13, 2012

Is it possible to add to an existing cell number with VBA rather than replacing the number? I would like to type a part# and a new qty in "Inv adj" sheet(A1 and B1) and have it find that part number in "names" sheet (A:A) then add the new qty to the existing qty in "names" sheet. (B:B)



1| part-001...... 4
2| part-002...... 2
3| part-003...... 1

"Inv adj"

1| Part-003...... 6 (running macro should then change "names" "B3" to qty "10")

I have this, but it only copy and pastes. not exactly sure how to get the cells to add....

Sub adjustment()
Sheets("INV ADJ").Activate
Dim ran As Range


View 8 Replies View Related

Add Decimal Point To Existing Number

Jan 17, 2009

I need to add a decimal point to a column of numbers. For example, where it says 126 needs to be changed to 1.26, 3035 changed to 30.35, 13593 to 135.93 and so on. Can this be done automatically or with a formula?

View 2 Replies View Related

Add A Letter Before An Existing Number In A Cell

Jan 27, 2006


View 9 Replies View Related

Append A Number Into Existing String

Jun 26, 2013

I'm looking to append a zero into an existing string

For example, A1:D1 has {1,2,3,4} and I want to have it {0,1,2,3,4} without having to use another cell.

Can this be done?

View 8 Replies View Related

Macro To Copy Existing Workbook X Number Of Times

Dec 4, 2009

Just curios if this is the most efficient way to copy a workbook x number of times.
I tried copying 77 workbooks and not sure exactly how long it took, but about 2 mintues. The original workbook is 300 KB.

View 7 Replies View Related

Adding Numbers In Multiple Cells Where Individual Cells Contain Both Numbers And Text?

Jan 8, 2014

I have a column that looks like the following and I need to add the numbers:

27 skids
31 skids
56 skids
13 skids

The unit "skids" is constant. The answer I am looking for is "127" or "127 skids"

View 3 Replies View Related

VBA For Adding Numbers

May 7, 2008

I have a sheet that auto-populates with code from a userform that also provides the cell formatting. What I need is that in Column A it keeps a running count of the errors that are populated on the sheet.

Code for the formatting

With ActiveSheet
lastrow = .Cells(.Rows.Count, "B").End(xlUp).Row

For i = 4 To lastrow

If Cells(i, "B").Value "" Then
With .Cells(i, "A")

With .Offset(0, 0)
.Value = "1"
End With

.Offset(0, 1).Resize(1, 9).Borders.LineStyle = xlContinuous
.Offset(0, 5).Resize(1, 3).Interior.ColorIndex = 35
End With
End If
Next i
End With
What I need is instead of Value of "1" with the offset(0, 0), I need it to take the previous rows value and Add 1.

So the Range("A4").Value = "1"
Range("A5").Value = "2"

As the new errors are added to the sheet I need the value in "A" to be 1 more than the previous "A" value.

View 9 Replies View Related

Adding Up Numbers

May 30, 2006

i've gotta do this thing for school and i was wondering if thier was any way i could add up numbers from random number thing eg.rand()... if that makes any sense ?

View 3 Replies View Related

Adding Numbers Together That Are From Same Location?

Dec 31, 2013

I attempting to develop a forumla to account for 50 locations I am responsible for that will add different numbers together based on a specific location.

For example, if the location says "Los Angeles", I need the formula to look for all instances of "Los Angeles", the quantity of items sold and add them up for me in one spot.

View 3 Replies View Related

All Possible Combinations When Adding 2 Numbers

Feb 16, 2014

I have stamps of 2 denominations: .32 and .33

I want to know how I would write/format a spreadsheet that would tell me what are all the possible outcomes between the two numbers and what the components of these two numbers would be.

For example.

(8 * .32) + (3 * .33) = 3.55

So somewhere I would be able to see that in order to achieve 3.55 I need (8) .32 stamps and (3).33 stamps

View 6 Replies View Related

Adding Numbers In Columns

Aug 14, 2008

What's the fastest way to display the sum of each column in one row. Here's a picture of what I want to do: now I want the sum of each column to be displayed in for example row 10. I have tried manually clicking "autosum" (sp?) but that will take a lot of time as I have about 400 more of these.

View 2 Replies View Related

Adding Zeros To The End Of Numbers

Mar 27, 2009

I have a large spreadsheet of employee data saved in a shared network folder so that others can access it. Starting about a week ago, anytime I enter a number in any cell, Excel adds two zeros to the end of the number. For instance, a 1 becomes 100.

When other users open the file on their computer and enter a number, everything is normal - no zeros are added. I'm guessing I inadvertantly enabled a function somewhere along the line, but have been unable to figure out how to undo the function.

View 5 Replies View Related

Copyrights 2005-15, All rights reserved