Excel Issue: Working over multiple sheets

[lmeinke]

Hello all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I am attempting to read a partial column (A20: Aundetermined) and then compare that multiple worksheets in the same Excel file. I am not a heavy user of Excel but I did stumble across this formula (=IF(ISNA(MATCH ...). If I copy and paste all the appropriate columns from my multiple worksheets onto a new sheet I can then run this formula to compare the text strings from column to column. The formula will produce a 1 (if a match is found) or a 0 in a new column. At the end I then sum these new columns to give me the number of times a value occured in these columns.The issue though, is I want to be able to let other users do this painlessly. In other words perhaps write a macro that would automatically compare this list of column values to other lists (same cell locations) on multiple sheets. One other thing, the worksheets are named by date (ie. 7/2/08, 7-1-08 etc..). I hope this is understandable to most people...if not please email and I will attempt to clarify.<o></o>
<o> </o>
Thank you,<o></o>
Lonnie Meinke

 

[DonkeyOte]

Lonnie, not sure if you still require a solution to this or not ?

Can you clarify what you are matching exactly ?

Are you saying you want to see if A20:A30 on one sheet exists on other sheets (ie a collection of values) or are you saying you want to match a given value on one sheet to see if it exists in the other sheets within a given range ?

If you could provide an example that would be very helpful.

 

[lmeinke]

I am talking about the latter. The situation is A:20, through an undetermined row number, contain a list of trailers that contain product ready to ship. This list is sent out every day as a new page in the workbook (named 7/2/08 etc..). I need to read the current days list and then compare that to the preceeding 5 or so pages.

Hope this helps. Thanks for the reply.
Lonnie