Posts by Venkat1067

Hi,

Kindly need your help..!!

I have several .xl files in folders and Sub folders, but file naming is done as Part Number_Part Name.
I want to create hyperlink for all the files based on the part name I enter in Sheet 1 of new workbook.

Ok,
Anyway thanks a lot it eased my work to great extent.

Hi Jolivanes
Thanks a lot..!! its working absolutely fine..!!
But small query is after running code when i apply filter, in second column, its only showing data which is copied from first file.
May I get re-edited code.

Attached test file for your reference, like this I have 30+ files from where I have to copy data only from "All Levels" sheet.
But First row data remains same so i do not want to copy it every time, number of rows data is dynamic in each file.

Hi...
Thanks for your response..

The code works fine but all files do not have this "All levels" sheet as first sheet, and Moreover its copying headers (Row 1) from all files which should not because its identical for all files, So it has to copy from only first file.
In addition I do not want to keep the file in same folder.
Kindly let me know changes.

Hi guys,

I need your help..!!

I have around 30+ xl files in folder with different names but all files contain "All levels" sheet I just want to copy data from this All level sheet from all files to my Master sheet.
However Header or first row remains same across all files i want it to be copied once.

Hi All,

I already have some Mac in my spreadsheet to copy PDF files from Server to local drive, but if I gave file name in Search Criteria it copies all files irrespective of Date Modified So I need the Macro to define date range so that I can copy exact files which am looking for.