+ Reply to Thread
Results 1 to 3 of 3

Advice and Examples on how best to arrange data

  1. #1
    Registered User
    Join Date
    01-22-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    75

    Advice and Examples on how best to arrange data

    Hi All,

    I need some advice on how to best arrange information on two spread sheets I'm attaching to this thread.

    The first spread sheet entitled "tabs" has too many tabs but I like how each tab contains all the info I need.

    The second spread sheet entitled "datescroll" has everything on one tab BUT dates are too spread out requiring you to scroll all the time to see all the dates. I'd like to be able to see all tabs and dates (a month at a time) on a single tab if possible.

    tabs.xlsx

    datescroll.xlsx

    Examples and/or suggestions would be greatly appreciated - Thanks in advance!

  2. #2
    Registered User
    Join Date
    09-05-2009
    Location
    Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    55

    Re: Advice and Examples on how best to arrange data

    my suggestion would be in attachment as sheet name NEW





    Vorabha
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-22-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    75

    Re: Advice and Examples on how best to arrange data

    Hi vorabha,

    Nice - thanks so much!

    I'm open to other suggestions if anyone else has them please don't hesitate to share!

+ 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. Data Manipulation Examples
    By davesexcel in forum Tips and Tutorials
    Replies: 4
    Last Post: 12-15-2019, 09:30 AM
  2. Examples of Data Entry
    By Jonathan78 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2013, 06:54 AM
  3. Splitting data from cells (examples included)
    By Memort in forum Excel General
    Replies: 8
    Last Post: 04-12-2013, 06:31 AM
  4. [SOLVED] Examples of using Bloomberg API / real time data with Excel VBA?
    By 12Keys in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2006, 11:10 AM
  5. Looking for Userform examples - site on web, download examples
    By thom hoyle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2005, 01: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