+ Reply to Thread
Results 1 to 3 of 3

create a table based on values selected in rows and columns

  1. 08-13-2015, 03:21 AM #1
    hemagala
    hemagala is offline
    Registered User
    Join Date
    07-30-2015
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    3

    Lightbulb create a table based on values selected in rows and columns

    Hi friends,

    I really need your help with this macro code.

    I am looking out for a macro code in the attached excel, wherein if I enter the no of rows and columns it should create a tables in a separate new sheet with sheet name as the question no. Also the table should have all the row labels and columns label I enter.

    Regards,
    Hema
    macro.xlsx
    Reply With QuoteRegister To Reply
  2. 08-13-2015, 09:50 PM #2
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: create a table based on values selected in rows and columns

    see attached file

    Please Login or Register  to view this content.
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 08-14-2015, 03:46 AM #3
    Parth007
    Parth007 is offline
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: create a table based on values selected in rows and columns

    http://www.excelforum.com/excel-prog...ml#post4161131
    Regards
    Parth

    I appreciate your feedback. Hit * if u Like.
    Rules - http://www.excelforum.com/forum-rule...rum-rules.html
    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] create a dynamic table based on selected check boxes
    By melody10 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-13-2015, 07:28 AM
  2. [SOLVED] Auto populate columns based on selected values in a cell
    By abdulji in forum Excel General
    Replies: 7
    Last Post: 07-23-2015, 02:23 AM
  3. Create criteria-based summary table from table rows across sheets
    By Alibumaye in forum Excel General
    Replies: 2
    Last Post: 04-16-2013, 06:17 AM
  4. Highlight rows and columns of selected cell within a table
    By tiny4725 in forum Excel General
    Replies: 0
    Last Post: 10-15-2012, 01:58 PM
  5. VBA: formatting cells in multiple columns based on selected rows
    By muckem333 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-06-2011, 01:43 PM
  6. SUMIF to add values only from selected rows based on a list
    By ride_op in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 12-06-2010, 08:38 PM
  7. [SOLVED] Create a report with selected rows based on the content in a cell
    By ThirdTim in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-05-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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1