I would like to know how to

insert a record within a list of data which groups
automatically selected records (A bit like what adding
subtotals does) which will contain different types of
formulas like a vlookup.

I want this instruction to be added automatically either
by a button or when a new group of records has started to
be entered.

rows(3).Insert
Rows(3).Cells(1,1).Formula = "=Vlookup(""abc"",Sheet2!A1:Z26,8,False)"


Beyond that, you would need to provide more details on what you want.


Regards,
Tom Ogilvy


"Gary Constable" wrote in message
...
I would like to know how to

insert a record within a list of data which groups
automatically selected records (A bit like what adding
subtotals does) which will contain different types of
formulas like a vlookup.

I want this instruction to be added automatically either
by a button or when a new group of records has started to
be entered.

I Want the macro or code to select all the data within a
list. Approx 10 columns by 5000+ rows.

At each change in a particular columb i want the macro to
insert a new row and add all the values with in that group
per column (like inserting subtotal) but as well as adding
i want it to insert forumlas that i specify as well, like
a vlookup.

Regards,

Gary


-----Original Message-----
rows(3).Insert
Rows(3).Cells(1,1).Formula = "=Vlookup(""abc"",Sheet2!
A1:Z26,8,False)"


Beyond that, you would need to provide more details on
what you want.


Regards,
Tom Ogilvy


"Gary Constable" wrote in
message
...
I would like to know how to

insert a record within a list of data which groups
automatically selected records (A bit like what adding
subtotals does) which will contain different types of
formulas like a vlookup.

I want this instruction to be added automatically either
by a button or when a new group of records has started
to
be entered.


.

Why not start by turning on the macro recorder and use the subtotal function
under the data menu. This will get 90% of the work done with one line of
code. Then you can add code to achive the rest.

--
Regards,
Tom Ogilvy



"Gary" wrote in message
...
I Want the macro or code to select all the data within a
list. Approx 10 columns by 5000+ rows.

At each change in a particular columb i want the macro to
insert a new row and add all the values with in that group
per column (like inserting subtotal) but as well as adding
i want it to insert forumlas that i specify as well, like
a vlookup.

Regards,

Gary


-----Original Message-----
rows(3).Insert
Rows(3).Cells(1,1).Formula = "=Vlookup(""abc"",Sheet2!
A1:Z26,8,False)"


Beyond that, you would need to provide more details on
what you want.


Regards,
Tom Ogilvy


"Gary Constable" wrote in
message
...
I would like to know how to

insert a record within a list of data which groups
automatically selected records (A bit like what adding
subtotals does) which will contain different types of
formulas like a vlookup.

I want this instruction to be added automatically either
by a button or when a new group of records has started
to
be entered.


.