Excel: Copying ranges from a folder on desktop

Hi all, I am looking for what i think will be code in order to copy ranges from every spreadsheet inside a folder in my desktop the folder is called PL and every "Work In Progress" job will be put into this folder, so the amount can vary from time to time Hopefully if it is possible i need the code to open each spreadsheet in turn and copy ranges BQ16:CB317 pasting them as values only starting from B6, if any blank rows are found ( There will always be some blank rows ) delete them then leave a blank row then copy the next spreadsheet Not sure how complicated this may get but it will act as a report that will be vital to my days work Many thanks for any help at all

This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of May 12, 2014.

For more resources for Microsoft Excel