+ Reply to Thread
Results 1 to 4 of 4

Possible Array, or Transpose?

  1. #1
    Registered User
    Join Date
    04-24-2013
    Location
    Scotland
    MS-Off Ver
    Excel 2013
    Posts
    43

    Possible Array, or Transpose?

    Attached simple example of what I am trying to achieve.
    Also attached the original method which got too complicated for my next step, hence trying to do in VBA.

    Basically, looking to have the master sheet be populated with all variations of project and sub number found on any subsequence worksheet in columns a+b.

    Then to sum the total values of all instances of that specific project/sub number.

    Please Login or Register  to view this content.
    thought about modifying the above code to search all worksheets???
    but that only does the first bit populating the list...
    how then do I return and sum the time values?

    Any help would be very much appreciated.

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Possible Array, or Transpose?

    Hi Fred,

    This may be better:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    04-24-2013
    Location
    Scotland
    MS-Off Ver
    Excel 2013
    Posts
    43

    Re: Possible Array, or Transpose?

    thank you for your help.
    for some reason I get a "subscript out of range error 9"

    also, can you point towards how I can make this work to collate collumns A & B across multiple worksheets onto one master sheet?

    Thanks

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Possible Array, or Transpose?

    Maybe:

    Please Login or Register  to view this content.
    For the other just keep changing the column number

+ 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. Transpose Array VBA Script
    By King_Yoshi in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 09-02-2014, 08:16 PM
  2. [SOLVED] Transpose a table's first row into an array
    By jimmalk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-23-2012, 05:33 AM
  3. [SOLVED] How to transpose a bidimenional array
    By nemo66ro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2012, 07:10 AM
  4. [SOLVED] Transpose an Array
    By Aphyx in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-28-2012, 10:51 AM
  5. VBA Array Formula cant transpose to rows
    By Redline in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2011, 02:09 PM
  6. Conditional transpose to Array
    By reachthepalace in forum Excel General
    Replies: 0
    Last Post: 03-01-2006, 06:36 PM
  7. Out of Memory: Array Transpose
    By TheVisionThing in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-01-2005, 04: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