$$Excel-Macros$$ Re: want to data month wise

2008-12-18 Thread Naveen
Hi,   It can be solved using subtotal function     Regards Naveen Kumar M N     Transport Supervisor(HP) 91-08-99728 10886     Email :naveenkumarmn...@yahoo.com   Best Wishes-Karunaada Kuvara --- On Wed, 12/17/08, Ajay Varshney wrote: From: Ajay Varshney Subject: $$E

$$Excel-Macros$$ , is to .csv as ____ is to .xls

2008-12-18 Thread Yonih
Hey Everyone, We have a php website made for us and we are able to export reports from it however it exports it in .csv. I see where I can change the extension to .xls but then it puts all the info in one cell with , separating them. Does anyone know what the equivalent of , is for xls. is there

$$Excel-Macros$$ Userform and xlup function

2008-12-18 Thread Phillip Swanepoel
I have a userform1. In that i got amongst other stuff the following. Frame within that 4 textbox. 20, 21, 22,24 then i got comandbutton10. I need a comand that execute on comandbutton10_click event. I need it to do the following, textbox20.value = sheet17 range b9 and column k xlup. - . textbox21.

$$Excel-Macros$$ How do I create formula to return row number of search result...

2008-12-18 Thread ShellyGirl
Hello, I am trying to create a macro. I would like for user to be able to type in a search criteria and hit search button. I would like the macro to search a range of cells for the input and return the row number of the first search result. Any help will be greatly appreciated... I think my ma

$$Excel-Macros$$ Ultimate goal: pasting variable sized regions to different tabs.

2008-12-18 Thread guggd2868
Hi all I have searched online extensively for help on this, and found some solutions but not enough. What I ultimately need to do is take one excel spread sheet that has 12 tables arranged vertically. The tables are split up by headers; one table ends when the next table's header is. I want to

$$Excel-Macros$$ Re: want to data month wise

2008-12-18 Thread Naveen
It can be solved by using the formula SUBTOTAL(Data menu).     Regards Naveen Kumar M N     Transport Supervisor(HP) 91-08-99728 10886     Email :naveenkumarmn...@yahoo.com   Best Wishes-Karunaada Kuvara --- On Wed, 12/17/08, Ajay Varshney wrote: From: Ajay Varshney Subject: $$E