chrysanthi
New Member
- Joined
- Dec 6, 2019
- Messages
- 12
- Office Version
- 365
- 2010
- Platform
- Windows
Dear all,
I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following: Column E & ( & column F & ) & Rev & Column C.
Then each one of them must be send to a new folder location which is C:\Users\chma\Desktop\F2 - Copy & Column G (but the word PROJECT_483 must be repplaced by the C:\Users\chma\Desktop\F2 - Copy)
Thank you
I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following: Column E & ( & column F & ) & Rev & Column C.
Then each one of them must be send to a new folder location which is C:\Users\chma\Desktop\F2 - Copy & Column G (but the word PROJECT_483 must be repplaced by the C:\Users\chma\Desktop\F2 - Copy)
A | B | C | D | E | F | G |
FILE | DOCUMENT IDENTIFICATION | ISSUE | DATE | KKS | TITLE | PATH |
483-21-DT-M-00300-Ed001.pdf | 483-21-DT-M-00300 | 1 | 05-12-19 | 111915-21-YDS-MDD-EA-00300 | P&ID SYMBOLOGY AND GENERAL NOTES | PROJECT_483\200 Mechanical Area\221 Systems\221.01 P&IDs |
483-21-FV-D-00001-Ed001.pdf | 483-21-FV-D-00001 | 1 | 05-12-19 | Monthly Progress Report (NOVEMBER 2019) | PROJECT_483\000 Project Management\001 General\001.03 Progress Reports | |
483-21-S-M-20250-Ed002.pdf | 483-21-S-M-20250 | 2 | 04-12-19 | 111915-21-PA_-MHP-EA-20250 | COOLING TOWERS (INDUCED DRAFT) DATA SHEET | PROJECT_483\200 Mechanical Area\221 Systems\221.05 Data Sheets |
Thank you