Hi,

I need to pull information from 2 tabs (one has header info; Wor Summary and the other raw data; WoR Questionnaire) and are within the same worksheet and have it automatically copy it into another spreadsheet. I wrote the code below the line and the code when individually for each tab works fine ... but when combined I only pull information for the 1st tab (Wor Summary) and it doesn't pull information from the 2nd tab (Wor Questionnaire). I think it's failing at the part where it has;

End With
r = r + 1
End If
Next
Application.ScreenUpdating = False
Application.DisplayAlerts = False

Cuz it thinks it needs to stop therefore it fails to go to the next code to run to pull data from the next tab. Can anyone help me please?

Please Login or Register  to view this content.