Hello,
I have a workbook with 2 tabs. Tab 1 (Calculate) this tab has 3 different trainers with topics. #people trained and # minutes trained. Tab 2 (training Log) is the months laid out exp(C1, D1, E1, etc,, )
A1 has the names.
Now on Tab2 for each month I have the formula to grab the numbers from the cells need on Tab1. Now these are the same cells I need for the information each month. But I need the cells on Tab2 to stop calculating at end of month and start new the nest month.
This is example tab2 (Training Log)
<tbody>
</tbody>
Example Tab1 Calculate
<tbody>
</tbody>
In this tab I input new numbers monthly in the B column and it auto calculates by minutes in column c. So column B numbers will change every month But I need the numbers on Tab2 to stay frozen and not change when I put in the new numbers for the next month.
Any help would be greatly appreciated.
Thank you
I have a workbook with 2 tabs. Tab 1 (Calculate) this tab has 3 different trainers with topics. #people trained and # minutes trained. Tab 2 (training Log) is the months laid out exp(C1, D1, E1, etc,, )
A1 has the names.
Now on Tab2 for each month I have the formula to grab the numbers from the cells need on Tab1. Now these are the same cells I need for the information each month. But I need the cells on Tab2 to stop calculating at end of month and start new the nest month.
This is example tab2 (Training Log)
Trainers | Jan | Mar | Apr | May | Jun |
Jane | |||||
Doe | |||||
<tbody>
</tbody>
Example Tab1 Calculate
Jane | Current Month | Totals |
SFB | 5 | 225 |
NH | 4 | 360 |
OJT | 3 | 45 |
Doe | ||
SFB | 5 | 225 |
NH | 4 | 4 |
OJT | 3 | 3 |
<tbody>
</tbody>
In this tab I input new numbers monthly in the B column and it auto calculates by minutes in column c. So column B numbers will change every month But I need the numbers on Tab2 to stay frozen and not change when I put in the new numbers for the next month.
Any help would be greatly appreciated.
Thank you