import data

  • Thread starter Thread starter cgkeel
  • Start date Start date
C

cgkeel

I have a workbook with 6 worksheets. I need to pull
specific data from one sheet to one of the other 5. For
example: If O99 ="X" the I need all the data from row 99
to goto sheet A row 1(columns a-s), if O110 ="X" I need it
to goto sheet A row 2 and if O76="Y" I need it to goto
sheet B row 1 (columns a-s).

Thanks for your help.
 
Would this work?

Sheet1
O99 = X
P99 = Y
Q99 = Z....

Sheet2
A1 = IF(Sheet1!$O$99 = "X", Sheet1!A$99,"")
B1 = IF(Sheet1!$O$99 = "X", Sheet1!B$99,"").... Copy this formula across.

Depending how large this spreadsheet is, all these formulas could make the
file size very large. Or you could write a macro that would evaluate the
cell and copy/paste the values in the required cells.
 
I have a workbook with 6 worksheets. I need to pull
specific data from one sheet to one of the other 5. For
example: If O99 ="X" the I need all the data from row 99
to goto sheet A row 1(columns a-s), if O110 ="X" I need it
to goto sheet A row 2 and if O76="Y" I need it to goto
sheet B row 1 (columns a-s).
Click to expand...

Unless your data as a whole would exceed 65,536 rows, the expedient way to do
this would be to combine all your data into a single table on yet another
worksheet, possibly add field names in the top row of this new worksheet and
also in the top rows of the destination worksheets (the ones where the data
should end up), then use an Advanced Filter to populate the destination
worksheets based on a criteria range for column O. Macros would be next best.
 
Back
Top