Rename and move files to a new location

[chrysanthi]

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)

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

 

[DanteAmor]

In which folder is this file:

483-21-DT-M-00300-Ed001.pdf

 

[chrysanthi]

this one is under the 221.01 P&IDs

W:\GR-IPP_II\02. Engineering\200 Mechanical Area\221 Systems\221.01 P&IDs

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

 

[DanteAmor]

So the source folder is this:
W:\GR-IPP_II\02. Engineering\200 Mechanical Area\221 Systems\221.01 P&IDs

And which folder do you want to move?

 

[RoryA]

Cross-posted here.

 

[chrysanthi]

No... i am sorry i didn't understand the question
The source folder is a temp folder C:\Users\chma\Desktop\EA

The destination is W:\GR-IPP_II\02. Engineering\ + what is shown in the last column without the PROJECT_483

 

[chrysanthi]

yes but none is helping me!!

 

[DanteAmor]

Hi @chrysanthi, You can put here the links where you have published the same question.

 

[RoryA]

yes but none is helping me!!

Please read the forum rules on cross-posting - they are basically the same in all Excel forums so it pays to learn them.

 

[chrysanthi]

Thank you dante!

 

[chrysanthi]

I shall do that!