Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: still having trouble with adding rows from cell value

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    here's the situation: i have numerous sheets. the last sheet is a summary of all the data, in a table.

    on one sheet, you need to input a number signifying the number of people.

    with the use of a macro, rows are added in the summary table for the names of the people

    but i dont know how to do this.

    please tell me how, by posting the code (in full)

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-25 15:02, Ahjem wrote:
    here's the situation: i have numerous sheets. the last sheet is a summary of all the data, in a table.

    on one sheet, you need to input a number signifying the number of people.

    with the use of a macro, rows are added in the summary table for the names of the people

    but i dont know how to do this.

    please tell me how, by posting the code (in full)
    If A1 is the reference cell

    Sub tester()
    Rows(ActiveCell.Row).Resize([A1]).Insert
    End Sub

    This is dependent on the active cell. Where are these rows being inserted? How are you to identify where to start?

    Not a full solution, but this may help get you started.

    HTH,
    Jay

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    by "active cell", do you mean the cell that is currently selected?

    how would you change "ActiveCell.Row" to a certain row on a certain sheet?

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ok i'll try to be more specific, sparing you unnecessary details of the spreadsheet..

    the summary table and where you put the amount of people are on different sheets

    the macro will activate after you press a button on the number of people sheet, where it inserts the rows (how many depends on the value in the number of people box) into the summary table on the other sheet to accommodate for their names

    ...??

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Never spare details...
    List them all or no-one is
    going to be able to help you...
    Tom

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •