REG:copy and paste data from one sheet to another using vba

[laxmananm]

Hi all,

Hope you all doin good..well am new to this forum as well as VBA.I have a 30+ seperate excel files in one folder.The sheets contains data for a single month for 30+ projets.I want to pull the data into new master file using excel macro.Im trying to create macro .What i need is


1.The 30+ sheets are different projects which contains its own datas.
2.I need to put one master/Consolidated sheet which has a macro to collect the data by an single click for every month.
3.The Master sheet which should update automatically based on the different project sheet colum name.


Need your assisatance to complete this activity.




Thanks in advance people.




Regards,
Lakshmanan

 

[dmt32]

Hi welcome to the board.
This is quite a common request & there are many examples how to do this out there. Here are just couple:

Merging Data from Multiple Workbooks into a Summary Workbook in Excel

http://www.jpsoftwaretech.com/excel-vba/merge-workbooks/

Suggest that you search around & find an example you think best meets your need. If still need help, post back with code you are using - plenty here you will offer advic & guidance.

Hope helpful

Dave

 

[laxmananm]

Hi dave,

Thanks for the response..Am new to VBA programming.But i need to complete this tool for my project reports.Need your assistance to complete this tool..Thanks

 

[dmt32]

Hi dave,

Thanks for the response..Am new to VBA programming.But i need to complete this tool for my project reports.Need your assistance to complete this tool..Thanks

Hi,
you should find the assistance required in links provided but if need help understanding VBA then have a look here:
Getting Started with VBA in Excel 2010

or here:

http://www.contextures.com/excelvbagettingstarted.html


Hope Helpful


Dave

 

[laxmananm]

Hi,

Thanks for the links provided. It will take long time to learn and complete the tool.if u dont mind i will share the sample sheet.Can any one provide me the tool that one i required.

Thanks..

 

[VoG]

Cross posted copy and paste data from one sheet to another using vba

Please read Excelguru Help Site - A message to forum cross posters

 

[laxmananm]

Cross posted copy and paste data from one sheet to another using vba

Please read Excelguru Help Site - A message to forum cross posters

Hi,

do you have macro to satify my requirement?


thanks