I apologize for my English, I teach it less than 6 months.
Register in Google, if there is no account. And create a new table.
https://www.google.ru/intl/eng/sheets/about/![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fa.radikal.ru%2Fa08%2F1804%2Fbe%2F73ec3432522a.jpg&t=663&c=iFOZegvxQbwK7Q)
![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fb.radikal.ru%2Fb35%2F1804%2Fb7%2F166ba4c5368f.jpg&t=663&c=YasikimMfHaaIw)
Here is a table where the Manager puts stakes
![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fc.radikal.ru%2Fc03%2F1804%2Fe4%2Fa83b5459faee.jpg&t=663&c=SzO5Is6VrEodYA)
We are interested in the code of table 1h-8ps9VQNQK033gyc09-rBOSvPVbSoZpcuwy-fz0jms, also the name of the sheet (in this case Twitter) and our line number(for example, take №6)
![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fc.radikal.ru%2Fc06%2F1804%2Fbf%2Ffb93ddd61e5c.jpg&t=663&c=wQU7yVA69pRBpg)
In the table we created, we fill in: 1 line - the name of the bounty, 2-in which company we participate (in this case, Twitter) and in the third line we copy the function, which will import data:
=IMPORTRANGE("1h-8ps9VQNQK033gyc09-rBOSvPVbSoZpcuwy-fz0jms"; "Twitter!A6:O6")
where:
1h-8ps9VQNQK033gyc09-rBOSvPVbSoZpcuwy-fz0jms table code where Manager puts points
Twitter sheet name from the same table
A6 and O6 start column and end column of the table and our row number
A very convenient feature (binding to the name) is when the Manager constantly edits the table (removes rows) and this changes the binding of the row number.
To do this, I advise you to have a separate table, because it will constantly import data from many cells of other tables and with a large number of bounties it will be possible to add. But the convenience of it is still overlaps.
In the first line, I bring the company name and a link to the Manager table for a quick transition to it.
![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fd.radikal.ru%2Fd14%2F1805%2F20%2Fbbd696a33cb2.jpg&t=663&c=F5jfr3BP_rC-_Q)
From the Manager table we need the following data:
![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fc.radikal.ru%2Fc01%2F1805%2F14%2F33b39063cb18.jpg&t=663&c=QKR_pfGih-u7hw)
In the second line we write the function =VLOOKUP this type:
On my screenshots there is a function =BПP, but in the English tables you need to use =VLOOKUP. Google sheets won't let me use it.
=VLOOKUP("AAA";IMPORTRANGE("BBB"; "CCC!B1:V5800");1;0)
Where AAA - string name to bind (Bitcointalk username) it will be the beginning of our range for importing data
BBB - the reference to the table Manager (
https://docs.google.com/spreadsheets/d/160LpOlxJmkWwwE_2BPzIwbDsVMJWyyAq6iLIxUvqCqI/edit#gid=1086350140)
CCC - the name of the sheet from where the data will be imported
B1:V5800 - range for importing data
1 - column number from our range for importing data
0 - leave as is
As a result, we get this function:
=VLOOKUP("Bitcointalk username";IMPORTRANGE("
https://docs.google.com/spreadsheets/d/160LpOlxJmkWwwE_2BPzIwbDsVMJWyyAq6iLIxUvqCqI/edit#gid=1086350140"; "Twitter!B1:V5800");1;0)
![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fc.radikal.ru%2Fc05%2F1805%2F9b%2F8b0953cd787b.jpg&t=663&c=wdQoTAirkyODlw)
The third hundred-fate prescribed the same exact function only change in it the name of the row for the binding (our nick)
=VLOOKUP("madnessteat";IMPORTRANGE("
https://docs.google.com/spreadsheets/d/160LpOlxJmkWwwE_2BPzIwbDsVMJWyyAq6iLIxUvqCqI/edit#gid=1086350140"; "Twitter!B1:V5800");1;0)
If all have made correctly get.
![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fc.radikal.ru%2Fc19%2F1805%2Fb2%2F3dde790e147f.jpg&t=663&c=3jyR1-sHNzbevg)
Next, copy both rows as many times as many columns we need to import from the Manager table.
![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fc.radikal.ru%2Fc21%2F1805%2Fe7%2F12505b6f7ec5.jpg&t=663&c=-JQAM_26CbMLZQ)
Change 1 at the end of the function to as much as the desired column is moved relative to the beginning of our range.
![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fa.radikal.ru%2Fa43%2F1805%2Fc7%2Fa856374a2998.jpg&t=663&c=q7NtI9WB0jRLKQ)
In the next two columns, too, change 1 to the desired column from the Manager table
![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fd.radikal.ru%2Fd39%2F1805%2Fbb%2Fd02e179c038e.jpg&t=663&c=lBo992AQ2FDq1g)
Here such it turns out our table.
![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fd.radikal.ru%2Fd34%2F1805%2F80%2F03aa1112e37a.jpg&t=663&c=t3l1wji7p9SOMw)
At first it seems that it takes too much time for this, but a little understanding you understand that such tables are made with ease. It is very convenient if you make such a table from the beginning of bounty and then do not have to edit anything.