Wondering if this is possible. I have a spreadsheet of 40k entries. Basically names and addresses of property owners. I would like to be able to search for a certain word (in this case "Heir") throughout the spreadsheet and be able to find every line containing that word and place it in a separate spreadsheet. Is this even possible? It would be awesome to be able to sort like this.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Need help scrubbing a spreadsheet
- Thread starter PSpence
- Start date
bebo021999
Well-known Member
- Joined
- Jul 14, 2011
- Messages
- 2,469
- Office Version
- 2016
Could you pls share image/screenshot/XL2BB of the main sheet? We dont have the location.
Upvote
0
Upvote
0
bebo021999
Well-known Member
- Joined
- Jul 14, 2011
- Messages
- 2,469
- Office Version
- 2016
Does "Heir" only appear in column R and S? or other columns?
Upvote
0
I only need it from Column R but it does appear in other columns.
Upvote
0
I wouldn't mind it pulling from anywhere on the sheet but the main column I need would be Column R
Upvote
0
bebo021999
Well-known Member
- Joined
- Jul 14, 2011
- Messages
- 2,469
- Office Version
- 2016
Do you know which columns could contain ownwer's name? from column R to the right, or from R to U, for instant?
what the table size could be?
Serching in whole sheet reduce the code speed.
what the table size could be?
Serching in whole sheet reduce the code speed.
Upvote
0
Columns R, S and T could contain the word "heir" in them. Is that what you mean?
Upvote
0
I'm quite new to anything beyond basics in excel. I use it frequently though and this would be a future common task if I can find a way to do it.
Upvote
0
You didn't specify what you want copied to a different sheet. The entire row of data? if so we need to know the the range of your data, ie what columns are involved. If you only want certain cells copied to a different sheet, what are they.
Upvote
0
