Excel spreadsheet question
I have multiple different sheets with computer dates on them. I’m trying to come up with a replacement pattern for these computers. I want to replace the oldest computers first, but I also want to spread out the replacement of the computers over different departments. I have these departments organized in different spreadsheets? Is there a way for me to have excel automatically poll, a list of computers from those differing a spreadsheet’s without me, having to go and manually pick, and organize all of these computers into a single table.
Concentrate on one task at a time.
Step one seems to be collecting the data. If all the spreadsheets are in the same workbook (Excel file), you can use the VBA worksheets collection to cycle through them. If you have multiple workbooks containing the worksheets, the VBA workbooks collection provides a similar capability. Within a workbook, you need some method of determining the range of cells containing the data you need. You can copy that data to a new workbook/worksheet and append additional data as you process each set.
Once you have the data collected, you can sort as often and in as many different ways as you need.
You don't want to overburden any department and you want the replacement project to last five years with activity each quarter. That is 20 activities so you can replace the oldest 5% in each department each quarter. Conditional formatting could identify the candidates for you.
Sign in to comment