PDA

View Full Version : Cut Paste macro



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.

mdmackillop
07-21-2008, 01:40 PM
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
07-22-2008, 04:48 PM
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