Sedang Disiapkan

Highlight new and changed entries in Excel spreadsheet

On a regular basis, we receive a pricelist update in the same Excel format (it's basically a table).

As there are thousands of entries, it's very difficult to identify the changes and new additions to the list.

We need a tool (I'm thinking Excel, but I'm open to other suggestions) which updates the old list with new entries.

Your solution must do the following:

1. add ONLY new entries to the old list and highlight them with blue font (based on PN field)

2. update CHANGED entries and highlight only changed cells with red (PN is identical, but other fields differ)

3. unchanged and old entries must remain black and, of course, unchanged

The table header is:

+ Category

+ Brand

+ MODEL / TYPE

+ PN (part number, is unique)

+ Product description

+ Currency

+ Sale Price

+ 1 Star Program Price

+ 3 Star Program Price

+ 5 Star Program Price

+ Stock info

Attached you can find an Excel file with 3 sheets: new price list, old pricelist before and after your program ran.

Kemahiran: Pemasukan Data, Excel

Lihat lebih lanjut: highlight entries excel, highlight changed entries, identify entries spreadsheet, sheets add, red black data, model your brand, m format in excel, in the red black, currency table list, excel highlight entries, font entries excel, highlight changed, pricelist update, red and black, price excel, new model, Highlight, excel model, excel format, data entry in excel sheets, changed, black and, spreadsheet price list, product entry price excel, highlight excel entries

Tentang Majikan:
( 0 ulasan ) Timisoara, Romania

ID Projek: #1525047

25 pekerja bebas membida secara purata $39 untuk pekerjaan ini

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$40 USD dalam sehari
(61 Ulasan)
6.3
danielgpratidya

Hi, you don't have to wait anymore, it's done and available in your pmb

$30 USD dalam 0 hari
(84 Ulasan)
5.7
Teloquence

Excel expert at your service. Consider it done. Check your PM for details.

$45 USD dalam 0 hari
(74 Ulasan)
5.7
nagybatonyi

My bid consists of an xlsm spreadsheet containing a Control sheet for identifying old and new files and a button to trigger a macro placing conditional formatting on the new file as shown in the sample uploaded in PMB. Lagi

$50 USD dalam sehari
(47 Ulasan)
5.6
Krusche

Hello. It's a kind of one hour job. Please check your PMB for examples.

$30 USD dalam 0 hari
(21 Ulasan)
5.1
tmoi06

Sir/Madam, It is our pleasure to be able to bid on your project. I would like to give my fullest and maximum contribution towards the success of this project. Anticipating your favorable reply. For further reference Lagi

$30 USD dalam sehari
(317 Ulasan)
5.1
coolbuddy19

Hi I am confident to handle this

$40 USD dalam sehari
(20 Ulasan)
4.8
imudita

I have done it. Please see PM.

$30 USD dalam 0 hari
(27 Ulasan)
4.7
Engineer85

Hi I can do this job for you. Please check PM.

$40 USD dalam sehari
(12 Ulasan)
4.5
microk

********* The macro is Ready.. Please check PM...***********

$35 USD dalam sehari
(18 Ulasan)
4.2
FLtowhid

Please see my PM.

$30 USD dalam sehari
(4 Ulasan)
3.8
hfbaker

I will prepare a visual basic macro which will insert rows highlighted by a blue font for new part numbers and will update changed fields, highlighting them with a red font. I can complete this project in less than a d Lagi

$35 USD dalam sehari
(4 Ulasan)
3.7
shagoon2u

Excel Experts are ready to start immediately.

$40 USD dalam sehari
(3 Ulasan)
2.9
mandarfreelancer

The pricelist updates can be compared on PN field using Excel VBA macro. Thus, you only need Excel and nothing else. All you need to do is click a button in Excel sheet and process will be complete. Please refer to PM Lagi

$30 USD dalam sehari
(1 Ulasan)
2.6
sumshank

Thanks for your time in reading my bid. What you have said can be done with an Excel macro. Here are my credentials: - Excellent MS Excel skills, having used it extensively during my work with the Information Te Lagi

$50 USD dalam 2 hari
(3 Ulasan)
2.4
harunnaim

Dear Employer, I have strong command on MS Excel and English with helps me to perform data entry accurately following the exact instructions. I believe I can provide you fast and accurate service within your budg Lagi

$100 USD dalam 10 hari
(0 Ulasan)
0.0
katalink

Hello, this is my first bid like a freelancer. Your need, is my daly-bussines, in Automotive industry. Will be my pleasure, to provide you on time, the sollution.

$30 USD dalam 2 hari
(0 Ulasan)
0.0
shajinbd

I like to work with you.

$30 USD dalam sehari
(0 Ulasan)
0.0
mahmud1001

I can do this job. you give me a chance..

$30 USD dalam sehari
(0 Ulasan)
0.0
farazayub50

i am a accounting student.i am already used to of finding [url removed, login to view] i can do this job very well.

$30 USD dalam 0 hari
(0 Ulasan)
0.0