Replies

Hi macropod,

I’ve copied the steps exactly (I believe) and am still getting the line wrapping. Can you tell from a quick glance what I am doing incorrectly?

Thanks again,
aapke

I just knew I did something incorrectly. Basic steps I used are: Generate the report again in the finance system. Saved the generated file as .TXT. Opened it up in Word. Inserted your totally cool code into a module. Saved the file as a .docm. Ran the macro, sat back, and watched it work it’s magic. Saved the file as a .TXT again. Imported it into Excel using the Text to Data feature. And yes, I did incorporate the additional 4 lines.

Did I miss a step along the way? Either way, the new file I have to work with is so much cleaner than the old one, it won’t take more than a few hours to clean it up manually if needed! Thank you so much!

aapke

Okay, that was pretty cool to just watch. Thank YOU! Do I need to run it more than once to fix the issue with the multiple lines for one record?

1 3000022 $697.49 04/16/09 COA05 0 COASTAL BLUE, INC OUTSTANDING 24.84 50-00000-62250-07203-000 FILM/MAPS/BLUEPRINTS 423225

25.91 25-00000-63608-80028-000 FILMS/MAPS/BLUEPRINTS 423272
12.34 50-00000-62250-09207-000 FILMS/MAPS/BLUEPRINTS 423458

20.10 25-00000-63608-80058-000 FILMS/MAPS/BLUEPRINTS 423527
19.22 50-00000-62250-09207-000 FILMS/MAPS/BLUEPRINTS 423950

59.86 25-00000-63608-80068-000 FILMS/MAPS/BLUEPRINTS 423980
51.56 25-00000-63608-80064-000 FILMS/MAPS/BLUEPRINTS 424065

77.85 01-62000-63608-00000-000 FILMS/MAPS/BLUEPRINTS 424076
30.44 50-00000-62250-07104-000 FILMS/MAPS/BLUEPRINTS 424187

77.58 50-00000-62250-07107-000 FILMS/MAPS/BLUEPRINTS 424191
37.34 50-00000-62250-07101-000 FILMS/MAPS/BLUEPRINTS 424320

47.02 01-62000-63608-00000-000 FILMS/MAPS/BLUEPRINTS 424439
20.10 60-94030-63608-00000-000 FILMS/MAPS/BLUEPRINTS 424479

29.56 60-94030-63608-00000-000 FILMS/MAPS/BLUEPRINTS 424480
53.71 60-94030-63608-00000-000 FILMS/MAPS/BLUEPRINTS 424620

34.53 50-00000-62250-07104-000 FILMS/MAPS/BLUEPRINTS 424695
75.53 25-00000-63608-80065-000 FILMS/MAPS/BLUEPRINTS 425067

Thanks.

That is so cool! Thank you! Exactly what I needed.

Totally appreciate it! Thanks. But what would I have to modify this to in order for the macro to capture the row immediately above the selected cell? For instance, someone wants to copy and paste rows 200 and 211? I made that up…

Thank you. Now I see what I did wrong.

US. Thanks.

I just checked and it worked fine for me. I added the ‘hit download button’ information above. Thank you.

I am new at lookup formulas and need help figuring out how to match the two sheets on the zip file (150k) located at the link below.

http://www.filedropper.com/danapointapnaccount_1 (hit the download button)

What I would like is if the account numbers match on Sheet 1 and 2, then the consumption data from sheet 2 gets transferred to sheet 1. Hopefully makes sense. Thank you.