for some reason it wont work but you should be able to paste this data
data name nam nam nam nam nam nam nam
3/5/2012 random john bob dog bob john new
name nam
3/6/2012 random john bob dog bob john new
name nam
3/6/2012 random john bob dog bob john new
name nam
3/6/2012 bob dog bob john random random
john bob
3/6/2012 john bob dog bob john random
john bob
3/6/2012 random john bob dog bob john new
name nam
3/6/2012 bob bob dog bob john random
john bob
3/6/2012 random john bob bob random random
john bob
3/6/2012 random john bob dog bob john new
name nam
Name report
On Mar 6, 8:30 am, Sam Mathai Chacko <samde...@gmail.com> wrote:
> Will be easier if you attach a sample file
>
> Sam
>
>
>
>
>
>
>
>
>
> On Tue, Mar 6, 2012 at 5:51 AM, LearnExcel <sendse...@gmail.com> wrote:
> > Hi Guys/Girls i use VBA to copy a range using the following code
>
> > Selection.AutoFilter Field:=7, Criteria1:="bob"
> > ActiveSheet.Range("a1:o1", ActiveSheet.Range("a1").End(xlDown)).Select
>
> > the problem that i have is in cell "G" after the last cell there is a
> > 3 lines of blank cell and then the report,
>
> > once the filter is made i want the cell to also include the"Name
> > report"
>
> > can anyone help?
>
> > data name nam nam nam nam nam nam nam
> > 3/5/2012 random john bob dog bob john new name
> > nam
> > 3/6/2012 random john bob dog bob john new name
> > nam
> > 3/6/2012 random john bob dog bob john new name
> > nam
> > 3/6/2012 bob dog bob john random random john bob
> > 3/6/2012 john bob dog bob john random john bob
> > 3/6/2012 random john bob dog bob john new name
> > nam
> > 3/6/2012 bob bob dog bob john random john bob
> > 3/6/2012 random john bob bob random random john bob
> > 3/6/2012 random john bob dog bob john new name
> > nam
>
> > Name report
>
> > --
> > FORUM RULES (986+ members already BANNED for violation)
>
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> > will not get quick attention or may not be answered.
>
> > 2) Don't post a question in the thread of another member.
>
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
>
> > 4) Acknowledge the responses you receive, good or bad.
>
> > 5) Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
>
> > NOTE : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
>
> > ---------------------------------------------------------------------------
> > ---------------------------
> > To post to this group, send email to excel-macros@googlegroups.com
>
> --
> Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
