Cancelled

Xl macro needed to compare 2 files and mark modified rows

Process

File 1 is the base set for our data

Contains the basic Information

File 2 is the our version of the data

Contains 4 extra rows Rows K-N (Position has not been finalised)

Repetitive Process

In file 1 a user can change any field or insert new rows, new records

When this happen

1) If the fields in file 1 have changed then in file 2, The equivalent se rows should be marked so

(You can take as constant field Unit code Presently column O)

2) If you have new Rows in file 1 those rows should be added in file 2 marked with a different colour leaving room in colums K:N for the admin to fill the details missing

3) If rows in File 1 have been deleted, the equivalent rows should be marked in file 2 with a different colour in order for the user to make those additions

Colours , Yellow . changes, Green Addtions, Grey Deletion

Skills: Excel, Visual Basic

See more: room files, mark fields, excel mark, xl, rows, mark, excel colour, insert macro excel, rows insert, data compare, compare rows excel, files missing, excel modified, file excel compare, excel rows, excel macro order, excel files compare, macro fields excel, data admin excel, mark file deletion, admin excel data, green code, code excel macro, data excel admin, excel macro data compare

About the Employer:
( 5 reviews ) ATHENS, Greece

Project ID: #1256818

13 freelancers are bidding on average $38 for this job

nagybatonyi

In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are inclu More

$35 USD in 1 day
(43 Reviews)
5.6
northwolves

Million thanks for your invitation,I can help you.

$30 USD in 0 days
(50 Reviews)
5.0
DrTech76

Hi!

$30 USD in 0 days
(27 Reviews)
4.7
dev3dworx

Please check PMB for details.

$33 USD in 1 day
(19 Reviews)
4.7
dasmoeh

Hi, i can do this for you.

$30 USD in 1 day
(5 Reviews)
4.2
microk

Excel whiz here :).. Please see sample in PM..

$40 USD in 1 day
(19 Reviews)
4.1
piyushdpatel

Hi This is Piyush Patel I have 6 yrs of Exp in VBA,VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

$50 USD in 1 day
(10 Reviews)
4.0
shacoim

***Plz Check PM***

$30 USD in 1 day
(10 Reviews)
3.9
Pichart

I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. I have read your requirement throughly,confident to finish within less than 3 hrs. I explain how t More

$35 USD in 1 day
(13 Reviews)
3.8
vgrichards

Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement.

$30 USD in 1 day
(19 Reviews)
3.7
MaxCalif

Hello, I can do this. See please some questions in PM.

$35 USD in 1 day
(1 Review)
2.0
dineshkothari

I have solution, see PM.

$50 USD in 3 days
(1 Review)
1.0
AliveSoftwares

Alive Softwares Pvt. Ltd is a software development company based in the India. We provide operational development framework to our clients with the security. We identify the companies' needs and work with our developme More

$32 USD in 1 day
(0 Reviews)
0.0
mishad38

i can do this sir!!!

$60 USD in 6 days
(0 Reviews)
0.0