Hi, my problem is this, I'm trying to find a way to cross-check two separate spreadsheets specifically there names , is there a way to do this? i have over 30,000 lines to search and doing so manually will take a lifetime.
any information or help will be gratefully appreciated.
Hi and welcome to the forum.
Can you explain a little more pls?
Be sure that best way to describe your problem is to upload a sample workbook.
Be sure that all sensitive data removed, showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that.
To attach a small sample workbook.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Basically i have 2 seperate excel worksheets, and i want to know if theres a formula or a macro that i can use to cross-check the excell sheets agaisnt each other and if they match on both sheets that they get highlighted.
COUNTIF is 1 way.
Perhaps MATCH function is the other.
Ok, are you able to go into a bit more detail on how to do that? im new to excel
Of course i am able to do this. Just why i replied to your question. But as i asked for in my first post, upload a small sample workbook to show you how to do this, or else we'll discuss it for many posts..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks