Replies

Hi Steve, thanks for getting back to me. I have attached a document on what I have done. and the problems.

Hi Steve, thanks for getting back to me. I have attached a document on what I have done. and the problems.

Hi Steve,
Thanks for being so fast. I have messed around and come up with this chart. (It’s attached). The problem is they want the Average for May and Average for Sept to be side by side. I’m Not sure how to make the chart as wide as the paper.
Yes they want 3 different charts. I’m not sure why they only want May and Sept months.

Hi Steve,
Thanks for being so fast. I have messed around and come up with this chart. (It’s attached). The problem is they want the Average for May and Average for Sept to be side by side. I’m Not sure how to make the chart as wide as the paper.
Yes they want 3 different charts. I’m not sure why they only want May and Sept months.

Thank you so much for the help. You guys came through again your the greatest. All the girls at work will be very happy.

Thank you so much for the help. You guys came through again your the greatest. All the girls at work will be very happy.

Hello
The program is call Misys, it is a commercial application data base that the company purchased for keeping record information.

Hans, I would like to be able to do it in two different programs. Work Orders and Time Sheets. Thanks

Lagare, Thanks for responding to my question. I am new to excel and I am not sure what a VBA code is or how it works, so is there another way other than a VBA code that will work?

Thanks Andrew
I wish there was a book or a video on examples of how the different formulas were used.

Thank you very much. It works great. You saved me alot of time

Steve thanks for checking my problem. I have updated the information to make it hopefully more understandable. A list for all new or changed entries is what i’m looking for. In my example John-MT is the only name that stayed the same. What we do now is make a print out of the new and old list. One person reads off the names and address while the other person Marks any changes, then we make a new worksheet and we have to type in all the updates or changes that were made. It takes about 4 days to do this.

Please help! I have a worksheet that gets updated every month. How do i tell excel to find all the text that does not match. Example. Headings are “Name” in A1 and “Address” in B1. Every month a new name is added or the address is changed. Example in January the names and address may be John-MT,Mary-ND,Ken-SD. In February it may change to John-MT,Tom-TX,Ken-OK. I want to tell excel to look in sheet 1 then look in sheet 2 and tell me which names and address changed or stayed the same.