Two sets of code on my spreadsheet, one won't run automatically while the other will

[steve80s]

Hi All,
A few months ago someone helped me create a Macro/Code for my spreadsheet. What happens is, on the 'Main Tab', when Y is entered on column R, the code automatically copies some data from this row to the 'Bloods Log'. This works perfectly. However, I set up the same thing for the 'SEN & LAC' tab. In this case, it should look for when Y is entered in column S, and then copy the information from that row to the same 'Bloods Log', so the 'Bloods Log' builds a list from both the 'Main Log' and 'SEN & LAC' tabs. Hope that makes sense!

Anyway, the code for the Main Log works perfectly whenever a Y is entered, but the code for the 'SEN & LAC' log won't run automatically. The only way I can get it to copy the data over to the 'Bloods Log' is for me to Run Macro from the menu.

Can someone please look at my draft (link below) and help fix this problem?

Thanks in advance!

My spreadsheet

 

[johnnyL]

Your 'Main Log' sheet uses:

Private Sub Worksheet_Change(ByVal Target As Range)

your 'SEN & LAC' sheet is using:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

 

[steve80s]

Your 'Main Log' sheet uses:

Private Sub Worksheet_Change(ByVal Target As Range)

your 'SEN & LAC' sheet is using:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Easy as that! Thank you @johnnyL

 

[johnnyL]

Glad to help.