+ Reply to Thread
Results 1 to 8 of 8

Pulling Info from one sheet to another based on information found in one cell

  1. #1
    Registered User
    Join Date
    11-06-2015
    Location
    Springfield, MO
    MS-Off Ver
    2013
    Posts
    8

    Pulling Info from one sheet to another based on information found in one cell

    OK I need help with figuring this formula out.

    I am needing to pull certain columns from one spreadsheet to another, but I only want it to do if one of the cells in the first sheet reads a particular piece of information.
    So for example I need to display on Sheet 2 any info from columns E-P on if the info in Column C Reads "Commercial" on Sheet 1. I know I would have to go Row by row, but I think you get the idea. I am sure I will have to go to each column in sheet 2 and adjust the formula for the corresponding column I want from Sheet 1. I just need to know where to start. I tried something like =IF(ISERROR(MATCH('Form Responses 1'!D:D,0)),"Commercial",VLOOKUP('Form Responses 1'!J:J,FALSE))
    That just brings over the commercial part. I'm sure it's something easy and I am probably overthinking it at this point, but any hep would be appreciated.

  2. #2
    Forum Contributor Obsessed's Avatar
    Join Date
    05-22-2013
    Location
    Cincinnati, Ohio
    MS-Off Ver
    Excel 365
    Posts
    215

    Re: Pulling Info from one sheet to another based on information found in one cell

    Is "Commercial" always by itself in a cell? Is it always in the same cell, or can it be anywhere in column C? How many rows need to be moved over? Depending...I'd really recommend VBA for this. This is going to end up being a formula nightmare. Not hard formulas...but you'll need one for every cell you want to copy data to.
    Want to show appreciation for the help you received from a member? Give them reps by clicking the bottom left of their post!

  3. #3
    Registered User
    Join Date
    11-06-2015
    Location
    Springfield, MO
    MS-Off Ver
    2013
    Posts
    8

    Re: Pulling Info from one sheet to another based on information found in one cell

    That Cell will either read Commercial or Residential. If it reads Commercial I need too be able to pull info from other cells. I know I have to duplicate the formula for each cell and modify it to some for each. It will be like 9 or 10 columns worth of info. So not a ton of repeating but a bit. So to make it simple I need something like if C2 on sheet 1 reads Commercial then the info from D2 on sheet 1 and so on and so on.

  4. #4
    Forum Contributor Obsessed's Avatar
    Join Date
    05-22-2013
    Location
    Cincinnati, Ohio
    MS-Off Ver
    Excel 365
    Posts
    215

    Re: Pulling Info from one sheet to another based on information found in one cell

    Can you upload a workbook for me to work off of with example data in it?

  5. #5
    Registered User
    Join Date
    11-06-2015
    Location
    Springfield, MO
    MS-Off Ver
    2013
    Posts
    8

    Re: Pulling Info from one sheet to another based on information found in one cell

    So In this example I would need the info in cells E, F, G, H, and I if D says Commercial. If it says residential I don't need it to pull any info.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    11-06-2015
    Location
    Springfield, MO
    MS-Off Ver
    2013
    Posts
    8

    Re: Pulling Info from one sheet to another based on information found in one cell

    Of course I would need to do this with the entire sheet going down to row whatever

  7. #7
    Forum Contributor Obsessed's Avatar
    Join Date
    05-22-2013
    Location
    Cincinnati, Ohio
    MS-Off Ver
    Excel 365
    Posts
    215

    Re: Pulling Info from one sheet to another based on information found in one cell

    Ah. I was misunderstanding the layout at first. VBA is the only practical solution here. You comfortable with that? I can throw something together quickly for you if you're okay with a macro solution.

    If so, which columns do you want it pasted into in sheet 2? Just want to mimic sheet one, pulling out all the residential? Headers get copied as well, I suppose?

  8. #8
    Registered User
    Join Date
    11-06-2015
    Location
    Springfield, MO
    MS-Off Ver
    2013
    Posts
    8

    Re: Pulling Info from one sheet to another based on information found in one cell

    As long as it works I am ok with anything. Thanks for the help

    Headers don't need to copy per say I can do that part. Essentially for the purpose of that example the info I would need in sheet 2 is Columns E-I. That is approximately the info I need in what I am working on.Maybe one or 2 more pieces of info, but not a lot. And yes anything that is residential can be excluded completely.
    Last edited by Tromgood; 11-06-2015 at 11:58 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 03-06-2013, 01:09 PM
  2. Replies: 1
    Last Post: 02-03-2013, 09:54 PM
  3. Pulling info from master sheet to sheet 2 based on ID number input
    By GSI2013 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-25-2013, 12:38 PM
  4. Need help pulling information from a cell, based on two matching criteria
    By acvitanov in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-18-2012, 06:45 PM
  5. Replies: 1
    Last Post: 06-28-2012, 03:59 AM
  6. Replies: 1
    Last Post: 07-14-2010, 07:08 PM
  7. Pulling Information in seperate sheet based on data in current sheet
    By joekunin in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-03-2009, 05:06 AM
  8. Replies: 2
    Last Post: 05-12-2006, 05:15 AM

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