(Thought I would rename the issue. Maybe it will help define the issue.)
Hi guys....
I have Excel 2000 and am needing to do something that I have never done, but believe it can be done.
I have several worksheets containing some duplicate data which needs to be condensed into one worksheet. There are over 400 rows of data that need to be compared. The only common data that the worksheets share are the client names. (Some of the clients have dropped off the previous years list, so their names may not be on my main list.)
I need to take the data from the excess worksheets that is not in my new, main worksheet, and bring it over to the new sheet.
What is the best way to do this?? I am having to do this manually, but I know it can be done in some other fashion.
Any suggestions??
I have provided a link to an example of the data I am dealing with.
Thanks again,
Jason
Example of issue
This message was edited by J Lowe on 2002-04-05 09:00
This message was edited by J Lowe on 2002-04-05 09:32
Hi guys....
I have Excel 2000 and am needing to do something that I have never done, but believe it can be done.
I have several worksheets containing some duplicate data which needs to be condensed into one worksheet. There are over 400 rows of data that need to be compared. The only common data that the worksheets share are the client names. (Some of the clients have dropped off the previous years list, so their names may not be on my main list.)
I need to take the data from the excess worksheets that is not in my new, main worksheet, and bring it over to the new sheet.
What is the best way to do this?? I am having to do this manually, but I know it can be done in some other fashion.
Any suggestions??
I have provided a link to an example of the data I am dealing with.
Thanks again,
Jason
Example of issue
This message was edited by J Lowe on 2002-04-05 09:00
This message was edited by J Lowe on 2002-04-05 09:32