HI ALL,

I am doing repetative on a daily basis . i ma looking for a macro for teh same .


I have a spread sheet with A to G filled with data , now i ahve assighn the work to users

for example

i have 1000 rows of work i am alloting to diffrent users , depending on their capability.

if pop up can come out and ask me for for every single user i will allot the line items , so that it copies the line items and put it in a seprate file , with the user name.

the user name can be taken form a file called username in A colomun.


can anybody help me on this


thanks in advance.