Creating a summary sheet

[Patricia]

I have a spreadsheet that is about 200 rows down and 60
columns accross. I want to create a second summary tab
that will pull over only certain columns from
the "detail" sheet. As I update the detail sheet I want
to also update the summary sheet - so far no problem, but
if I add a new row in the detai sheet - how can I also
add the same row in the summary sheet and only bring over
columns I want on the summary sheet (the columns are not
next to each other)
Paste link does not insert the row in the summary sheet
unless I drag the formulas - which I do not want to do.

Is there a way to do this?
Thanks

 

[mudraker]

Patricia

As yOu do not want to use formulas the only way I know of would be
macro.

If you are not familuar with macros post a reply here giving details o
the :
sheet name to be copied from
sheet name to be copied to
which columns is to be copied from and pasted into which columns on th
summary sheet

Is the same row number to be used on the summary sheet the row numbe
that the data was copied from



How do you want the macro to be triggered.

By a button
or
by the contents of a certain column being changed
or
some other metho