Forum Discussion
Help with Excel Form autopopulating into another sheet.
Hello, I have a excel form which I use to input catering information. I input the data and then sort it with a timestamp so that the most recent information is at the top. There is a separate ...
You may be able to use the INDIRECT function, for example
=INDIRECT("'Form Sheet'!A2")will refer to A2 on Form Sheet even of you sort, insert or delete rows on that sheet.