Ditutup

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, Pemprosesan Data, Excel

Lihat lebih lanjut: excel highlight entries, highlight entries excel, highlight changed, update entries excel, highlight updates excel, highlight excel entries, identify entries excel, sheets add, red black data, model brand, currency table list, pricelist update, price excel, new model, highlight, excel model, excel format, changed, black and, spreadsheet price list, product entry price excel, find product description, stock data tool, excel unique, stock excel model

Tentang Majikan:
( 0 ulasan ) Bangladesh

ID Projek: #1525058

14 pekerja bebas membida secara purata $7235 untuk pekerjaan ini

mike25

You have not attached any file. Please check your inbox.

$50 USD dalam 10 hari
(10 Ulasan)
3.6
jyotiranjanca

Hi, we have done this type of work before with great success.We are an experienced group and can do the job with 100% accuracy and in the stipulated time.So we look forward to work with you.We can do the sample work Lagi

$30 USD dalam 3 hari
(7 Ulasan)
3.6
coolcoder2

Hi, i am interested in this work,i will do this work perfectly.

$130 USD dalam 4 hari
(1 Ulasan)
2.3
prabinyogi1

wow i love doing same job...give me and watch..

$200 USD dalam 30 hari
(0 Ulasan)
0.0
DreamerTran

I can write a script ( like an exe file). You will run the script an have the result. Please contact with me for more inforamation.

$150 USD dalam 5 hari
(0 Ulasan)
0.0
mhayrha

Good day! I am Myra P. Cruz from Philippines. As of now, I am unemployed due to recession done by our company. In my previous employment, we are making lots of reports using Excel so I have a knowledge in doing Lagi

$100 USD dalam 5 hari
(0 Ulasan)
0.0
Shazzadbd

Dear sir, I can do this job.Please give me a chance.I'll give my best.

$60 USD dalam 3 hari
(0 Ulasan)
0.0
gilesian

You can be assured of the quality of the final product.

$100000 USD dalam sehari
(0 Ulasan)
0.0
ameykekre

I have done one of such project for domestic market so I can do this work using excel tool.

$110 USD dalam 2 hari
(0 Ulasan)
0.0
kkn1978

Excel expert, have done similar automation work before. Please see PM.

$35 USD dalam 0 hari
(0 Ulasan)
0.0
mubshshirali

Please check PM

$45 USD dalam 8 hari
(0 Ulasan)
0.0
sanketpatel87

I can handle the project requirements which you have mentioned in a day. I have already implemented this requirement in one of my module.

$30 USD dalam 0 hari
(0 Ulasan)
0.0
WilsoK

Can complete the work accurately and correctly

$250 USD dalam 10 hari
(0 Ulasan)
0.0
kothamadhu

i am very interested to do this type of work.

$100 USD dalam 5 hari
(0 Ulasan)
0.0