Becky, This looks like FUN (I know, sick AND twisted!) ------------------------------- There's a few things I need to help you out.
First of all, do you recieve this data already in an Excel file? or is it a "flat" text file? If it's a "text" file, it would almost be easier to use VBA to read the file itself. I could read each line, for the first row of data looks like it was probably tab-delimeted. Your first field of interest is in column "E" The second line looks like it has two delimeter pairs. each field and value is separated by "--" then, the field and value are separated by ":" although, the first line looks like it SOMETIMES can have a "--"/":" pairing (with the Action Note:) I think I can do this fairly quickly. but first, I'd like to know if THIS format (as an Excel sheet) is how you want to process the input data. Or would you prefer that I/we use a "dialogbox" to select an external file to use as input. Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- ________________________________ From: Becky Kaliq <beckyka...@gmail.com> To: excel-macros@googlegroups.com Sent: Wed, December 5, 2012 4:45:48 PM Subject: $$Excel-Macros$$ Rearrange data: Move and split cells, delete irrelevant info Hello all, I have an Excel output from a legal software in which I need to (significantly) rearrange the data. I’ve attached a sample of the output with identifiers removed. The second sheet in the workbook is my ideal output. Here are the rearrangements I’d like to be able to do: 1. Data for one person comes out on two rows; I would like it all on one row. 2. Some data are condensed into a single cell; I need particular items extracted to separate cells. 3. Output gives irrelevant data; I would like it deleted. 4. I would like the remaining columns arranged in a particular order. Notes: -- I am new to macros in Excel and have a little experience writing Visual Basic code for an Access database. I can get to the Developer tab, et cetera. I have recorded a basic macro (cut and paste). I see where to access the code in my PERSONAL.XLSB modules. --Output is created for Excel 97-2000. I am working in 2010. --I left the output formatted exactly as it comes out of the software, including column widths. --Output is sorted by Court with a header row for each. I don’t need those header rows. --Not all defendants will have data for all my desired columns (i.e., there may or may not be a second defendant, a service date, or a type/note). I replicated this with my sample: one case has a second defendant and a service type. A different case has a type/note. --I would like to be able to use the macro(s) weekly when we generate this report. The usual week will have 150-300 cases. Any assistance you all can provide will be much appreciated!-- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.