Basically, I have two excel sheets. What I am trying to do is to copy specific cell value from current cell to another. Let say, I have a form sheet of cash deposits:
Cash deposits form info:
1.PNG
and then, I need to copy and paste some of the data needed to another form.
This is the form where I want to paste the cell value from cash deposits:
2.PNG
Any idea on how to automate this? I have a tons of cash deposits and I want to automate this task. thank you.
Hello jreloz,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
You can use VBA. Q: is the cash form the same? Does it change from one cash form to another? Can you post a sample in this tread along with what exactly needs to be posted in the spreadsheet?
Hello jreloz and Welcome to Excel Forum.
Answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks