|
Is this posible to do?
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 |
Is this posible to do?
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 wrote: 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 |
Is this posible to do?
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" wrote: 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 wrote: 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 |
Is this posible to do?
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 wrote: 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" wrote: 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 wrote: 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 -- Dave Peterson |
Is this posible to do?
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. "Dave Peterson" wrote: 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 wrote: 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" wrote: 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 wrote: 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 -- Dave Peterson |
| All times are GMT +1. The time now is 04:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com