update used rows

P

pwill

Active Member
Joined
Nov 22, 2015
Messages
406
Hi, can anyone help with a macro?

I have Data on sheet1 - AJ2 has the row Ref and AK2:AQ for the Data and column AS to add 1 for every row used.
I have two buttons on sheet2 I want to use as a Plus and Minus (E1 as Minus and F1 as Plus)
I want to click the Plus button to add 1 to next row in column AS(sheet1) and use the Minus button to remove 1 from the last row used in column AS and have the Ref from Column AJ(sheet1) show in D1(sheet2) for the row in use on sheet1

ie if the Plus button is clicked on sheet2 - then 1 would be added to AS5 and the Ref from Column AJ would show 4 in D1(sheet2) and if the Minus button is clicked - then 1 would be removed from AS4 and the Ref from Column AJ would show 2 in D1(sheet2)

Sheet1


<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:1353;width:28pt" width="37"> <col style="mso-width-source:userset;mso-width-alt:768; width:16pt" width="21" span="7"> <col style="mso-width-source:userset;mso-width-alt:1170;width:24pt" width="32"> <col style="mso-width-source:userset;mso-width-alt:1353;width:28pt" width="37"> <col style="width:48pt" width="64"> </colgroup><tbody>
[TD="class: xl65, width: 64, align: center"]
[/TD]
[TD="class: xl64, width: 37, align: center"] AJ [/TD]
[TD="class: xl63, width: 21, align: center"] AK [/TD]
[TD="class: xl63, width: 21, align: center"] AL [/TD]
[TD="class: xl63, width: 21, align: center"] AM [/TD]
[TD="class: xl63, width: 21, align: center"] AN [/TD]
[TD="class: xl63, width: 21, align: center"] AO [/TD]
[TD="class: xl63, width: 21, align: center"] AP [/TD]
[TD="class: xl63, width: 21, align: center"] AQ [/TD]
[TD="class: xl63, width: 32, align: center"] AR [/TD]
[TD="class: xl64, width: 37, align: center"] AS [/TD]
[TD="class: xl63, width: 64, align: center"] AT [/TD]

[TD="class: xl65, align: center"] 1 [/TD]
[TD="class: xl63, align: center"] ref [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"] Data [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"] Used [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 2 [/TD]
[TD="class: xl64, align: center"] 1 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"] 1 [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 3 [/TD]
[TD="class: xl64, align: center"] 2 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"] 1 [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 4 [/TD]
[TD="class: xl64, align: center"] 3 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"] 1 [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 5 [/TD]
[TD="class: xl64, align: center"] 4 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 6 [/TD]
[TD="class: xl64, align: center"] 5 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 7 [/TD]
[TD="class: xl64, align: center"] 6 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 8 [/TD]
[TD="class: xl64, align: center"] 7 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 9 [/TD]
[TD="class: xl64, align: center"] 8 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 10 [/TD]
[TD="class: xl64, align: center"] 9 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 11 [/TD]
[TD="class: xl64, align: center"] 10 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 12 [/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

</tbody>


Sheet2 D1 is showing 3 as the Ref for the row in use in the above example


<colgroup><col style="width:48pt" width="64" span="6"> </colgroup><tbody>
[TD="width: 64, align: center"]
[/TD]
[TD="width: 64, align: center"] D
[/TD]
[TD="width: 64, align: center"] E [/TD]
[TD="width: 64, align: center"] F [/TD]
[TD="width: 64, align: center"] G [/TD]
[TD="width: 64, align: center"] H [/TD]

[TD="align: center"] 1 [/TD]
[TD="align: center"] 3 [/TD]
[TD="class: xl65, align: center"] - button [/TD]
[TD="class: xl65, align: center"] + button [/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]

[TD="align: center"] 2 [/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]

[TD="align: center"] 3 [/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]

</tbody>

Any help would be appreciated

Regards
pwill
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
I am a little confused.
For your Sheet 1, is the first column meant to be the row numbers that Excel has in the border?
Are the words "ref" "Data" and "Used" also appearing on your sheet?

As an example of my confusion "in D1(sheet2) for the row in use on sheet1", what is row? Is the Excel row or the row in Column AJ?

Another few questions.
Are we always discussing the very last value in AS? So pressing the buttons toggles add 1 to the last cell in AS, ie two "+" presses adds two consecutive "1s" down the column?
Can AS have a value greater than 1?
 
Upvote 0
Hi BrianJN1, thanks for your reply, sorry for the confusion.
the row number is from the Ref column not the excel border, the word Ref is in AJ1, the word data is centered across AJ1:AQ1 and the word used is in AS1,
Yes we are discussing the very last value in Column AS and adds 1 to the last empty cell in AS and two '+' presses would add two consecutive 1's down the column and vise versa if pressing the '-'button.

Hope that helps

Regards
pwill
 
Last edited:
Upvote 0
Sheet1


<tbody>
[TD="class: xl65, align: center"]
[/TD]
[TD="class: xl64, width: 37, align: center"] AJ [/TD]
[TD="class: xl63, width: 21, align: center"] AK [/TD]
[TD="class: xl63, width: 21, align: center"] AL [/TD]
[TD="class: xl63, width: 21, align: center"] AM [/TD]
[TD="class: xl63, width: 21, align: center"] AN [/TD]
[TD="class: xl63, width: 21, align: center"] AO [/TD]
[TD="class: xl63, width: 21, align: center"] AP [/TD]
[TD="class: xl63, width: 21, align: center"] AQ [/TD]
[TD="class: xl63, width: 32, align: center"] AR [/TD]
[TD="class: xl64, width: 37, align: center"] AS [/TD]
[TD="class: xl63, width: 64, align: center"] AT [/TD]

[TD="class: xl65, align: center"] 1 [/TD]
[TD="class: xl63, align: center"] ref [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"] Data [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"] Used [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 2 [/TD]
[TD="class: xl64, align: center"] 1 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"] 1 [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 3 [/TD]
[TD="class: xl64, align: center"] 2 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"] 1 [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 4 [/TD]
[TD="class: xl64, align: center"] 3 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"] 1 [/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 5 [/TD]
[TD="class: xl64, align: center"] 4 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 6 [/TD]
[TD="class: xl64, align: center"] 5 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 7 [/TD]
[TD="class: xl64, align: center"] 6 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 8 [/TD]
[TD="class: xl64, align: center"] 7 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 9 [/TD]
[TD="class: xl64, align: center"] 8 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 10 [/TD]
[TD="class: xl64, align: center"] 9 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 11 [/TD]
[TD="class: xl64, align: center"] 10 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"] 0 [/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

[TD="class: xl65, align: center"] 12 [/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl63, align: center"]
[/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl65, align: center"]
[/TD]

</tbody>


Sheet2 D1 is showing 3 as the Ref for the row in use in the above example


<tbody>
[TD="align: center"]
[/TD]
[TD="width: 64, align: center"] D [/TD]
[TD="width: 64, align: center"] E [/TD]
[TD="width: 64, align: center"] F [/TD]
[TD="width: 64, align: center"] G [/TD]
[TD="width: 64, align: center"] H [/TD]

[TD="align: center"] 1 [/TD]
[TD="align: center"] 3 [/TD]
[TD="class: xl65, align: center"] - button [/TD]
[TD="class: xl65, align: center"] + button [/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]

[TD="align: center"] 2 [/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]

[TD="align: center"] 3 [/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]

</tbody>
Click to expand...


Hi BrianJN1,
(forgot to say column AS can't have a value greater than 1)

Just thought I would I give a further example to try and make it clearer what I am trying to achieve.

If I now clicked on the '+' button twice at the point showing in the example above, on sheet1 it would show 1 has been added to AS5 and AS6 and the Ref from column AJ would show 5 in D1(sheet2)

Sheet1 after clicking twice on the '+' button

[TABLE="class: cms_table"]
<tbody>[TR]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[TD="class: cms_table_xl64, width: 37, align: center"]AJ[/TD]
[TD="class: cms_table_xl63, width: 21, align: center"]AK[/TD]
[TD="class: cms_table_xl63, width: 21, align: center"]AL[/TD]
[TD="class: cms_table_xl63, width: 21, align: center"]AM[/TD]
[TD="class: cms_table_xl63, width: 21, align: center"]AN[/TD]
[TD="class: cms_table_xl63, width: 21, align: center"]AO[/TD]
[TD="class: cms_table_xl63, width: 21, align: center"]AP[/TD]
[TD="class: cms_table_xl63, width: 21, align: center"]AQ[/TD]
[TD="class: cms_table_xl63, width: 32, align: center"]AR[/TD]
[TD="class: cms_table_xl64, width: 37, align: center"]AS[/TD]
[TD="class: cms_table_xl63, width: 64, align: center"]AT[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]1[/TD]
[TD="class: cms_table_xl63, align: center"]ref[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]Data[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]Used[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]2[/TD]
[TD="class: cms_table_xl64, align: center"]1[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]1[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]3[/TD]
[TD="class: cms_table_xl64, align: center"]2[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]1[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]4[/TD]
[TD="class: cms_table_xl64, align: center"]3[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]1[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]5[/TD]
[TD="class: cms_table_xl64, align: center"]4[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]1
[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]6[/TD]
[TD="class: cms_table_xl64, align: center"]5[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]1
[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]7[/TD]
[TD="class: cms_table_xl64, align: center"]6[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]
[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]8[/TD]
[TD="class: cms_table_xl64, align: center"]7[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]
[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]9[/TD]
[TD="class: cms_table_xl64, align: center"]8[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]
[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]10[/TD]
[TD="class: cms_table_xl64, align: center"]9[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]
[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]11[/TD]
[TD="class: cms_table_xl64, align: center"]10[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]
[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]12[/TD]
[TD="class: cms_table_xl64, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]
[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
</tbody>[/TABLE]

Sheet2

<tbody>
[TD="align: center"]
[/TD]
[TD="width: 64, align: center"] D [/TD]
[TD="width: 64, align: center"] E [/TD]
[TD="width: 64, align: center"] F [/TD]
[TD="width: 64, align: center"] G [/TD]
[TD="width: 64, align: center"] H [/TD]

[TD="align: center"] 1 [/TD]
[TD="align: center"] 5 [/TD]
[TD="class: xl65, align: center"] - button [/TD]
[TD="class: xl65, align: center"] + button [/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]

[TD="align: center"] 2 [/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]

[TD="align: center"] 3 [/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]

</tbody>


going the other way if I had clicked the '-' button twice it would show 1 has been removed from AS4 and AS3 and the Ref from column AJ would show 1 in D1(sheet2)

Sheet1
[TABLE="class: cms_table"]
<tbody>[TR]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[TD="class: cms_table_xl64, width: 37, align: center"]AJ[/TD]
[TD="class: cms_table_xl63, width: 21, align: center"]AK[/TD]
[TD="class: cms_table_xl63, width: 21, align: center"]AL[/TD]
[TD="class: cms_table_xl63, width: 21, align: center"]AM[/TD]
[TD="class: cms_table_xl63, width: 21, align: center"]AN[/TD]
[TD="class: cms_table_xl63, width: 21, align: center"]AO[/TD]
[TD="class: cms_table_xl63, width: 21, align: center"]AP[/TD]
[TD="class: cms_table_xl63, width: 21, align: center"]AQ[/TD]
[TD="class: cms_table_xl63, width: 32, align: center"]AR[/TD]
[TD="class: cms_table_xl64, width: 37, align: center"]AS[/TD]
[TD="class: cms_table_xl63, width: 64, align: center"]AT[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]1[/TD]
[TD="class: cms_table_xl63, align: center"]ref[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]Data[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]Used[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]2[/TD]
[TD="class: cms_table_xl64, align: center"]1[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]1[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]3[/TD]
[TD="class: cms_table_xl64, align: center"]2[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"][/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]4[/TD]
[TD="class: cms_table_xl64, align: center"]3[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"][/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]5[/TD]
[TD="class: cms_table_xl64, align: center"]4[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]
[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]6[/TD]
[TD="class: cms_table_xl64, align: center"]5[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]
[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]7[/TD]
[TD="class: cms_table_xl64, align: center"]6[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]
[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]8[/TD]
[TD="class: cms_table_xl64, align: center"]7[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]
[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]9[/TD]
[TD="class: cms_table_xl64, align: center"]8[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]
[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]10[/TD]
[TD="class: cms_table_xl64, align: center"]9[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]
[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]11[/TD]
[TD="class: cms_table_xl64, align: center"]10[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]0[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]
[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl65, align: center"]12[/TD]
[TD="class: cms_table_xl64, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl63, align: center"]
[/TD]
[TD="class: cms_table_xl64, align: center"]
[/TD]
[TD="class: cms_table_xl65, align: center"]
[/TD]
[/TR]
</tbody>[/TABLE]

Sheet2

<tbody>
[TD="align: center"]
[/TD]
[TD="width: 64, align: center"] D [/TD]
[TD="width: 64, align: center"] E [/TD]
[TD="width: 64, align: center"] F [/TD]
[TD="width: 64, align: center"] G [/TD]
[TD="width: 64, align: center"] H [/TD]

[TD="align: center"] 1 [/TD]
[TD="align: center"] 1 [/TD]
[TD="class: xl65, align: center"] - button [/TD]
[TD="class: xl65, align: center"] + button [/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]

[TD="align: center"] 2 [/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]

[TD="align: center"] 3 [/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]
[/TD]

</tbody>

so basically whenever the buttons are clicked it either adds 1 or takes away 1 in column AS and shows the Ref Number from column AJ in D1

Hope that helps?

Regards
pwill
 
Last edited:
Upvote 0
I think these two macros do the trick.
I've put in a safeguard to the TakeRows to advise when Used has no contents, ie, no row is "Used".
Code: 
Sub [COLOR=#ff0000][B]AddRow[/B][/COLOR]()
Dim lastrow As Long
Sheets("Sheet1").Select
lastrow = Cells(Rows.Count, "AS").End(xlUp).Row
Range("Sheet1!AS" & lastrow + 1).Value = 1
Sheets("Sheet2").Select
Range("Sheet2!D2").Value = Range("Sheet1!AJ" & lastrow + 1).Value
End Sub

Sub [COLOR=#ff0000][B]TakeRow[/B][/COLOR]()
Dim lastrow As Long
Sheets("Sheet1").Select
lastrow = Cells(Rows.Count, "AS").End(xlUp).Row
If lastrow = 2 Then
MsgBox ("All rows unused")
Exit Sub
End If
Range("Sheet1!AS" & lastrow).ClearContents
Sheets("Sheet2").Select
Range("Sheet2!D2").Value = Range("Sheet1!AJ" & lastrow - 1).Value
End Sub
 
Upvote 0
Thanks Brian,

I'm just on my way to work so will give it a try when I get home and let you know how I get on

Regards
pwill
 
Upvote 0
BrianJN1 said:
I think these two macros do the trick.
I've put in a safeguard to the TakeRows to advise when Used has no contents, ie, no row is "Used".
Code: 
Sub [COLOR=#ff0000][B]AddRow[/B][/COLOR]()
Dim lastrow As Long
Sheets("Sheet1").Select
lastrow = Cells(Rows.Count, "AS").End(xlUp).Row
Range("Sheet1!AS" & lastrow + 1).Value = 1
Sheets("Sheet2").Select
Range("Sheet2!D2").Value = Range("Sheet1!AJ" & lastrow + 1).Value
End Sub

Sub [COLOR=#ff0000][B]TakeRow[/B][/COLOR]()
Dim lastrow As Long
Sheets("Sheet1").Select
lastrow = Cells(Rows.Count, "AS").End(xlUp).Row
If lastrow = 2 Then
MsgBox ("All rows unused")
Exit Sub
End If
Range("Sheet1!AS" & lastrow).ClearContents
Sheets("Sheet2").Select
Range("Sheet2!D2").Value = Range("Sheet1!AJ" & lastrow - 1).Value
End Sub
Click to expand...



Thanks BrianJN1,

works great :) much appreciated

Regards
pwill
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Solved
Skip Row When Column Word Meet
2
Replies
14
Views
347
Peter_SSs
Peter_SSs
R
  • Question Question
Lowest value in range of cells excluding this row
2
Replies
10
Views
864
Peter_SSs
Peter_SSs
W
  • Solved
Insert column using VBA
Replies
5
Views
120
Peter_SSs
Peter_SSs
Y
  • Solved
Highlighting selected words in a column.
Replies
6
Views
547
Akuini
Akuini
A
  • Solved
3 way use button to run macro
Replies
2
Views
377
Aleytha
A

Forum statistics

Threads
1,223,787
Messages
6,174,561
Members
452,573
Latest member
Cpiet

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top