ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to obtain my goal? (https://www.excelbanter.com/excel-discussion-misc-queries/244047-how-obtain-my-goal.html)

Islic-ExcelChallenged

How to obtain my goal?
 
Greetings! I am using office 2k7 and I would like to be able to pull
information from several files into 1 centeral file:

Details:

Project 1
Project 2
Project 3

Each of these projects are on a sharepoint site and have "Task" listed
inside them (say 1-15 rows each) in Column A there would be a status report
with "On Target, Behind, Complete, Cancelled" I created a master sheet and I
want to create a macro or something where I can pull each projects task list
status. I would then have something like this:

25 On Target
39 Behind
15 Complete
11 Cancelled


I am not sure if what I need to accomplish that. If someone has a few
minutes can you point me in the right direction?

Many Thanks!

PhilosophersSage

How to obtain my goal?
 
Try something like:
=COUNTIF([project1.xlsx]sheet1!A2:A20,"On Target") &"On Target"

"Islic-ExcelChallenged" wrote:

Greetings! I am using office 2k7 and I would like to be able to pull
information from several files into 1 centeral file:

Details:

Project 1
Project 2
Project 3

Each of these projects are on a sharepoint site and have "Task" listed
inside them (say 1-15 rows each) in Column A there would be a status report
with "On Target, Behind, Complete, Cancelled" I created a master sheet and I
want to create a macro or something where I can pull each projects task list
status. I would then have something like this:

25 On Target
39 Behind
15 Complete
11 Cancelled


I am not sure if what I need to accomplish that. If someone has a few
minutes can you point me in the right direction?

Many Thanks!


Islic-ExcelChallenged[_2_]

How to obtain my goal?
 
I was able to use:
=COUNTIF([1.xls]Projects!$A$2:$A$16, "On Target") &" "

That was with both files being in the same folder and both files being open.
when one is closed it will not grab the totals. The target I am trying to
reach will be a SharePoint site. How can I define a path so the countif
knows where to look? I have tried using the \\servername\share\file.xls but
no luck. Any other thoughts?


"PhilosophersSage" wrote:

Try something like:
=COUNTIF([project1.xlsx]sheet1!A2:A20,"On Target") &"On Target"

"Islic-ExcelChallenged" wrote:

Greetings! I am using office 2k7 and I would like to be able to pull
information from several files into 1 centeral file:

Details:

Project 1
Project 2
Project 3

Each of these projects are on a sharepoint site and have "Task" listed
inside them (say 1-15 rows each) in Column A there would be a status report
with "On Target, Behind, Complete, Cancelled" I created a master sheet and I
want to create a macro or something where I can pull each projects task list
status. I would then have something like this:

25 On Target
39 Behind
15 Complete
11 Cancelled


I am not sure if what I need to accomplish that. If someone has a few
minutes can you point me in the right direction?

Many Thanks!



All times are GMT +1. The time now is 01:41 PM.

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