trudymcd
03-02-2006, 09:37 PM
I hope I described in the tile what my problem is, but if not perhaps the following will give you a better idea.
Copying examples given me months ago by Dreamboat (what a life saver), I managed to create a database that meets the needs of the church. At the time, I stumbled on a way to highlight many rows of a column and by holding down some keys with the Enter Key, the formula was incrementally copied to the highlighted cells. I run into problems when making new entries in the database that are now below the rows where the formulas were/are. I don't know how to repeat what I did before. Further, if I insert a row within the other rows containing data, the formulas are not present.
I know that Dreamboat tried to set it up so that if I pressed Enter or maybe some macro button after entering data, the formula's were supposed to be automatically carried to the row below. I could never get that to work, and as I said above, I stumbled on something that worked in reading the Excel Help. I keep thinking I have found the same instructions, but as it does not work, clearly it is not the same or there was some step I no longer remember that I need to do before that. The formulas are written below with explanations of what they do. This is a database of names, addresses and other information, used to create different mailings according to different sort criteria not included in the formulas.
Formula of Mail_List column: =IF(ISBLANK(I2),E2&" "&F2,IF(I2=F2,E2&" and "&H2&" "&I2,E2&" "&F2&" and "&H2&" "&I2))
If there is no name in Column I (Last_Name2), the name of the individual is input as E2 F2 (First_Name1) (Last_Name1), However if column I is not blank and is the same as column F then couple's name is entered as (First_Name1) "and" (First_Name2) (Last_name2); however if the last names are not the same, then the couple's name is input as First_Name1) (Last_Name2) "and" (First_Name2) (Last_Name2)
The following two formula's are using the same name information for a different publication.
Formula of Directory Part1 column: =F2&","
Formula of Directory Part2 column: =IF(ISBLANK(I2),E2,IF(I2=F2,E2&" and "&H2,E2&" and "&H2&" "&I2))
Thank you,
Trudy
Copying examples given me months ago by Dreamboat (what a life saver), I managed to create a database that meets the needs of the church. At the time, I stumbled on a way to highlight many rows of a column and by holding down some keys with the Enter Key, the formula was incrementally copied to the highlighted cells. I run into problems when making new entries in the database that are now below the rows where the formulas were/are. I don't know how to repeat what I did before. Further, if I insert a row within the other rows containing data, the formulas are not present.
I know that Dreamboat tried to set it up so that if I pressed Enter or maybe some macro button after entering data, the formula's were supposed to be automatically carried to the row below. I could never get that to work, and as I said above, I stumbled on something that worked in reading the Excel Help. I keep thinking I have found the same instructions, but as it does not work, clearly it is not the same or there was some step I no longer remember that I need to do before that. The formulas are written below with explanations of what they do. This is a database of names, addresses and other information, used to create different mailings according to different sort criteria not included in the formulas.
Formula of Mail_List column: =IF(ISBLANK(I2),E2&" "&F2,IF(I2=F2,E2&" and "&H2&" "&I2,E2&" "&F2&" and "&H2&" "&I2))
If there is no name in Column I (Last_Name2), the name of the individual is input as E2 F2 (First_Name1) (Last_Name1), However if column I is not blank and is the same as column F then couple's name is entered as (First_Name1) "and" (First_Name2) (Last_name2); however if the last names are not the same, then the couple's name is input as First_Name1) (Last_Name2) "and" (First_Name2) (Last_Name2)
The following two formula's are using the same name information for a different publication.
Formula of Directory Part1 column: =F2&","
Formula of Directory Part2 column: =IF(ISBLANK(I2),E2,IF(I2=F2,E2&" and "&H2,E2&" and "&H2&" "&I2))
Thank you,
Trudy