Hello fellow Excel users, I've got a pretty good grasp on using excel but this one stumps me and hoping one of you have an excellent solution.
I'm trying to build a list of title from Discogs seller, that I can match with a want list.
The above is a "Import from Web Page" with enquiry in A1, then G1&H1 using couple of IFs only listing Album Title & Cost.
Due to Discogs search, only 1st 250 of someone's marketplace can be loaded, each title has 5-6 lines of unnecessary info and then I've got another enquiry at around line 1200 to load next 250 titles.
The blue button is a macro that copies all G & H to I & J, then sorts and removes duplicates. K removes using SEARCH everything after last '('.
Then 'L' is conditional formatting on '0' for red cross or '1' green tick.
So what I'd like to do is;
A. somehow edit the WEB PAGE import so I can insert the user by referencing a CELL and execute the enquiry;
E.G https://www.discogs.com/seller/ABC/profile
B. Automate the whole process so I don't need to click the blue button after data downloaded.
Can anyone help please.
Regards
Jeff