M
Moneyman6369
Hey,
Bare with my apparent naivete; I am a complete novice to macroing and need
some help setting up what I think should be simple, but on the other hand,
who am I to judge? ;p
I understand the record function fine, but it's when you're editing and
adapting the macro in Visual Basic that I begin to become confused.
What I need to be able to do is to copy information from a cell in Sheet 1,
and then copy it into a second cell, in Sheet 2. I got that part down ;p What
I need help with is, if the cell to be copied into already has an entry, to
copy into the cell below that, and if that cell already has an entry, go one
more down, etc, indefinitely.
I have tried applying the If code, but, unlike the function, it doesn't seem
to have a option of what to do if the requirement is not fulfilled; it only
executes if if=true. Unless, of course, I am completely missing it.
Anyhow, anyone who can shed some light on the situation or simply even just
give me the code and tell me where to enter the cells I would use, your
response is extremely welcome.
Bare with my apparent naivete; I am a complete novice to macroing and need
some help setting up what I think should be simple, but on the other hand,
who am I to judge? ;p
I understand the record function fine, but it's when you're editing and
adapting the macro in Visual Basic that I begin to become confused.
What I need to be able to do is to copy information from a cell in Sheet 1,
and then copy it into a second cell, in Sheet 2. I got that part down ;p What
I need help with is, if the cell to be copied into already has an entry, to
copy into the cell below that, and if that cell already has an entry, go one
more down, etc, indefinitely.
I have tried applying the If code, but, unlike the function, it doesn't seem
to have a option of what to do if the requirement is not fulfilled; it only
executes if if=true. Unless, of course, I am completely missing it.
Anyhow, anyone who can shed some light on the situation or simply even just
give me the code and tell me where to enter the cells I would use, your
response is extremely welcome.