1. K

    help with customer AutoNumber

    I need help with how to setup a custom AutoNumber in Access. I want to be able to enter a starting number with up to eight digits and then have it increment by one. So, for example I want my starting number to be 30064889 and increment from there. Is this possible?
  2. D

    Increment value of cell if another cell changes value

    Hello, Is there a way in Macros or VBA to increment the value of a cell by 1 if another cell changes value? Ill give the example: In cells A1 to A56 I have links to another workbook that update every few seconds. I would like to count in Column B -- B1 to B56 -- The changes from each cell...
  3. O

    Auto increment two cells with userform

    I am trying to figure out to have two cells increment after creating a record with my user form. My form is simple where I have a button that will create a row every time it is clicked. After clicking the close button the data will sort from highest to lowest trace number. Lets say for example...
  4. D

    how to increment numbers in a range and ignore blanks

    hello, i am trying to increment the cells that hold a numerical value within a range whilst ignoring blank cells. i am using the code below, but it has no affect: Set cellrange = Range("M8:M44").Cells.SpecialCells(xlCellTypeConstants) For Each cell In cellrange cell.Value =...
  5. S

    Increment alphanumeric string by 1 for each cell in Excel issue.

    Lads, i have formula in cell A2: ''=LEFT(A1,4)&RIGHT(A1,4)+1'' that increments next cell by 1. Problem is when number go over 1000 it looks like this: HMR01000, but I need it to be HMR1000 , HMR1001 etc. <tbody> A 1 HMR0500 2 HMR0501 </tbody> Thanks.
  6. O

    Automatically insert an incrementing number, but allow manual override

    If possible, I'd like to have Excel insert a number that increments by one in the first column of every new row in a given table like so: GID FN LN 800 John Smith 801 Jill Rogers 802 Sam Spade 803 Sally Spade 804 Bill Bayes but that will also allow for manual...
  7. K

    How to increment data using two sheets in excel

    I have two sheets: sheet 1 contains a list of orders in ascending order. Sheet 2 is supposed to extract the last order number in sheet 1 and increment it by one. This is what I have come up with: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit...
  8. L

    duplicate an x amount of rows but with each duplication increment by 1 all the numerical values within the row

    Hi, I have the following problem and not sure how to go about doing this. I have the axample below" <colgroup><col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:3730;width:77pt" width="102"> </colgroup><tbody>...
  9. L

    Incrementing year by 1 if week number is 27 but only triggering once a year VBA

    Hi, I just can't get me head around what is probably an easy solution. The code below is a date inputter into a sheet that on workbook open but only triggers if it's a new day. It inputs the current season, year, week number and day. What I need is for when the week number gets to 27, the year...
  10. J

    Do While & Number Advancing

    MrExcel forums to the rescue again - furthermore, I always give full credit back to the forums when folks ask "how did you figure that out!?" Cell B1 contains a number, we'll say "25"; I would like to increment the number in cell A1, beginning at "1" until it reaches the equivalent of B1 then...
  11. K

    Leading Zeroes in a List

    Hi All, I am trying to create a list of numbers in one column. My list needs to have two leading zeroes. The problem is that once the list hits 10, it takes away one leading zero. For example, excel does this:001 004 ... 009 010 011 ... 099 100 101 I would like the list to increment...
  12. T

    Increment through range with VBA

    Hi, The code below is supposed to iterate through a range, so x starting from row 16 through to 25 and y to control the column increment from 5 to 13, i.e. E to M. The line highlighted in red is incorrect, can someone advise how this should be written or a different approach please? For...
  13. N

    Increment Number in a column every time a cell changes color

    If I have a column where some cells are blue and some are white, I want to start at 1 and increment by 1 only when the color changes in the cell below it. If a cell changes colors again, I would like to increment by 1 again all the way to the bottom of the column. Could someone point me in the...
  14. U

    Increment Form and Revision Number with Hyphen in Between

    Hello, I am looking at many examples online on how to auto increment Invoice / Form number but they aren't specific to what I need to do. The format to number my forms is (Change Order #) - (Revision #). Example, If I were on the fourth revision of change order three, it would be 3-4. I need to...
  15. U

    Increment Form and Revision Number with Hyphen in Between.

    Hello, I am looking at many examples online on how to auto increment Invoice / Form number but they aren't specific to what I need to do. The format to number my forms is (Change Order #) - (Revision #). Example, If I were on the fourth revision of change order three, it would be 3-4. I need to...
  16. A

    Multiple conditions to look at

    Hi all I have 4 columns of data in column A I have some random values and mostly blanks. in column B I have a calculation which looks at column A and if a value appears there it discards the values above it and takes the new value from column A. In column C I have a formula =...
  17. B

    Help in correcting excel formula

    Can anyone help me correct the following formula: =IF(C2>100,IF(T2="Change of Ropa",ROUNDUP(VLOOKUP(DATE(2006,1,1),$Q$2:$R$28,2,0)*1.86,-1)+G2),IF(C2>100,IF(OR(T2={"Superannuation","Appointment","Annual Increment","Enhancement of Qualification","10 Years' Benefit","18 Years' Benefit","20 Years'...
  18. S

    Salary statement - Help with salary increase

    Salary increments will be given once in a year at random times as fixed amount. Increments are given randomly, so if 5000 rs increment is given this month, it should be added to allowances (increases to 14500), so it increases gross salary to 40,000, but next month there won't be any...
  19. S

    VBA- Rounding a static value to closest increment of a Loop/Array created from another static value

    <tbody> INCREMENT STATIC 1 STATIC 2 VALUE .25 100 100.35 .45 200 201.55 .65 300 302.75 </tbody> I'm struggling to figure out in VBA the most efficient way to create a loop/array within the value in the STATIC 1 column using the increment in same row, and then rounding the STATIC 2...
  20. Y

    Excel vba increment cell and sheet selection

    I do run this VBA code Sub sbCopyRangeToAnotherSheet() Sheets("Sheet1").Range("B1:I1").Copy Destination:=Sheets("Sheet2").Range("D39:K39") Sheets("Sheet1").Range("B2:I2").Copy Destination:=Sheets("Sheet3").Range("D39:K39") End Sub i.e. changing the range "B1:I1" and sheet "Sheet2"...

Some videos you may like

This Week's Hot Topics