i have a question about adding a number to a cell. This is the problem. Each day we track contacts we made in a spread sheet. how could i, lets say type 2 in a cell that already reads 42 and once a tab away from the cell it would change to 44 (add in the background 42+2=44).
View 5 RepliesIn a sheet (4) I have a pivot refreshed by a VBA macro code. Since I have defined a Chart on this pivot, I need to copy this pivot in a new sheet to avoid to reduce rows using a filter of the Chart. I copy this pivot using this VBA code
Sheet4.Select
Sheet4.Copy After:=Sheet2
I have e new sheet with a number Sheet(n) not equal to maximum sheet number +1
For a new run of the VBA macro I need to delete this sheet
Sheets(n).Select where (n) is not = maximum sheet number +1
ActiveWindow.SelectedSheets.Delete
Then I need to avoid the message box where I need to confirm to delete the sheet because the sheet is not empty.
Is there a solution to copy a pivot in a new sheet replacing the previous pivot and vithout changing the number of the sheet?
Can we add the value of the cell with the value of another cell? Fo example In Cell A1 have a value of 5 and In cell C1 i have a value of 10
Can I write a formula in Cell A1 Keep the value of the A1 and Add with the value of C1 10 to get a result of value 15 in cell A1.
Can you cut out part of a number and replace it in another cell. For example
A1 come in as ###+### and it will not always be a three digts all the time but I would like to keep the number in front of the "+" in A1 and the number behind the "+" into A2 cell.
Can you do this my a SEARCH("+",A1)LEFT("+)
I am trying to calculate the percentage of a number, have it subtotal, and then add to that subtotal another number all within the same cell like so:
20000 + 5% = 21000 + 4000 = 25000
I want to create a formula that will refer to the cell I want by adding a number to the cell reference, not to the contents of the cell. For example, lets say that the cell C11 holds a value of 22. I want to add 4 to C11 to get my formula to reference cell C15, I don't want it to add 4 to the contents of C11 which is 22 and would give me a result of 26. I have a large spreadsheet and I can't just fill down the way I have it now and I don't want to have to retype the formula every time.
View 2 Replies View RelatedIm trying to develop a formula that sequentially numbers in column a depending on if there is a value in column B
We have documents at work that have alot of text with random spacing between that needs a sequential reference number so would like the formula to be able to look at the value in column b and if its not blank add a number . I would like this number to be the previous cell above + 1
the formula ive started looks something like =if(B10""), ???????,""
can not get excel to reference cell the last cell above with data.
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'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 do receive invoices from my vendors. They send me an invoice in PDF formate. I am using able2extract software to conver the PDF to excel. It is working great but most of the times my vendors enters the items/Case in the description field. Like the example below:
"Bajri Rotla 11 oz.(24)"
I would like to place a "," in between the last character and begining of the first number. In the above case it will be after "a" (in Rotla) and before "1" in (11). If I can do this then I can apply texttocolumn from excel and use "," as delimiter and separate item name from size and case/Pack. Then can use another "Texttocolumn" and separate size and case/pack. If there is a VBA code that can be written for this it would make my life a whole lot easier.
Following are 3 images that I have copied from actual data.
1. Original PDF invoice data that I receive from my Vendor
2. Image of the excel file before formating. This is the format from "Able2Extract" (3rd party software that I use to convert PDF to excel. Works great!!
3. Converted Excel data sheet. This is the way I want to format the data.
I am trying to create a macro where it finds a a certain word in a column for example C. What i want it to do is find anything that says FWD_EUR and then replace that cell (e.g C2) with CASH_EUR_FWD and after it has done that it replaces the adjacent cell (e.g. D2) with EUR_FWD. I then want this to do the same with FWD_USD to CASH_USD_FWD and adjacent cell to USD_FWD.
View 2 Replies View RelatedI have over 16000 cells with different information in them, each cell is unique. There are parts of these cells that have similar information.
I am looking to search part of the cell, and replace the whole cell with my new description, so I can run pivot tables on it.
In column N I would like a formula to add 3 columns,e.g. C and D and F. The problem is I want the symbol ~ replaced by 1.0 for calculation purposes.I need a solution in 1 column,if possible. I have made a few efforts,but just not getting there. See attached section of sheet.
View 2 Replies View Relatedhow I could search for any number great then (x) and replace it a letter
For example I have an excel table with a series of weights.
lbs
6001
4560
6789
2000
5656
8879
1243
I like to replace any number greater or equal to 6001 lbs with the letters SS.
Example:
lbs
SS
4560
SS
2000
5656
SS
1243
Then I'd like do the same thing again but this time replace any number less
then or equal to 6000 lbs with the letters SS-LL .
Example
lbs
SS
SS-LL
SS
SS-LL
SS-LL
SS
SS-LL
I have a column of references I wish to standardize. Contained within a general text description there is also an order-specific reference number, which is not relevant for my purposes. I wish to find all of these numbers and replace them with nothing (i.e. retain the rest of the description).
The reference numbers are always in the format "P#####/##". Unfortunately these references are in the middle of the text field, not at the start or end, so I can't use a LEFT or RIGHT formula to delete them.
Once these reference numbers have been deleted I will then be able to filter for unique records only. When I do this at the moment the filtering has no effect due to these specific reference numbers.
I have a column of Latitudes (12° 32.467'S) to which I wish to add 0.09'.
The result being 12° 32.557'S
I have excel sheet with lot of number, I want total 7 digits in call. Some of numbers i have in 6 digits so I need to include 0 after “L” and Some of numbers is already has 7 digits.
e.g.
Numbers
L34654
L215487
L54875
L459875
L48546
Need to add “0” after “L”
L034654
L215487
L054875
L459875
L048546
I have a form that requests random info. All this information is saved to a worksheet. I would like to give each transaction a reference number. In order to do so I would like each time a new record is saved to add 1 to the previous reference number. Also I would like to start the transaction with a unique identifier "ie. rn1001".
View 4 Replies View RelatedI have two groups of data? I selected the cells in yellow and defined the name of those cells as group1. I want to be to do absolute value of individual cells and add them up. I tried pressing shift control and enter and it still isn't giving me a number. I can do it if the numbers are next to each other but if they are separated by a row it won't let me.
[URL]
Is there a way to add a percentage to a number, I know the Method of Multiply by 1.25 for 25% The problem is there another way to formulate without the "1."
Sheet1 Â LMN
32640%15.28?
I'm trying to add plus 1 to a cell from another cell but it doesn't work because the number starts with a letter. I do want to keep the letter in there for a reason so removing the letter to make it work is not what I want.
Example:
Code:
ThisWorkbook.Sheets("Invoice").Range("H5").Value = ActiveCell.Value + 1
Is it that I need to declare and set the ActiveCell value as a string or something?
I have phone numbers imported from outlook in csv format. Now these numbers are like 2782512512, i want to add Zero at the start of this number. So, it will become 02782512512. How can i do this. Find and Replace method doesn't work.
View 9 Replies View RelatedI have a worksheet to keep track of products. I use an SKU column with a Unique Number to keep track of those items on the shelves.
When I started my project I never imagined that my database would grow as large as it has. I started my SKU numbers with 80000, never suspecting that I would get to 90000. I am now at 125700. Many items have been removed / sold so it only encompases only 15500 rows.
On the site that I sell these Items, the SKU's when displayed start with 100000 and go to 125700 where 80000 is next and goes to 99999? ( or the reverse depending on which tab I choose ) Not sure why this is but there is nothing I can do to change the way they do it so I must find a way to change my system. With all the 80000 - 99999 items numbered - changing them to 6 digit 125700+ numbers would be a huge undertaking so I would like to add a 0 in front of each 5 digit Number in my SKU Column. That way my items will show 080000- 125700 instead of starting in the middle.
I do keep the column my ascending order so it is currently formated as a Number. I do at times copy an paste or pull ranges items by SKU numbers to mark down or modify.
When I place a 0 manually in front of 80000- it disappears when I move from the Cell.
If I change it to a TEXT cell- it stays in place.
Excel help doesnt answer my dilemma-- nor does my book.
I see there are masks etc -- or is just text OK ? (as I stated - I do use an numbered order or range to identify groups of items at times )- if text is OK, what is the best way to add a 0 to the start of each 5 digit number other than individually ?
There are Gaps in my sequence so I cannot just replace the first cell with 080000 and pull down.
You will probably find this very easy but I am having all sorts of trouble making it work as I want to! Basically I need to do the following procedure...
1) Open an Inputbox to collect an eight digit number
2) Insert a column in A:A
3) In A1, enter a col header (URN)
4) In A2, enter the number that was collected in the inputbox
5) Enter sequential number from A2+1 to the last row
Ideally, this would be randomised, so after stage 2 do RAND(), sort, and clear contents, but if I can get the main part right I'm sure I can work that out!
In the IAF tab, last one on sheet, I want to highlight a cell if on the Day tabs there is anything in column E, this will be text e.g. LAD, LE, E, AD, LC or NS, and in the same cell show the number that appears in column J of the day tabs, the excel sheet I'm working is to large to upload, if I delete some of the tabs all of the formulas go out of kilter. If Joe Blogs was at work on Day 1, the corresponding cell in the IAF tab should be yellow, if the supervisor monitored Joe's work on Day 1 the same IAF tab cell should remain yellow and show the number that is placed in column J on Day 1 for Joe Blogs.
I have managed to upload an amended copy of the file : Job PSS MASTER - v3 6 AMENDED.xlsx‎
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
10035-TSZ651-MT0A01-42004314-F01-0023.
I'm working on a complex A/R aging summary. So Ill have couple of question, but right now I'm trying to have excel automatically keep track of the A/R process. For instance every business day I would like the number of days the Invoice is outstanding to go up by 1. So when I get to work on monday the invoices that have been due for 20 days will now show 21 without me touching it.
View 5 Replies View RelatedI have few range of data that may range from 0 to 24 and the return to "0 " after 24 and the 2nd set of value keep repeating 0 to 24, but I would like to keep adding 24 when the value return to 0 and if the number less than 5 will be adding 24 and the number from 6 to 8 will be equal to 11 and also the number from 9 to 23 will not change. I have attached an example that Colum A needed to be converted to column B (which I done it manually).
View 2 Replies View Relatedi've got a sample database (attached) with a userform for inputting of data. What i want it to do is automatically generate the next number and add it to textbox "our ref" on the userform. the number is in Col C. This is the code i've tried using the code highlighted in red which doesnt work.
View 12 Replies View RelatedI'd like to add a number of calendar days to a date shown on Col A
I have 2 columns
a margin with a row number --- and Col A
When I try to add say 50 to the Col A ie =A261+50 to get 50 cd from cell A261 ----
I get a # problem
Tried to place 50 in a cell and then add the 2 cells but got the same result -- #
Can I use the margin row number to add to -- this would work well as I'd get the Row number which would also be the date.