Search:

Type: Posts; User: crazycanuck; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    7
    Views
    418

    Re: Macros within excel (v11.1.1 for Mac)

    just applied this to my excel spreadsheet and it worked great!

    Thanks again
  2. Replies
    7
    Views
    418

    Re: Macros within excel (v11.1.1 for Mac)

    Thanks,,,,,,,i really appreciate your help!

    Mike
  3. Replies
    7
    Views
    418

    Re: Macros within excel (v11.1.1 for Mac)

    here is the basic idea, i have three worksheets and added on worksheet Mike the results and where they should come from. My problem originates from having multiple excel worksheets that are...
  4. Replies
    7
    Views
    418

    Re: Macros within excel (v11.1.1 for Mac)

    i can work up a rough example and send it along, the concept will be the same.
  5. Replies
    7
    Views
    418

    Macros within excel (v11.1.1 for Mac)

    I have three worksheets, each sheet has a common column that ties all 3 work sheets together (each sheet contains different informatin associate to that "key". I want to create a fourth worksheet...
  6. Convert a 97 database to 95? (Office 2000)

    I have access 2000 on my desktop, my colleague has 95, he has a 97 database that he needs to use on his machine. What, if possible, is the best way to convert it back to a version he can use. He is...
  7. Re: linking data between excel documents (excel 2000)

    Errol,

    Thanks Eh! you have to say it with attitude or someone might think you were from the US midwest. Thanks for the info and i will try it over the weekend to see if i can get it to work.
    ...
  8. Re: linking data between excel documents (excel 2000)

    Very close, The team members would enter the time they worked for the week against the tickets they were assigned to. A ticket is simply a piece of work and the ticket tracks the effort until the...
  9. Re: linking data between excel documents (excel 20

    That is what i wanted to use for this. ACCESS would be much better but the PM doesn't have it installed and she will not get the funding to have a license bought. She is also not familiar with...
  10. Re: linking data between excel documents (excel 2000)

    Second attached file! The Summary file
  11. linking data between excel documents (excel 2000)

    Okay, here goes.....i have been staring at this for some time and have become suddenly brain dead. I have a simple request from a project manager who wants to use excel to report information around...
  12. Re: Worksheet format question (Excel 2000)

    I cut and Pasted the values over to a new worksheet, it looks fine now.

    Thanks for the help!
  13. Re: Worksheet format question (Excel 2000)

    I tried this suggestion and no luck. When i go to the A45 cell and do the ctrl-shift-end, it highlights the range of cells, i hit right mouse button, select Delete Row, and nothing changes.

    Thanks
  14. Re: Worksheet format question (Excel 2000)

    i cut and pasted it into a VB module and then ran it. Nothing happened unfortunately...it doesn't seem to run at all. I have attached the document in question and any help would be appreciated.
    ...
  15. Re: Worksheet format question (Excel 2000)

    Yes, the remaining rows are empty. Do i cut and paste this into a VB editor window and run it?
  16. Worksheet format question (Excel 2000)

    I have an Excel spreadsheet, there are 44 active rows within this sheet. When i print it prints 44 rows only but when i view the worksheet on line, the scroll bar indicates a lot more...
  17. Re: how to have a formula build a table! (version 2000)

    I appreciate your insight. From a project perspective they want their own worksheets. Maybe a summary worksheet of all the project worksheets is needed then use the built in optiosn you describe. ...
  18. Re: how to have a formula build a table! (version 2000)

    i am not familar with pivot tables so i didn't explore that option. The current excel documnet has 7 project worksheets with each sheet containing the same types of data as follows:

    Resource...
  19. how to have a formula build a table! (version 2000)

    I have an excel document with multiple worksheets. I want to create a summary worksheet that reflects the current status of all the other worksheets. The idea is to be able to hit a <ctrl> X for...
  20. Replies
    5
    Views
    394

    Re: exporting from MSP 2002 (2002)

    Thanks Gary, I will look into trying to centralize the files or exporting new views when needed. Have to used or have any information on the 2002 version using the web option. I understand this...
  21. Replies
    6
    Views
    435

    Re: Reosurce Pools (Proj 2002 & 2000)

    I am sure there might be some instances where using sub pools make sense, i just not sure what the problems would be of using just a master pool. With your duplicates issue, that is a benefit of...
  22. Replies
    5
    Views
    394

    Re: exporting from MSP 2002 (2002)

    Yes, everyone is one the same global network. The issue that you raise is valid from a point where the Excel spreadsheet will have to be copied into a folder instead of emailed to individuals. That...
  23. Replies
    6
    Views
    435

    Re: Reosurce Pools (Proj 2002 & 2000)

    What i have found is that the resources are listed in the master, then in the sub project you select the option to use the resource pool from the master. If by chance you have to add a resource to a...
  24. Replies
    5
    Views
    394

    exporting from MSP 2002 (2002)

    I want to export all the left hand columns of the Gantt view to an excel spreadsheet, but, i want the spreadsheet to look like the gantt view. I also want the excel spreadsheet to be linked to the...
  25. Replies
    6
    Views
    435

    Re: Reosurce Pools (Proj 2002 & 2000)

    I am currently using MSP 2002 with multiple sub projects and i will be sharing resources around the globe. I have set up my project to use a single resource pool located in the master. At the sub...
Results 1 to 25 of 76
Page 1 of 4 1 2 3 4