Anyway, I just thought I'd let you know that I'm learning a
lot from your posts,

I am glad you are able to get some useful ideas and techniques from the
postings I provide on these newsgroups and that you are able to incorporate
them in your own work. Given that, you will probably find the approach I
used in my last posting back to the OP of some interest.

Since you find my postings instructive in some small ways, I just want to
give you a heads up that there is a chance I will cease my volunteer efforts
starting in October. I have a strong feeling that I will not have my MVP
status renewed when it comes up for renewal in October. I'm sure you, as
well as others, question what my having MVP status would have to do with my
continuing to volunteer answering questions on newsgroups which, of course,
I can do with or without the MVP recognition. This is true, but my
volunteering efforts take up a lot of my time... time I could be using to
pursue some of my many other interests. So, you will probably ask, why don't
I just stop now? The MVP award is given for activities performed in the year
prior to its being awarded. This has never made sense to me... after being
given the honor of being able to sign myself as an MVP, there is no
obligation to continuing doing a "good job" afterwards. Well, I have an
internal "something" that won't let me do that. I figure that if I have been
given the honor of being able to sign myself as an MVP, then I should
continue trying to perform at the same level that won me the honor in the
first place. So, while this is not Microsoft's position, I **personally**
consider receiving the honor as binding on me to continue performing at the
same level (or better) as I did the year before. If I should not be
re-awarded in October, as I suspect will probably happen, then I will
consider myself free of this "self-imposed" obligation and this, in return,
would allow me to pursue those other activities I have put off for, oh, some
eight years now. If I am re-awarded, then I'll be back as active as ever;
but if I am not re-awarded, then I won't. As I said, just a heads up in case
you need it.

--
Rick (MVP - Excel)

Rick Rothstein submitted this idea :
Anyway, I just thought I'd let you know that I'm learning a
lot from your posts,

I am glad you are able to get some useful ideas and techniques from the
postings I provide on these newsgroups and that you are able to incorporate
them in your own work. Given that, you will probably find the approach I used
in my last posting back to the OP of some interest.

Since you find my postings instructive in some small ways, I just want to
give you a heads up that there is a chance I will cease my volunteer efforts
starting in October. I have a strong feeling that I will not have my MVP
status renewed when it comes up for renewal in October. I'm sure you, as well
as others, question what my having MVP status would have to do with my
continuing to volunteer answering questions on newsgroups which, of course, I
can do with or without the MVP recognition. This is true, but my volunteering
efforts take up a lot of my time... time I could be using to pursue some of
my many other interests. So, you will probably ask, why don't I just stop
now? The MVP award is given for activities performed in the year prior to its
being awarded. This has never made sense to me... after being given the honor
of being able to sign myself as an MVP, there is no obligation to continuing
doing a "good job" afterwards. Well, I have an internal "something" that
won't let me do that. I figure that if I have been given the honor of being
able to sign myself as an MVP, then I should continue trying to perform at
the same level that won me the honor in the first place. So, while this is
not Microsoft's position, I **personally** consider receiving the honor as
binding on me to continue performing at the same level (or better) as I did
the year before. If I should not be re-awarded in October, as I suspect will
probably happen, then I will consider myself free of this "self-imposed"
obligation and this, in return, would allow me to pursue those other
activities I have put off for, oh, some eight years now. If I am re-awarded,
then I'll be back as active as ever; but if I am not re-awarded, then I
won't. As I said, just a heads up in case you need it.

Yes, your last posting is very interesting indeed, and makes perfect
sense to me. It seems my own thinking is forming a similar pattern
after studying many of your postings. I think that's a good thing
overall, but there's times when it's a challenge to get things where
they fall into place as well as you seem to put them. I'm determined to
get there, though!

Thanks for the 'heads up'! I completely understand where you're coming
from. I suppose I should consider doing the same but it's hard to do
most things anymore since I'm forced to spend most my waking hours in a
wheelchair. (I have ALS ..$%^!) Anyway, between here and the VB forum
I've learned so much from all you MVPs, and so I feel I owe it to the
community to give something back. I'm a machinist/toolmaker by
profession but since I can't work at that anymore I decided to teach
myself programming (other than CNC programming) so I could turn some of
my Excel solutions into something anyone could use. My formal ed during
high school and college was business, majoring in accounting and bus.
management. I worked as a cost accountant and forensic auditor for a
fortune500 company after college, but decided I could put my formal ed
to better use working for myself. (that was back in the late 60's!)
Thus, I made a business of working at my hobby. I started using Excel
in v4 while I was teaching at community college. (They were switching
to M$O from Corel Suite) I wish I had put more time into it back then
but I had a business to look after when I wasn't teaching. I started
using VBA on Thanksgiving weekend of 2003, when I picked up my first
book by JWalk. In June 2004 I met Rob Bovey via email and have been a
devotee of the Bovey, Bullen, Green movement ever since. I can't thank
Rob enough for all the help and support he's given to my learning
process. This also extends to all the 'vets' in the NGs. I've read 10s
of thousands of postings and only this year did I start using a
newsreader. Man.., I wish I had done that long, long ago! -website UI
sucks compared to this!

I've been worried that this NG shutdown fiasco might mean losing
contact with the pros I've grown to respect over these past few years.
I'm saddened by your heads up, frankly. Your contributions will be
truly missed! I certainly will appreciate the remaining time you stick
with it all that much more. However, I do sincerely wish you best of
best wishes for your future plans. I promise I will be your fan for
life, and I'll work diligently to prove myself worthy of this honor.

Kind regards,
Garry

See inline...

Yes, your last posting is very interesting indeed, and makes perfect sense
to me. It seems my own thinking is forming a similar pattern after
studying many of your postings.

There are some (many?) who would question whether that is a good thing or
not.<g


I think that's a good thing overall, but there's times when it's a
challenge
to get things where they fall into place as well as you seem to put them.

Hey, don't think for a moment the solutions I post come to me fully formed.
The way my mind works is I see an "outline" (but no details) of the approach
I think will work... I have to fight to get everything to work together
correctly also. That part, to me, is the fun part of programming.


I'm determined to get there, though!

Desire is the first and most important step in accomplishing, well, pretty
much anything. Since you have it, then I am sure you will succeed.


Thanks for the 'heads up'! I completely understand where you're
coming from. I suppose I should consider doing the same but it's
hard to do most things anymore since I'm forced to spend most
my waking hours in a wheelchair. (I have ALS ..$%^!)

I am really very sorry to hear this. I hope the progress of this terrible
disease goes as well as possible for you.


Anyway, between here and the VB forum I've learned so much
from all you MVPs

I used to be an MVP for the compiled version of the classic version of VB
(from VB3 to VB6) before moving over to the Excel world. Perhaps you came
across some of my earlier VB postings in your Google searches.


... and so I feel I owe it to the community to give something back.

Your participation is most welcome.


I'm a machinist/toolmaker by profession but since I can't work at that
anymore I decided to teach myself programming (other than CNC
programming) so I could turn some of my Excel solutions into
something anyone could use. My formal ed during high school and
college was business, majoring in accounting and bus. management.

I was a math major in college.

I worked as a cost accountant and forensic auditor for a fortune500
company after college, but decided I could put my formal ed to better
use working for myself. (that was back in the late 60's!)

I worked for 32-1/2 years with the New Jersey Department of Transportation
here in the US before retiring. The first half of that time was spent
designing roads (I'm a Licensed Professional <Civil Engineer) and the
latter half in the department's CADD Development group (providing
programming supporting for the engineers and draftsmen in their use of the
system).


Thus, I made a business of working at my hobby. I started using Excel in
v4 while I was teaching at community college. (They were switching to M$O
from Corel Suite) I wish I had put more time into it back then but I had a
business to look after when I wasn't teaching.

I moved to Excel solely to be able to continue offering VB help in the
newsgroups. The classic VB newsgroups started to become very slow about five
years ago or so, mainly because of the introduction of VB.NET five years
before that and Microsoft's de-emphasizing of the classic version of VB as a
result. I figured I could apply what I knew about VB programming to the very
active Excel macro world, so I started posting in both worlds for awhile
(using the time to learn parts of the Excel object model) and eventually
changed my MVP discipline from VB to Excel.


I started using VBA on Thanksgiving weekend of 2003, when I picked
up my first book by JWalk.

You remember the exact date? Good memory! I have no idea what the date was
when I started in on Excel.


In June 2004 I met Rob Bovey via email and have been a devotee
of the Bovey, Bullen, Green movement ever since. I can't thank Rob enough
for all the help and support he's given to my learning process. This also
extends to all the 'vets' in the NGs

Yes, there are some very talented individuals involved in the Excel
community and the Internet offers remarkable access to all of them.


Man.., I wish I had done that long, long ago! -website UI sucks
compared to this! I've read 10s of thousands of postings and
only this year did I start using a newsreader.

Yes, I like the newsreader access much better than the website access as
well.


I've been worried that this NG shutdown fiasco might mean losing contact
with the pros I've grown to respect over these past few years.

I am **not** looking forward to the newsgroup shutdowns either... I find the
newsreader approach far more comfortable to use, but I guess I will have to
get used to the forum approach as that is where Microsoft has decided to
take us all. I wouldn't worry about the losing contact with the "pros" as I
expect they will move their volunteering efforts over to the forums when the
newsgroups close down.


I'm saddened by your heads up, frankly. Your contributions will be truly
missed! I certainly will appreciate the remaining time you stick with it
all that much more.

There is always the chance I won't be leaving. Microsoft might renew my MVP
status in October... if they do, I expect I would continue in the Excel
forums. I only gave the heads up because I don't think the volume of my
posting this year will be enough to re-qualify... I had to take nearly a
month off to attend to a problem that needed fixing in my house and then
there is an upcoming family wedding stealing some of my time as well. Maybe
the volume of my postings from now to October will make up for the earlier
deficit, but I kind of doubt it. Anyway, we will see what will be.


However, I do sincerely wish you best of best wishes for your
future plans. I promise I will be your fan for life, and I'll work
diligently to prove myself worthy of this honor.

Thank you for the kind words and sentiments... they are much appreciated.


--
Rick (MVP - Excel)

Hi Rick
Sorry I wasn't clear enough.

The Sub Terranean macro is the quickest but we need to put the data after
some existings data. That's the one that I hope can be modified.

Also need a macro to clear data from the carryover sheet where column N has
a value. This macro will be run before the one to move the data from sales.


Cheers

Alan

"Rick Rothstein" wrote:

See inline...

Yes, your last posting is very interesting indeed, and makes perfect sense
to me. It seems my own thinking is forming a similar pattern after
studying many of your postings.

There are some (many?) who would question whether that is a good thing or
not.<g


I think that's a good thing overall, but there's times when it's a
challenge
to get things where they fall into place as well as you seem to put them.

Hey, don't think for a moment the solutions I post come to me fully formed.
The way my mind works is I see an "outline" (but no details) of the approach
I think will work... I have to fight to get everything to work together
correctly also. That part, to me, is the fun part of programming.


I'm determined to get there, though!

Desire is the first and most important step in accomplishing, well, pretty
much anything. Since you have it, then I am sure you will succeed.


Thanks for the 'heads up'! I completely understand where you're
coming from. I suppose I should consider doing the same but it's
hard to do most things anymore since I'm forced to spend most
my waking hours in a wheelchair. (I have ALS ..$%^!)

I am really very sorry to hear this. I hope the progress of this terrible
disease goes as well as possible for you.


Anyway, between here and the VB forum I've learned so much
from all you MVPs

I used to be an MVP for the compiled version of the classic version of VB
(from VB3 to VB6) before moving over to the Excel world. Perhaps you came
across some of my earlier VB postings in your Google searches.


... and so I feel I owe it to the community to give something back.

Your participation is most welcome.


I'm a machinist/toolmaker by profession but since I can't work at that
anymore I decided to teach myself programming (other than CNC
programming) so I could turn some of my Excel solutions into
something anyone could use. My formal ed during high school and
college was business, majoring in accounting and bus. management.

I was a math major in college.

I worked as a cost accountant and forensic auditor for a fortune500
company after college, but decided I could put my formal ed to better
use working for myself. (that was back in the late 60's!)

I worked for 32-1/2 years with the New Jersey Department of Transportation
here in the US before retiring. The first half of that time was spent
designing roads (I'm a Licensed Professional <Civil Engineer) and the
latter half in the department's CADD Development group (providing
programming supporting for the engineers and draftsmen in their use of the
system).


Thus, I made a business of working at my hobby. I started using Excel in
v4 while I was teaching at community college. (They were switching to M$O
from Corel Suite) I wish I had put more time into it back then but I had a
business to look after when I wasn't teaching.

I moved to Excel solely to be able to continue offering VB help in the
newsgroups. The classic VB newsgroups started to become very slow about five
years ago or so, mainly because of the introduction of VB.NET five years
before that and Microsoft's de-emphasizing of the classic version of VB as a
result. I figured I could apply what I knew about VB programming to the very
active Excel macro world, so I started posting in both worlds for awhile
(using the time to learn parts of the Excel object model) and eventually
changed my MVP discipline from VB to Excel.


I started using VBA on Thanksgiving weekend of 2003, when I picked
up my first book by JWalk.

You remember the exact date? Good memory! I have no idea what the date was
when I started in on Excel.


In June 2004 I met Rob Bovey via email and have been a devotee
of the Bovey, Bullen, Green movement ever since. I can't thank Rob enough
for all the help and support he's given to my learning process. This also
extends to all the 'vets' in the NGs

Yes, there are some very talented individuals involved in the Excel
community and the Internet offers remarkable access to all of them.


Man.., I wish I had done that long, long ago! -website UI sucks
compared to this! I've read 10s of thousands of postings and
only this year did I start using a newsreader.

Yes, I like the newsreader access much better than the website access as
well.


I've been worried that this NG shutdown fiasco might mean losing contact
with the pros I've grown to respect over these past few years.

I am **not** looking forward to the newsgroup shutdowns either... I find the
newsreader approach far more comfortable to use, but I guess I will have to
get used to the forum approach as that is where Microsoft has decided to
take us all. I wouldn't worry about the losing contact with the "pros" as I
expect they will move their volunteering efforts over to the forums when the
newsgroups close down.


I'm saddened by your heads up, frankly. Your contributions will be truly
missed! I certainly will appreciate the remaining time you stick with it
all that much more.

There is always the chance I won't be leaving. Microsoft might renew my MVP
status in October... if they do, I expect I would continue in the Excel
forums. I only gave the heads up because I don't think the volume of my
posting this year will be enough to re-qualify... I had to take nearly a
month off to attend to a problem that needed fixing in my house and then
there is an upcoming family wedding stealing some of my time as well. Maybe
the volume of my postings from now to October will make up for the earlier
deficit, but I kind of doubt it. Anyway, we will see what will be.


However, I do sincerely wish you best of best wishes for your
future plans. I promise I will be your fan for life, and I'll work
diligently to prove myself worthy of this honor.

Thank you for the kind words and sentiments... they are much appreciated.


--
Rick (MVP - Excel)


.

Here is a revision for Sub Terranean for you to try...

Sub Terranean()
Dim LastRow As Long
LastRow = Sheets("Carryovers").Cells.Find(What:="*", _
SearchOrder:=xlRows, SearchDirection:=xlPrevious, _
LookIn:=xlValues).Row
On Error Resume Next
Intersect(Sheets("Sales").Columns("A:T"), Sheets("Sales"). _
Columns("N").SpecialCells(xlCellTypeBlanks). _
EntireRow).Copy Sheets("Carryovers").Cells(LastRow + 1, "A")
End Sub

--
Rick (MVP - Excel)


"ajm1949" wrote in message
...
Hi Rick
Sorry I wasn't clear enough.

The Sub Terranean macro is the quickest but we need to put the data after
some existings data. That's the one that I hope can be modified.

Also need a macro to clear data from the carryover sheet where column N
has
a value. This macro will be run before the one to move the data from
sales.


Cheers

Alan

Also need a macro to clear data from the carryover sheet where
column N has a value. This macro will be run before the one to
move the data from sales.

When you say "clear", I am assuming you mean to delete the entire row so
that no gaps appear in your data rows. You can use this macro to delete the
rows of data on the Carryovers sheet where Column N has a value placed in
it...

Sub ject()
Sheets("Carryovers").Range("N2:N" & Rows.Count). _
SpecialCells(xlCellTypeConstants).EntireRow.Delete
End Sub

--
Rick (MVP - Excel)



"Rick Rothstein" wrote in message
...
Here is a revision for Sub Terranean for you to try...

Sub Terranean()
Dim LastRow As Long
LastRow = Sheets("Carryovers").Cells.Find(What:="*", _
SearchOrder:=xlRows, SearchDirection:=xlPrevious, _
LookIn:=xlValues).Row
On Error Resume Next
Intersect(Sheets("Sales").Columns("A:T"), Sheets("Sales"). _
Columns("N").SpecialCells(xlCellTypeBlanks). _
EntireRow).Copy Sheets("Carryovers").Cells(LastRow + 1, "A")
End Sub

--
Rick (MVP - Excel)


"ajm1949" wrote in message
...
Hi Rick
Sorry I wasn't clear enough.

The Sub Terranean macro is the quickest but we need to put the data after
some existings data. That's the one that I hope can be modified.

Also need a macro to clear data from the carryover sheet where column N
has
a value. This macro will be run before the one to move the data from
sales.


Cheers

Alan

Damn, I forgot the On Error statement (needed in case all of Column N is
blank)...

Sub ject()
On Error Resume Next
Sheets("Carryovers").Range("N2:N" & Rows.Count). _
SpecialCells(xlCellTypeConstants).EntireRow.Delete
End Sub

--
Rick (MVP - Excel)



"Rick Rothstein" wrote in message
...
Also need a macro to clear data from the carryover sheet where
column N has a value. This macro will be run before the one to
move the data from sales.

When you say "clear", I am assuming you mean to delete the entire row so
that no gaps appear in your data rows. You can use this macro to delete
the rows of data on the Carryovers sheet where Column N has a value placed
in it...

Sub ject()
Sheets("Carryovers").Range("N2:N" & Rows.Count). _
SpecialCells(xlCellTypeConstants).EntireRow.Delete
End Sub

--
Rick (MVP - Excel)



"Rick Rothstein" wrote in message
...
Here is a revision for Sub Terranean for you to try...

Sub Terranean()
Dim LastRow As Long
LastRow = Sheets("Carryovers").Cells.Find(What:="*", _
SearchOrder:=xlRows, SearchDirection:=xlPrevious, _
LookIn:=xlValues).Row
On Error Resume Next
Intersect(Sheets("Sales").Columns("A:T"), Sheets("Sales"). _
Columns("N").SpecialCells(xlCellTypeBlanks). _
EntireRow).Copy Sheets("Carryovers").Cells(LastRow + 1, "A")
End Sub

--
Rick (MVP - Excel)


"ajm1949" wrote in message
...
Hi Rick
Sorry I wasn't clear enough.

The Sub Terranean macro is the quickest but we need to put the data
after
some existings data. That's the one that I hope can be modified.

Also need a macro to clear data from the carryover sheet where column N
has
a value. This macro will be run before the one to move the data from
sales.


Cheers

Alan

Rick Rothstein pretended :
See inline...

Yes, your last posting is very interesting indeed, and makes perfect sense
to me. It seems my own thinking is forming a similar pattern after studying
many of your postings.

There are some (many?) who would question whether that is a good thing or
not.<g

I would not be one of those!<g


I think that's a good thing overall, but there's times when it's a
challenge
to get things where they fall into place as well as you seem to put them.

Hey, don't think for a moment the solutions I post come to me fully formed.
The way my mind works is I see an "outline" (but no details) of the approach
I think will work... I have to fight to get everything to work together
correctly also. That part, to me, is the fun part of programming.

Isn't that the truth!


I'm determined to get there, though!

Desire is the first and most important step in accomplishing, well, pretty
much anything. Since you have it, then I am sure you will succeed.

Well, the ALS know-it-alls can't figure out why I'm still here. They
claim my passion for my work is what keeps me going. (I was diagnosed
Mar '95 after 2+ years of tests)


Thanks for the 'heads up'! I completely understand where you're
coming from. I suppose I should consider doing the same but it's
hard to do most things anymore since I'm forced to spend most
my waking hours in a wheelchair. (I have ALS ..$%^!)

I am really very sorry to hear this. I hope the progress of this terrible
disease goes as well as possible for you.

Thanks for the sentiment! What would make me happy is if its progress
doesn't go so well!<g That way I'll live longer!<bg

(I know what you meant so please forgive my sense of humor)


Anyway, between here and the VB forum I've learned so much
from all you MVPs

I used to be an MVP for the compiled version of the classic version of VB
(from VB3 to VB6) before moving over to the Excel world. Perhaps you came
across some of my earlier VB postings in your Google searches.

Yes, your name is familiar from both NGs.


... and so I feel I owe it to the community to give something back.

Your participation is most welcome.

Thanks! I'll do my best to make it worthy of membership!


I'm a machinist/toolmaker by profession but since I can't work at that
anymore I decided to teach myself programming (other than CNC
programming) so I could turn some of my Excel solutions into
something anyone could use. My formal ed during high school and
college was business, majoring in accounting and bus. management.

I was a math major in college.

I was a math failure until I started having to use it every day whether
I liked to or not.

I worked as a cost accountant and forensic auditor for a fortune500
company after college, but decided I could put my formal ed to better
use working for myself. (that was back in the late 60's!)

I worked for 32-1/2 years with the New Jersey Department of Transportation
here in the US before retiring. The first half of that time was spent
designing roads (I'm a Licensed Professional <Civil Engineer) and the latter
half in the department's CADD Development group (providing programming
supporting for the engineers and draftsmen in their use of the system).

That's interesting. When I first started programming in VBA, it was
while working for one of the major engine rebuilding equipment
manufacturers, designing machine fixtures and specialty tooling. I've
been using CADD software since the late 80's. I still do some free
lance stuff. During those years I got a chance to work with many
programs, some mickey mouse but most fairly serious (AutoCad, ME10/ME30
(Unix), CadKey, SolidWorks, ..to name a few) I now just use SolidWorks.

CNC machining programming was all I was familiar with before getting
into VBA.


Thus, I made a business of working at my hobby. I started using Excel in v4
while I was teaching at community college. (They were switching to M$O from
Corel Suite) I wish I had put more time into it back then but I had a
business to look after when I wasn't teaching.

I moved to Excel solely to be able to continue offering VB help in the
newsgroups. The classic VB newsgroups started to become very slow about five
years ago or so, mainly because of the introduction of VB.NET five years
before that and Microsoft's de-emphasizing of the classic version of VB as a
result. I figured I could apply what I knew about VB programming to the very
active Excel macro world, so I started posting in both worlds for awhile
(using the time to learn parts of the Excel object model) and eventually
changed my MVP discipline from VB to Excel.

Well, I'm sure glad you're here!


I started using VBA on Thanksgiving weekend of 2003, when I picked
up my first book by JWalk.

You remember the exact date? Good memory! I have no idea what the date was
when I started in on Excel.

I remember because it seems like a week ago or so. Hey.., I'm a newbie,
and so it goes that I should still remember!


In June 2004 I met Rob Bovey via email and have been a devotee
of the Bovey, Bullen, Green movement ever since. I can't thank Rob enough
for all the help and support he's given to my learning process. This also
extends to all the 'vets' in the NGs

Yes, there are some very talented individuals involved in the Excel community
and the Internet offers remarkable access to all of them.


Man.., I wish I had done that long, long ago! -website UI sucks
compared to this! I've read 10s of thousands of postings and
only this year did I start using a newsreader.

Yes, I like the newsreader access much better than the website access as
well.


I've been worried that this NG shutdown fiasco might mean losing contact
with the pros I've grown to respect over these past few years.

I am **not** looking forward to the newsgroup shutdowns either... I find the
newsreader approach far more comfortable to use, but I guess I will have to
get used to the forum approach as that is where Microsoft has decided to take
us all. I wouldn't worry about the losing contact with the "pros" as I expect
they will move their volunteering efforts over to the forums when the
newsgroups close down.


I'm saddened by your heads up, frankly. Your contributions will be truly
missed! I certainly will appreciate the remaining time you stick with it
all that much more.

There is always the chance I won't be leaving. Microsoft might renew my MVP
status in October... if they do, I expect I would continue in the Excel
forums. I only gave the heads up because I don't think the volume of my
posting this year will be enough to re-qualify... I had to take nearly a
month off to attend to a problem that needed fixing in my house and then
there is an upcoming family wedding stealing some of my time as well. Maybe
the volume of my postings from now to October will make up for the earlier
deficit, but I kind of doubt it. Anyway, we will see what will be.


However, I do sincerely wish you best of best wishes for your
future plans. I promise I will be your fan for life, and I'll work
diligently to prove myself worthy of this honor.

Thank you for the kind words and sentiments... they are much appreciated.

Regards,
Garry