Cut Paste macro

[jeffsf1967]

In a workbook, I need to create an Excel macro to,

Cut/delete rows completely and copy range H-AJ from a sheet named, 'Import TIPS' to rows in range Y-BD in the sheet named, 'Combined Report'

I only want to cut the rows from 'Import TIPS' and paste them to the rows in 'Combined Report' where the data in Col H and Y are the same, respectively. Any rows of data left in sheet 'Import Tips' will be new and I will enter them manually. The sheet is over 1700 rows long and is growing weekly. Manual entry has become nearly impossible to do in a reasonable time frame

The data in col's H and Y are the same but in different order. The macro must also be able to skip blanks and not stop.

Any help with this would be greatly appreciated.

[mdmackillop]

Hi Jeff,
Welcome to VBAX,
Can you post a small sample of your layout?
Use Manage Attachments in the Go Advanced reply section
Regards
MD

[jeffsf1967]

the actual workbook is from A to BU wide and 1759 lines long. I expect the length to change. I have shortened to about 40 lines. Enough for the different variables to show up.

Thanks for taking a look,
Jeff