Hi
I have an excel workbook that I want to create formula with data from a separate sheet. Is there a way I can export and import data from a record to the excel sheet that is use as my lookup? I need these to be fixed columns and rows since I have formulas that will reference to them.
Thank you in advance.
Hi Mike, I want on a click of a button for a selected record, export that record data to excel via excel template. I need it export in a fixed column and row. This is because in the template I have another sheet with formulas that will reference to the data exported.
Hi @pnguyen1241
I am sorry I am not following, can you add a step by step run of what you mean?
Just by reading it though I would say yes, I would use a Power Automate Flow.
Depends on if it runs on a Schedule, manual, triggered by a Power App, Triggered FLow etc
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey