Hello All,

I've got a very annoying problem, hope you can help me. I'm starting to become desperate.......

I created a supply demand excel file which will calculate my stocks (stock yesterday - demand + supply = stock today)

It looks like this:

date supply demand stock replenishment advise
1/1/05 500 300 1000
1/2/05 0 250 750 350
1/3/05 500 0 1250 150

Replenishment of the stock is based upon minimum stock requirements as set by the user and the file will advise the user on the quantities to be replenished.

I want the user to give the opportunity to follow or ignore the replenishment advise. In case he wants to follow the advise, the user should push a button which fires a macro that copies the quantity to a second sheet. This sheet will be input for the production planning.

Now my problem is that I need a macro to 'freeze' the advised quantity and copy it to the next sheet. As the macro consist of a line per date I need the same macro for each line (=day). The sheet consists of 365 lines. For each line I basically need the same macro except that, in order to run the macro correctly, it should run from the cell where the button is positioned. And that's my problem...

How can I get the cursor to move to the cell where the button is? Obviously I want to be able to copy the buttons and macro's to all the lines of the sheet so some kind of relative reference needs to be made. I tried using 'goto' and also tried to record the macro 'relative'but it doesn't seem to work......

Please help me.....!

thanks
Remco