Here is the link to my mockdata:
https://www.box.com/s/rqxe42d1i5kws5djvw8d: File name page2b.xls has 7 sheets. Sheet 2-6 data (a to k column data) is formatted in required form from N column of each sheet. I want to get all assembled formated data in "all in one sheet" with out the data from other data sheet. "Other data" may contain similar data as in other sheets. Here numbered sheets can go upto any number.
https://www.box.com/s/r5a67ap3ioy35754boxn: File name page1b.xls contains data in sheet 1-3 and data is only in column A. The required format starts from column C of sheet 1-3. Page x will have the assembled data from sheet 1-3 with out touching the data from page y and page x. Column b is just for understanding the fields. page y and page x may contain similar data as in other sheets. Here numbered sheets can go upto any number.
I am still a learner so I request you to write comments as well with VBA.
https://www.box.com/s/rqxe42d1i5kws5djvw8d: File name page2b.xls has 7 sheets. Sheet 2-6 data (a to k column data) is formatted in required form from N column of each sheet. I want to get all assembled formated data in "all in one sheet" with out the data from other data sheet. "Other data" may contain similar data as in other sheets. Here numbered sheets can go upto any number.
https://www.box.com/s/r5a67ap3ioy35754boxn: File name page1b.xls contains data in sheet 1-3 and data is only in column A. The required format starts from column C of sheet 1-3. Page x will have the assembled data from sheet 1-3 with out touching the data from page y and page x. Column b is just for understanding the fields. page y and page x may contain similar data as in other sheets. Here numbered sheets can go upto any number.
I am still a learner so I request you to write comments as well with VBA.