jeffsf1967
07-21-2008, 11:49 AM
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.
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.