Inserting Records

  • Thread starter Thread starter Gary Constable
  • Start date Start date
G

Gary Constable

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
 
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
 
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.
 
Back
Top