Hi Juracy,
I found that this query of yours has not been answered.
Suggestion:- Try recording a macro for this OR try to refine your
requirement(s). In order to record a macro go to Tools->Macro -> Record New
Macro. and follow your steps.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Mon, Feb 8, 2010 at 3:04 AM, Juracy <juracyamer...@gmail.com> wrote:
> 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
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 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
