Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

increase number automatically

I want to automatically increase the number in a certain cell each time the
document is saved. I also would like the number in the document name to
increase each time the document is saved (the new number will be the same for
both the number in the cell and the document name). The document name is
currently 0000Estimations (the 0s are where the new number will be).

Thanks!


Post your answer or comment

comments powered by Disqus
I need to know how to make a number automatically increase by a percentage at a certain interval.

For example, 1-12 need to be 3% of 100, so, 3. Then, from 13-24 need to be 3.5% of 100, and so on. Does anyone know how to do this?

Is there anyway to create a counter, whereby I can click it and the value of a cell grows by one number each time?

What I'm doing is counting up responses made by customers. So, instead of manually changing, let's say 30 to 31, then manually change 31 to 32, and so on, can I click on something to make the number automatically increase by one number? What's happening is that at times, people manually change a number to one greater (i.e. 33 to 34) but they transpose the numbers (i.e. instead of 33 to 34, they change it from 33 to 44, or some other number by accident) without realizing it. If there was a counter we simply clicked on, that wouldn't happen! It would be really helpful if the counter would not need it's own cell, but that might be pushing it.

I hope this makes sense! I would love to be able to change the way these reports are set up. =)

~GSG

Hi All, i have a situation i just cant get around.
i have a large amout of data that contains many Rows & columns.
for example A1 contains invoice number, C1 is a descriptions etc.
A1 can have multipe (identical) entries that i need to make unique, whilst still keeping the original number.
i need to add an increaseing number (suffix) to each identical number but reset when the number(A1) changes..
hope this all makes sense..
excel quirey.JPG

any help greatly appreciated

I'm working in Telecom industry, where I'm using Excel almost 90% of my
duties, I am facing the problem when I want to transport the information
from the billing system to Excel, I am talking about 1,000,000 + entries
(rows), where excel it only have 65,000 rows, it is very difficult to split
the data into different sheet, it is also a time consume to run the quiry in
the billing by considering the limitation of excel, to carry all the rows
extracted from billing. i.e. I f i want the data from 1st to 31st, then I
have split them in 3 group ( ten days each) I would suggest to increase
number of rows atleast to 2,000,000 rows. in addition to that CDR extracted
from billing system contains more then 2,000,0000 entries.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I need a formula that will sum increasing numbers up to an nth value.

For example:

A1 = 50
A2 = 50 + 5
A3 = 55 + 5
A4 = 60 + 5

...

A1 = 50
A2 = A1 + 5
A3 = A2 + 5
A4 = A3 + 5

etc

Want to increase number by 1% each year for first 3 years and the thereafter
ther will be no increase for next 4 years

I'm working in Telecom industry, where I'm using Excel almost 90% of my
duties, I am facing the problem when I want to transport the information
from the billing system to Excel, I am talking about 1,000,000 + entries
(rows), where excel it only have 65,000 rows, it is very difficult to split
the data into different sheet, it is also a time consume to run the quiry in
the billing by considering the limitation of excel, to carry all the rows
extracted from billing. i.e. I f i want the data from 1st to 31st, then I
have split them in 3 group ( ten days each) I would suggest to increase
number of rows atleast to 2,000,000 rows. in addition to that CDR extracted
from billing system contains more then 2,000,0000 entries.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Can anyone help me please?

I want to be able to extract the top 6 values in an increasing number of values overa period of time, any ideas?

cheers

Ian

I have problem, and follow the instructions in old post that might be similar to my need http://www.excelforum.com/excel-2007...xt-number.html but doesn't have result in my workbook. Is there other operations, like save after put the formula into code area? And if you know if this instruction is valid for my specific need:
I need excel to generate increasing number in every one random empty cell. When I type digit "1" for the first entry I want it to calculate next progressive number for every other cell in random order which I choose and type "1"
Thanks in advance
Best regards
Plams

Hi,

i want help in appending excel sheet number in a formula. Here is the example.
In an excel book, I have sheets 1 to 50. In each sheet i have a standard format to enter the details. And in one sheet I want to keep some summary with required cells. I made a table by applying formula, for example in cell A1 i kept formula ='9'!$D$9. In this '9' refers sheet9. In the similar way i want to capture the data from all sheets.

A1 cell ='9'!$D$9
A2 cell ='10'!$D$9
A3 cell ='11'!$D$9....etc

Is there any formula to append the Sheet number automatically (like dragging the shell) intead changing sheet number manually. because it is wasting so much time.

can anybody help.

I am trying to add increasing numbers to existing column of text with hundreds of names:

Example:

baco
bake
boes

I want it to look like this:

baco01
bake02
boes03

Thanks for your help. Diane

Column A, is an continually increasing number.
Column B, is also an continually increasing number, but starting smaller then Column A.

What i want, once Column B equal or exceed Column A, it will subtract itself and start from Zero or what ever value that is left, then both column continue to increase until same thing happen again...

P.S - i am sorry if my explanation is a bit poor.

How can I get Excel to highlight columns that have an increasing number sequence?

For example, I would be looking for Excel to highlight Column 2 below

Column 1 Column 2 Column 3
24 90 76
38 80 95
67 70 24
56 65 88
54 60 43

Thanks in Advance

I want to automatically increase a number by one everytime I open an excel workbook. For example, we have a purchase order template on excel and we want that purchase order number to increase by one every time somebody opens the file to write a PO. So the PO numbers start at 0000, the next time someone opens that template, we want the number to be 0001, then the next time 0002 and so on. Is that possible? Any help would be appreciated.

Thanks

Thank you in advance for any assistance. I have been trying to follow some previous threads (mainly the Thread:
Auto Increment Invoice Number When File Opened

and Thread:
Automatically Increment Invoice Number.

Unfortunately, I am lost.

How do I make these posts relevant to my own workbook?
I am trying to store the invoice number in a range of cells (I have merged cells together to keep the template orderly). The range of cells is AH2:BH2.

I need to increase the number of characters that a Text Box will accept. I am trying to have a text box automatically populate from multiple cells and I am running out of character space. I am new to this and would like to know if this is possible and if so, how do i do this. I will need step by step direction if possible.

Thanks so much to all those who help.
ccudm611

Hi

A user would like to know is there a way they can enter numbers in column A and automatically this increases by 10%, they do not want a separate column or to hide/unhide data.

Many thanks

Hi
Two ,what Im sure are very easy questions.....

No 1. By using code and a button I need to increase a cell value by 1 on each click(to change week number at start of new week)

No 2.I have a workbook "weekly data" that is filled with data,by various users over the course of a week,at the end of the week all the data is copied and pasted into another workbook"stored data" and the original workbook cleared of all values for use the following week.How do i automatically make the cut and pasted cells from the "weekly data "book paste into the next available empty cells in the storeddata" workbook (i.e.I dont have to specify the paste cell range every week)
I have just started dipping my toe in VB and have worked out everything I need to do except for forcing the data to paste into the next available cell,at the moment i change the cell range in the code each week!!!!!!

Many thanks in advance for any help given

I have an excel spreadsheet that is used for purchase orders. I would like
to be able to increase the Purchase Order number automaticly by one each time
the spreadsheet is opened.

eg Order 1002 on 18/01/2006 becomes Order 1003 the next time the sheet is
accessed.

Any suggestions?

I need a macro that every time I run it, it increases the number only by 1, always leaves the T and has 6 digest in cell "A1".

For example

000002T
goes to
000003T
And so on

Hi All,

Please we need help with a vba code for automatic and sequential invoice numbering.

We generate invoices using an Excel invoice template. Currently, the numbering is done manually – the invoice number typed in manually. As a result, we have had problems of missing out some number ranges including having more than one invoice with the same number!

We want to ensure that henceforth, when we generate invoices, they are numbered automatically and sequentially. At the moment, for each invoice, the invoice number is typed into Cell C13, and the current number is P1043. We want the automatic and sequential numbering to start from P1044, and the number inserted into the appropriate Cell C13.

We will greatly appreciate a vba code that will help us on this.

Thank you.

Buddy

Does any one know if it is possilbe to increase the number of columns in a sheet? I am starting to run out of column space and would like to keep the data on one sheet.

Also if not are there other options?
Is there a way to switch the location of the rows and columns? (rows = 250, column = 65000)

Thanks,
Trav

Usually when I use Excel if I type a number into a cell then select the cell and drag it down to copy, it will drag and copy the numbers, increasing each cell by 1. However today when I am using Excel it won't increase. It just drags and copies the same number. So for example I type the number 1, and when I select the cell and drag down, it just copies 1 all the way down the column. I also tried going into Edit>Fill>Series and selecting *Columns & *Growth and it still doesn't work. What could be going wrong ?

I am not very experienced with excel. So I was wondering if somebody could help me.
I am looking to create a Button (with macro), which when pressed increases a number by one, i.e. when pressed turns the number 4 into 5 etc.

Thanks
Mike


No luck finding an answer? You could always try Google.