sample macro

  • Thread starter Thread starter alex
  • Start date Start date
A

alex

hello everyone.

can someone give me a sample code that could scanned a column for non-blank
cell of another worksheet and retrieve data to be entered to another
worksheet. honestly, i don't know how to make a macro but i've read it could
be done with looping statement.

thanks
 
yes, i need to copy non-blank cells to another worksheets. it's really
comlicated to explain since there will be set of conditions to the whole
process but yes generally that's what supposed to happened. this would be the
first time i actually be doing macro.
 
The macro recorder can be your friend. Record a macro while doing
data>filter>autofilter>non blank>copy>paste
 
Thanks Don, but the data i want to copy needs to meet certain conditions. how
could i attached a file so i could explain it better.
 
You can't attach a file here and shouldn't anyway. If desired, send you file
to my address below along with a very clear explanation of what you want,
snippets of these messages copied to an inserted sheet, and before/after
examples.
 
You can post to free shared sites like: 4shared.com, box.net and
mediafire.com.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Macro... 8
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Need to run a Macro to .... 3
VBA - retrieve data on last create named range from previous inserted named range 0
Tools for Analysis - Samples with VBA 3
Excel 2013 Merge Data 2
Programatically changing the macro content. 1
Help needed 0

Back
Top