Excel macro to compare range of cells to another range of cells

The situation is a spreadsheet with several columns containing text and numbers. There will be a whole range of columns with numbers that will be of interest.

The macro should do the following things.

(1) In the first worksheet of the example file, let the user select the range of columns ("range") containing the numbers of interest. (highlighted in yellow in the example file)

(2) In the first worksheet: After the right most column of the above selected range, the macro should insert an additonal column named "changed".

(3) The marco should compare the numerical values of each cell within "range" to the list of numbers ("list") given in the first column of the second worksheet.

(4) If any cell within "range" contains a number from "list", the respective cell should be cleared, shaded in a light grey colour and the affected row where any deletion happened will show an "x" in the before inserted column "changed".

(5) The macro should check each cell within "range".

(6) No other cell except those within selected "range" may be altered by the macro.

The example file is very small and only for illustrative purposes, but the the final macro should also be able to work on 100.000 rows and a few thousands of different values for "list", for example. Therefore, if the final bidder knows efficient programming, this is even more welcomed.

Attached is the example file.

Taidot: Excel, Visual Basic for Apps

Näytä lisää: excel macro compare cells, compare range macro, excel macro compare range, macro excel compare cell range, excel range compare, excel macro compare cell cell range, excel compare cell range macro, programming in excel 2013, numerical programming, macro programming in excel, applications of c++ programming, macro compare range, programming with excel, excel small work, compare spreadsheet, cells, excel colour, insert macro excel, excel contains, rows insert, 2013 visual basic applications excel, excel compare list columns, excel row column, excel macro row, compare rows excel

Tietoa työnantajasta:
( 10 arvostelua ) Kempten, Germany

Projektin tunnus: #4222167

Myönnetty käyttäjälle:


please refer to my private message to get my exclusive offer.

$30 USD 1 päivässä
(15 Arvostelua)

3 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Top 1% in VB6 on Freelancer and lot of experience in this field, please check PM.

$34 USD 1 päivässä
(4 arvostelua)

Yes, I can do this for you. Want it done overnight (my time) for you tomorrow afternoon? Let me know. BTW, do you need this as a VBA macro? If an external application (VB.Net 2010) would work for you, I should be able Lisää

$75 USD 1 päivässä
(9 arvostelua)