Macro operated by the table or list

Hi Everyone,

I want to create a Macro that will process dependent on my Table. Here's the logic:

1. I have a table like this:

Initial Filename in the Folder Fieldname1 New Filename
File1 AA1 File1New
File2 AA2 File2New


2. The macro will open File1 from a certain folder.
a. When the File1 is open, it will delete the entire row 1 and will insert a new column before column A.
b. Column A header will be named String.
c. The Fieldname1 will be pasted in A2 all the way down until the last row of column A whenever there is data in
column B.
3. After doing all the tasks in 2, the macro will save File1 with the new filename File1New in the same folder
4. The Macro will be continuous until the last row of the table.

I badly need your help on this guys. Please help me.

Bgards,
Nem0