macro for deleting cells trought column A
See inline comments...
I dont understand what need to change in
Const DataStartRow As Long = 3 - this dont understand
Put the row number of your first piece of data in the DataStartRow constant.
For your posted example data, that would be the row number where "ALBANIJA
211" is located. I don't know your layout (do you have header rows for
example... if so, do you have a blank separating row between your header and
first piece of data?)... so you have to tell the code where your data is.
i need individual sums per country and then delete unwanted country's.
need only summation and one country
But where do you want these sums to go? In an array in memory? On the
worksheet somewhere? If on the worksheet, where (what column and/or row)?
And what do you mean by "delete unwanted country's"? What makes a country
wanted or unwanted?
--
Rick (MVP - Excel)
|