Results 1 to 4 of 4

Thread: changing arrangement of data to new style

  1. #1
    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

  2. #2
    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.

  3. #3
    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

  4. #4
    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.

Similar Threads

  1. Replies: 8
    Last Post: 09-04-2014, 02:45 AM
  2. 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •