Help with the simpliest macro ever...

  • Thread starter Thread starter Moneyman6369
  • Start date Start date
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.
 
Moneyman,

The focus of this newsgroup is macros in Access, the database program. Your
question appears to relate to another product, possibly Excel. You will
have a better chance of getting good help if you re-post to a newsgroup
related to this product.
 
Moneyman,

The focus of this newsgroup is macros in Access, the database program. Your
question appears to relate to another product, possibly Excel. You will
have a better chance of getting good help if you re-post to a newsgroup
related to this product.
 
Back
Top