still having trouble with adding rows from cell value

[Ahjem]

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)

 

[Jay Petrulis]

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

 

[Ahjem]

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?

 

[Ahjem]

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

...??

 

[Legacy 98055]

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