Hello everyone,
I need to find the range of the listed variables in a column and delete all but the last one in the row. So, I could assume that I'll see "100" like 2400 times, I'd like to find the range of all but the last row, and delete it shifting Excel up keeping that last row. I should be able to do the rest myself, just need help on the Range part.
Attached is sheet with some data in it and perhaps a better explanation.
Unless you have over simplified this, why not use Advanced Data -> Filter -> Unique items. Then copy & paste
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Because this is ran as a sub Routine to sort out data from 100-800. There's a ton of Data to the Right of the column that I cant share, but since it'll be deleted as well, I don't need to.Originally Posted by royUK
It's also ran in the middle of a huge script that's grabbing data from an access Database and pasting it all over the place in different Tabs.
I'm also unfamiliar with the Filtering tool. Would like to aviod things like hard coded ranges ("A3") cause the Data can start and end differently each time the macro is ran.
I think I see what you're saying. Is there a better way to code this in other then recording a Macro?
Also, will it shift my Data to the right along with the filtered column?
Okay, it looks like the filter is working correctly. The first row is incorrect however. The Data that corresponds to the right of it doesnt seem to match what I have recorded in the Database. Its filtering the first point instead of the last for 100. 200-800 are correct and I've verified. This will work, but I need to correct the 100, any ideas?
Last edited by Ageia; 11-26-2008 at 02:26 PM.
Solved, Thanks again!
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks