Hi Bob,

Thank you for your reply.

It's too bad that it can't be done. Still it may be interesting wit
the button. Can you give me more details on that? It has to insert row
relative to the rows added in the main sheet.

The other sheets are linked to the main sheet. When the row is adde
can one do it in such a way that the links are also in there?

/Jom

Bob Phillips wrote:
*Inserting a row is not a trappable event, so you cannot do i
automatically.

You could have a button that you click that runs a macro to insert
row on
all sheets.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"vwhungsuriya " wrot
in
message ...
Hi All,

I am working with a couple of sheets in a workbook. In the mai
sheet I
add information and often I add new rows. The other sheets ar
linked
to this main sheet. I know there must be a way such that a new ro
is
added in the other sheets when I add a row in the main sheet. Even
better if it would be possible to have formulas and link
automatically
copied in as well.
I am sort of a beginner and I am wondering if you might have any
suggestions.

Thanks!


---
Message posted from http://www.ExcelForum.com/


--
Message posted from http://www.ExcelForum.com