VBA with sum and vlook up

Sheet 1

A1 has a name (Bob)
A2 has a value (10)

Button 1


Sheet 2

John 0
Dave 0
Ben 0
Bob 0

I need it so when someone clicks button 1 its added the value of cell a2 in sheet 1 to the next collum to the right of the name in collum a1 in sheet 1.

example if they clicked now sheet 2 would then look liek this:-

John 0
Dave 0
Ben 0
Bob 10

clicked it again BOB would go to 20 and so on

I got to this but now getting an error:-

Private Sub CommandButton1_Click()

Please Login or Register  to view this content.

End Sub

Please do use code tags as required by our rules http://www.excelforum.com/forum-rule...rum-rules.html it really makes easier to read code.

As for the problem - vlookup returns value, while you need the reference to cell to manipulate it's contents

if your data layout is name in sheet2, cell E11, time in sheet2 cell G8 and names in Time column A (starting row 2) and total times in Time column B something like this could work - again calling for the rules - the sample workbook would make answering easier (especially that you described your layout as sheet1 and sheet2, and A1, A2 ... etc).

Please Login or Register  to view this content.

PS. before answering - Do please edit your post and use code tags.

Hi,

The way I'd approach this is to use a formula in say B1 on sheet1 which records the row number on sheet 2 that contains the name in A1. i.e.

Formula:

Please Login or Register  to view this content.

name this cell say "Row"

Now the macro attached to your button would be.

Please Login or Register  to view this content.

As we are probably talking about different layouts - attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

So it's exactly as I wrote - the only difference is in sheet names

Please Login or Register  to view this content.

see attachment

you are welcome. would be nice if you mark therad as solved.