Results 1 to 2 of 2

Thread: Rearrange Data - Sheet 1 into Sheet 2 Macro?

  1. 03-16-2021, 02:11 AM #1
    BlakeReuben
    BlakeReuben is offline
    Junior Member
    Join Date
    Mar 2021
    Posts
    1
    Rep Power
    0

    Rearrange Data - Sheet 1 into Sheet 2 Macro?

    Pulling my hair out, hoping someone can help. I'm looking for a macro to turn data in sheet 1 into sheet 2. Thank you.

    Thank you very much and apologies for the cross posting. Carim from the Ozgrid kindly took some time to create the attached. Also thank you to Alan for your input. Greatly appreciated!








    Cross Posts

    Rearranging Data, Sheet 1 into Sheet 2
    https://www.mrexcel.com/board/thread...eet-2.1165012/
    https://www.excelforum.com/excel-pro...-2-macro.html/
    http://www.excelforum.com/excel-prog...t-2-macro.html
    Attached Files Attached Files
    Last edited by DocAElstein; 03-16-2021 at 06:16 PM. Reason: Cross Post links
    Reply With Quote Reply With Quote
  2. 03-16-2021, 03:39 AM #2
    sandy666
    sandy666 is offline
    Sir Moderator sandy666's Avatar
    Join Date
    May 2018
    Posts
    239
    Rep Power
    7

    Cool

    are you sure your expected result is correct?
    because I got
    res.png

    Could you explain your logic from source data to the result?
    Last edited by sandy666; 03-16-2021 at 04:09 AM.
    sandy
    I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Copy data from one sheet to another sheet
    By sathishsusa in forum Excel Help
    Replies: 2
    Last Post: 03-14-2017, 09:29 AM
  2. Macro to Automatically Update a sheet based on values in another sheet on daily basis
    By sammy7187 in forum Excel Help
    Replies: 4
    Last Post: 02-27-2014, 08:49 PM
  3. Pull data within the work sheet and save as master sheet with pulled sheet name.
    By amar.kshirsagar in forum Excel Help
    Replies: 2
    Last Post: 09-30-2013, 03:40 PM
  4. VBA Code To Move Data From One Sheet To Another And Delete From Source Sheet
    By rich_cirillo in forum Excel Help
    Replies: 14
    Last Post: 06-24-2013, 06:17 PM
  5. require formula help to copy data from sheet to sheet
    By Terry in forum Excel Help
    Replies: 2
    Last Post: 12-26-2012, 08:31 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
  •  

Forum Rules