+ Reply to Thread
Results 1 to 7 of 7

-- Selective Cut and Paste -- Cut and Paste based off of B Column's Content --

  1. #1
    Registered User
    Join Date
    08-08-2011
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    13

    -- Selective Cut and Paste -- Cut and Paste based off of B Column's Content --

    Please see my sample of how my data is and how I would like it to be. I have a macro automating the process to get it to how I'll show you... This is really the big last step I'm having a lot of difficulty with.

    Thank you so much for your help. I really appreciate it.


    Wow, so I have a file all set up to show... How do I attach it here or simply paste it in spreadsheet form?
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-08-2011
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: -- Selective Cut and Paste -- Cut and Paste based off of B Column's Content --

    Oops for comment at bottom of my post - I got it figured out

  3. #3
    Registered User
    Join Date
    08-08-2011
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: -- Selective Cut and Paste -- Cut and Paste based off of B Column's Content --

    I also posted this on other forums... In case it gets fixed in one place, here are the links:

    http://www.mrexcel.com/forum/showthr...=1#post2821128

    and

    http://www.ozgrid.com/forum/showthre...403#post570403

    Thank you so much for your help!

  4. #4
    Registered User
    Join Date
    08-08-2011
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: -- Selective Cut and Paste -- Cut and Paste based off of B Column's Content --

    Please post solutions on Mr Excel if you have an account there.

    Thanks!

  5. #5
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: -- Selective Cut and Paste -- Cut and Paste based off of B Column's Content --

    Quote Originally Posted by brad70989 View Post
    I have a macro automating the process to get it to how I'll show you...
    hi, brad70989, there is no code inside the posted file

    What's the logic behind? Why are those rows separated from the rest?

  6. #6
    Registered User
    Join Date
    08-08-2011
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: -- Selective Cut and Paste -- Cut and Paste based off of B Column's Content --

    Hey - thanks for taking a look.

    So the first worksheet is what's output from a macro... I just don't really know where to start to get it from tab a to tab b now / don't have any code.

    Things are separated just for formatting...(All x's usually have titles, I just removed them to post online) Where I download data from outputs things in a different format (and includes things where they shouldn't be) than it should be - that's the logic behind it. I just need to reformat it all.

    Thanks

  7. #7
    Registered User
    Join Date
    08-08-2011
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: -- Selective Cut and Paste -- Cut and Paste based off of B Column's Content --

    Just to clarify for your quote - the macro I have preps the information from something else INTO the info in the first tab of this worksheet... I just want to add additional steps to the end of the macro I was referencing.

    Sorry for the confusion.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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