Moving data from one worksheet to another in automated, linked, or

[BruceLoe]

I have a workbook containing 28 worksheets with names and addresses for
owners of different tracts of land

In the same workbook I have 28 other worksheets that are templates I created
to mail to each owner of the 28 tracts of land

I need to move data from the "tract" worksheets to the "mail piece"
worksheets in an efficient manner.

Please Help! Thanks.

 

[Ron de Bruin]

Hi BruceLoe

good morning

I have a workbook containing 28 worksheets with names and addresses for
owners of different tracts of land

Why can't you use this sheets to mail?

Why not use one worksheet and filter ?
http://www.rondebruin.nl/mail/folder3/row2.htm

 

[BruceLoe]

Hi BruceLoe

good morning


Why can't you use this sheets to mail?

Why not use one worksheet and filter ?
http://www.rondebruin.nl/mail/folder3/row2.htm

 

[BruceLoe]

Hi BruceLoe

good morning


Why can't you use this sheets to mail?

Why not use one worksheet and filter ?
http://www.rondebruin.nl/mail/folder3/row2.htm

Ron,

It is a complicated project involving Bureau of Indian Affairs (BIA) "Trust"
lands, the BIA holds in Trust for the benefit of individual Indians. Each
tract may have 100 beneficiaries with different ownership percentages. I am
required by statute to contact each beneficiary.

All I want to do is specify on one worksheet (tract) for example C9 and C10
should be transferred to say E13 and E14 on another worksheet (mail piece)
for example

Thanks so much, I am looking forward to hearing from you