How to import data from another excel worksheet

[denesh3560]

Hi guys,

I want to ask you on how to import a data from a excel worksheet into another excel worksheet.
The are many columns and rows in my excel worksheets where my completed and ongoing projects information is listed on. My each projects will listed in each rows. One of my column is where i put the completion status of my project. I want to import only my completed project information into another worksheet where i can plot graphs. So, i wanted to ask you guys, if the row in the completion status column is not empty it should be automatically generate the specific row information in another excel file. This process should be automated, where if i edit the completion status column in my main excel fire, it should be automatically added the specific row into the other excel file too.

Thank you. Please help me out in this specific problem.

 

[sandy666]

you can use Power Query
PowerQuery add-in for XL 2010/2013,
with From File feature

 

[denesh3560]

Hi Sandy666,

Can you please elaborate the steps to me on how i can use the power query. Im very sorry because i am quite new to these advance excel functions.

Thank you.

 

[sandy666]

you mixed worksheet and file
workbook (file) contain worksheets
check this: Import data from external data sources (Power Query)