macro: The number next to name increases by one

**dundukas** · 01-07-2013, 06:56 PM

Hello,

i'm trying to write a macro but i can't find function which could help me.

Everything should look like this:

I have two sheets:

In Sheet1 when i enter the name in A1 and press the commandbutton next to it

macro should find that name in sheet2 on column A and increase the number next to it on column B in the same row by one.

I'd be very grateful if someone could help me ;/ sorry for bad english :/

**protonLeah** · 01-07-2013, 08:15 PM

Attach a sample workbook.

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic

**Jakobshavn** · 01-07-2013, 08:15 PM

Try this.....................

**dundukas** · 01-08-2013, 12:46 PM

Thanks a lot !!

I have another question :

How to protect sheet1 in my VBAexpl.xlsm document? Do i need to rewrite that macro command which finds random text from sheet2 ?

Thanks for a help

VBAexpl.xlsm

**Jakobshavn** · 01-08-2013, 01:01 PM

Do you want to protect Sheet1 from User actions or from macro actions?

**dundukas** · 01-08-2013, 01:02 PM

User actions

**Jakobshavn** · 01-08-2013, 01:13 PM

Here is a typical method

**dundukas** · 01-08-2013, 02:08 PM

Thanks again !!

But how should look like macro command which do not show that "random" formula when I select on Cell B3 .

Sorry for bad english. I hope you understand what I wanted to say :/