Update the new colum

[jitendra]

I want to update my file when I am receiving new prices for any place as well as if any new new place name came also need to update in place column and the prices I need to highlight in yellow color which I have received, for example I am giving some data.


Existing data

01/02/2011
€
prefix Destination price
93 AFGHANISTAN-FIXED 0.3606
9375 AFGHANISTAN-MOBILE 0.3375
93750 AFGHANISTAN-MOBILE 0.1375
9370 AFGHANISTAN-MOBILE (AWCC) 0.1288
9378 AFGHANISTAN-MOBILE (ETISALAT) 0.126
9377 AFGHANISTAN-MOBILE (MTN) 0.1402
9379 AFGHANISTAN-MOBILE (ROSHAN) 0.1294



Received data

937503 AFGHANISTAN-MOBILE (WASHEL) 0.8485
937504 AFGHANISTAN-MOBILE (WASHEL) 0.8485
355 ALBANIA-FIXED 0.0379
355422 ALBANIA-FIXED, TIRANA 0.3164
355423 ALBANIA-FIXED, TIRANA 0.3164
3554240 ALBANIA-FIXED, TIRANA 0.3164


Required data

On the next column the new rates if received and if no new new rate then the old rate and if any destination not in my file then need to update the destination name also in destination column and price in latest price column and at the starting cell of the column i want the date of update and I need to highlight in yellow color the cells which are containing the new price for existing destinations as well as for new destinations also,then on the next column I want the difference between existing column price and new update column price.


If any one can help for this problem then I will be ever grateful to him/her.

 

[hiker95]

jitendra,

Have you checked the responses to your first post?
Posts: 1 Convert text to column and transpose
http://www.mrexcel.com/forum/showthread.php?t=575713


What version of Excel are you using?

Again, it is difficult to see what worksheets you are using, and where your data begins (rows and columns).

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

 

[jitendra]

I am using MS Excel 2007 and the new data what I will receive first I will paste in one file then I will start the macro in my master file.

The new data I will paste from cell a1