+ Reply to Thread
Results 1 to 2 of 2

Automatically Organize data in a sheet differently (in order to create a dynamically updat

  1. #1
    Registered User
    Join Date
    05-02-2016
    Location
    Portugal
    MS-Off Ver
    2013
    Posts
    9

    Automatically Organize data in a sheet differently (in order to create a dynamically updat

    I currently have this in sheet1 columns A,B,C:


    Date Time Worker
    04/04/2016 4,5 John
    05/04/2016 2 John
    06/04/2016 6,5 John
    07/04/2016 0 --
    08/04/2016 0,5 Charles
    08/04/2016 2 John
    08/04/2016 0,5 William
    09/04/2016 0 --
    10/04/2016 0 --
    11/04/2016 9 John
    11/04/2016 3,75 William


    I want this in sheet2 columns A,B,C,D (or more in case of more names):


    Date Charles John William
    04/04/2016 0 4,5 0
    05/04/2016 0 2 0
    06/04/2016 0 6,5 0
    07/04/2016 0 0 0
    08/04/2016 0,5 2 0,5
    09/04/2016 0 0 0
    10/04/2016 0 0 0
    11/04/2016 0 9 3,75


    I need this because I need to make a graph and data has to be organised like this or I'm not able to create the graph!
    The code (which i believe it's the only way) has to work with any given dates, times or worker names! Worker names in alphabetical order if you can.
    I don't have any clue how to code this and it is giving me nightmares for weeks. Really need all the help for this one.

  2. #2
    Registered User
    Join Date
    05-02-2016
    Location
    Portugal
    MS-Off Ver
    2013
    Posts
    9

    Re: Automatically Organize data in a sheet differently (in order to create a dynamically u

    Found it!
    pivot table solves it.

+ 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. Replies: 5
    Last Post: 07-10-2013, 02:33 PM
  2. [SOLVED] Move and Extract Data in One Sheet to ORganize Differently in Another
    By webdivx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2012, 06:07 PM
  3. Create new sheet and copy data automatically using VB
    By exchangejames in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-28-2012, 06:50 AM
  4. Replies: 4
    Last Post: 04-26-2012, 07:24 AM
  5. Organize Data With New Headings Automatically
    By shane1800 in forum Excel General
    Replies: 3
    Last Post: 07-23-2011, 12:51 PM
  6. Search and Organize dynamically
    By fourmurphys in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-19-2008, 04:47 PM
  7. Dynamically create variables based on sheet data
    By beeawwb in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-02-2007, 12:28 AM
  8. [SOLVED] Why aren't links between tabs in same workbook automatically updat
    By UMP-07 in forum Excel General
    Replies: 1
    Last Post: 01-07-2005, 03:06 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