Hi,
I am trying to create a master sheet where I can populate the values in certain format based on values from an input sheet (different work book). The way I am tiring to do this is by creating a MACRO switch in master work sheet, where it access the active input work sheet and extract the data to required format. I can then copy the extracted data into different sheet and keep my Master sheet to do the same work again and again for different input sheets. Now, I know I can create something like this with my little knowledge on VBA coding but how to start and how to proceed?
I have appended two work sheets to the post.
1. "Given Format Work Book"- It contains 15-20 work sheets, each sheet has different input data and all sheets are in the same format.
2. "Required Format Work Book"- This sheet has the data (yellow shaded), which is extracted from “Given Format" work book- from each work sheet.
Please let me know if I am going in a right direction or if it is too much to do. What I want to accomplish is by creating a master sheet I can extract data to required format from N number of input sheets without spending too much time.
Your help is greatly appreciated.
Thanks
Kishore
Bookmarks