Hello everbody .
I need help to create a macro(I just start to use macro).
So I'm looking for a macro that will check in
Sheets("pequenas_granel_1").Range("C13:D13") need to copy it if
Range("G13:J13") has some value, so if Range("G13:J13") has value copy
Range("C13:G13") and Range("G13:J13") to Sheets("BD") column "F" next
empty line, go back to Sheets("pequenas_granel_1") check
Range("G14:J14") if has value, if yes than copy Range("C14:G14") and
Range("G14:J14") to "BD" column F next empty line until reach line 27
so that verification start in line 13 until 27 .
Them from line 27 jump to line 32 and start same verification above
from line 32 Range("G32:J32") till line 36 Range("G36:J36"), jump to
line 41 and do same verification above from line 41 Range("G41:J41")
till line 43 Range("G43:J43"), jump to line 48 and do same
verification above from line 48 Range("G48:J48") till line 49
Range("G49:J49"), jump to line 55 and do same verification above from
line 55 Range("G55:J55") till line 56 Range("G56:J56").After that
clean Range("G13:J13"),Range("G14:J14") ...Range("G56:J56")if those
had some value.
And than same verification for next block of information from
Range("L13:O13") if has value copy Range("C13:D13") and
Range("L13:O13") to "BD" column F next empty line all the same like
above , Same situation from column Range("Q:T") and column
Range("V:Y") till line 56 as well
I don't know if Am I clear with you because is pretty hard to explain
what I need in that case, even because my knwoledge is really few
about macro.I did some change in my macro so I'll send it but doesn't
work well
Thank you in Advanced, any help will be really good.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
