running number in a cell every time click 'keep' button.

**sand takagi** · 10-28-2012, 10:09 PM

i make first sheet as a receipt. the function is to copy details of payment into any other selected sheet (48 sheet).
i would like to have a running number in sheet1,b12 and will be updated into new number everytime i click
"simpan"(keep) button.

also i need to begin the number as the number on current actual bill book. for instant, i need to begin with 6500

i attached a sample to explain the situation.

thank you.

**taps** · 10-29-2012, 05:20 AM

Hi,

Assign below macro with SIMPAN.

Please Login or Register  to view this content.

regards
taps

**sand takagi** · 11-03-2012, 04:15 AM

its not working

**sand takagi** · 11-03-2012, 04:33 AM

pls help me make a running number in b12 after clicking the "simpan" button. the function of the 'simpan' button is to to update the screen. and automatically copy things written in the form into selected sheet. the details would be copied into selected sheet which is by selecting the sheet name in sheet1,c10.

i also attached the sample of my work. its already coded.
pls lend me a time to at the workbook.

**taps** · 11-05-2012, 07:51 AM

Hi,

You want to copy data from "RENAME" sheet to Sheet "ADF 1282" (if cell C10 is "ADF 1282") and so on...
Please tell me the range needs to be coppied and the target cell in "ADF 1282" sheet where it is needed to be paste.

Regards
taps