VBA Help - Insert a row in Sheet 1 and it automatically inserts in Sheet 2

[dholiman]

Hi all,

I am looking for help on this inquiry I have.

I have attached my sample excel sheet.

I have 4 sheets at the bottom labelled 'May', 'Jun', 'Jul', 'MIS May'

May, Jun, Jul are the exact same format

what I am looking to do is:
I want to insert a blank row between line 10 and 11 (New york rangers and chicago blackhaws) in the May sheet
I want that blank inserted row to be reflected in sheet Jun and sheet Jul.
The twist is when I enter information in Column A to D in that newly inserted row in Sheet May, the inserted rows in sheet jun and sheet Jul should automatically pick up the information and display. Consequently, Column E to P has a formula so the inserted row in sheet Jun and Sheet Jul needs to have a forumla that can pick up information from sheet 'MIS Jun'

Thanks in advance for any help.

[dholiman]

bump



bump