Hi
I will start by saying I don't know if this is possible to do but I feel some very smart person on here will have a solution for me
What I want to do is the below
Please see the sample Sheet attached
I would like to have a list of terms (Shown on the Request sheet)
I would like Excel to search those terms on a the sheet called Stock Sheet
Upon finding a matching result I would like Excel to Copy the entire row which the result occurs on to a Results sheet (Shown as results sheet)
and that row to be removed from the Stock Sheet. (Example shown on sheet Stock sheet results) I would not want it to create a new sheet I would want it to remove them from the original Stock Sheet to end up looking like (Stock Sheet Results)
If it cannot locate a corresponding result, it simply skips that search term but leaves empty row in that result
Basically its like the below
Say this is my search terms
Avatar: The Burning Earth (Xbox 360)
Avatar: The Burning Earth (Xbox 360)
Bakugan: Battle Brawlers (Xbox 360)
Battle Fantasia (Xbox 360)
Battle for the Pacific (Xbox 360)
on my stock sheet they appear as this
Bakugan: Battle Brawlers (Xbox 360) Pre-Owned X360 £2.96
Avatar: The Burning Earth (Xbox 360) Pre-Owned X360 £8.59
Bakugan: Battle Brawlers (Xbox 360) Pre-Owned X360 £2.9
Avatar: The Burning Earth (Xbox 360) Pre-Owned X360 £8.51
Battle-Fantasia (Xbox 360) Pre-Owned X360 £4.00
Bakugan: Battle Brawlers (Xbox 360) Pre-Owned X360 £2.90
Battle for the Pacific (Xbox 360) Pre-Owned X360 £5.21
Avatar: The Burning Earth (Xbox 360) Pre-Owned X360 £11.27
I would want it to search the stock sheet and generate the below Results Sheet
Avatar: The Burning Earth (Xbox 360) Pre-Owned X360 £8.59
Avatar: The Burning Earth (Xbox 360) Pre-Owned X360 £8.51
Bakugan: Battle Brawlers (Xbox 360) Pre-Owned X360 £2.90
(None Found)
Battle for the Pacific (Xbox 360) Pre-Owned X360 £5.21
Leaving the stock sheet looking like this
Bakugan: Battle Brawlers (Xbox 360) Pre-Owned X360 £2.96
Battle-Fantasia (Xbox 360) Pre-Owned X360 £4.00
Bakugan: Battle Brawlers (Xbox 360) Pre-Owned X360 £2.90
Avatar: The Burning Earth (Xbox 360) Pre-Owned X360 £11.27
As you can see Battle-Fantasia (Xbox 360) is spelled differently here, this would be an error and I would want the results sheet to show (None Found instead)
It is crucial that it removes the full row and there will be multiple of each so it must only remove the amount shown in the search terms so if 6 appear on the search terms 6 would be removed from the stock sheet and finally its crucial the results sheet is in the exact same order as the search terms sheet leaving gaps (Such as (None found)) when a result cannot be located.
If somone can come up with a way to do this for me I would be eternally grateful and you would officially be extremely smart haha
Thanks for anyone who has taken the time to read this and of course an extra thank you to anyone that can offer me a solution
Hope everyone had a Great Xmas and hope everyone has a great new years!
Thanks
Samuel
Bookmarks