Is it possible to skip saving it as a text file. The report comes in as an email and currently I copy/paste the data into Excel and manipulate the report to get what I need. An extra file would be an undesired result, but if it is needed I could accommodate.
On Friday, July 13, 2012 10:12:52 AM UTC-4, JsinSk wrote: > > Hello Group, > > I'm attempting to automatically format a report that has several parts and > break it down to what I need. > > The report comes in plain text and has three parts that all in with the > phrase "total :" in the last part of that section. I'd like to see about > having it break down each section into different sheets. I currently have > it broken down to four sheets. > > Sheet 1 "Paste Sheet" - raw data goes here > Sheet 2 "Listing" - First section of the raw data is put here > Sheet 3 "Bond" - Second section of raw data > Sheet 4 "Clear" - Third section.... > > The way I currently do the is is search for "total :" scroll up to the top > of the paste sheet until I get to the top row and cut all data and move to > the first sheet. Delete blank rows still the next section and repeat > searching for total :. Then I do some text to columns to format the data to > my requirements. All the formatting is done already just need help getting > the data to automatically move to different sheets. > > Uploading sample data could be done if needed, will just require quite a > bit of time to cleanse confidential information. > > Regards, > Jason > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
