Bolzenschweisstechnik

Bolzenschweißtechnik seit 1970. Geräte und Schweißbolzen direkt vom Hersteller. Hohe Qualität Made in Germany

Eintrag vom: 11.04.2013.

Hello all I?m in need of a macro or VB that will help my customer service auto increase a record number by one each time they open or copy a new worksheet. Example: In cell A1 is a numeric entry of 81115. When they copy or create a new worksheet the number in cell A1 needs to auto adjust to...

 

In sheet 2 I reference values in Sheet 1 and when I drag down the formula it performs as expected. Row 1 =Sheet1!A1 Row 2 =Sheet1!A2 Row 3 =Sheet1!A3 Row 4 =Sheet1!A4 Row 5 =Sheet1!A5 Row 6 =Sheet1!A6 When I drag the formula down I want it to increment by different values maybe 2 5 7 50. In this case I need it to increment by 12.

 

I would like to define a keyboard shortcut (Alt+1 or something) that will add 1 to whatever value is in the selected cell. If the cell contains 23 the shortcut will increase it to 24.

 

I am trying to create an automatic increment. the Formula I tried is =IF(OR(L2="P" L2="T") G2+1 G2) I had it working but it was requiring me to have the values in 2 places to function and the source remained the same so it would not increment but once. If someone could give me the correct...

 

Here's my issue. I have a main column that will have duplicate values (List). I want to count the key value and as I work my way down the list and at the same time I want to increment the last value by +1 each time. I've created separate columns for each value to capture. They value will be at...