Search results

"Victory Loves Preparations"

"La Victoria favorece a la Preparación"

How can i translate Microsoft Excel VBA code to OpenOffice Calc VB code????

Perfect! Thanks for your help!

How does Excel handles "ups & downs values" in the Average( ) formula? For example: If we have the following series of values: {3,4,6,201,8,65,7,5}, 201 and 65 are ups values.

THANK YOU SO MUCH!!! Now it is working perfectly!! :-D I made exactly what you said and a little more: A) Column C: =FECHA($E$7,COINCIDIR($D$7,meses,0),FILA()-9) B) Column J: =SI(C10<=FIN.MES($C$10,1-1),DIASEM(C10,11),8) I really love this forum!!! Regards!! :-)

Hi SirJB7 Thank you so much for your help and suggestions! -Muchas gracias por su ayuda y sugerencias!- Basicly, the error is that in others machines, when users click on "Reset", the macro hide all rows from 10 until 40. I have column "J" to identify all days: Number 7 = Sundays...

This is the Excel/VBA file: http://bit.ly/MItBZt The password to enable book en see the vba code es pdpx1x

Ok, I will share the file here... wait a min.

Hello Everybody! I'm a student of Online Excel/VBA School from this site. I made an Excel/VBA file to generate sales forecast. The file is working perfectly in my PC, but in others PC, with same office version, it's not working. I really need some help with that. Thank you!

Perfect! I used CF with this funtion =IF(DIASEM(C10,11)=7,TRUE,FALSE). Thank you so much for your help SirJB7 ;-)

Hi, How can i extract or highlight the holydays (sundays) from a list of days of month? Ejemp: Columm B July 1 (sunday)(extract or highlight) 2 3 4 5 6 7 8 (sunday)(extract or highlight) 9 ...

Great! Thank you for your help!

Which formula can i use to get weekdays in Excel 2010? Ejem: Monday, tuesday, wednesday...

P.S. THANKS A LOT!

Remember this depends on the date. So how could I set this formula to automaticaly move according to the ongoing date. I am trying to make a template for a re-order point of an item in inventory. so the formula will be Qty of the purchase order will be =Point of re-order - maximun inventory +...

As for instance, I have a 31 days range cells for a month and I want to only consider the sum of the last three values corresponding to the last three days of the ongoing month. It is like today which is the 24th, I would like to sum the values corresponding to day 22, 23 & 24. but by tomorrow...

How can I sum only the last three values digits on a range of cells?

Yes, that's what i want to do, insert an empty field... :-/

Ok, Excelent! Thank you so much for your help. Greatings!

Hello, Mr. Chandoo How could i save a document in excel so that i could send it to someone and it could only be opened in presentation mode? Is it possible? Greatings, Davinosky

Hello, Mr. Chandoo How can i insert a new field into pivot table??

Hi. Chandoo, just to ask you for a little help! I'm kind of stuck here with a grafic compounding two years and the VBA that I wrote seems not to be working properly. I Intend to visualize both years from the same source. How could i change the source of charts using VBA codes and a Combobox...