Monday, March 18, 2013

yogi_Pull Select Data From Sheet Complaints Into Sheet Investigation Per User Specification


                                          Google Spreadsheet   Post  #1085
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Mar 18, 2013
user Inv Downs :(http://productforums.google.com/forum/?zx=9bydteme3h15#!category-topic/docs/spreadsheets/2ad-FzeFS-k)
Hello, I need some help on creating a formula to import the datarange from A2:E2 ( below ) from a master spreadsheet called "Complaints" to another spreadsheet Called "Investigations"  which has the same field names  A2:E2 on this spreadsheet , However I only want the data imported if  "Yes" is entered in the field (Generate Report) which is Column U in the Complaints spreadsheet. 

I have tried many formulas to no avail. 

My table looks like this

          A             B                            C                          D                   E                                               U

1    CC#      ViolAddrs              ViolStrt                Hamlet           SCTM#                               Generate Report    <-----------FEILD NAMES


2   130043     13                     Smith Street             Medford          123.-2-13                                         Yes  

3


4
---
Here is the link to the spreadsheet, as I still can not seem to accomplish this task...ughh.


I would like certain row data from spreadsheet complaints to be exported to spreadsheet Investigations when the Generate Report column is set to yes or not null.

The row data that I would like exported over (from spreadsheet complaints) is  within column A, B, C, D, E, L, M, N and that said data would be imported into same columns in spreadsheet investigations (A, B, C, D, E) however L, M, N would go to columns H, I, J as the information is the same. 

Any help would be greatly appreciated.

Thanks so much. 
---------------------------------------------------------------------------------------------------------------
following is a solution to the problem


2 comments:

  1. Thanks Yogi for the help in solving this for me you rock! However now that you solved it the spreadsheet does not really work for what I designed, I am using autocrat and need to be able to query data exactly like you did above but to a different workbook, worksheet. So the question is where would I insert the worksheet key # in this formula to pull the same data as above to another workbook sheet. I have experimented with ImportRange etc to no avail.

    ReplyDelete
  2. Hi Inv Downs:

    If You want to pull select data into another workbook, you will have to use the IMPORTRANGE function to pull the data from the other workbook.

    Make It A Great One
    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete