Hi, I am looking for a macro code that will transfer data from different sheets to a main "database" sheet in the same workbook when you click a single button called "save/update database".
Also every time the Save Button is pressed it must load the new data on a new line below the previous amounts saved in the database.
Example sheet is attached
Your help would really be appreciated!
Thanx
Last edited by Rudidw; 03-20-2015 at 02:56 AM.
I am easily able to find code to transfer data from one sheet to another sheet but I have no vba skills to solve my original problem.
Rudidw
Hello. I am a newbie and I was trying to solve a similar problem. You might like to read this thread:
http://www.excelforum.com/excel-prog...se-system.html
It helped me get some ideas on how to transfer the data from one worksheet to a database worksheet.
Good luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks