See the attached file. (push the button).
Use one sheet to get all the data and after that make a pivot table of it.
You only have to refresh the pivot table.
See the attached file. (push the button).
Use one sheet to get all the data and after that make a pivot table of it.
You only have to refresh the pivot table.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Tnx a lot oeldere. I have just one more question. Since I have to make this in google spreadsheet is there a way to do this without VBA as I believe Google spreadsheet still doesn't have VBA option. Or is there a way to somehow link those two documets so an excel file would pull data from spreadsheet and use its VBA code to do what I need it to do.
Regards
Last edited by macimacileona; 05-18-2014 at 12:50 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks