+ Reply to Thread
Results 1 to 2 of 2

Returning transposed data from multiple tabs

  1. 02-06-2015, 08:10 AM #1
    letstuffhappen
    letstuffhappen is offline
    Registered User
    Join Date
    08-07-2014
    Location
    London:England
    MS-Off Ver
    2010
    Posts
    7

    Returning transposed data from multiple tabs

    Is there a formula possible for me to return data transposed from multiple tabs?

    Find attached example document. The information in each country tab is inputted manually, i would like the data to be collected together automatically. Returning transposed data from multiple tabs.xlsx
    Reply With QuoteRegister To Reply
  2. 02-06-2015, 10:27 AM #2
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Returning transposed data from multiple tabs

    Try this macro.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA code to merge multiple sheet with multiple tabs into one workbook in different tabs
    By Jagdev in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-06-2015, 07:42 AM
  2. [SOLVED] summing multiple sub-tabs where each sub tabs row data is not the same
    By waternut in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-11-2014, 01:44 PM
  3. [SOLVED] Importing Data from Multiple Excel Forms into Multiple Tabs in New Workbook
    By hollybo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2014, 03:42 PM
  4. Finding and returning multiple values in colomns across two tabs.
    By leaveit2bevo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-01-2013, 01:21 PM
  5. Multiple rows with the same name transposed to one row
    By keeper882 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-16-2012, 11:54 AM

Tags for this Thread

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1