Forum Discussion
use same formula of reference cell
I have 50 forms of data, the sheet that combines the data from all 50 tabs is called the database tab. Each form has 100 rows of data in the database tab. The first 100 rows relate to the 'template f...
Sounds like you could use the INDEX function to get the data you need. Suppose you put the row # into cell A1 of a Form sheet and you want to get data from column A of your DATABASE tab into a form, starting from cell A3:
=INDEX(DATABASE!A:A,$A$1+ROW()-2)
will give you a formula you can drag down and right. If you need the 50 rows from row 150 and on, just change cell A1.
=INDEX(DATABASE!A:A,$A$1+ROW()-2)
will give you a formula you can drag down and right. If you need the 50 rows from row 150 and on, just change cell A1.