Importing Selected Source Book Data
I have a large source worksheet containing data in various columns. When a
value is indicated in the "qty" column of the source book, I need the entire row of information to display and list in a second worksheet. How do I display only the selected information in the second worksheet? |
Importing Selected Source Book Data
Personally, I'd keep the data in one location.
You could apply Data|Filter|Autofilter, then filter on greater than 0 to show the values that you want. If you really want this stuff on another worksheet, you could copy those visible rows and paste into a new worksheet. Greyson wrote: I have a large source worksheet containing data in various columns. When a value is indicated in the "qty" column of the source book, I need the entire row of information to display and list in a second worksheet. How do I display only the selected information in the second worksheet? -- Dave Peterson |
Importing Selected Source Book Data
"Greyson" wrote: I have a large source worksheet containing data in various columns. When a value is indicated in the "qty" column of the source book, I need the entire row of information to display and list in a second worksheet. How do I display only the selected information in the second worksheet? Thanks Dave -very helpful. One more question...Now that I have filtered the data, is there a way to have new entries meeting the specified criteria in the source book added to the list without performing another filter action? |
Importing Selected Source Book Data
I guess you could loop through each row using that criteria and only copy the
rows that meet the criteria to the other sheet. But if the criteria is easily applied via a filter, I think I'd just apply that next filter. Greyson wrote: "Greyson" wrote: I have a large source worksheet containing data in various columns. When a value is indicated in the "qty" column of the source book, I need the entire row of information to display and list in a second worksheet. How do I display only the selected information in the second worksheet? Thanks Dave -very helpful. One more question...Now that I have filtered the data, is there a way to have new entries meeting the specified criteria in the source book added to the list without performing another filter action? -- Dave Peterson |
All times are GMT +1. The time now is 08:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com