Code For Adding 2 Numbers From Another Workbook

Jul 16, 2014

I have a code that opens another WB, and gather data from it. most of the lines look like this:

HTML Code: 

wb.Sheets("Data").Range("K" & Rows.Count).End(xlUp).Offset(1) = wb2.Sheets(1).Range("M49").Value

However i need it to gather the sum: M49+M50, how can i do this without importing both values and then adding them in a 3rd column, like i am currently doing.

View 3 Replies


ADVERTISEMENT

Code Writes Decimal Numbers Next To Each Other Instead Of Adding

Sep 4, 2009

Code writes decimal numbers next to each other instead of adding. I have the following code on a very simple form:

View 5 Replies View Related

Adding Numbers From Multiple Worksheets Within One Workbook

Aug 22, 2012

I would like to be able to use VBA to add a total amount from different worksheets. What I have attached is a copy of my workbook. It is a blank PO and at the bottom is the word total. Is there any way that I could use VBA or an add in to be able to sum the numbers that are adjacent to the word total on separate worksheets?copy.xlsm

View 2 Replies View Related

Excel Crashes When Adding Code To Workbook Via VBA

Apr 9, 2009

The code below resides in my personal.XLS Module. When I step through the code everything works till it reaches the point in red then I get the pop up that says excel needs to close and asks to send or not to send.

I noticed that if I choose recover my work and restart excel and I look at the code in THISWORKBOOK of the recovered workbook that the code I wanted placed there is there.

Can anyone explain why this is happening? I have the macro's security set to low and a check mark in the trust access to vb projects.

Any Idea's how to fix this?

View 6 Replies View Related

Adding Some Additional Code To Prevent Someone From Saving Workbook?

Aug 14, 2014

Adding some additional code to prevent someone from saving the workbook under a different name. Currently if someone tried to enter data after the allotted time period, it would allow them to in any "unlocked" cells. When exiting or trying to save the file with this new data, they will get a message stating something to the effect that this is a read only file would you like to save as another name, which would allow the user to circumvent what I'm trying to accomplish. The end result would be they'd need a new spreadsheet.

[Code].....

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

FEdLkuj.jpg

View 2 Replies View Related

2002 Code V 97 Code: Add A Small Workbook Open Event Code Which Works For Me But Debugs For The Others

Jan 27, 2009

I use excel 2002 but some of my office are on 97, i want to add a small workbook open event code which works for me but debugs for the others?? The code is basically, go to a tab, on that tab and that range sort..

View 2 Replies View Related

Adding Code: Combine 2 Sections Of Code

Sep 9, 2009

I am now trying to combine 2 sections of code but being a complete VBA novice I'm stuck, where should the second Sub go so that it works,

View 4 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

Macro Code To Change Positive Numbers Into Negative Numbers

Feb 1, 2007

I know ASAP has a feature to do this but I need the code in a bigger macro that I wrote.

EX: -1 needs to be 1

View 9 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: http://www.filefreak.com/ppublic/33833/excel%20help.bmp 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

Adding Numbers With Formulas

Apr 23, 2009

I'm tring do a simple formula: =CA3+BP3+BE3+AT3+AI3+X3+M3, but because the cells I am adding have formulas in them already it is returning a error. Can I add them using 'sumproduct' formula, or is there another way?

View 9 Replies View Related

Adding Letters With Numbers

Jan 30, 2013

I have in cell A1 the number 2 and in cell A2 the letter m.I want to add these two cells in cell A3 so as to appear 2+m.So i type in cell A3 =A1+A2 but it appears error.Is there a way to do what i am asking?

View 3 Replies View Related

Adding Up Numbers In Same Cell

Nov 14, 2011

I am trying to create a cell that can add up numbers

For example if I have cell A1 and type 10 in there, if I then type 5 in the same cell it will over write the 10, is there anyway that where u type 5 it will add it to the 10 to make it 15, then if I type 5 in again it will make it to 20? Is this possible or not.

View 2 Replies View Related

Adding Numbers / Userforms

Jan 1, 2012

I have a userform where I input say .2, and then another(which is basically the same userform) where I input any other number, we'll say .3.

I try to add these two, and instead of .5 I'm getting .2.3.

I tried using cInt() but that made it all come out as 0 instead.

Formula I am using is

Code:
WSH.Range("H" & cvrrow).Value = WSH.Range("H" & cvrrow) + miss

View 2 Replies View Related

Adding Numbers Using Dates

May 10, 2007

I have a spread sheet that shows the dates items were shipped. When trying to work out the value of parts shipped in a month using SUMIF I get the value zero, I believe this to be because (obviously), there are multiple dates of ships during the month, I therefore tried ignoring the day of ship in the SUMIF but this did not work, the date format is DD/MM/YYYY.

View 9 Replies View Related

Adding Numbers In A Cell

May 5, 2008

I am trying to figure out how to add the individual numbers in a cell to return me a value in another cell.

Ex: In cell "A1" the number 5861.01 is entered.
In Cell "B1" the value 21 is returned (which is computed as 5+8+6+1+0+1=21)

I have tried playing around with array formulas within the actual spreadsheet but I cannot seem to get this to work. I have also tried some VBA, however I am not familiar enough with arrays to figure it out, if its even possible.

View 9 Replies View Related

Adding Numbers Within The Cell

Mar 29, 2009

Would like help on how to calculate numbers within a cell. Say, I have these numbers in A1: 01-02-03-04-05 and I want A2 to give me the sum of all the numbers in A1 without the dash. Is it possible?

View 9 Replies View Related

Adding Positive Numbers Only

May 21, 2009

I'm looking for a formula that would add only positive numbers located in the same row and in 5 different cells. These cells may contain negative numbers at times. The total after adding the 5 cells are to be displayed in a different worksheet.

View 9 Replies View Related

Adding Numbers In A Single Cell

Mar 31, 2009

What is the function to add numbers in a single cell to show only a single number. I know it can be done but do not know the quick function to do it.

View 10 Replies View Related

Adding Numbers Beween Spacing

Oct 25, 2009

I got a number, OK lets make it every even "5","10", "15" est and i add another one beside it to be added 0.01 every "5" times, so ok i'll make it a bit better some how,

(A1)
lv 1
=1
lv 2
=2
lv 3
=3
lv 4
=4
lv 5---(A2)----(A3)
=5 + 0.01 = 5.01.............

um I had one idea that did and one that did not work, 1. to do it manually or 2. (that did not work) us "=IF function"

View 2 Replies View Related

Adding Two To Six Zeros To The End Of String Of Numbers

Jan 11, 2013

I need to add 2 to 6 zeros to the end of string of numbers beginning in A2:

01
011
0111
0112
011901

The end result, all numbers must be 8 characters long.

View 2 Replies View Related

Adding Numbers In A Column Results In Zero

Dec 19, 2005

When I type in a cell [say cell F1] "=sum(A2:A8)" I get a "0" as the result.
Yes, there are numbers in A2 through A8 which add to 12. Anyone know why the
formula doesn't work? This happens on some sheets in my workbook, but not all
sheets.

Also, another wierd thing: on some cells doing the above reults in the
formula showing as text in the cell.

View 9 Replies View Related

Adding Numbers Treated As Text?

Dec 26, 2011

Is there a way to add numbers when you have them in a cell treated as text?

For example, instead of writing the information in each cell by hand, I copy/paste the information to excel, but the format I get is this:

Cell A1: 25-35
Cell A2: 31-30
Cell A3: 2-12
etc.

In the above example, I am treating those cells as text because if I don't do it this way, some information will format it as dates. (For example, cell A3 it would read is 12-FEB (2-12), but it should be 2-12)

I want to add the values 25 + 31 + 2 = 58 and 35 + 30 + 12 = 77

Without using "Text to Columns" tab to separate the numbers in each cell?

View 8 Replies View Related

Adding Numbers That Have Text In Same Field?

Sep 20, 2012

I am working on making a time sheet log that will have employee name, 7 rows for days of the week and a row for total hours worked. each cell will either be blank in that row because employee has not worked that day or it will have numerical hours and the place the employee worked. We have many different job sites so text is subject to change. For example Monday employee 1 worked 8 hours at MRCR, so cell would state 8 MRCR Tuesday did not work so left blank. Wednesday worked 8 hours at CCR so will be 8 CCR. Thursday worked 8 hours at CU. so 8 CU in cell. Friday Saturday and Sunday left blank. How do i add create a formula that would be standard formula for each week for employee that would add numbers and omit text as well as ignore blank cells from week to week as the employee schedule changes.

View 7 Replies View Related







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