Please bear with me, I have limited spreadsheet knowledge.
I’m trying to make a sheet for my husband for our hobby. It involved the website NationStates, a online country simulator. I need the sheet to check to see who has endorsed a certain person and list out the nations, if that makes sense. Basically just check a section of the page and list out the nations there.
I have tried Sheets–>Link to external data and it pulls the webpage, but sadly it pulls ALL of it and has the nations all on once cell. I tried changing up the table ranges, but it just pulls other data from the page.
I’d just copy the info over, but I need to sheet to update everyday as the info can change. I’m worried that if I delete all the useless info and rearrange the nation names, that the sheet won’t update properly.
Any help is greatly appreciated!