+ Reply to Thread
Results 1 to 13 of 13

Extracting data with advance filter only from range of cells that have value

  1. 07-17-2013, 04:56 AM #1
    Pilot5000
    Pilot5000 is offline
    Registered User
    Join Date
    05-28-2013
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    96

    Post Extracting data with advance filter only from range of cells that have value

    I have this code to extract data with advance filter from one sheet to another based on one criteria , which I made myself, my problems is as follow : when I run the macro I would like the advance filter to choose information only from the range of cell that have value (i.e. my data base table range is A1:Q100 , the cell that contain value is fluctuate every months , one week is a1:Q55 , and week later is A1:Q69 , and here is where I need your assistance) and not from all the table range , my question how I can change the line 13 in my code " Sheets("Database").Range("B7:Q100").AdvancedFilter Action:=xlFilterCopy,CriteriaRange:=Range("IncOverTime!Criteria"),CopyToRange:=Range("B46:Q46") _ , Unique:=False" and change the rage "B7:Q100" to the range of cells that have value only 

    Please Login or Register  to view this content.
    Thank you in advance for your collaboration
    Last edited by Pilot5000; 07-17-2013 at 06:44 AM. Reason: change of title
    Reply With QuoteRegister To Reply
  2. 07-17-2013, 06:37 AM #2
    Pilot5000
    Pilot5000 is offline
    Registered User
    Join Date
    05-28-2013
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    96

    Re: Looking for more effective solution

    hi

    I am sorry for that I read the rules , sometime it little bit hard to understand everything , I will do the change of the title and post that again , I also have another question for you , in my inbox I messages from you that I am not sure addressed to me, do you something about that ?
    Reply With QuoteRegister To Reply
  3. 07-17-2013, 06:42 AM #3
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Extracting data with advance filter only from range of cells that have value

    I have sent you messages? Can you please forward them back to me so i can take a look? I dont recollect sending you any.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
  4. 07-17-2013, 06:47 AM #4
    Pilot5000
    Pilot5000 is offline
    Registered User
    Join Date
    05-28-2013
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    96

    Re: Extracting data with advance filter only from range of cells that have value

    I already changed the title of my post as you advice me , thank you for that , regarding the info in my inbox can I send that to you as private message ? or you want me to post here all the message I see in my inbox regarding you ?
    Reply With QuoteRegister To Reply
  5. 07-17-2013, 08:01 AM #5
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Extracting data with advance filter only from range of cells that have value

    Send it to me as a private message,.
    Reply With QuoteRegister To Reply
  6. 07-17-2013, 01:48 PM #6
    Pilot5000
    Pilot5000 is offline
    Registered User
    Join Date
    05-28-2013
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    96

    Re: Extracting data with advance filter only from range of cells that have value

    I tried to send you the messages as private message but I keep getting the following massages,"
    The following errors occurred with your submission
    arlu1201 has exceeded their stored private messages quota and cannot accept further messages until they clear some space.
    Reply With QuoteRegister To Reply
  7. 07-17-2013, 01:50 PM #7
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Extracting data with advance filter only from range of cells that have value

    Sorry, i have cleared my inbox now.
    Reply With QuoteRegister To Reply
  8. 07-18-2013, 11:33 AM #8
    Pilot5000
    Pilot5000 is offline
    Registered User
    Join Date
    05-28-2013
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    96

    Re: Extracting data with advance filter only from range of cells that have value

    Quote Originally Posted by arlu1201 View Post
    Sorry, i have cleared my inbox now.
    I tried again today but that what I am getting "
    Errors


    The following errors occurred with your submission
    arlu1201 has exceeded their stored private messages quota and cannot accept further messages until they clear some space.


    Your Message
    Reply With QuoteRegister To Reply
  9. 07-18-2013, 11:36 AM #9
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Extracting data with advance filter only from range of cells that have value

    Sorry, it got full again. Cleared it now.
    Reply With QuoteRegister To Reply
  10. 07-19-2013, 07:40 AM #10
    Pilot5000
    Pilot5000 is offline
    Registered User
    Join Date
    05-28-2013
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    96

    Re: Extracting data with advance filter only from range of cells that have value

    ok I will try again, maybe if you have some time can you try to help me with my problem I posted ?
    Reply With QuoteRegister To Reply
  11. 07-19-2013, 08:01 AM #11
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Extracting data with advance filter only from range of cells that have value

    What you found and sent me in a PM are visitor messages in MY inbox not yours . You can leave them alone as they wont bother you.
    Reply With QuoteRegister To Reply
  12. 07-19-2013, 08:28 AM #12
    powdow
    powdow is offline
    Registered User
    Join Date
    05-20-2013
    Location
    Boston
    MS-Off Ver
    Excel 2010
    Posts
    38

    Re: Extracting data with advance filter only from range of cells that have value

    Try this on line 13.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  13. 07-19-2013, 10:28 AM #13
    Pilot5000
    Pilot5000 is offline
    Registered User
    Join Date
    05-28-2013
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    96

    Re: Extracting data with advance filter only from range of cells that have value

    ok thank you for the info
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Can this method of Ranking be modified to be more effective?
    By ephkay in forum Excel General
    Replies: 2
    Last Post: 01-14-2013, 01:19 PM
  2. [SOLVED] effective gross income
    By Ror in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-10-2006, 04:20 AM
  3. [SOLVED] Effective Data structure required
    By thiaga in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2006, 04:15 PM
  4. [SOLVED] More effective code
    By Roman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2005, 12:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1