At my work, we use a spreadsheet to track jobs. We add to it when we take new jobs, and delete rows when those completed jobs are shipped. We use it to track labor in our shop, to see how much work we're taking in vs. how much we're shipping. Is there a way to use a formula to copy cells from those added/deleted rows to another sheet? There would be one cell that adds in the added jobs hours, and another cell to subtract out the shipped jobs hours.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel vs. VBA for recording cells deleted/added to excel that impacted a specific cell
Similar threads
- Solved
