Tamamlanmış

Write some VBA to highlight cells in a colour to a set criteria

Hi,

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.

Beceriler: Veri Girişi, Veri İşleme, Excel, Visual Basic

Daha fazlasını gör: vba highlight row if cell contains, excel vba change cell color when value changes, excel vba highlight cell based conditions, excel vba change cell color based on another cell value, vba highlight cell yellow, vba change row color based on cell value, excel vba conditional formatting based on cell value, excel vba change cell background color based on value, run excel vba select update filed based criteria, write vba excel 2007, write vba script outlook 2007, vba copy cells macro, excel vba paste cells, vba cut cells, vba paste cells excel, excel vba cut cells, excel vba pasting cells, vba excel cells cut paste, vba paste cells, excel vba paste cells column

İşveren Hakkında:
( 20 değerlendirme ) Bristol, United Kingdom

Proje NO: #17719502

Seçilen:

ilkecokay

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.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% GBP
(4 Değerlendirme)
3.2

Bu iş için 20 freelancer ortalamada £31 teklif veriyor

elqueabandona

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

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(212 Değerlendirme)
6.8
ksriniravi

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(162 Değerlendirme)
6.7
satishtl

-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

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(50 Değerlendirme)
6.0
archanaoswal

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(72 Değerlendirme)
5.7
vsprybhanu

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(73 Değerlendirme)
5.3
TechnoGuruu

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

in %bids___i_period_sub_35% gün içinde47%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(43 Değerlendirme)
5.2
rumarahman

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(35 Değerlendirme)
5.1
aubrey03

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]

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(35 Değerlendirme)
5.0
sdroberts

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

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
3.3
justTry

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(7 Değerlendirme)
3.1
dataexplorer

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.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)
3.2
GaryMoylan

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(1 Yorum)
2.5
Capitan0Trueno

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(3 Değerlendirme)
2.4
rayyankabir

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(2 Değerlendirme)
1.0
rashedkhanrubel

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

in %bids___i_period_sub_35% gün içinde20%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
0.3
freelancer4100r

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

in %bids___i_period_sub_35% gün içinde20%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
0.3
ah6039

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
StuartLuo

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
SamerHany

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0