Transferring Nested Data Organization from Excel to MSProjec

quigley6

New Member
Joined
Oct 2, 2006
Messages
22
Hello,

I have a set of nested and grouped data in an Excel spreadshet. The group data shows the dependancies of certain tasks relative to others. The data is nicely indented show conveying the correct format and organization of the tasks.

Is there anyway to transfer these dependancies (indentations) to MSProject?

Thank you,

Burt
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
I don't know if this can help you or not, but:

This code was indented when written, but it is not so displayed:

if a=b then
x=a+b
else
x=a-b
end if

This is the identical code, entered with a preceding "["code"]" and an ending "["/code"]" (Note: I had to enclose the [s in quotation marks, to display the word "code" without activating it, as below.)
Code:
if a=b then
  x=a+b
else
  x=a-b
end if
 

quigley6

New Member
Joined
Oct 2, 2006
Messages
22
Still trying to work this. I was told there are ways to import info from Excel into Project to make this work, but I have no specific knowledge of how to go about doing this.
 

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
Sorry, Quigley6, that was my only thought on the subject, so, I'm out of this. Good luck!
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,300
Office Version
  1. 365
Platform
  1. Windows
Quigley6

The only way I can think of this being possible would be to automate Project from Excel to import/export the information.

Mind you I could be wrong, have you checked out the Import capabilities of Project.

It's been some time since I've worked with it and don't have it to hand but I seem to recall there was some sort of Import functionality.
 

Forum statistics

Threads
1,136,426
Messages
5,675,773
Members
419,585
Latest member
popsin

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