From the course: Excel VBA: Process Modeling
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Manually reset the results cells
From the course: Excel VBA: Process Modeling
Manually reset the results cells
- [Instructor] To be effective, a simulation uses random numbers to generate its results. After you run a simulation, you can delete its results from the results worksheet to make room for a new set of outputs. In this movie, I will show you how to delete rows from an Excel table so that you can run the simulation again with a new set of results. My sample file is Chapter07_02 and you can find it in the chapter seven folder of the exercise files collection. In this workbook I have already run and saved a simulation. So I'll go to the results worksheet and we see the data in the table. You've seen me delete rows from Excel tables before, but I always did it in passing. I wanted to explain the process in a separate movie so you can come back to here in case you forget the steps. The first row of the Excel table has data written in it, but it also has two formulas and those are in Time in System and % Idle, columns G and…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.