Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. My second quote was as it was you did not miss it.

    My second quote was as it was you did not miss it.
  2. Thanks Gary been to the sight before...I know how...

    Thanks Gary been to the sight before...I know how it works. IF you have a solution lmk.

    And don't be so uptight...you took my comment out of context.
  3. WHERE'S HANS?!?!?!!? (He'd have this solved...

    WHERE'S HANS?!?!?!!?

    (He'd have this solved by now).
  4. ok that's a start where would I find those shapes?

    ok that's a start where would I find those shapes?
  5. Anybody? please. Thanks

    Anybody? please. Thanks
  6. With PPPres.SlideMaster.Shapes("Rectangle...

    With PPPres.SlideMaster.Shapes("Rectangle 2").TextFrame.TextRange

    [attachment=91121:Doc1.docx]
  7. Hi my company recently upgraded us from 2003 to...

    Hi my company recently upgraded us from 2003 to 2010 Excel. Now as a result none of our macros work. Below is the Error and the entire. If someone could please explain why this is happening and what...
  8. Replies
    1
    Views
    391

    Hello I need a macro that will check a range of...

    Hello I need a macro that will check a range of cells for dependents (Trace Dependent Function). Lets say I6:I942 and if it's NOT dependent to anything then highlight the entire cell in RED. Thank...
  9. For example I want to use the same range name...

    For example I want to use the same range name "retrieve" for sheet1,sheet2,sheet3,sheet4,etc. For this example the cell range is A1:D50.

    Unfortunately everytime I try to do this it overwrites...
  10. Replies
    6
    Views
    1,807

    Re: Easy way to Trace Dependents? (Excel 2003)

    No that's the objective. I am trying to delete the select cells that are NOT linked to other sheets in the workbook but first I need to determine if they are dependent elsewhere in the workbook.
  11. Replies
    6
    Views
    1,807

    Easy way to Trace Dependents? (Excel 2003)

    I have a spread sheet with 10 columns and 1000 rows for a total of 10,000 cells. Of that 10,000 there are about 2000 cells randomly scattered that I would like to check for dependents and then delete...
  12. Replies
    6
    Views
    1,807

    Re: Esay way to Trace Dependents? (Excel 2003)

    Post deleted by aluislugo
  13. Replies
    6
    Views
    1,807

    Re: Esay way to Trace Dependents? (Excel 2003)

    anybody? please.
  14. Replies
    3
    Views
    574

    Re: links and chart problem (excel 2003)

    1. opened file B09 yoy walk.xls
    2. selected update
    3. recieved edit links message and selected
    4. received the following message under Status "warning open source to update values" (Error message)...
  15. Replies
    3
    Views
    574

    links and chart problem (excel 2003)

    Word attachment replaced with picture by HansV - saves a few clicks

    getting the following error and can't seem to update my charts. Thanks you in advance for your help.
  16. Replies
    3
    Views
    1,748

    Tracing a link? (Excel 2003)

    Anybody know how to trrace a link in a spreadsheet?( I am trying to find the linked cell/s). I have tried to switch to formula auditing mode and try to find it that way but no luck. And I just don't...
  17. Replies
    17
    Views
    2,941

    Re: Moving Monthly Formula (Excel 3.0)

    Point well taken my friend!

    Nevertheless thank you once again for all your help.

    Regards,
    aluislugo
  18. Replies
    17
    Views
    2,941

    Re: Moving Monthly Formula (Excel 3.0)

    Hi Hans I did as you suggested but I still got errors in cells AC25,27,28 and AQ25,27,28 ?
  19. Replies
    17
    Views
    2,941

    Re: Moving Monthly Formula (Excel 3.0)

    Hi Hans, once again it seemed to work for col AC, however for col AQ there were a few errors (see highlighted cells in yellow). I think that the formula in AQ needs to be modified slightly to add in...
  20. Replies
    17
    Views
    2,941

    Re: Moving Monthly Formula (Excel 3.0)

    Hans I was thinking why can't your original formula be revised with an AND statement i.e., IF(COUNTIF($B12:$M12,">0"(and(countif($b12:$m12,"<0")......etc.

    If so how would that formula look like? ...
  21. Replies
    17
    Views
    2,941

    Re: Moving Monthly Formula (Excel 3.0)

    I actually tried before posting, however it did NOT work. Anyway I appreciate your help and patience.

    Regards,
    Aluislugo
  22. Replies
    17
    Views
    2,941

    Re: Moving Monthly Formula (Excel 3.0)

    Hi Hans, this seems to work now except it does not recognize negative values in the actuals section and therefore sums incorrectly the budget (see cell AC12 should be 11,750 not 9,400.

    Regards.
  23. Replies
    17
    Views
    2,941

    Re: Moving Monthly Formula (Excel 3.0)

    Hi Hans, once again it almost works...lol. This managed to get rid of the REF error however now the formula sums everything (Jan - Dec)?
  24. Replies
    17
    Views
    2,941

    Re: Moving Monthly Formula (Excel 3.0)

    Hi Hans,
    This seems to work pretty well except for the issue with the zero's (see cells AC14,15,etc.) Cell AC13 worked only because I entered zero values. If there a way to modify the formula only...
  25. Replies
    17
    Views
    2,941

    Moving Monthly Formula (Excel 3.0)

    I need to create a formula in cells AB11 & AP11 that will adjust themselves based on data as it comes in month after month. Currently I have data in cells b11:f11 (Jan thru May). Next month when June...
Results 1 to 25 of 77
Page 1 of 4 1 2 3 4