Results 1 to 4 of 4

Thread: changing arrangement of data to new style

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 02-03-2015, 10:53 PM #1
    saied
    saied is offline
    Junior Member saied's Avatar
    Join Date
    Jan 2015
    Posts
    5
    Rep Power
    0

    changing arrangement of data to new style

    hi
    i have two style of dataarrangements of date time & hight
    i want to change 1.xlsx as table.jpg
    is it possible?
    thanks
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 02-06-2015, 09:55 AM #2
    alansidman
    alansidman is offline
    Senior Member alansidman's Avatar
    Join Date
    Apr 2012
    Posts
    125
    Rep Power
    13
    Your jpg is unreadable. Too small to read. Suggest you upload as an excel file.
    Alan
    Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
    Like my answer? Click * below
    Database Normalization
    Database Principles
    Pivot Table Tips
    Excel Video Tutorials
    SumProduct Video Tutorial
    DataPig Access Tutorials
    MS Query Tutorial
    SQL Tutorial
    Reply With Quote Reply With Quote
  3. 02-12-2015, 09:32 PM #3
    p45cal
    p45cal is offline
    Member p45cal's Avatar
    Join Date
    Oct 2013
    Posts
    94
    Rep Power
    12
    Attached is your file with a macro added which is executed by clicking the button on the sheet. Each click adds a new sheet after a few seconds. It's best if the first date on the sheet is the 1st of the month.
    2015-02-12_162955.jpg
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  4. 02-12-2015, 10:34 PM #4
    p45cal
    p45cal is offline
    Member p45cal's Avatar
    Join Date
    Oct 2013
    Posts
    94
    Rep Power
    12
    oh groan...
    cross post where already answered:
    changing arrangement of data to new style [SOLVED]

    saied, please have a read of Excelguru Help Site - A message to forum cross posters
    I feel I've wasted my time.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Convert Matrix Style Data into Stacked Rows preserving identifying row values
    By normonster in forum Excel Help
    Replies: 8
    Last Post: 09-04-2014, 02:45 AM
  2. AutoFill in Formula (R1C1 Style) till data found in adjacent column, multiple IF(AND
    By analyst in forum Excel Help
    Replies: 6
    Last Post: 12-23-2013, 04:07 PM
  3. changing code from using Combobox to optionbuttons
    By paul_pearson in forum Excel Help
    Replies: 24
    Last Post: 09-05-2013, 12:59 PM
  4. Changing Picture Using Data Validation
    By jeff in forum Excel Help
    Replies: 3
    Last Post: 08-03-2013, 09:39 AM
  5. Changing Hyperlink To Another Sheet By Changing Value Of Cell
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 04-30-2011, 11:55 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
  •  

Forum Rules