Guys,
My real world situation is to identify changes to budgets and for the owner to comment on why the item in their budget has changed
My excel world situation is I have 2 sheets
1. The budget
2. The extract of budget items that have a <>0 value
The Budget worksheet holds the data
Code Desc 2002 2003 Type
XXX XXX £XXX £XXX XXX
I need to look through this information and extract the above information to a new sheet if the figures between 2002 and 2003 are different.
This process should happen whenever the workbook is opened, new rows of data that meet the criteria should be added to the end of the list. If the numbers change then this should also change - although it would be good to highlight the change.
I know this can be done on a pivottable, but what I need is the data to be extracted to a new sheet and then some other information to be added next to the extracted data
I hope this helps,
Thanks in advance
AshLad
My real world situation is to identify changes to budgets and for the owner to comment on why the item in their budget has changed
My excel world situation is I have 2 sheets
1. The budget
2. The extract of budget items that have a <>0 value
The Budget worksheet holds the data
Code Desc 2002 2003 Type
XXX XXX £XXX £XXX XXX
I need to look through this information and extract the above information to a new sheet if the figures between 2002 and 2003 are different.
This process should happen whenever the workbook is opened, new rows of data that meet the criteria should be added to the end of the list. If the numbers change then this should also change - although it would be good to highlight the change.
I know this can be done on a pivottable, but what I need is the data to be extracted to a new sheet and then some other information to be added next to the extracted data
I hope this helps,
Thanks in advance
AshLad