$$Excel-Macros$$ count if filter problem

2018-10-07 Thread My Excel
Hi, need help on filter countif formula not showing only filtered calculation( count ) but count visible working fine here in attached file i put formula but when i put filter on pname showing all other count solution pls Thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

$$Excel-Macros$$ Vlookup from ms access and sqlite

2015-12-18 Thread My Excel
Hi Expert's, need help. It will great appreciated if someone can send me the macro i have data in ms access & sqlite multiple files regularly i received data in excel ms access & sqlite data received once in a month i convert access & sqlite data which data present in excel than use vlookup

Re: $$Excel-Macros$$ need macro to generate serial no

2015-08-28 Thread My Excel
any macro solution ? On Thu, Aug 27, 2015 at 10:18 PM, My Excel myxlg...@gmail.com wrote: Sir, need help on serial no generate (like attached file) using auto increment loop start from 1200 to better if possible 1 crore in 1 sheet thanks, -- Are you =EXP(E:RT

Re: $$Excel-Macros$$ Port VBA code to VB.net

2015-04-14 Thread My Excel
sir, Pls share update of this thread how to convert vba to .exe thanks in advance On Thu, Oct 9, 2014 at 3:27 PM, Anil Gawli gawlianil8...@gmail.com wrote: Dear Rupesh, Pls share the file. Warm Regards, Gawli Anil. On Thu, Oct 9, 2014 at 1:50 PM, Rupesh Patil patil.rupesh1...@gmail.com

Re: $$Excel-Macros$$ Find Color Details using search box output in form (UI editor add-in)

2015-04-04 Thread my excel
experts, need output in form check using vlookup in colordata.xlsx it near 500 records to search easily by seeing on cotton it vl be helpful to my friend thanks On Wed, Apr 1, 2015 at 8:35 PM, myxlg...@gmail.com wrote: Sir, need form to show result from colordata.xlsx (auto search in closed

Re: $$Excel-Macros$$ multiple files to single file

2015-03-11 Thread my excel
Sir, when i browse not showing .csv files excel worksheet thank you On Wed, Mar 11, 2015 at 11:59 PM, Bé Trần Văn betnmtdongna...@gmail.com wrote: Try using the Merge File. See instructions in File. 2015-03-11 20:02 GMT+07:00 myxlg...@gmail.com: Sir, i need a macro to import multiple

Re: $$Excel-Macros$$ Information

2014-12-03 Thread my excel
shocking news you are not from IT field not trained programming lang is it possible me also guruji ? than suggest basic vba for me pls check my url guruji thanks On Wed, Dec 3, 2014 at 12:56 PM, Vaibhav Joshi v...@vabs.in wrote: Hi There is no team buddy.. 80-90% queries are not a new, i

Re: $$Excel-Macros$$ need help to convert this code into excel macro

2014-12-01 Thread my excel
'41.038526,28.985649'?sll=?php if(isset($addr)) echo $addr; else echo '41.038526,28.985649'?t=hz=12output=embed/iframe pnbsp; pnbsp; p On Fri, Nov 28, 2014 at 12:09 PM, my excel myxlg...@gmail.com wrote: sir, this code from bahri in c# php something sir pls help convert it to excel macro thank

Re: $$Excel-Macros$$ need help to convert this code into excel macro

2014-12-01 Thread my excel
format instead of this code.. + *I did not do this for you. God is here working through me for you.* On Mon, Dec 1, 2014 at 1:36 PM, my excel myxlg...@gmail.com wrote: hi experts pls convert to vba macro mmc input text box mnc input text box lac input text box cid input text box

$$Excel-Macros$$ need help to convert this code into excel macro

2014-11-27 Thread my excel
sir, this code from bahri in c# php something sir pls help convert it to excel macro thank you html head titleGSM LAC/CID - loc test/title /head body style type=text/css body { font-family: Verdana, Helvetica, Geneva, Arial, SunSans-Regular, sans-serif; font-size:12; } td { font-family:

Re: $$Excel-Macros$$ Userform - Login

2014-11-03 Thread my excel
On Sun, Nov 2, 2014 at 7:05 PM, my excel myxlg...@gmail.com wrote: Pramod is it possible to use this login form to excel add-in file using this authorized user can use (run) add-ins macro add-in name = ctools macro names= get SlNo, Top10, Reports etc Sir, pls send code for add in if login

Re: $$Excel-Macros$$ Userform - Login

2014-11-03 Thread my excel
joseph.cam...@gmail.com wrote: Hi, I am not sure who this is myxlg...@gmail.com. Please use a different mail to solve your queries, as it may confuse me to look for an appropriate answer and ask question to the experts. On Sun, Nov 2, 2014 at 7:05 PM, my excel myxlg...@gmail.com wrote

Re: $$Excel-Macros$$ Userform - Login

2014-11-02 Thread my excel
Pramod is it possible to use this login form to excel add-in file using this authorized user can use (run) add-ins macro add-in name = ctools macro names= get SlNo, Top10, Reports etc Sir, pls send code for add in if login success than only add-in macros enable else disable thanks On Sun, Nov

$$Excel-Macros$$ If Condition Problem

2014-09-22 Thread my excel
Sir, i created an add-in for my excel work but i am trying to write a condition it will only run in Computer Name= PCEARTH otherwise sub programs will be disabled automatically or not working thanks Sub CompName() Dim tSName As String Dim ThisComputerName As String

Re: $$Excel-Macros$$ If Condition Problem

2014-09-22 Thread my excel
for you.* On Mon, Sep 22, 2014 at 2:56 PM, my excel myxlg...@gmail.com wrote: Sir, i created an add-in for my excel work but i am trying to write a condition it will only run in Computer Name= PCEARTH otherwise sub programs will be disabled automatically or not working thanks Sub

$$Excel-Macros$$ Folder data to wbk

2014-09-06 Thread my excel
Sir, i need on copy data from a folder. daily i receive 4-5 excel file email from my friends i download that file in to a folder on sunday i copied all files in to 1 file sir need a macro button to copy of all that files in to single workbook without any data change using (open dialog window

Re: $$Excel-Macros$$ Folder data to wbk

2014-09-06 Thread my excel
Sir, copy all data from folder into 1 workbook sheet wise choose any folder containing excel file open new work book run macro that macro it vl copy 1 file sheet to sheet1 than next to sheet2 so on thanks On Sat, Sep 6, 2014 at 1:35 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi,

Re: $$Excel-Macros$$ Folder data to wbk

2014-09-06 Thread my excel
Ultimate Sir thanks a lot sir On Sat, Sep 6, 2014 at 7:57 PM, Vaibhav Joshi v...@vabs.in wrote: cheers bro!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 6, 2014 at 7:53 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Bhai, Its

Re: $$Excel-Macros$$ CCare Log Mgnt Sys

2014-08-28 Thread my excel
Hi, possible to show like heat map chart not like attached file opinion : not possible to all pivot (double click data) show surrounding to that toll free no Vibhav Brother did good work thanks to him Tnx to all On Thu, Aug 28, 2014 at 3:55 PM, Vaibhav Joshi v...@vabs.in wrote: Check

Re: $$Excel-Macros$$ make 10 digit data

2014-08-06 Thread my excel
is any solution from expert? On Tue, Aug 5, 2014 at 12:52 PM, my excel myxlg...@gmail.com wrote: just copy paste data to excel if i select A column data hit on button A column data convert in to 10 digit no... i want data as text also convert in to number it must be 10 digit

Re: $$Excel-Macros$$ make 10 digit data

2014-08-06 Thread my excel
thank you On Thu, Aug 7, 2014 at 10:00 AM, Vaibhav Joshi v...@vabs.in wrote: check this file.. press Alt + F8 to run macro Cheers!! On Wed, Aug 6, 2014 at 5:31 PM, my excel myxlg...@gmail.com wrote: is any solution from expert? On Tue, Aug 5, 2014 at 12:52 PM, my excel myxlg

Re: $$Excel-Macros$$ make 10 digit data

2014-08-05 Thread my excel
Joshi v...@vabs.in wrote: hi you can do it without macro by changing cell format to number format. Cheers!! On Sun, Aug 3, 2014 at 9:36 PM, my excel myxlg...@gmail.com wrote: Sir, i have a excel file its contains customer mobile no ex: Jan Feb Mar …. ….. etc 919845098450

$$Excel-Macros$$ make 10 digit data

2014-08-03 Thread my excel
Sir, i have a excel file its contains customer mobile no ex: Jan Feb Mar …. ….. etc 919845098450 09888021555 9.19293E+11 919899989696 9.19845E+11 9.19845E+11 09595959595 +919449449460 9845098430 9845098430 94949494949 [image: Inline image 1] Q: how to convert to 10 digit mobile no ? i

Re: $$Excel-Macros$$ Fwd: R Shop Data

2014-07-19 Thread my excel
thanks a lot guruji On Fri, Jul 18, 2014 at 9:12 PM, Vaibhav Joshi v...@vabs.in wrote: PFA excel with vba Macro!! Its more dynamic, click blue button new sheet will get created. Cheers!! On Fri, Jul 18, 2014 at 10:30 AM, my excel myxlg...@gmail.com wrote: Sir, i sent attached file

Re: $$Excel-Macros$$ macro

2014-07-19 Thread my excel
Thank you Guruji On Sat, Jul 19, 2014 at 9:19 PM, Vaibhav Joshi v...@vabs.in wrote: Hi you can run macro thru one go by creating macro.. Sub AllMacro() Call Macro1 Call Macro2 Call Macro3 End Sub On Sat, Jul 19, 2014 at 6:41 PM, daya p princedaya2...@gmail.com wrote:

Re: $$Excel-Macros$$ macro

2014-07-19 Thread my excel
thanks daya brother On Sat, Jul 19, 2014 at 9:46 PM, my excel myxlg...@gmail.com wrote: Thank you Guruji On Sat, Jul 19, 2014 at 9:19 PM, Vaibhav Joshi v...@vabs.in wrote: Hi you can run macro thru one go by creating macro.. Sub AllMacro() Call Macro1 Call Macro2 Call

$$Excel-Macros$$ Fwd: R Shop Data

2014-07-17 Thread my excel
Sir, i sent attached file of my friend ration shop pls see out put data he wanted a macro to generate output data pls help regards: Veerendra -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

$$Excel-Macros$$ my vba macro file

2014-07-06 Thread my excel
Sir, i created a vba project file (macr0) someone (friend) put unknown password for it (fun) how can i recover it contains imp data i need urgentely thanks, Veer -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page