Problem in Macro

[jitsaha]

Hii all, I am a newbie in the field of Macro writing.I am facing a problem while writing a macro.

I have a folder containing some excel files.I have to copy a particular range from all files and append that part to another excel file with 1 row gaps each time.

Suppose I have to copy A25:M39 of Sheet 1 of all files and paste that part with the formatting in tact to another excel file starting from B2.2nd file contents will be pasted in the same output file after 1 row gap.

Like if the 1st file content starts at B26 and ends at N40,next file contents will be pasted starting at B42.

Please help me regarding this. Waiting for your kind reply.

 

[mole999]

many many posts in the forum with exactly that need, effectively the question is answered, just need to pick out the bits you want to use and replicate that

 

[jitsaha]

many many posts in the forum with exactly that need, effectively the question is answered, just need to pick out the bits you want to use and replicate that

I am absolutely new to the forum,just joined today.Can you please help me find out the related posts or send me the macro for this one so that I can modify if any new requirement comes??

Thanks in advance.

 

[mole999]

go here
> Advanced Search - MrExcel Message Board

Search for > Keywords > copy from files > Search Now

and you get pages of answers, I can't choose which suits your need, once you find something close to what you need, tell us what you need and related to the code and it probably can be tweaked.

You'll need to think about directory paths, file names, sheet names, identical data areas, what is common for each that you will process

 

[jitsaha]

Thanks Mole..Let me try out.

 

[jitsaha]

I tried with the posts but could not get what I sought..Please have a look...