How to create a command button to transfer CALCULATED data to another worksheet
I need help creating a template that I will use to import data that will be summarized and calculated for certain percentages.
What I need help on is creating a COMMAND BUTTON that when pressed will transfer the data in the next line on worksheet 1.
So this is the process.
- I copy and paste (import) the data to worksheet 3.
- Using defined names for ranges in worksheet 3, calculations such as total number of data (rows), percentage etc will be calculated in worksheet 2
- THE COMMAND BUTTON WILL BE ON WORKSHEET 2 that will transfer the result to the next row on worksheet one.
The point is, the data being pasted on worksheet 3 will constantly change every month but I want to keep a track of month to month change on worksheet 1.
I hope I explained myself well.
I've attached the test template
Thanks for the help
Last edited by LTY9; 04-06-2011 at 06:03 PM.
Re: How to create a command button to transfer CALCULATED data to another worksheet
The Contacts form example has code that you can adapt
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1