Copy/Paste/Merge examples

Important message to visitors of this page

Ron de Bruin decided to remove all Windows Excel content from his website for personal reasons. If you want to know why, head over to rondebruin.nl.

Luckily, Ron was kind enough to allow me to publish all of his Excel content here.

Most of these pages are slightly outdated and may contain links that don 't work. Please inform me if you find such an error and I'll try to fix it.

Kind regards

Jan Karel Pieterse

---

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

 

Copyright © 2022 Ron de Bruin

Site designed by Spider Web Woman Designs