Forum Discussion
Amy Vigouroux
Dec 10, 2017Copper Contributor
Automatic update of worksheet name in formula
I have several worksheets within the same workbook in which data is pulled from a worksheet titled "2017 Budget". I would like to update this workbook with my 2018 budget numbers. Is there a way t...
FAUSTOSOBRINHO
Jan 23, 2021Copper Contributor
Hi, Amy, I have a different problem, but I believe also related to the automatic update of worksheet name in formula: I decided to use lambda function to turn into formula a long command line, which had been working perfectly until then. The LAMBDA function also worked perfectly the first time. As soon as I closed the workbook and rebooted it, the function stopped working. I manually deleted the reference to the page at the beginning of the function and it returned to work. If you or others at the Tech Community can help with that too, I'd be very grateful.