incrementing

Hi there, I have this string in A1: Player 1 and I'd like to setup excel so no matter what I typed I A1, that all the other predetermined cells auto increment by 1. For example: If I typed "Player 1" in cell A1, then cells A2 through A40 would change to "Player 2", "Player 3", etc. Hope...

I have random text fields, but always in similar formats: Gi2/0/1 Gi33/2/55 Gi17/17/4 What I need to be able to do is (with a formula, not a macro) increment the last digit(s) up to a maximum of 99 So the next cell after Gi2/0/1 would be Gi2/0/2 Gi2/0/3 up to .../99, and the same for the...

Hi all, Context: 1. M3 is a a variable number >0 2. The rest of columns M as well as columns N and A;J are IRRELEVANT. Objectives: 1. I'd like to clear the columns K4 to L(Value of M3 + 2); 2. Increment the values 1 by 1 in column K. Starting with K3=0, K4=1, K5=2, ... , K(Value of M3+2)=Value...

Please help! I have been teaching myself excel to help out my school with a more efficient grade entering system. I am creating a workbook that has all the students marks entered in rows on the first sheet called Marks!, analysis of grades for the entire class on the second sheet called...

Hi, please do correct if violate some rules. I have a workbook that needs to be saved everytime there is a new name that is selected and if ever that the same name will be save the file name will increment. The filename I choose is the value of cells. Name - Date - Line of business. so for eg...

Hi. I have starting and ending dates as follows: Cell A1 is 11/09 Cell A2 is 15/09 Cell A3 I have =TEXT(A1, "dd/mm")&" - "&TEXT(A2, "dd/mm") This returns a result of 11/09 - 15/09 in Cell A3 In Cell B3 I want to increment the dates shown in Cell A3 by 7 days without the need of incrementing...

I am creating a spreadsheet that references another spreadsheet of mine and I am trying to find out how to reference every 16th cell in a column to every row in another column. I have a form on one sheet where users can enter all of their information and I want to create a separate overview...

I have created a class to record the properties of a foreign currency trade (date, amount, buy/sell, rate, currency. A new instance must be created for each unique rate. I have figured out the if thens to establish when to create a new instance but I have been unable to figure out how to create...

Ok, I am trying to figure out how to increment a R1C1 reference. I am running this code through a loop so I have to move columns for each loop. Here is an example of my attempted code Dim ProductCol As Integer ProductCol = 1 ActiveCell.FormulaR1C1 = "=Original!R[ProductCol]C &...