I still can't display spreadsheet so I'll try my best to explain.
In any given cell I would like to enter different amounts and have it add as amounts are entered let's say in cell C13 I put $1000.00 then tommorrow I enter another $1000.00 this should then be $2000.00.
When I put the formula =sum(C13) it tells me something about circular reference within same cell.
I would like to add a date to one cell (say A6) and have this do two things:
#1) this would add "Closed" to a given cell such a A5.
#2) and this would add a color to a group of cells like A1 through A8.
Trying to get a record of who authorized spending in one of my worksheets and when they did it
I had some VBA code in one of my worksheets which added a time stamp and a user ID to two different cells after the user enters their name. Why it is no longer working, though I suspect after moving the worksheet around.
I would like my users to type their name into cell G65 (which is actually merged from G65-K65). Once the user enters their name, cell L65 (which is actually merged L65-O65) populates with the current time stamp. Also, when the user enters their name into cell G65, I would like cell P65 (which is actually merged into P65-S65) to auto populate. I would like this all of this to go down through line 70.
I have values in a number of cells. Next to them, if there was a value, regardless of what the value is, except blank or zero, i would like the cell to turn blue and if possible have a 1 in the cell.
I've used the conditional formatting, however, among the options, 'less than' is the closest to to getting the color right. The issue is that if the cell has nothing in it, it still colors the corresponding cell blue; because it is not less than the already blank cell. If it is blank, I don't want it to color the cell.
First I would like to say that I am not English nor very good to explain myself so hope the title is according to the forums rules. Now to my problem
I would like to to put in for instance the number 100 in cell A and then the number should appear in cell B. I would like to remove the number in cell A without the number in cell B to dissapear. Then add for instance 50 in cell A to get the number in cell B to add up to 150 and so on. How can I do this? I would like to add that cell B is already connected to a different cell. And I am using Vista.
I have a column of times: e.g. 10:03:00 and I would like to add them all up.
=A1+A2 works fine.
=sum(A1:A10) does not.
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.
I have a userform that I'm using to add data to a worksheet, with the following
Private Sub CommandButton1_Click()
Dim OutSH As Worksheet
Set OutSH = Sheets("Sheet1")
OutSH.Cells(nextrow2, 1).Value = Surname.Value
OutSH.cells(nextrow2,2).value = ID.value
OutSH.cells(nextrow2,3).value = Date.value
......
I need to ensure that duplicate entries are not made for the same person on the same date. The ID is unique to each person.
IF statement that can check for a duplicate and then come up with a dialouge box with some custom text, and then exiting the sub?
I have an excel file that we add data too for assignments and I want the date to auto popuate if the status is changed to Mitigated, Escalated, or offline. I wrote the below function which works but when i open it the next date the current date is written to those cells. creating a function that writes the date when the status is change and then leave the date alone unless the status is changed again.
[Code] .....
I have attached an example of what i have and below is the function
Example.xlsx‎
I want to Adding my one of the cell value in Table1 by the one of the cell in table 2. and i will do the same thing with another cell in Table1. but it will take so much time to do it because my Table1 Has 9 Cols and 200 Rows. And Table2 has same Cols and Rows like Table1, too How to make it faster?
View 4 Replies View RelatedSo i was asked to do a spreadsheet for "counting" electrical items from a project. For instance, quantity of cables, cable trays, electrical equipment, etc.
One of the sheets is called "Cables" and is structured in a database form, i mean, the first row contains the name of the columns (fields) and from the second row will be the records (much like a table in Excel).
One of this columns has to be calculated, for example, Qty (B3) * Measured (C3) = Subtotal (D3). If i put the formula in the whole column filling D:D the size of the excel file grows up to 10 mbs. So to keep the size small, I want Excel to introduce this formula only if it can find a value in Qty (B3).
Is liking adding records in Access, the table should grow with each row completed. We cannot use access, it has to be something the team can handle (they know a bit of Word and Excel, nothing else).
I have a spreadsheet with two columns and 39900 rows, from that data I want to create two new columns so cell C1 = A143 and D1 = B143, C2=A286, D1=B286, and so on. The row location increases by 143.
The simplest thing I tried to do was to say C1=A1+142, but (knowing it is wrong) I get a #value error.
How can I tell excel to grab these values located every 144 rows below and create two new columns?
I would like to know if it's possible to add a number to a number in a cell ie.. cell a1 has a 6 in it and i want to add a 3 to that cell to make 9, at the moment i hilight the cell and mentally add the two numbers together 6+3 and then type 9 in the cell
I am trying to add numbers from cells if it IsNumeric and for some reason in column K the macro doesnt recognize numbers after row 14?
The range column is "E4:E"
Search criteria is the letter "R" in column "E" Then using OffSet, I go thru other columns and process data. Most of the macro works except for column K after row 14?
I am needing so I did it as a picture. (Please assume "Day 1" is A1)
View 7 Replies View RelatedHere is the Scenario what I am into.
Row 1 Col1 Col2 Col3 Col4 Col5 Col6 Total
Row 2 10 "A" 19 "A" 13 "A" 42
Row 3 1 "A" 9 "B" 10 "A" 11
I was trying to have a formula which would add all values in the total column of that row whose adjacent cell has "A" in it . I am not sure if I am clear enough in my explanation but my example above is more clear want I meant .
I tried posting the same post earlier but I guess I was able to explain the same . I was trying to put the formula which will give the total column with a value in which it all gives addition of those values who's adjacent cell as "A" in it in the row .
Col1
Col2
Col3
[Code].....
How to add effects on a cell "e.g; blinking or making sound effect " if a condition is achieved... ? is it possible
View 2 Replies View RelatedI had already asked a question like this on the forum and was unable to get a working answer. I'm still grateful at the time JBeaucaire spent trying to help me. The solution we had worked in Excel 2003 but when moved into 2007, an error came up. To see the solution and the error, the previous post is at
HTML http://www.excelforum.com/excel-2007-help/663593-adding-function.html
What I'm trying to accomplish is if a person inputs a number into a cell, A1, the value will be added to another cell, A2, then A1 will be cleared. If another value is inputted into A1, then it will be added to the value into A2 on top of all the other values inputted and clear A1 again.
I have found following example:
This month I will show you some handy formulas used with a twist. SUM ALL SHEETS.
The first one is how we can use the SUM function to Sum, say cell A1, on all Worksheets in your Workbook. With this method, all new sheets that are added to the Workbook are included in the SUM. Here is how;
Add a new Worksheet to you Workbook at the far right. To do this select "Worksheet" under "Insert" on the Worksheet Menu Bar. Then left click on this new Worksheet name tab, holding down the the left mouse button drag to the far right and release.
Name this sheet (double click the name tab) "Spacer" (although any name will do).
With "Spacer" being the active sheet, go to Format>Sheet>Hide. Repeat steps 1 to 3 above, but this time name the Worksheet "Start " and drag it to the far left. On the Worksheet you wish to have the result shown on enter: =SUM('Start :Spacer'!A1)................
I have a number in each cell 42189654 and I want to add a period in the 3 place. Example 42.189654. I cannot seem to get the correct formula.
View 5 Replies View RelatedIs there any way of inserting the Sheet name into a cell? When you are in print preview for Header / Footer it is a comand - &[Tab. I have 3 Tabs called UK, France, Germany and would like to add a few more with a refference in A1 that picks the name up. I have tried =concatenate("Profit Journal - ",&[Tab]) and many other ways. I am sure I have seen this done before.
View 2 Replies View RelatedI have approximately 180,000 rows of data in column A. Is there anyway to return a value next to a highlighted cell in column B?
Example: If Cell A4 is filled(highlighted), I need to return 1 in cell B4.
Capture.JPG
I need to add what specfic cell was modified on the sheet tab "data" or it could refer to the reference in column A for the specific row within the sheet "data"
View 10 Replies View RelatedWhat type of formula do I need that will convert the following into one sum?
in Cell A1 : 34-23
I need a formula that will add 34+23 into another cell... this should be simple, but I've never had to write one for this before...
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.
I am trying to add to a cell number and I am not entirely sure its possible. Here is my question:
My formula is thus:
='Sheet1'$A1 On sheet 2
And My next cell that I want it to show would be From Sheet 1 A4, then Sheet 1 A7, and so on and so on.
Can I do something on Sheet 2 to put =A1+3 and that would somehow give me A4?
I am trying to use the reference of Sheet 1 A1 and have next cell show me the value of Sheet 1 A4, then Sheet 1 A7 and so on and so on.
I created a custom ribbon with tickmark button. The problem is that at sometimes, i will need 2 tickmarks in the same cell.
Actually in using the simple line :
ActiveCell.Value = "a"
And when i click on a second tickmark, it replace my "a" by ei. "b"...how to make it "ab" instead ?
Is it possible to have the following simple formula =D3-D13 with the answer in D20, this works fine but I also want D20 to be amended if, say D9 has a number added to it. For example, if the answer to my formula is 20 (in D20) and I then want it to change to 25 by putting 5 into D9. How can it be done?
View 1 Replies View RelatedI have name some random names as name1, name2.... name5
to add these cells, the formula is not working
=SUMPRODUCT(INDIRECT("name"&{"1","2","3","4","5"}))
I have Abbreviation in column A and their full description in column B. I need them both (A + B) to be in column C.
Eg:
in column A
AVER
ANNU
BEFO
CALC
NETP
Blank cell
TOTA
SUBT
GRAN
In column B
Average
Annual Leave
Before Tax
Calculated
Net Profit
Blank cell
Total
Sub Total
Grand Total
In column C at cell C1
AVER – Average
ANNU – Annual Leave
BEFO – Before Tax
CALC – Calculated
NETP – Net Profit
In column C7
TOTA – Total
SUBT – Sub Total
GRAN – Grand Total
I am manually type this and using ALT+ENTER keys to place cells together in column C
If I can have VB code to do this task would be great. The code is to add a group of cell in column A and B then place them in column C and also reverse them back to where they were if I needed to.
I’m trying to attach the HTML file if I can, otherwise, please see the above example ....