VBA: More complex data formating

[sroyroy]

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.

 

[tusharm]

I imagine there are people in this forum or elsewhere who will go through your XLS file(s) and figure out what you want.

At the same time, you may have better responses if you (1) avoid asking people to download a file that might contain macros, and (2) don't expect people to wade through multiple files, multiple worksheets, and multiple columns trying to figure out what you want.

Think of it this way. Volunteers give free help to people with problems. But, now, the same volunteers have to spend time and take risks figuring out what you want!

Maybe, you should put all the information in your post and see if you find any takers.

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.