Greetings,

thanks to anybody who reads this

I got sales data exported as excel. each row contains an item and al
its data, cost, tax, end price, shipping cost, and so on.

basically i got a macro that records all the varous costs and tells m
my end profit per item.

but i keep adding more items every week so i was thinking about makin
a row specific button that would execute the macro for that row only.
that way i could calculate each new row only, or recalculate older row
if i need to alter teh data.

this would require a command button for each row, preferaby consistin
of the size/shape of the last cell of each row.

is this even possible? to make an entire colume of command buttons fro
cells?

the only other alternative would be to use an isempty thing to star
from the top each time and skip over all the ones with answers alread
filled, untill it gets to the new ones, and only calculate those.

i am not sure exactly how to code either, but of course i would onl
want to tackle the one that is simplist.

any suggestions?
i think from my limited vba sklls that the isempty route might b
easiest.

i am not sure how to make it check cells down a column, skip the row i
it is already filled, or execute my existing sub if its empty.

any help is appreciated, i spend 15 hrs making my simple profi
calculator and this would just make it perfect.

sirrif

--
Message posted from http://www.ExcelForum.com