increment

Hi folks, I've been solving this so far by doing lots of steps and thought someone might have a better idea. My real application is counting vaccinations that are given in different combinations, but to make this shorter, I'll pretend that the people are students in a painting class that ran for...

I have two sheet in sheet1 i have department and question <colgroup><col style="width:48pt" span="8" width="64"> </colgroup><tbody> A B C D E F G Q1 4 4 4 4 4 4 4 Q2 4 2 3 3 4 4 4 Q3 4 1...

I am looking to increment Column A by one, if the corresponding cell in Column B has text. It gets tricky as shown in the picture attached / linked at row 9 and 10. B9 and B10 have no text, so A9 and A10 are not incremented. The next column with text is B11, so that value in A11 is 9. I...

Hi Excel Gurus, i would like to come up with a formula that will increment a number in order to place it whithin a vlookup. I think the rows formula is the answer but i cant figure it out? I would like to have a formula giving me the following in the third argument of my vlookup in order to...

I have items in a column like below: 50 50 50 50 What I would like to be able to do is highlight the four 50's and fill down, but I would like for it to increment and paste the next four filled like this: 51 51 51 51 Then below that the next four filled like this: 52 52 52 52 If its a...

I am running Access 2010. I think I am pretty adept at coding in Excel, but I am having trouble understanding how to make my Access invoice database that I wrote for my business automatically assign an invoice number and increment by one on every following invoice. I have done a lot of reading...

I am trying to write a loop to update files ther are numbered 1-36 but for consistency the file name always has 2 digits filename06.xlsb filename22.xlsb how do i convert the integer that increments from 1-36 to the two digit string for use in the filename refernece?

Hi all, I have the following code (to copy sheets to a new workbook and save) and I want to change it such that: 1) if the file name C:\abc.xlsx already exists, it will save as C:\abc-v2.xlsx; 2) if both the file name C:\abc.xlsx and C:\abc-v2.xlsx already exist, it will save as abc-v3.xlsx...

I want to drag a formula to create a column, but I need some cell references to change as I drag , and some not to =IF(ISTEXT(A2),VLOOKUP(A2,'ingredients & components'!A2:E100,5,FALSE),""), the red A2 needs to increment , but the range a2:e100 needs to stay the same , I think I need to use $a$2...

Hi, sorry for the code, couldn't make it work with VB HTML Maker. I'm new with VBA :) Basically my idea is when someone open default file, insert data, try to save file, macros save workbook with inserted data as another file (*.xlsx) and make pdf in another folder. Pdf part is working fine...

I have a workbook that until yesterday was just fine. Now all of a sudden all the dates in two columns have changed so that the DAY is incrementing non-stop. That is, I have dates like: 2012.03.45 2012.03.46 2012.03.47 ... 2012.03.820 I've checked the format and it's yyyy.mm.dd as it should...

Hi There, I have a workbook that has a few data sheets and a summary sheet. On this summary sheet I have to grab data from the data sheets which is in the same row number but different column (always 5 to the right of the previous one). Eg: Person's Name is in Row 10, Col E (E10), the next...

hello all, i have researched for a day and can't come up with the right formula so any help will be greatly appreciated. I have data on a spreadsheet listed in rows (name of spreadsheet is Cleared by Returns Data). The information I need is in every 10th cell of the H column. On a different...

Hi all, I currently have an array that is 6 columns by 7 rows that is populated by referencing other workbooks and returning the sum of their values. For issue tracking revison etc... I would like to have the rows incrementally numbered (0,1,2... until it reaches number "X" which is a grand...

Hi, I have a spreadsheet containing parts to name. Numbering works as follows : two letters followed by 4 numbers. The first 3 characters (two letters and first number) of the part name are chosen logically depending on what type of part it is (two letters) and what circuit # it's located on...

If I have a text string such as WDR1034 in cell B6, then the formula =B6 will return the result WDR1034 <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Is there an expression that will return WDR1035 ?? In other words, my original text string...

Hello, I am trying to increment in a macro, for a period set in a for loop. I need the macro to retrieve data from one sheet and paste it in another use solver and past the results in the original sheet. The code that I have so far is as follows: Sub take4() ' ' take4 Macro ' '...

background: I have files that have file names 06-01-11, 06-02-11....ie dates. I am trying to return file names going in date order (part of a larger thing but this is the piece I have having issues with). for now, I am just trying to get a message box to show me the proper file name (one...