Okay...I have never used VB before so please try and tell me some way to do
this with formulas, if that is not possible then please direct or explain to
me how to do enter/use the vb code you provide.

I have two sheets, formula.xls and names.xls.

On my names xls. I have 10 empty columns called Code1 through Code 10.

I take random data from names.xls and move it to formula.xls. When its moved
to formula.xls, there is a column there called CODE that is created that
changes with every record. I have about 40K rows in names.xls and only 10K
in formula.xls....I only copy certain chunks from names.xls to formula.xls.
Every record has a specific record number also.

I want to be able to say, USE CODE1, or CODE2 (I want to be able to change it
every mailing i do) and I want the CODE1 field in my names.xls to contain the
code created by formula.xls for that particular record. Formula.xls will
constantly be cleared out and stuff will be repasted back in there, so I dont
want something that will just link it.....Or if you could even tell me a way
to get it linked and I could just write a macro to copy and paste special,
values....that'll work. I know you are probably thinking why dont you just
make the code formula for the names.xls but i can't...if i tell you why it
just becomes more complicated for you but if you would like i will.

I know i made this superrrrr complicated, but if you think you could help I
would really appreciate it...I am even willing to pay someone for their time
if they want to talk to me over the phone through this. Just post on here .

Thanks,

Derek Yaldo


--
Message posted via http://www.officekb.com