I need to combine the information in the 4 spreadsheets below and some of the spreadsheets do not allow downloading/copying and may use plugins/programs etc. They also are NOT formatted the same. So this might require lots of manual work. Ideal candidates are from non USD/EURO economies.
Summary of what I need in the end:
A master overview sheet that shows the following columns
1st column ICO - A list of any ICO listed in any of the 4 spreadsheets sorted alphabetically in the following format 'Name (SYMBOL)' ie 'Bitcoin (BTC)' casing matters. Then ADD LINK to the field with a direct link the companies ICO website ie 'http://ico.bttcoin.io'
Author columns: BUDDY (Buddy will be for my own field to enter data later), SERGIO, THEGOBONE, IANBALINA, OHHEYMATTY - These columns will show a number (1-999) showing how high the ICO was listed on their sheet when sorted by potential ALSO there will be conditional formatting as follows : if the item is listed in another authors column in a top 25 position it will highlight the background green
Fact columns (These should be the same information across all 4 spreadsheets if not we need to visit the ICOs website and find the actual data) : Price, Time left, Start date, End datICO Bonus, Circulation, Supply, Hardcap, Team%, Advisor%, Dividend (yes no), Inflation (yes no)
Time left field: This should compare todays date to the start date to create a countdown timer and within 7 days background green, 5 days yellow, 1 day red