If a value in column h = x then copy multiple rows

[BEEROG]

I have been trying to do this with simple formulas, but with no luck. I am not very familiar with VBA, but do write reports in other software. Here's what I am trying to do:

If a cell in column H contains "CALL" I need to copy that row + the following 3 rows to the next worksheet. (Some of the following rows contain merged cells also.)

IE:
If
SHEET1!H30 = "CALL"
then paste
SHEET1!40:43

This seems very simple to me, but I keep running into issues. Please help! I so don't want to be working on this all night. LOL

[JBeaucaire]

Attach a sample workbook. Make sure the data make clear what is needed. Include BEFORE and AFTER sheets in the workbook if needed to show the results you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[BEEROG]

Here is my sample. Any time "CALL" appears in Attendance Tracking!H:H I need the row it is in and the next three rows to copy to Sheet2.

[JBeaucaire]

Try this:

Please Login or Register  to view this content.

[BEEROG]

That worked for what I was trying to do, but of course; the data needed changed, slightly. SO - what all do I need to change in order to make it the three rows above/prior and the row which has "CALL"?

[JBeaucaire]

Like so:

Please Login or Register  to view this content.