I am hoping someone can help.
I have one spreadsheet where we log data and we regularly will add new lines to the bottom. The data is logging non-compliance's so will be numbered sequentially. What I need to see if it is possible to do is we have a second sheet which we want to automatically update from the first, the second sheet though is set out differently and so only some of the information needs to be pulled across. I can link the two sheets on 1 line, but not sure if I can automatically get it to use the next line from the first spreadsheet to update when I create a new sheet in the second.
Hope this makes sense.