| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formatting Table within Excel
I have ~50,000 rows of data that I need to analyze/format for easier viewing. I want to create boxes/lines around data for each unique name in a column. I have data in Column B. Everytime the name changes, I want to create a new box and I also would like to Merge the cells if possible. I am trying to write a Macro using a loop function but having no luck. See attached spreadsheet for Raw Data and the desired result is going to be. +-------------------------------------------------------------------+ |Filename: Format Table.zip | |Download: http://www.excelforum.com/attachment.php?postid=3894 | +-------------------------------------------------------------------+ -- maacmaac ------------------------------------------------------------------------ maacmaac's Profile: http://www.excelforum.com/member.php...fo&userid=2959 View this thread: http://www.excelforum.com/showthread...hreadid=474183 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with linked Excel table in a word Document | Excel Discussion (Misc queries) | |||
| Adjust an Excel table with the width of a Word page | Excel Discussion (Misc queries) | |||
| Excel could not save all the data and formatting you recently ad.. | Excel Worksheet Functions | |||
| Use Excel to make an update query to another database table? | Excel Discussion (Misc queries) | |||
| Pivot Table Security in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
