I have a spreadsheet that i am using during the transition from an excel spreadsheet job system to a new online system. The idea is that i dump a load of data from my excel version into the first tab on the spreadsheet, and then a dump of data from the new system into the second tab.
I then need VBA to look up the information and highlight the cell if it does not match the same cell on the opposite spreadsheet. The job number is the constant number on both sheets, so need to say "If job xyz on sheet 1 appears on sheet 2, check column N on sheet 2, and if this does not match column F on Sheet 1, highlight the cell in Red, and highlight the job number in red too, and if it does not appear, highlight the job number in blue".
I DO NOT WANT CONDITIONAL FORMATTING!! The actual sheet has over 10,000 lines on each and over 100 columns. Formatting makes it too slow to work, and breaks very easily.
The third tab on the sheet is a cross reference to say what the column on the second sheet relates too on the first sheet.
PLEASE ASK ME ANY QUESTIONS BEFORE YOU ACCEPT THE JOB IF YOU ARE UNCLEAR! THE ATTACHMENT IS LIVE DATA THAT YOU WILL WORK WITH, IF YOU DONT UNDERSTAND IT PLEASE DONT BID ON THIS.
I am preparing it right now. It is easy for me. You do not need to spend more money than my bid. I'll guarantee to aid you for changes in same file in the future FREE if you choose me. Thanks.
Bu iş için 20 freelancer ortalamada £31 teklif veriyor
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
Greetings! I have a couple of questions - 1) I presume that the example given was just an illustration "check column N on sheet 2, and if this does not match column F " of requirement. When I look up the "Key" Wo Daha Fazla
-Went through the Excel sheet. Based on the Existing sheet data tab and the SmartSheet Sheet data compare with Job_No and highlight if Col F does not match. - Have done similar matching of contract values using VBA Daha Fazla
I have understood the requirement and can write a code to highlight the differences in red and missing data in blue based on the mapping in the "key" sheet. I have excellent command on MS Excel. I have completed com Daha Fazla
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I clearly understood your project. I can create a macro to match data between two sheets and change specific color ac Daha Fazla
Hi, I checked the project details and description that you are looking for VBA macro for comparison of data of your two sheets. I will design the same for you with high accuracy. I have many years of experience in E Daha Fazla
Web Search Web Scrapping Excel Access PowerPoint Statistics Data Processing Data Collecting (Using Macro) MS Office C++ HTML VBA Mathematics Excel VBA Macro Automation User Forms Data Daha Fazla
I am an Excel specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
Hello I would be happy to help with your vba issue. I appreciate how conditional formatting can slow down a job with a large data set. I would look to create a macro that would look up the job from both sheets and i Daha Fazla
Hi! First of all - employing VBA in it's usual manner (single thread parsed inline) is always going to be slower than what conditional formatting can achieve, simply because the latter is a compiled and optimized dll Daha Fazla
I would love to help you in your " Write some VBA to highlight cells in a colour to a set criteria " Project. We'd like to help you with confidence and satisfying results.
Hello, I saw your project and I can create a solution that works for you. I am an experienced programmer, and also have great project management skills, so will be able to handle this professionally for you. My Daha Fazla
Crystal clear. Aeronautical engineer and MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic Daha Fazla
Hello, The project description is pretty clear to me. Here is what I understood: Match the Job Number in both Sheets and then Match the Quotation Number. If it does match color it Red else Blue. I don' t see any Daha Fazla
Hi, I have read the project description & seen the attached file. I can make it without any error. Please send a massage so we can discuss. Thank You
Hi there, I have more than 12+ years of experience in MIS Reporting using Excel, data analysis, data visualization, data management. Also, Report automation using VBA, MS Access. You may pls check my portfolio. If in Daha Fazla
Hi, I already got your requirement working in VBA coding. However, there are doubts which I want to clarify with you: 1. Which sheet you want to perform the colour formatting? Sheet1 or Sheet2? 2. Do you want Daha Fazla
I am an planner currently working for an Australian telecom carrier. I I am very familiar with Excel and use it everyday. I can do Macro VBA as well.
Hi, I have 5+ years of experience in MS Excel, and VBA programming. I think you meant to say Column "AF" on sheet 1 instead of Column "F" that corresponds to Column "N" in sheet 2. Just a couple of clarifications: Daha Fazla