I seem to be having a bit of a problem, I'm using Google Spreadsheet and have created a form that people would be able to fill in online. It sends that data to a sheet called 'Raw Entry Form', I then take that data and by using
'RAW Form Entry'!C8
I put the data into another sheet. However every time someone fills in the form and it updates that data the cell formula changes from say 'C8' to 'C9', the more forms, the bigger the number gets.
I believe it may be due to the form adding a new row each time someone enters new data, thus moving the cells down and increasing the number.
Does anyone know how to fix this?.