Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pulling raw data: TIME IS RUNNING OUT!
Can someone please tell me the clear procedure of pulling specific data that
meets a certain criteria from one worksheet to paste on another. It's a very large document and it would require alot of sifting. I don't have much time. Please help me. Also, once the data is pulled, I'll have to add a column with information corresponding to the rows that I pulled. So information on how to do that would be appreciated. Thanks. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pulling raw data: TIME IS RUNNING OUT!
I would set up another field in your data called "Record" and number the
table 1 through whatever. When the data gets pulled or copied to another sheet, include the record number and you'll have a cross reference between the two tables. If the conditions are not too complex, you might be able to use the autofilter on your table (under Data/Filter/Autofilter - don't know where it would be in XL07). Otherwise, perhaps use formulae in one or more empty columns (helper columns)next to your data table to perform your conditional tests (set the formulae up to return 1 or 0 or TRUE/FALSE) and use the autofilter on these helper columns. Then copy/paste the filtered data to your destination worksheet (including the record number). Then delete the helper columns. Sorry I can't assist w/ formulas or more details than this, but you did not include any info about your data, how it is set up, or what your criteria are. I'm getting ready to sign off for the evening- perhaps someone else will assist if you have additional questions. Just be sure to add some details - you'll get better responses. "Determined07" wrote: Can someone please tell me the clear procedure of pulling specific data that meets a certain criteria from one worksheet to paste on another. It's a very large document and it would require alot of sifting. I don't have much time. Please help me. Also, once the data is pulled, I'll have to add a column with information corresponding to the rows that I pulled. So information on how to do that would be appreciated. Thanks. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pulling raw data: TIME IS RUNNING OUT!
Ahh... I see some details in another post.
If you're looking for A, C, H, P, and Z in a particular cell (say B2), you could put this in an adjacent empty cell =OR(B2={"A","C","H","P","Z"}) copy it down the length of your table and then filter on this column for TRUE (if autofilter does not recognize where your table is at, you may need to select/highlight your table before activating autofilter). Only those records that TRUE will be left visible. And you could set up additional columns for other tests and filter each of those columns so that, when all of your filters are applied, all that is visible is the info you need. Then copy/paste to another sheet (XL does not copy rows hidden by the autofilter). "JMB" wrote: I would set up another field in your data called "Record" and number the table 1 through whatever. When the data gets pulled or copied to another sheet, include the record number and you'll have a cross reference between the two tables. If the conditions are not too complex, you might be able to use the autofilter on your table (under Data/Filter/Autofilter - don't know where it would be in XL07). Otherwise, perhaps use formulae in one or more empty columns (helper columns)next to your data table to perform your conditional tests (set the formulae up to return 1 or 0 or TRUE/FALSE) and use the autofilter on these helper columns. Then copy/paste the filtered data to your destination worksheet (including the record number). Then delete the helper columns. Sorry I can't assist w/ formulas or more details than this, but you did not include any info about your data, how it is set up, or what your criteria are. I'm getting ready to sign off for the evening- perhaps someone else will assist if you have additional questions. Just be sure to add some details - you'll get better responses. "Determined07" wrote: Can someone please tell me the clear procedure of pulling specific data that meets a certain criteria from one worksheet to paste on another. It's a very large document and it would require alot of sifting. I don't have much time. Please help me. Also, once the data is pulled, I'll have to add a column with information corresponding to the rows that I pulled. So information on how to do that would be appreciated. Thanks. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pulling raw data: TIME IS RUNNING OUT!
Thank you, thank you, thank you!
"JMB" wrote: Ahh... I see some details in another post. If you're looking for A, C, H, P, and Z in a particular cell (say B2), you could put this in an adjacent empty cell =OR(B2={"A","C","H","P","Z"}) copy it down the length of your table and then filter on this column for TRUE (if autofilter does not recognize where your table is at, you may need to select/highlight your table before activating autofilter). Only those records that TRUE will be left visible. And you could set up additional columns for other tests and filter each of those columns so that, when all of your filters are applied, all that is visible is the info you need. Then copy/paste to another sheet (XL does not copy rows hidden by the autofilter). "JMB" wrote: I would set up another field in your data called "Record" and number the table 1 through whatever. When the data gets pulled or copied to another sheet, include the record number and you'll have a cross reference between the two tables. If the conditions are not too complex, you might be able to use the autofilter on your table (under Data/Filter/Autofilter - don't know where it would be in XL07). Otherwise, perhaps use formulae in one or more empty columns (helper columns)next to your data table to perform your conditional tests (set the formulae up to return 1 or 0 or TRUE/FALSE) and use the autofilter on these helper columns. Then copy/paste the filtered data to your destination worksheet (including the record number). Then delete the helper columns. Sorry I can't assist w/ formulas or more details than this, but you did not include any info about your data, how it is set up, or what your criteria are. I'm getting ready to sign off for the evening- perhaps someone else will assist if you have additional questions. Just be sure to add some details - you'll get better responses. "Determined07" wrote: Can someone please tell me the clear procedure of pulling specific data that meets a certain criteria from one worksheet to paste on another. It's a very large document and it would require alot of sifting. I don't have much time. Please help me. Also, once the data is pulled, I'll have to add a column with information corresponding to the rows that I pulled. So information on how to do that would be appreciated. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pulling data from one sheet and listing selected data in another | Excel Worksheet Functions | |||
Sumproduct - Pulling info based on lenght of time between dates | Excel Worksheet Functions | |||
running macros at a set time | Excel Discussion (Misc queries) | |||
Running a macro at a specified time | Excel Discussion (Misc queries) | |||
Running a macro at a certain time | Excel Discussion (Misc queries) |