Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

Copy/Paste/Merge examples

Worksheet examples

Copy to a Database sheet with VBA

Merge cells from all or some worksheets into one Master worksheet

Create a summary worksheet from all worksheets (formulas with VBA)

Create a link to or Sum a cell in all worksheets (worksheet functions)

Create separate sheet for each horizontal PageBreak

Copy records with the same value in a column to a new sheet or workbook

Create a workbook from every worksheet in your workbook

 

Workbook examples

Merge data from all workbooks in a folder

Merge data from all workbooks in a folder: RDBMerge Add-in

Change cell or range in all workbooks in a folder

Create a summary worksheet from different workbooks (formulas with VBA)

Merge data from all workbooks in a folder in a txt file

Copy records with the same value in a column to a new sheet or workbook

Create a workbook from every worksheet in your workbook

 

CSV and TXT files

Merge all CSV or TXT files in a folder in one worksheet

Copy every TXT or CSV file that you select in a new worksheet

Merge data from all workbooks in a folder in a txt file

 

Closed workbooks and ADO

Copy a range from closed workbooks (ADO)

Copy data from an Access database into Excel with ADO

 

Specialfolders and Copy/Move Files and folders

Copy and Move files and folder

SpecialFolders and Windows Temp folder