I need to create a macro as below but the record doesn't seem to work. since I'm new to VBA I'm unable to debug the issue as well.
the idea is as below.
1. give the path by browsing the set of files in a folder.
2. copy sheet 1 with row range - row 10 to last row from multiple files, and paste one below the other in a master file..
3. copy sheet 2 with range row 22 to last row by referring to column g and paste one below other in the same master file as above.
your help will be of great favour... thanks in advance.