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
Bookmarks