Comparing two worksheets

[J0N]

Hi,

I need to run monthly reports of a fixed format and want to be able to compare and highlight any changes between the new and old report. I am ok with conditional formatting and delta etc. the problem I have is that the fields are not in a fixed postion and therefor I cant use tradition formulas as I dont know where the comparative data will be placed. As tasks are completed or started entries will appear and disapear from the list. Is there a way of linking two entries in different worksheets together if for example they have the same name in column A, but are in different and unpredictable rows. Or is there another way anyone can think of to solve this problem. Any suggestions very much appreciated. If you need any clarification to help suggest a solution then please let me know.

thanks

Jon

[starguy]

Hi,

I need to run monthly reports of a fixed format and want to be able to compare and highlight any changes between the new and old report. I am ok with conditional formatting and delta etc. the problem I have is that the fields are not in a fixed postion and therefor I cant use tradition formulas as I dont know where the comparative data will be placed. As tasks are completed or started entries will appear and disapear from the list. Is there a way of linking two entries in different worksheets together if for example they have the same name in column A, but are in different and unpredictable rows. Or is there another way anyone can think of to solve this problem. Any suggestions very much appreciated. If you need any clarification to help suggest a solution then please let me know.

thanks

Jon

Hi
you should attach a sample file for better consideration.

[J0N]

Thanks for the reply, please see below: -

COMPANY_NAME MANAGER_NAME START DATE NUM SITE ANNUAL VOL RENEW PROB NEW PROB
Company A manager 1 01/04/2009 7 51.6 6 0
Company B manager 2 01/10/2008 18 33 0 0
Company C manager 3 01/01/2008 2 32.22 0 1

[J0N]

Sorry that isnt very clear.

[starguy]

Sorry that isnt very clear.

yes
you should put data in Excel sheet and attach that Excel file with your post in zip format.