I am copying data from a web site to creat a excel data base. Sometimes the data will populate 8 rows and other times 9 rows. I have formulas set up to parse the strings. I need a macro that will delete all the cells in between the cells with the key words. I copy this data and paste it to another sheet.
Last edited by bh36303; 11-12-2012 at 10:00 AM.
I'm betting that if you attached a spreadsheet that shows what data you have, where it is, and what data you want saved for copying, someone on here would be able to help you out. It's best to not leave geniuses guessing. Strange things happen when geniuses resort to guessing. Strange things, indeed.
- Moo
Here is my attachement.Attachment 192746
Here's the code used in the attached sheet. Run it WITH SAMPLE DATA -or- A COPY OF YOUR ACTUAL DATA! Remember... there is no "UNDO" when running macros! You can run it in the attached file. It doesn't matter if there are 8 rows or 9, because it will always look for the lastrow (lr) with a value in column A, then delete from A2:lastrow - 1, and shift the rest of column A up.
Hope it helps!
Please Login or Register to view this content.
- Moo
Last edited by Moo the Dog; 11-10-2012 at 03:28 AM. Reason: updated code to include sheet references
Moo,
That worked great but I didn't give you enough details. I have data underneath that I need to keep. I have attached a file with the original data that I am working with. I apologize for the lack of details.
Brett
Do you mean like this?
Please Login or Register to view this content.
Thanks Jindon. Was just about to post a similar response then saw yours. Good work.
- Moo
jindon,
That worked perfect. Thankyou very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks