+ Reply to Thread
Results 1 to 1 of 1

Pulling data lines based on criteria - VBA

  1. #1
    Registered User
    Join Date
    10-16-2012
    Location
    Maidenhead
    MS-Off Ver
    Excel 2010
    Posts
    2

    Pulling data lines based on criteria - VBA

    Hello all,

    In the attached spreadsheet (Only looking at 'Report' and 'Data' tabs. I have various dropdown boxes for users to use to select the criteria for their report. I need to pull certain fields from the 'data' sheet based on the criteria given. I wouldn't even be sure how to go about this. Could someone point me in the right direction?

    I also need the criteria to be ignored if the boxes are left empty. so empty = all.

    CAPEX Dropdown : column V in 'Data' sheet
    Capitalised? Dropdown: This needs to pull the data based on column 'A' in 'data' sheet. YES = anything with values in column A, NO = Anything with blank in column A, (Blank) = all.
    Period From & To Dropdown: Column C in 'data' sheet. blank should be all.

    If too complicated, just setting me on the right path for what macros I should be using would help. I can do some jigging myself.

    Regards,
    James
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1