How to import data from another excel worksheet

denesh3560

New Member
Joined
Sep 21, 2020
Messages
3
Office Version
  1. 2010
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

denesh3560

New Member
Joined
Sep 21, 2020
Messages
3
Office Version
  1. 2010
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,514
Messages
5,602,091
Members
414,501
Latest member
mdhaumyu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top