Hi, I am using Excel 2003. I have a spreadsheet with the name of "Profiles Research Check List". It contains the following entries in rows e4 through e11 (row heading) The data is contained in the cells infront of the row label
Entity Name: H4 DBA Name: H5 Entity Name City, State Zip: H8,I8,J8 Client Representative Name:: H9 Client Representative Address: H10 Client Representative: City, State Zip: H11,I11,J11 I am taking this information and generating letters from this data to my clients.The name of the sheet where I am inserting the addresses is named "Conditional Letter" . Here is the problem most of the times the letter is addressed to the Entity Name like such: Entity Name Address: City, State Zip: But some times only when there is data in the Client Representative Address field (h10) I have to format the address as below Client Representative Name: RE: Entity Name Client Representative Address: Client Representative City, State Zip So I need a macro which will check for data in h10 (Client Representative Address ) and then if there is data in h10 then create my address as above in the "Conditional Letter" spreadsheet. I would like to start the insertion from cell b13 downward. And if there is nor information in h10 (Client Representative Address ) then create my address as the first example in the "Conditional Letter" spreadsheet I hope I was clear its kind of hard to explain. Thanks is advance! Dave --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
