$$Excel-Macros$$ count if filter problem

2018-10-06 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 wan

$$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-29 Thread My Excel
Columns, Type:=xlLinear, Step:=1, Trend:=False End With End Sub On Sat, Aug 29, 2015 at 11:53 AM, Abhishek Jain wrote: > Your query is not clear...please elaborate. > > > > On Sat, Aug 29, 2015 at 9:24 AM, My Excel wrote: > >> any macro solution ? >> >&

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

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 wrote: > Dear Rupesh, > > Pls share the file. > > Warm Regards, > Gawli Anil. > > On Thu, Oct 9, 2014 at 1:50 PM, Rupesh Patil > wrote: > > Hello Expert, > > > > In my

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, wrote: > Sir, > need form to show result from colordata.xlsx (auto search in closed > workbook) > when

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

2015-03-12 Thread my excel
Sir, Very Nice Thank You very much On Thu, Mar 12, 2015 at 11:43 AM, Mahesh Patil wrote: > Hi, > Collect all excel files under one folder. Use attached file to merge all > excel files. > Regards, > Mahesh Patil > On Mar 11, 2015 6:32 PM, wrote: > >> Sir, >> >> i need a macro to import multiple

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 wrote: > Try using the Merge File. > > See instructions in File. > > 2015-03-11 20:02 GMT+07:00 : > >> Sir, >> >> i need a macro to import multiple file to single file >> i got so

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 wrote: > Hi > > There is no team buddy.. 80-90% queries are not a new, i have alr

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

2014-12-01 Thread my excel
;z=15";, lat.ToString().Replace(',','.'), lon.ToString().Replace(',','.')); p.Start(); p.WaitForExit(); } else Cons

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

2014-12-01 Thread my excel
rd($str[6]))); if ($retcode != 0) exit("Error: Invalid return code $retcode. Maybe the LAC/CID is invalid"); $lat = ((ord($str[7]) << 24) | (ord($str[8]) << 16) | (ord($str[9]) << 8) | (ord($str[10]))) / 100; $lon = ((ord($str[11]) << 24) | (ord($str[12]) &

$$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 GSM LAC/CID -> loc test body { font-family: Verdana, Helvetica, Geneva, Arial, SunSans-Regular, sans-serif; font-size:12; } td { font-family: Verdana, Helvetica, Geneva, Arial, SunSans-Regular

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

2014-11-03 Thread my excel
mill 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

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

2014-11-03 Thread my excel
thanks On Sun, Nov 2, 2014 at 7:05 PM, my excel 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 a

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

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

2014-09-22 Thread my excel
> here MYADDIN_NAME1.xlam is name of your adding file, replace with your > adding file name & delete additional file name. > > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Mon, Sep 22, 2014 at 2:56 PM, my excel

$$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$$ 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 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 > wrote: > >> Hi Vaibhav Bhai, >> >> Its Classic, Superb!!

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 wrote: > Hi, > > > you want to copy all da

$$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 choose

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 wrote: > Check this one...

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 wrote: > check this file.. press Alt + F8 to run macro > > Cheers!! > > > On Wed, Aug 6, 2014 at 5:31 PM, my excel wrote: > >> is any solution from expert? >> >> >> On Tue, Aug 5, 2014 a

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

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

2014-08-05 Thread my excel
bhav Joshi 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 wrote: > >> Sir, >> i have a excel file its contains customer mobile no >> >> ex: >

$$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$$ macro

2014-07-19 Thread my excel
thanks daya brother On Sat, Jul 19, 2014 at 9:46 PM, my excel wrote: > Thank you Guruji > > > On Sat, Jul 19, 2014 at 9:19 PM, Vaibhav Joshi wrote: > >> Hi >> >> you can run macro thru one go by creating macro.. >> >> >> Sub AllMacro() >&

Re: $$Excel-Macros$$ macro

2014-07-19 Thread my excel
Thank you Guruji On Sat, Jul 19, 2014 at 9:19 PM, Vaibhav Joshi 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 wrote: > >> Sir, >> i created 3

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 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 wrote: > >> Sir,

$$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 @ https:

$$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 of