dave bates
Board Regular
- Joined
- Jul 7, 2008
- Messages
- 106
Hi
I'm using Excel 2003. I have used the Data Subtotals function to sort and subtotal a series of data. However on checking I need to recode several of the items on which "the change in" subtotal was based eg change them from code A to code B. I am not adding more data simply changing reference code.
Is there a way of refreshing the data to reorganise and rerun the subtotals?
hope it makes sense, thanks
I'm using Excel 2003. I have used the Data Subtotals function to sort and subtotal a series of data. However on checking I need to recode several of the items on which "the change in" subtotal was based eg change them from code A to code B. I am not adding more data simply changing reference code.
Is there a way of refreshing the data to reorganise and rerun the subtotals?
hope it makes sense, thanks
