I have 2 different sheets in 2 different locations (say one is the Master sheet). I need to copy few columns from the sub sheet to the master one periodically. I work in the software field, so after every release I need to keep the release details in a specific master sheet. Each releases will have separate release details sheet stored and the master sheet contains these data together.
So what I am looking for is, I want to automate this activity. Say, I add a button in master sheet and when I click on it (after the release), it fetches the required column data from the other sheet and paste in the specific cell range. I hope it's clear.
Let me know your thoughts. Your help would be really appreciated.