Save a Couln file on basis of a cell

[nitesh_greatie]

Hi All,

I am trying to create a code for the following

1) I am working on a file for work allocation for the entire team member I have. Procedure “

I receive work from my boss in an excel workbook and the name of the file is

"DSMT Exception Report Oct 25 2012 GGN” and I have to save the file in my shared location so that everyone can work on that file.

After I save the file I also have to allocate the work to each team member in the same workbook. Hence for equal allocation I have create an excel work allocation sheet which allocate to the entire associate equally.

Hence, I copy the entire cell from that file and paste it in my work allocation workbook" and then distribute it among my team members.

Now after equal allocation, I copy the name of my team members (column "G") with the heading (SMT Associate) from work allocation and paste it to the main file under the heading of “SMT associate”.

Now I want to create a macro which can perform this task.

Therefore, in My work allocation sheet I have create some cells as mentioned below

File Name Location WorkSheet
DSMT Exception Report C:\Users\Jiya\Downloads NYCE
the macro can locate the file and save the column to the specified location and file and in the correct sheet and in the correct column after locating the heading that is SMT associate

I hope I was able to explain in a better manner

Thank You in advance

Regards,

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[nitesh_greatie]

Hi Arlu1201, This thread is yet not solved...