Complicated Question

[M3Power]

Hi All,

I'm trying to do something similar to a vlookup and pivot table. I have an all up summary tab in excel. I am trying to import data from other feeder tabs into this tab but don't know how to do it. I want the summary sheet to automatically pull in the data from the "planned execution date" column and the "completion" column just for a specific month (April, May, June, etc....). The overall objective is to build a monthly summary slide & status report of where we are on current projects.

What I am looking for is to automate the summary tab so that any time I update the detail tabs, the summary tab is automatically updated.

Here is the summary tab that I am trying to build.<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis...[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE]

 

[schielrn]

Welcome to the Board!

See this link with helping post the html maker:

http://www.mrexcel.com/forum/showthread.php?t=322557

There is a line that needs to be removed from teh code to have it post properly or switch your editor mode.

Or you can download Excel Jeanie HTML 4 and use that to post.

Hope that helps.