Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to obtain Col Letter - VBA | Excel Discussion (Misc queries) | |||
How To Obtain The Top 10% | Excel Discussion (Misc queries) | |||
vlookup to obtain pictures | Excel Discussion (Misc queries) | |||
How can I obtain a calendar that will go from Jun 06 to Sep 07? | Excel Discussion (Misc queries) | |||
how to obtain sheet name? | Excel Discussion (Misc queries) |