-
Cut Paste macro
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.
-
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
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
cut paste macro
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules