automatically copy character writen from sheet1 into any particular sheet.

[sand takagi]

i made 48 sheets in a workbook. all i need to do is, i would like to copy what did i do in the sheet1 in particular cell into a specific chosen sheet.
i.e, in sheet1 i cell B12 im gonna write "INSTALLMENT" and an amount in H12 for example 200. adnan project1.JPG
what i want is the word and the amount would be automatically copied into particular sheet i.e sheet9.

[arlu1201]

Do you want the data to be copied as soon as the amount is entered in H12?

Will data be entered in B13 and H13 too and data copied again? Where in sheet9 should the data be copied?

Why attach a jpg when you can attach a sample file?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[sand takagi]

dear Arlette,

thanks for your quick response.
i think its to complicated to xplain. im almost giving up on this work. if it possible u can see my desktop (share screen) then it would be easy for u to understand. i dont know what to do.
i would be so great-full if u can lend me your time if that is possible.

[arlu1201]

What you can do is create a sample which looks exactly like your original file. Just remove the sensitive data and upload it. Then i can try and understand the issue.

[sand takagi]

thanks for the fantastic effort. here is the sample of my work. i know it kind of to much but there is nothing i do rather then asking for help from
the other. thank you.

[dwint]

write down this code in sheet1 with event is worksheet change

Please Login or Register  to view this content.

and write down this code in VBE module

Please Login or Register  to view this content.

please see attached file

bangga menjadi orang Indonesia

[sand takagi]

hi dwint,

fantastic job. u are really helps me. its working as i want.
however when i copied the code into the new vba it come out with the error (in my actual workbook). when i klik "simpan" button
it come into error. plus the sample that i attached is just a part of the work.
if u dont mind, im asking your 'budi pekerti' to look up on my actual work. and pls help me solve this work.
pls look up into my work as i attached in this reply.

terima kasih kerana sudi menghulur bantuan.
saya banga jadi rumpun melayu

[dwint]

see attached file
hope this is what you want

i dont make any change with the code which you've been written

[sand takagi]

dwint,

what the heck. awesome!! exactly what i to be. many thanks to u. im glad came into this forum, coz there are lots of people provide their
specialist to the other. many thanks.

[sand takagi]

dwint,

there is one more thing. after trying the new system that u gave me,
i found there are few adjustment should be done.

im sorry cos didnt explaint it very well. im to excited coz it almost done and working as i want.
pls, lend me more time re edit my work. im attached the new adjustment that i want to be.

pls use the actual file as i posted in the previous post. the attached excel in this post is only the description for the thing to be change. many thanks.

sorry coz it seems asking for too much.

[sand takagi]

dwint,

regards my last post,

about the words in cell c12, i understand that u put an automatic recording to the date, however, some of the customer make a late payment,
therefore, the purpose of the installment is not specifically to the prior date. it could be installment from the last month or last two months from current receipt date. thus, it cant be link to c12.

im appreciate your effort, it show that u are great programmer. coz u understand

[dwint]

in module3, procedure Simpan
change this code

Please Login or Register  to view this content.

with this one

Please Login or Register  to view this content.

drop down is better than using input box to select sheeets name, when you have mistype sheets name then it will come out with error
i have made dynamic drop down for you, every time you add or delete your worksheet it will automatic have changed in drop down list