ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Import Data from the Same Workbook (https://www.excelbanter.com/excel-discussion-misc-queries/131389-import-data-same-workbook.html)

Ananth

Import Data from the Same Workbook
 
I have a large employee database worksheet that has 60000 rows and 120 Colms.
I want to import selective data based on multiple conditions to ointo
another sheet in the same workbook.

Is it possible. Any help considered as God Sent.


Dave Peterson

Import Data from the Same Workbook
 
Maybe you can apply data|filter|autofilter
Filter by some criteria
and copy the visible rows to the other worksheet.

Ananth wrote:

I have a large employee database worksheet that has 60000 rows and 120 Colms.
I want to import selective data based on multiple conditions to ointo
another sheet in the same workbook.

Is it possible. Any help considered as God Sent.


--

Dave Peterson


All times are GMT +1. The time now is 08:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com