Help Modifying VBA based on inserting new row in same location on multiple sheets.

[Iomega0318]

I have found the following VBA, I understand how it works but still being new to VBA I don't know how to edit it to do what I need:

Please Login or Register  to view this content.

I have 3 sheets, my main sheet and two other sheets that use formulas to pull data from my main sheet. This works great adding and deleting rows from my main sheet and having it do that same on the other sheets, this also copies the formulas down to the row created in my other sheets saving me a lot of time, however these are a few thigns I need help on:

1. I need to copy cell data and/or formulas (which I found help on this from https://blog.udemy.com/pastespecial-vba/) on the row created in my first sheet but only in columns; K, L, M & Q the rest have to be input manually (this is only on my main sheet).

2. How can I tell it not to do certain sheets if I don't want it to?

Any help would be appreciated, thank you

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[Iomega0318]

I wouldn't even know what to change the title to really, I mean I do need help modifying the code.. Like I said I understand how it works but I am still new to VBA and not sure how to edit it to do the things I need it to..