+ Reply to Thread
Results 1 to 5 of 5

Trying to organize data from random cells into destination cells

  1. #1
    Forum Contributor
    Join Date
    06-25-2013
    Location
    Longview, TX
    MS-Off Ver
    MS365
    Posts
    338

    Trying to organize data from random cells into destination cells

    Hello all!

    I have a spreadsheet where I need to research data. I have to copy and paste from various different cells from another application into Excel and it's VERY tedious (and puts me to sleep). So, I'm hoping to adapt another macro so that I can just paste the entire page from the other application (without picking out the pieces that I need) and have the macro weed through it and put the data into new columns, organized properly.

    I'm attaching a workbook. Sheet 1 is, of course, what I start out with; Sheet 2 is what I WANT to end up with; Sheet 3 is what the coding below does and, if I remove the piece of code in red, that gives me Sheet 4. I need to be able to get P-T and AA-AB to be filled in where they are blank.

    I've been working on this for just about 6 hrs and I'm mad at it now, so I'm hoping to get some assistance. It seems like there should be a way to copy P2:T2 and fill down through P8:T8 and copy AA2:AB2 and fill down through AA8:AB8, etc., down throught the destination columns, but I sure can't find the correct syntax to do it.

    Please Login or Register  to view this content.
    I'll REALLY appreciate any help! And if you see a way to do this whole job easier/more efficiently than the coding I have so far, I'm happy to alter the whole dang thing, LOL!

    Thank you!

    Jenny
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Trying to organize data from random cells into destination cells

    See result in sheet ("Blad1")

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    06-25-2013
    Location
    Longview, TX
    MS-Off Ver
    MS365
    Posts
    338

    Re: Trying to organize data from random cells into destination cells

    Thanks, LeoTaxi!

    That's perfect! I was probably going at it in the longest way possible, LOL! Your code works perfectly! First time, every time! If I had a thousand years, I would NEVER have come up with something so neat and fast!

    I just added a few little formatting things to it, just to save a little more time later in my process.

    You can imagine how tedious and mind-numbing it would be to copy and paste each of those components, individually, to the spreadsheet so I could work with them.

    You have made my day... no, my WEEK!

    Jenny

  4. #4
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Trying to organize data from random cells into destination cells

    graag gedaan

    Leo

  5. #5
    Forum Contributor
    Join Date
    06-25-2013
    Location
    Longview, TX
    MS-Off Ver
    MS365
    Posts
    338

    Re: Trying to organize data from random cells into destination cells

    I had to post again and say thank you! I just had a MASSIVE research project that would have been truly horrible to complete manually. This macro saved me, literally, about 2 1/2 days of work! It was a complete lifesaver!!!

    One thing I'm wondering about: it takes a second or to for it to work (which is TOTALLY not a problem for me!), but I'm just curious, because most of the other macros I have are virtually instantaneous. I added a little bit at the beginning of the code to turn off "auto calculate" before the macro runs and another piece at the end to turn "auto calculate" back on, so it shouldn't be calculations slowing it down. As I said, I'm THRILLEd with it as it is; I was just hoping to learn something new for future use.

    Thank you and hope you have a great weekend!

    Jenny

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy cells to a new sheet spacing out the destination cells
    By brianrhoff in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-06-2014, 01:07 PM
  2. Seeking VBA code or macro that will organize random data
    By guyonabuffalo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-29-2014, 09:23 PM
  3. Best Way to organize cells
    By rami10 in forum Excel General
    Replies: 8
    Last Post: 12-28-2012, 03:01 AM
  4. How to organize and insert blank cells between a huge number of data?
    By tareq in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-20-2011, 11:04 AM
  5. Leave destination cells blank when origin cells contain value 0
    By vince2g in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-16-2010, 11:24 AM
  6. Looking cells & organize
    By apos1982 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-29-2009, 09:53 AM
  7. [SOLVED] Sum of random cells with positive data
    By Susannah in forum Excel General
    Replies: 2
    Last Post: 02-18-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1