Updating new inserted sheet in excel
I have a excel workbook with 3 sheets, sheet1 contains all the data which is split into remanning 2 sheets.
A good design will accommodate most growth and changes, but often, you find yourself working with a data set that doesn't conform well to what you need to do.
The information needs to be displayed on separate sheets when the user needs to view lockers by area such as the "Men: Clean" area.
There are other areas such as "Women: Clean" and "Distribution" that have to be on their own separate sheets.re: "If there's any way to set it up to do the macro automatically, and update the records on the other sheets, that would be fantastic."I think it could be done automatically, but I still need to know more about your process.
In a moment, you will learn all these and a few more date entering techniques.
If you are curious to know how Excel stores dates and times, please check out part 1 of this tutorial - Excel date format.