+ Reply to Thread
Results 1 to 5 of 5

help, code to send data from random data from another sheet

  1. #1
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    252

    help, code to send data from random data from another sheet

    hi
    a bit difficult to write with sentence
    the point is, I want to change the data from sheet 1 to sheet 2 with change positions by name...
    for more details, I have included an example

    I appreciate any help
    (sorry do not accidentally send the same thread I can not delete)
    Attached Files Attached Files
    Last edited by herukuncahyono; 03-28-2015 at 05:33 AM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,379

    Re: help, code to send data from random data from another sheet

    Hi herukancahyono,

    This problem looks like a Pivot Table to me. The problem is you need to remove Blank Rows and/or Blank Columns in your data TABLE. I've done this for you on Sheet1. Then do a Pivot Table, like I've done on Sheet2. See the attached for what I think you want.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    252

    Re: help, code to send data from random data from another sheet

    Hi Marvin,
    Actually in sheet1 column C and E is not empty but ignored
    In Sheet1, For "A1" value in column B = JX, JJ, CX, QQ when moved to sheet 2 will be in the order when filling the first row of result table in sheet2
    and form of the table in sheet 2 is fixed as it looks in range( A1:E14) and the result is look like table in range (J1:N14)

    regards

  4. #4
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    252

    Re: help, code to send data from random data from another sheet

    probably as a picture would be like this

    change position.JPG

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,379

    Re: help, code to send data from random data from another sheet

    Hi,

    I just can't get my head around what you want. Maybe one of the smart Gurus can see what you are asking for.?

+ 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. [SOLVED] MACRO: Send Data from 'Master Sheet' to 'Data Collection Sheet'
    By cjhiggins in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-15-2013, 09:45 PM
  2. Replies: 0
    Last Post: 03-29-2012, 08:06 AM
  3. VBA code to send data to different sheets
    By covershaker in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-18-2010, 11:28 AM
  4. Replies: 17
    Last Post: 05-19-2009, 11:34 AM
  5. Creation of data series - chosing random data from sheet
    By May2009 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-05-2009, 12:37 PM

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