I am new in this VBA world so don’t know much about codes, I need one help actually in my office there are a lot of excel work so I need to create a macro which open a file “delete specific column data” (data is available in merged cell) and save and close.
This issue files are in thousands and they all are available over server folders which we access remotely.
So I need to create a macro in which we can give server path access details , and place where I can mention list of files name in which I want to delete data.
Note: (each files have multiple tabs of data but I need to delete data only in one tab (sheet) and specific merged area.
Can some one help me with code details?