Forum Discussion
aidanjames
Oct 23, 2023Copper Contributor
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 ...
HansVogelaar
Oct 23, 2023MVP
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.