Search results

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...

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...

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...

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

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...

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

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

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

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.

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...

I am using excel 2010 on a pc.

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!!!

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...

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...

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.

Good evening, I need a macro for excel that will copy a cell range ($A$14:$HF$14) and paste it in the following $A$15:$HF$15+ Range it finds ( What I mean by this is that it must not be paste it before row 14). so as to not erase the information created the last time the macro was run. in...

I am currently trying to solve an error that occurs when I combine two formulas and haven't been very successful. Both of them are used in a Gannt chart and work well individually, however, when I combine them it returns an error...