• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by jyanguela

  1. J

    Working with the AND function in combination with IF(AND()) in a Gantt chart.

    I figured as much. There isn't suppossed to appear any value in the weekends or holiday, the formula is suppossed to skipped them. So if a task has a duration of five days and begins on a thursday the in-cell symbol located on $D$12 would appear on the cells of thursday, friday, monday...
  2. J

    Working with the AND function in combination with IF(AND()) in a Gantt chart.

    Hello Hui, The error is gone, leaving only the wanted symbol in the cell and the weekends and holidays are filled with a five digit number. The number I have removed with conditionally formating the font to be the same color as the cell; However, all the cells have been filled in with the...
  3. J

    Working with the AND function in combination with IF(AND()) in a Gantt chart.

    Hello Hui, What I am trying to do is to have a cell range in a gantt chart be filled from one cell to another (Start date to end date)with a symbol; the same way that a conditional formating would fill a cell with color if condition is met. You can see on the file I sent you that it is a...
  4. J

    Macro that copies a Cell Range and pastes it on the next empty row it finds.

    IT WOOOOOORKSSSS!!!!!! Thank you so much Bro!!! ps: Cool, aren't they?
  5. J

    Working with the AND function in combination with IF(AND()) in a Gantt chart.

    I have just found a page that explains a bit more on the subject. It says that to combine two formulas you have to put the + sign between them and presscntrl+shift+enter. Curly brackets ({) will automatically appear around the whole formula. It is something that they call AFs (Array-Entered...
  6. J

    Working with the AND function in combination with IF(AND()) in a Gantt chart.

    Dear HUI, The file has been uploaded here: http://rapidshare.com/files/414859059/Checklist_Proceso_RCPs.xls MD5: 4680B2F113C41D71DAD55451C53F8893
  7. J

    Macro that copies a Cell Range and pastes it on the next empty row it finds.

    Dear Hui, The file has been uploaded here: http://rapidshare.com/files/414858664/Proceso_Sheet1.xls MD5: 97AFAF37DEE96CCBAFBA864AC938ED9A
  8. J

    Working with the AND function in combination with IF(AND()) in a Gantt chart.

    Now I ask. Could I send you the Gantt-Chart checklist that you may detect any mistake i'm not detecting....?
  9. J

    Macro that copies a Cell Range and pastes it on the next empty row it finds.

    It is on a worksheet like the attached jpg. Moreover, I put the attached jpg next to the actual VBA screen and they are exactly alike. Is there anyway I can, perhaps, send you the sheet that you may root out my mistake? Thank you so much.
  10. J

    Macro that copies a Cell Range and pastes it on the next empty row it finds.

    Hello Hui, I copied the macro's text from this message, went to the developer tab, clicked on Visual basic icon and when the vba window popped up I pasted it there. I then headed to sheet 1 and assigned the macro to an on/off jpg that will serve as a botton icon, In the VBA window, when I...
  11. J

    Macro that copies a Cell Range and pastes it on the next empty row it finds.

    I am using excel 2010 on a pc.
  12. J

    Macro that copies a Cell Range and pastes it on the next empty row it finds.

    Good evening Hui, I tried the copy to end macro and it comes back with a runtime error o the following line: Selection.End(xlDown).Offset(1, 0).Select As I am literally ignorant with macros I have no clue as to what to do. Any suggestions?, Thanks loads!!!
  13. J

    Working with the AND function in combination with IF(AND()) in a Gantt chart.

    Hey guys, Thank you for your answers. HUI, my office 2010 program is in english but at the office we use spanish. I tried using your modification to the formula and what comes back is very peculiar. the first two cells in the in the duration display the in-cell square and a 5-digit number...
  14. J

    Working with the AND function in combination with IF(AND()) in a Gantt chart.

    I should,however when I use "," instead of ";" it comes back with the message "The formula you typed contains an Error" and persists until I write it with ";". BTW I tried it this ways you wrote it(Without the "AND" Fucntion and using "&" instead) and it comes back with a numeric cell value in...
  15. J

    Working with the AND function in combination with IF(AND()) in a Gantt chart.

    Thank you TessaES but it doesn't work. the value it returns doesn´t allow for the weekend days to be excluded and the cells give back an unwanted numerical value. Thank you for taking an interest.
See more
Back
Top