Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining the cells data for cells with same name
1. Change data in the Offer $$ column the following way: $20k to 20,000.00 (I want the thousands separator to appear in my letters when the mail merge is complete) 2, The data is given by the individual lots and who owns them. Some people in the list own more than one lot, so their name appears more than once. If one person owns more than one lot, I would like to have all the lots they own listed in one cell (LOT column) and the offer price (Offer $$ column) to be updated/adjusted accordingly. So, each persons name should only appear on the list once. If they own 3 lots and the offer for each individual lot was 20,000.00 or 20k, the offer should be updated to 60,000.00 See attahed folder +-------------------------------------------------------------------+ |Filename: My work.zip | |Download: http://www.excelforum.com/attachment.php?postid=5126 | +-------------------------------------------------------------------+ -- nik_gujarathi ------------------------------------------------------------------------ nik_gujarathi's Profile: http://www.excelforum.com/member.php...o&userid=34522 View this thread: http://www.excelforum.com/showthread...hreadid=566245 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining the cells data for cells with same name
What field(s) do you want to use to identify that the LOTS that are to be
combined? Is it "MailingAddress1"? "nik_gujarathi" wrote: 1. Change data in the Offer $$ column the following way: $20k to 20,000.00 (I want the thousands separator to appear in my letters when the mail merge is complete) 2, The data is given by the individual lots and who owns them. Some people in the list own more than one lot, so their name appears more than once. If one person owns more than one lot, I would like to have all the lots they own listed in one cell (LOT column) and the offer price (Offer $$ column) to be updated/adjusted accordingly. So, each persons name should only appear on the list once. If they own 3 lots and the offer for each individual lot was 20,000.00 or 20k, the offer should be updated to 60,000.00 See attahed folder +-------------------------------------------------------------------+ |Filename: My work.zip | |Download: http://www.excelforum.com/attachment.php?postid=5126 | +-------------------------------------------------------------------+ -- nik_gujarathi ------------------------------------------------------------------------ nik_gujarathi's Profile: http://www.excelforum.com/member.php...o&userid=34522 View this thread: http://www.excelforum.com/showthread...hreadid=566245 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining the cells data for cells with same name
Ignore my last reply ...I'll assume it is First + Lastname.
"nik_gujarathi" wrote: 1. Change data in the Offer $$ column the following way: $20k to 20,000.00 (I want the thousands separator to appear in my letters when the mail merge is complete) 2, The data is given by the individual lots and who owns them. Some people in the list own more than one lot, so their name appears more than once. If one person owns more than one lot, I would like to have all the lots they own listed in one cell (LOT column) and the offer price (Offer $$ column) to be updated/adjusted accordingly. So, each persons name should only appear on the list once. If they own 3 lots and the offer for each individual lot was 20,000.00 or 20k, the offer should be updated to 60,000.00 See attahed folder +-------------------------------------------------------------------+ |Filename: My work.zip | |Download: http://www.excelforum.com/attachment.php?postid=5126 | +-------------------------------------------------------------------+ -- nik_gujarathi ------------------------------------------------------------------------ nik_gujarathi's Profile: http://www.excelforum.com/member.php...o&userid=34522 View this thread: http://www.excelforum.com/showthread...hreadid=566245 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining the cells data for cells with same name
Macro in attached. Sheet2 has consolidated data and Sheet3 copy of original Sheet2. HTH +-------------------------------------------------------------------+ |Filename: Copy of My work.zip | |Download: http://www.excelforum.com/attachment.php?postid=5129 | +-------------------------------------------------------------------+ -- Toppers ------------------------------------------------------------------------ Toppers's Profile: http://www.excelforum.com/member.php...o&userid=30076 View this thread: http://www.excelforum.com/showthread...hreadid=566245 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining the cells data for cells with same name
Hello Toppers, Thank you for the help. The macro is working but the column (LOTS) does not get updated. That is: - With the same name, all the Lot #'s should get displayed I have shown a small example Thank you Nikhil Bill & Mary Greenspan.......... ...Lots 27, 28, 29 and 30 80,000.0 -- nik_gujarath ----------------------------------------------------------------------- nik_gujarathi's Profile: http://www.excelforum.com/member.php...fo&userid=3452 View this thread: http://www.excelforum.com/showthread.php?threadid=56624 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining the cells data for cells with same name
Hello Toppers, Thank you for the help. The macro is working but the column (LOTS) does not get updated. That is: - With the same name, all the Lot #'s should get displayed I have shown a small example Thank you Nikhil Bill & Mary Greenspan.......... ...Lots 27, 28, 29 and 30 80,000.0 -- nik_gujarath ----------------------------------------------------------------------- nik_gujarathi's Profile: http://www.excelforum.com/member.php...fo&userid=3452 View this thread: http://www.excelforum.com/showthread.php?threadid=56624 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining the cells data for cells with same name
Amended file attached. Note that I had to manually add the lot numbers to your mail merg sheet and I removed the word "LOT". (See Sheet3 +------------------------------------------------------------------- |Filename: Copy of My work.zip |Download: http://www.excelforum.com/attachment.php?postid=5134 +------------------------------------------------------------------- -- Topper ----------------------------------------------------------------------- Toppers's Profile: http://www.excelforum.com/member.php...fo&userid=3007 View this thread: http://www.excelforum.com/showthread.php?threadid=56624 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combining data in multiple cells | Excel Discussion (Misc queries) | |||
Combining data from 2 cells into 1 cell | Excel Discussion (Misc queries) | |||
Combining data from different cells and more... | Excel Worksheet Functions | |||
COMBINING CELLS WITH LIKE DATA | Excel Discussion (Misc queries) | |||
combining partial data from 2 different cells | Excel Discussion (Misc queries) |