I need a macro that will auto paste data from a sheet named "make payment" row 1 and then paste the data in a sheet named "general ledger" available empty row and clear the data in make payment sheet. And when data is entered again in make payment sheet it will now go to the next available row in general ledger and on and on
Do you want to enter all the data and then click a button to trigger the transfer or do you want to have the data transferred each time a row is filled? If your answer is the 2nd option, then which is the column which will identify that the row is filled?
Also, should all rows be transferred or only if they meet a particular condition?
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]
Thank you Arlu1201,
I want all data entered before is triggered.
Should all rows be transferred or only if they meet a particular condition?
Dear Arlu1201,
Thank you for assisting.
Data should be transferred as soon as I finish entering data in a row.
Best Regards,
Daotor
Give a try to this.
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Dear Fotis1991,
I am humbled by this gesture I must confess that I have missed a lot, thank you for your swift response. I appreciate you and every one on this platform. I got your reply and it worked perfectly. I look forward to receiving more help.
Kindest Regards,
Daotor
You are welcome and thanks for the feed back.
As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Dear Fotis1991,
Thank you, I think I have done that.
Best Regards,
Daotor.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks