how to automatically insert a row in other sheets when i try to insert row in sheet one.

Hello hethu81,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

Originally Posted by hethu81

Can someone replies to this thread.
...

... here you go, some replies to this Thread, matey – boyo.. :

Hi hethu81,
Welcome to Excel Forum
( I have Ate one too, so do lots of poos just now, never mind )

The simple answer is YES, it can be done and it is usually very easy. You probably do not have any replies as this is just the Sub Forum to say hello

What you would / should normally do if you have a question or need help is the following:
Start here, https://www.excelforum.com/ , then look for an appropriate Sub Forum to post your question in:
start a new Thread in one of these sub forums if you need help:
http://www.excelforum.com/excel-general/
or here:
http://www.excelforum.com/excel-formulas-and-functions/
or if you would consider a macro solution then here:
http://www.excelforum.com/excel-programming-vba-macros/

If you are not sure, then probably the first will do
http://www.excelforum.com/excel-general/

_.....................

Please, also, if you get time, take some time before posting to read the Forum Rules here
http://www.excelforum.com/forum-rule...rum-rules.html
http://www.excelforum.com/forums-rules/
http://www.excelforum.com/developmen...ml#post4606484
It is usually worth it in the long run.


Thanks
Alan


_.....

P.S. some more replies, Just to get you started….
Attatched is a very very simple file to get you started ( hethu81QuickOne.xlsm ) :

( When the file is opened you may need to say yes to enabling macros)

Type anything in the first worksheet.
The second worksheet should then look the same

This very simple way of doing things is not very efficient, and probably not exactly what you want. To give you something better you would need to give us a bit more detail.


_.________

Code:

Please Login or Register  to view this content.

The above code must go in the code Module of a Worksheet. See Here: http://imgur.com/Vjih5rk

( In the uploaded file I have it in the code module of the first worksheet: http://imgur.com/pUxrFl7 )

_... and here another replies for you:

If you put this code instead into a Worksheet code module, then the following happens:

If you select an entire row ( all columns ) in the Worksheet in whose code module is in, then a row is inserted into all worksheets at the selected row:

Please Login or Register  to view this content.

Alan

As no one will probably ever read this, I can do my weekly Poo here: Poo ! :-) Actually just now I am doing rather a lot of watery Poos as I have very bad diarrhea for over 4 days. The doc says I should go in Hospital , but I am trying to avoid that.. Oh well