Had same thing but created a macro that worked on the rows selected with
mouse then a button on the toolbar. Select, click, pretty simple

John

sirriff < wrote:

Greetings,

thanks to anybody who reads this

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

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

but i keep adding more items every week so i was thinking about making
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 rows
if i need to alter teh data.

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

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

the only other alternative would be to use an isempty thing to start
from the top each time and skip over all the ones with answers already
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 only
want to tackle the one that is simplist.

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

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

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

sirriff


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


--
R-e-t-u-r-n A-d-d-r-e-s-s I-n-s-t-r-u-c-t-i-o-n-s
Change LID to