+ Reply to Thread
Results 1 to 3 of 3

dragging sheets like dragging cells.

  1. #1
    Registered User
    Join Date
    03-02-2017
    Location
    HAIFA
    MS-Off Ver
    2013
    Posts
    2

    dragging sheets like dragging cells.

    Hey,

    I have a table with about 100 rows, and i need to create a sheet for each row that will contain information from that row in certain cells in that sheet. Now i want to create one sheet, and then duplicate that sheet (drag it somehow) so that each sheet will contain information from it designated row.

    example

    cell B4 in sheet 1 will contain cell a1 in the original table
    cell B4 in sheet 2 will contain cell a2 in the original table
    cell B4 in sheet 3 will contain cell a3 in the original table.

    and so on.

    tnx.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,801

    Re: dragging sheets like dragging cells.

    Hi, welcome to the forum

    I would 1st question why you feel you need to duplicate data 100 times (in 100 sheets)? there are far better/simpler/more efficient ways to extract data from a data sheet (you cant "drag" sheets the way you want to, anyway)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    03-02-2017
    Location
    HAIFA
    MS-Off Ver
    2013
    Posts
    2

    Re: dragging sheets like dragging cells.

    thanks.

    I have a table with information about 1 product in each row. Now each product needs to have a separate sheet where this information needs to be included. if i could create one sheet, and then drag it, excel would "know" that it needs to jump a row when creating the next sheet, and then i would have similar 100 sheets with information about 100 different products. 1 in each sheet.

+ 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. Dragging across sheets
    By Allen_dulles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2016, 02:10 AM
  2. Dragging same cells across from different sheets
    By Stu.martin01 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-09-2012, 06:57 AM
  3. SUMIFS and VLOOKUP combination across sheets; dragging formula
    By alillian in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-09-2012, 10:21 AM
  4. Dragging Cells
    By jsohng in forum Excel General
    Replies: 3
    Last Post: 04-14-2011, 03:15 PM
  5. Dragging formulas that refer across sheets
    By DPGDPG in forum Excel General
    Replies: 6
    Last Post: 11-23-2009, 04:31 AM
  6. [SOLVED] Dragging formula linked to diff sheets
    By Chrism in forum Excel General
    Replies: 2
    Last Post: 09-10-2005, 07:05 AM
  7. Dragging cells
    By spog00 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-22-2005, 10:24 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1