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.
Được trao cho:
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.
20 freelancer đang chào giá trung bình £31 cho công việc này
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
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.
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