Increase Aphanumeric Number For Each Change In Data
Dec 28, 2006
I have many data in a worksheet named "Table" with "Item" in column A and "Reference" in column B. For each change of item, I need to assign a reference number with a prefix. Below is a sample of the data.
Column A Column B
Item Reference
Orange R9
Orange R9
Orange R9
Apple R10
Apple R10
Apple R10
Mango R11
Mango R11
The starting reference number is not fixed. It could start from 8 or 10.
Thought it would be possible to automate this process using vba.
View 7 Replies
ADVERTISEMENT
May 15, 2014
Our business has a spreadsheet set up for invoicing. A Macro has been created to increase the invoice number, save to the desktop as a PDF with a file name taken from the cells
This is working on my colleagues mac but when we've loaded onto my computer it errors, when I debug I am getting the following error:
Sub Macro3()
'
' Macro3 Macro
'
'
Range("g10").Select
[g10] = [g10] + 1
[Code] .......
View 2 Replies
View Related
Jun 2, 2014
I have a tracker where each row has a predicted complete date, this date is already based on some IF statements. I have a second column where I would like a second date to be based on the overall team workload.
the workload factor should add on extra time to the first date.
This would by adding on.
0-40 = 3 weeks (standard time)
41-60 = 4 weeks
61-80 = 5 weeks
81- 100 = 6.5 weeks
101-120 = 7.5 weeks
I have two tabs.....I take the total workload from the Tracker Status and the progress tab is where the first date and the new date will appear.
I tried a formula using a % increase in time (I did this using e.g. 0.33 for 33% for increase between 3 and 4 weeks) (based on the increase in weeks), but it came out with date in 2052!!! This is my formula that doesn't work properly.
=IF('Tracker Status'!B5>=100,'In Progress'!AE2*(1+'Tracker Status'!C22),IF('Tracker Status'!B5>=80,'In Progress'!AE2*(1+'Tracker Status'!C21),IF('Tracker Status'!B5>=60,'In Progress'!AE2*(1+'Tracker Status'!C20),IF('Tracker Status'!B5>=40,'In Progress'!AE2*(1+'Tracker Status'!C19,IF('Tracker Status'!B5
View 9 Replies
View Related
Nov 15, 2009
I have a 49 numbers in cell A1:AW1 they are not in acceding order. I want to separate all groups start from lowest number to highest giving them deferent color. As shown in example table below in cell (A2 start with nš 6 and increase up to nš 47 till cell F2 =yellow color) then Cell (G3 decrease nš 3 and increase up to nš 49 till cell L49=Green Color) and continue same process for rest ....
View 9 Replies
View Related
Sep 28, 2009
how to change the cell colour due to a sum increase or decrease? For example: if the amount is greater than 200, change cell colour to green. If under 200 change cell colour to yellow.
View 2 Replies
View Related
Nov 5, 2013
I would like to change a number to a letter and then drop a digit from the end.
Say my data in A1 reads 81234568, and I would like it to display in cell A2 as h123456.
View 3 Replies
View Related
Feb 18, 2007
formula to put in microsoft excel 2003 to increase a number by 10%, so for example, 20 by 10%.
View 10 Replies
View Related
Nov 18, 2008
what i need is a macro to run when I print a form. I am making a job card with a unique number on it ie: 100. when I print the form, I then need the 100 to change to 101 and so on. I cant work this one out.
EDIT - Ive attached my work in progress. It is for a computer repair shop. I have a few macros in there as I need to email a copy of the workbook too.
when you open the workbook, you will see the job number in red. I just need a macro tht will increase that number +1 every time it runs. I also need the email macro to rename the workbook to the customer name input in cell B4 - but I think im best to post this request in a new thread?
View 3 Replies
View Related
Sep 28, 2013
I have data to find standard deviation from a1:a5
So use a formulae to do the same.
I want to increase range automatically when i put a number in a6 and so on.
View 1 Replies
View Related
Dec 7, 2007
in cell A1 I have a ref no. eg aa/01/bb
in cell A2 I have a ref no. eg aa/02/bb
only the middle number increases in the reference each time eg: /01/
is there a formula that can achieve this or am i doomed to manual input, I have made a few attempts but cannot work it out.
View 9 Replies
View Related
Jun 12, 2013
writing a formula for the situation below,
In column "A1" i have the formula =C8. I now need to copy this formula across to column "B1" to get =C9 and also copy it across to column "C1" to read =C10.
So the row number should be increasing by 1 and the column remanin constant.
View 3 Replies
View Related
Aug 6, 2009
I need to be able to select a certain number (from, say, 1-20) from a drop down menu, which will decide a number of rows (filled with data) on the next sheet. As I prefer not to give anyone the sheet I'm actually working on I made a quick look-a-like which might explain this better.
A and B are different scenarios, with different values in the fake drop-down menu I made. Just to pass on the understanding of what I want the values to do. If putting a drop-down menu there is troublesome, then I can live without them. But entering a certain value in the field and getting that number of rows for a certain product is what I need. I tried searching for a function/macro to use for this, but I dont know what exactly to look for. Name, etc
View 4 Replies
View Related
Mar 15, 2005
I created an receipt template in excel. How can I have it increase the receipt invoice number by 1 every time I open this template? For example the first receipt is 100, I want the second receipt to be 101, and so on.
View 4 Replies
View Related
Jul 31, 2006
How can i format my excel spreadsheet cell so that a number
10,000,000
displays as
10
View 4 Replies
View Related
Dec 6, 2006
I am trying to write a program that needs to select a different cell everytime it is ran. For example, this month when it runs I need it to select cell BL137. Next time it is ran it will need to select cell BL138. Month after BL139. The cell it selects will always be in the same column (column BL) and the cell number always increases by the same amount (1).
View 6 Replies
View Related
Jun 9, 2014
I have set the check boxes for each line. I would like to have the today date to appear after clicking the check box on the next right cell. Do I have to use IF for this one?
ALSO I want the number to count up after click the check box. For example:
Name:
Bob (assigned)- 5
(completed)- 4
Every number of completed line increases every time each box is clicked. How can I do that?
View 2 Replies
View Related
Apr 28, 2012
I have a macro that increase a cell number and one that decreases a cell number, heres my code:
Code:
Sub Macro1()
Dim t
t = Split(Worksheets("Sheet1").Range("d5").Text, "/")
t(0) = Format(t(0) + 1, "0")
Worksheets("Sheet1").Range("d5") = Join(t, "/")
[Code] .......
So they do exactly what i want them to do but i want to put a limitation on them, so say the number in the cell is 0 then i dont want it to be able to subtract from it anymore, and say the number is 20 i dont want it to be able to add any more, i tried to put if statments into the code but no luck.
View 3 Replies
View Related
Aug 12, 2008
I have multiple worksheets (too many, actually!) and each worksheet is a record. I need to enter a Record Number into B5 of each sheet. The Record Number doesn't start at 1. I'd like to enter a number into the first sheet and the rest of the sheets to increase by 1. However, I only need to do this to some sheets.
View 9 Replies
View Related
Nov 2, 2006
I have a test due in the morning, and I really need this question answered ASAP, if anyone could. I need to create an IF formula for this situation: the standard Mhz is 500. Give 55.00 for that standard. But for every increase of of Mhz, give 25.00 per 100 increase.
View 2 Replies
View Related
Dec 22, 2012
Can you increase the number of fields shown in the list so that you don't have to scroll through the entire list?
View 2 Replies
View Related
Apr 21, 2009
Is there any keyboard shortcut to increase or decrease the number of decimals shown directly (I mean without having to use ctrl + 1... etc )
View 7 Replies
View Related
Jun 20, 2014
I am trying to create a spreadsheet that will automatically increase the work order number by 1. The cell will always be in the same place. The idea is that when the file is opened it populates the number. After being closed and reopened the number will be 1 higher than the previous.
The page will reused by various people to create and print work requests for my mechanics, I want it to assign the W/O automatically.
View 11 Replies
View Related
Jun 17, 2014
I need an OFFSET function to start off by moving down 1 row from the starting point and then on the next run through the loop, to move down 2 rows, then 3 rows, etc.
Code:
Workbooks(Thisname).Worksheets("Run Set Up").Range("Duration").Offset(1, 0).Value = Workbooks(Filename2).Worksheets("Front Page").Range("T20").Value
This is what I'm working with. At the moment, I have the value for the number of rows to move set to 1 because I can't figure out how I'd accomplsih what I need.
View 1 Replies
View Related
Nov 22, 2013
Can the data in chart change itself to be percentages & number ie, axis changing the format itself. i am trying to present a dynamic chart and trying to show both sales and % sales in same column chart (based on a drop down option).
View 1 Replies
View Related
Jun 3, 2014
I have declared a 'long' variable. however; how do I change the variable data type to string if user input is not a number? how do I recognize the user input's datatype?
View 7 Replies
View Related
Oct 24, 2013
I'm trying to track how complete a project is by checking if cells contain data, and if they do the percent in cell 'Y4' would increase.
I have 6 cells which represent milestones and if they contain data then they would add a certain percent to cell 'Y4'.
Cells B13 & R13 would have a weight of 15% each
Cells J13, J21 & J30 Would have a weight of 20%
Cell L34 would have a weight of 10%
Is there any way that if these cells contained any data that I could add that percent to the total in 'Y4'?
View 2 Replies
View Related
Sep 17, 2007
I having been looking at ways of increasing the width of a data validation list (drop-down) to accommodate items longer than the width of the target column. I found a solution here http://puremis.net/excel/code/068.shtml
The demonstration seems to do exactly what I require. However the code supplied does not work for some reason. I have run the code in debug to see what it is doing and the code runs until it gets to the line
Set objDic = CreateObject("Scripting.Dictionary")
from here it just jumps to the end of the procedure. Mousing over objDic says ObjDic = Nothing.
I am getting a bit out of my depth here - anyone know why objDic is not being assigned a value and the procedure bombing out from here.
View 6 Replies
View Related
Feb 19, 2014
I have a situation that I cannot get my hands on. I have a set of Project Numbers in my Column A. (Will Try to post an example).
I need that everytime I change a number in my Column B that it will change all the numbers, in my column B, based on the matching Text in my Column A.
Demo1.xlsm
View 14 Replies
View Related
Nov 3, 2008
How increase Sheets number+1 for all Sheets with Vba?
View 10 Replies
View Related
May 14, 2008
I know the basics of excell, but haven't ever written any formulas or macros (if that's what I need?) that would perform the following opperations. Bare with me, it's a three step process.
1. I need any zero's to the right of the last number (1-9)
to be removed. (I think this can be done with the click of a button, somewhere?)
examples:
a. 173.17300 = 173.173
b. 231.11000 = 231.11
c. 53.00000 = 53.
2. I also need for the decimal to be moved to the right of the last number after the zeroes have been removed from the previous step. (This seems to be the most deficult step, but most important for me.)
examples:
a. 173.173 = 173173
b. 231.11 = 23111
c. 53. = 53
3. I then need to be able to cross reference those remaining numbers with a set of numbers I have.
examples:
Remaining Numbers / My List
a. 173173 / Not on list
b. 23111 / MATCH
c. 53 / Not on list
View 7 Replies
View Related
