Is this posible to do?

[pgarcia]

Row A has the following:
East
East
East
<-blank cell
East
East
<-blank cell
South
South
<-blank cell
South
<-blank cell
West
West
West
West
<-blank cell
West
<-blank cell
<-blank cell
West
West

I would like to copy "East" all the way down to the last East in the Row,
then inset a cell and type "East Total" and do the same for South and West.
The data changes from day to day. Can this be done? Here is the end result:
East
East
East
East<-was a blank cell
East
East
East<-was a blank cell
East Total
South
South
South<-was a blank cell
South
South<-was a blank cell
South
West
West
West
West
West<-was a blank cell
West
West<-was a blank cell
West<-was a blank cell
West
West
West Total

 

[Dave Peterson]

I'd use one of these techniques from Debra Dalgleish's site:
http://contextures.com/xlDataEntry02.html

Then I'd add headers and use data|subtotals to get the subtotals.

(or maybe add headers and use a pivottable)

 

[pgarcia]

I used it and works fine. However, when it gets down to the last row with
data, it does not stop. I keep going on for another 2000 to 3000 lines. Do
you now how to make it stop at a cretin point?

 

[Dave Peterson]

Did you use the manual approach or the code approach?

If you used the manual approach, you select the range to start.

If you used the macro, then it uses what excel is the row for the last used
cell.

Maybe it's time to visit Debra Dalgleish's site again:
http://contextures.com/xlfaqApp.html#Unused

 

[pgarcia]

Thanks, but I'm not sure what it happing here. Oh, yes I'm using the VB code.
That's ok, I have a work around. Thanks again. I will be check out that site
more offiten now.