+ Reply to Thread
Results 1 to 4 of 4

Pull data into a unique table?

  1. 08-01-2015, 07:15 AM #1
    ccastell88
    ccastell88 is offline
    Registered User
    Join Date
    11-25-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    82

    Pull data into a unique table?

    Hi Guys,

    Basically i want to pull data from two different sheets (keyword and volumes + URLs) in the attached workbook and make it look like the output (example of output sheet) or something very similar in the example of output sheet.

    So each URL from the URLs sheet has the all the related keywords sorted by search volume from the keywords and volumes sheet as shown in the example of output.

    I think this is a doable with a pivot table but beyond my current excel expertise to mentally figure it out.

    Any suggestions would be very much appreciated!

    Cheers,
    Chris
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-01-2015, 07:26 PM #2
    micope21
    micope21 is offline
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: Pull data into a unique table?

    Hi

    Keywords and Volumes sheet
    Make sure you put in n/a instead #N/A! Otherwise formula Example of output sheet will get #N/A!

    A3
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Copy down and cross.

    See the file.
    Attached Files Attached Files
    Last edited by micope21; 08-02-2015 at 03:10 AM.
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".
    Reply With QuoteRegister To Reply
  3. 08-02-2015, 07:49 PM #3
    ccastell88
    ccastell88 is offline
    Registered User
    Join Date
    11-25-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    82

    Re: Pull data into a unique table?

    Hi thanks micope21.

    Is there a way to automate it?

    The method you provided, you will still need to manually add and pull data for each URL (on the URLs sheet) which would take a very long time to do.
    Reply With QuoteRegister To Reply
  4. 08-03-2015, 04:02 AM #4
    micope21
    micope21 is offline
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: Pull data into a unique table?

    Hi

    No, not in formula to carry next one after other!! You need VBA to do that?

    I'm not that good on VBA than I do with formula!

    Solved this thread (Click Thread Tools above your first post, select "Mark your thread as Solved".)

    Start a new thread this time VBA instead general.

    Hopefully someone in VBA will help you?

    The one I done. You type your url on cell A2 will automatic change the row.

    Thank you for reputation.

    All the best

    Regard
    Last edited by micope21; 08-03-2015 at 05:10 AM.
    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] Formula to Pull Data from Table
    By arpanpanchal in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 03-04-2015, 07:57 PM
  2. How to use pivot table to pull out most recent data with unique ID?
    By blackscholes in forum Excel General
    Replies: 3
    Last Post: 05-21-2014, 08:34 AM
  3. [SOLVED] Pull Data from one table to another
    By cjest2002 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-15-2013, 07:53 PM
  4. Pull data from HTML tag which is unique (tag within a tag)
    By gochel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-21-2013, 08:54 PM
  5. I need help to pull data that does not have unique values into another page
    By adman42 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-11-2013, 04:22 PM
  6. Pull unique data within a date range that matches criteria...confused.
    By LawC in forum Excel General
    Replies: 6
    Last Post: 09-12-2011, 12:51 PM
  7. Pull pivot table data
    By Dave in forum Excel General
    Replies: 1
    Last Post: 05-19-2006, 08:10 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