I have absolutely no idea how codes work and have been purely trying to do this using Google, so you might have to treat me like a child.
Currently, my "Store Price (JPY)" column is populated by the code in the screenshot by looking at the website in the corresponding cell in the "Website (JPY)" column and displaying that price, then converting that number into a regular number instead of the currency the website uses. There is only one price on that website link so it just displays that in the cell. To do this for every card though, I've had to use a different, specific website link for each specific card.
The problem is this is having too much strain on the spreadsheet and it's taking an insane amount of time to populate whenever I open it, especially since I have multiple pages. Is there an easier way for me to do this with less strain and less loading time? I had an idea to have it search https://yuyu-tei.jp/sell/hocg/s/hbp01 instead of each individual card link, then have it check if the card number displayed on the website matches the card number displayed in the "Card Number" column on my sheet, then if it does, it displays that price for that card number in the corresponding cell under "Store Price (JPY)". I have absolutely no idea if this is possible and if it is, if it will solve my long loading issue.
Any help or suggestions would be very appreciated.