View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
tabađija tabađija is offline
external usenet poster
 
Posts: 1
Default macro for deleting cells trought column A

tnx MAN...U RESCUE ME...my fingers almost palayse.

do u have idea how to make a SUM(cell A) by the same Atribut's and
then delete all but one atribut and leave the SUM


befo

ALBANIJA 211
AUSTRIJA 4260
AUSTRIJA 28274
AUSTRIJA 12696
AUSTRIJA 1199671
AUSTRIJA 12870
AUSTRIJA 13926
AUSTRIJA 406254
AUSTRIJA 249971
AUSTRIJA 89479
AUSTRIJA 106262
AUSTRIJA 2020476
BELGIJA 56070
BELGIJA 543
BELGIJA 35401
BELGIJA 202120
BOSNA I HERCEGOVINA 31718
BOSNA I HERCEGOVINA 26061
BOSNA I HERCEGOVINA 58798
BOSNA I HERCEGOVINA 54642
BOSNA I HERCEGOVINA 28931
BOSNA I HERCEGOVINA 2781
BOSNA I HERCEGOVINA 868
BOSNA I HERCEGOVINA 7422
BOSNA I HERCEGOVINA 9658
BOSNA I HERCEGOVINA 16383
BOSNA I HERCEGOVINA 152
BOSNA I HERCEGOVINA 172
BOSNA I HERCEGOVINA 2299
BOSNA I HERCEGOVINA 6775
BOSNA I HERCEGOVINA 17237
BOSNA I HERCEGOVINA 945
BOSNA I HERCEGOVINA 2248
BOSNA I HERCEGOVINA 1174
BOSNA I HERCEGOVINA 19470

after:

ALBANIJA 211
AUSTRIJA 4260
28274
12696
1199671
12870
13926
406254
249971
89479
106262
2020476
BELGIJA 56070
543
35401
202120
BOSNA I HERCEGOVINA 31718
26061
58798
54642
28931
2781
868
7422
9658
16383
152
172