Microsoft Office Questions? Ask a IT Expert for Support ASAP
Welcome To Just Answer!
A Macro would be best. What exactly do you wish to do? :)
I have two spreadsheets. I want to see if a jobname on one spreadheet is present on the other spreadsheet and vice versa.
yeah that can be done with a Macro. Are you familiar with them?
No worries, If you want I can add it to your workbook for you.
How would you like it setup?
What I mean by that is,..How do you want to search for said Jobname? 1 at a time?
i guess we could return the items that are not present on the other worksheet?
not one at a time-compare both lists and say true or false or something?
Ok, Do you want to add some kind of Marker to it? Like change the Colors Green for Found and Red for not found?
that would be cool!
What I need you to do is attach your file here.
See the Paper clip icon in the tool bar
both spreadsheets, correct?
You it to attach your book
Do you mean you have 2 Excel files? 2 separate workbooks?
did you get them?
You might have to upload them 1 at a time
Now we got them :)
Yes sir :)
I have them
Walk me thru what and where :)
okay, if you open 2013wip both status WB.....Column a is the job name.
Then in 130822 Cindy job report WB.... 7-29 tab,
column b, job name code
I wanbt to comapare the job report with the wip report
Ok just a sec
I dont have a Cindy report book
The file is called " Copy of 130822 Cindy Job Report?
you don't have that?
i don't know what that first one u mentioned is. do you have it now?
Are both of these sheets located inside the same workbook?
no, but I could make that happen....
If it wont mess with your routine it would be much better if the sheets were in the same book :)
Instead of creating a New Workbook, create a new sheet. Then all the data is under 1 roof :)
yes sir :) Or Mam :)
So I search Column A of sheet1 for a Match on the same Column of sheet 2 and turn Matches green and non matches red.? Sound good? :)
How would you like it :)
lol...column a of sheet one with column b of sheet 2
Oops I'm sorry lol, I didn't see Column A was hidden. My mistake :).. Give me like 5 minutes :)
what name shall I address you with?
Ok all done :) Just a sec while I upload it you.
I added a Button on the top right of Sheet1. Simply click it and watch it work :)http://www.mediafire.com/view/?mp43vj9f5y5cxib
Mr. Yegar, These aren't the ultimate spreadsheets I will be using. When I get the final versions, can you show me how to duplicate what u did. Okay, I'm going to play now...hold on..I'm excited!
It would be my pleasure to show you :)
its still working...
Did it mess up?
oh, I had to hot okay...WOW!!
Is it good? :)
no, its cool!!
It really easy to adapt the code. I am making Notes in my code to give you a better idea :)
if the ones on sheet one are on sheet 2 they turn green and if not it turns red. That is SO AWESOME!!!!!!!!
Glad you like it :)
i don't even know where your code is!!!
To see the code press the ALT key and hold it. Then tap the F11 key
do i put the cursor on the a column cell when i do that?
When you do what?
When you search?
no, alt, f11. i did it but nothing happened..
You may have to click a cell..Any cell just once. Then tap Alt + F11
not sure if my f11 button is working. its red, is that what the alt does- get to the red
Hmm not sure.. Try this..
See where it says Sheet1 at the bottom?
Right click the Sheet1 name and Click "View Code"
k, i did . that worked!
Then when the new window Opens, look on the Left and double click where it says Module
Thats the code.
i see the code. now what?
Ok,... heres where it can be tricky.
See where it says Sheet1 throughout the Code?
Sheet1 is where the Code begins its search.
Now see where it has a Range("A1:A1000")
Next to Sheet1
yes, it searched that range..
Thats the only part of the TOP of the code you should adapt.
Next look for where it says Sheet2.select
Its just below the top
Thats where the codes Looks for its match
yes, column b
You got it..
Just modify Where to start and where to look/
The rest of the code is just tweaks to make it run fast and smooth
okay. so can I replace the workshhets with updated values and the code will remain behind it?
okay, i think i got it. that is SO cool!!
um, so i can have 4 more questions for the rest of the month?
:) And later on if you want. it can be adapted to do lots of cool stuff. The sky is the limit :)
okay. I think i am gold for now! If i get back online later, can I get to you? I'd like to request you..
You sure can. Just put "ForCustomer at the beginning of your question or follow this link.....
Just a sec lol
and can I print and/or save this chat?
You should be able to yes. Or bookmark it and return anytime
how do i bookmaRK IT? : )
Right click the page and select "Add to Favorites"
ok, I am good to go! I'm so glad I found you . Thank you so much for all of your help!!!!
ps. you get an extra bright smiley!!
Your very welcome :) I am here anytime you need me. Please don't forget to Rate :)
you are rated TOP NOTCH. have a GREAT day!!
Thanks you too :)
HiCustomer Are you there? You helped me out Friday, but I need additional help on same project. I have new data for the worksheet, but can't get the macro to work.
Here ya go :)
What if I wanted to reverse Sheet one and 2...ie; see which ones are on two and not one?
You are THE BEST!! thank you!!
see ya next time!! I'll give you another great rating!! : )