Update macro

[MrZaibot]

Hello!
I have a workbook with two sheets. Sheet1 contains a article database with over 10000 rows. Sheet2 contains a utdate function.
Example:
Sheet1

Please Login or Register  to view this content.

Sheet2

Please Login or Register  to view this content.

I want a button with a macro on sheet2 to update posts, in this example article 1004 add 2 units and 1002 remove 2 units. I need to update 2-5 articles at the same time and scrolling or searching takes to long time.

Can anyone help me?

Thanks!

[rwgrietveld]

I've taken the easy route and defined 4 ranges. This made the code easy. If you define dynamic ranges than it will be even easier.

Please Login or Register  to view this content.