Forum Discussion
Automating import data into stylized excel sheet
I was wondering if there was a way to auto populate an excel sheet. I am importing data from DOMO into excel. I have to rename the same cells and stylize the same sheet over and over again the same way everyday just with different information getting imported. Is there a way to automate making this excel sheet? I use basic functions also that I would like to pre-do as well. The cells would stay the same just the data in them would change.
1 Reply
- You can do this with a Power Query! Go to the Data ribbon in Excel and click on Get Data. You can make all required changes and Excel will record this as a query that you can re-use.
