| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Write a macro that enables User to simply click a button and . . .
We receive data in Excel which we want to realign by Mortgage Lender and then
in the columns provided: 1. Sort to find loans closest to $417K using the Original Loan amount 2. Sort to find loans originated from 2000 to present. 3. Sort to find loans with 3 or more bedrooms (we want to eliminate properties that are condos) 4. We need to get a mailing label list for the above criteria with the Home Owners Name(s) and full address so we can mail to them ASAP (big time ASAP). 5. Create a "form letter" where with mail merge where the Lender's data will drop in where mentioned in the letter plus the Home Owners' name(s). I'll create the letter if someone can build the "Mail Merge" function. I can send via e-mail the spreadsheets to someone who knows how to do this. Thank you in advance. Excel 2003 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Write a macro that enables User to simply click a button and . . .
Kevin,
No macro needed. Simply use data filters and then filter using your criteria, and copy the resulting table to a new workbook. The mail merge feature is part of Word, and doesn't require a macro, just a table with headers. HTH, Bernie MS Excel MVP "KevinTren" wrote in message ... We receive data in Excel which we want to realign by Mortgage Lender and then in the columns provided: 1. Sort to find loans closest to $417K using the Original Loan amount 2. Sort to find loans originated from 2000 to present. 3. Sort to find loans with 3 or more bedrooms (we want to eliminate properties that are condos) 4. We need to get a mailing label list for the above criteria with the Home Owners Name(s) and full address so we can mail to them ASAP (big time ASAP). 5. Create a "form letter" where with mail merge where the Lender's data will drop in where mentioned in the letter plus the Home Owners' name(s). I'll create the letter if someone can build the "Mail Merge" function. I can send via e-mail the spreadsheets to someone who knows how to do this. Thank you in advance. Excel 2003 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Write a macro that enables User to simply click a button and .
Kevin,
They are certainly welcome to post messages in this forum, newsgroup, or thread.... Bernie MS Excel MVP "KevinTren" wrote in message ... Bernie - thank you. I am a REAL novice at this and don't want to spend the time to learn it given it is not the highest and best use of my time so your input is greatly appreciated. I have passed this on to the person more talented than I in this arena and they may be in contact with you. If that's OK, please e-mail me at . "Bernie Deitrick" wrote: Kevin, No macro needed. Simply use data filters and then filter using your criteria, and copy the resulting table to a new workbook. The mail merge feature is part of Word, and doesn't require a macro, just a table with headers. HTH, Bernie MS Excel MVP "KevinTren" wrote in message ... We receive data in Excel which we want to realign by Mortgage Lender and then in the columns provided: 1. Sort to find loans closest to $417K using the Original Loan amount 2. Sort to find loans originated from 2000 to present. 3. Sort to find loans with 3 or more bedrooms (we want to eliminate properties that are condos) 4. We need to get a mailing label list for the above criteria with the Home Owners Name(s) and full address so we can mail to them ASAP (big time ASAP). 5. Create a "form letter" where with mail merge where the Lender's data will drop in where mentioned in the letter plus the Home Owners' name(s). I'll create the letter if someone can build the "Mail Merge" function. I can send via e-mail the spreadsheets to someone who knows how to do this. Thank you in advance. Excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unshared workbook allowing write access to more than 1 user | Excel Discussion (Misc queries) | |||
| How do I write a macro for a button to send user to a custom view? | Excel Discussion (Misc queries) | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
| Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
| Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Linear Mode
