Re: $$Excel-Macros$$ Weekend rates to place in range

Hi Sleek, Use below condition in cell A3 to get output as per your requirement. =IF(OR(WEEKDAY(A3,2)=6,WEEKDAY(A3,2)=7),$L$4,150) Regards Ashish Bhalara On Sat, Apr 29, 2017 at 7:29 PM, 'Sleek' via MS EXCEL AND VBA MACROS < excel-macros@googlegroups.com> wrote: > Is there a si

Re: $$Excel-Macros$$ sharing a template for accounting

Hi Izhar, I know the fundamental of accountancy, you can share your require points to include it. Regards Ashish Bhalara On Sat, Aug 29, 2015 at 10:08 AM, GENIUS izharra...@gmail.com wrote: Thank you very much for sharing the workbook, but it requires more comprehensiveness, I dont know about

Re: $$Excel-Macros$$ sharing a template for accounting

​See this attachment. Regards Ashish Bhalara​ On Fri, Aug 28, 2015 at 1:37 PM, GENIUS izharra...@gmail.com wrote: it requires a password to password to open the file On Thursday, 27 August 2015 17:36:06 UTC+5, Ashish_Bhalara wrote: Hi, See attached file as per your requirement. Enable

Re: $$Excel-Macros$$ Need help to split numbers available in the last

Hi Nasir, Your message can not view but you can use below formula to split number. =--IFERROR(TRIM(RIGHT(A2,LEN(A2)-SEARCH( ,A2,1))),0) Regards Ashish Bhalara On Wed, Aug 5, 2015 at 5:11 PM, Nasir Shaikh nasirsa...@gmail.com wrote: KEY=1ad2be5fa4f57b86403816ac8682739e41b04832CLIENT

Re: $$Excel-Macros$$ how to seperate

/optout. -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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

Re: $$Excel-Macros$$ Vlookup query

. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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://www.facebook.com

Re: $$Excel-Macros$$ I need a excel where users can add data but cannot delete.

this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP

$$Excel-Macros$$ Split Data Query

Hello experts, I want to split selection data to next columns by macro, please see attached file for require output. -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP

Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness

Re: $$Excel-Macros$$ Re: Please help with Activex cannot insert object. error

to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness

Re: $$Excel-Macros$$ Re: Need function help to calculate on matched field data

with Sheet2 task. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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

$$Excel-Macros$$ Need function help to calculate on matched field data

of Sheet1 task with Sheet2 task. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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

$$Excel-Macros$$ How to show VBA code in *.xlsm format file

. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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://www.facebook.com

Re: $$Excel-Macros$$ Query in code of email send with attachment from excel

, Mar 23, 2015 at 6:30 PM, Vaibhav Joshi v...@vabs.in wrote: Before adding att check if attachment exists or not, if its null then you will get error... Cheers!! On Mon, Mar 23, 2015 at 5:00 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, See the attached file of email

$$Excel-Macros$$ Auto mail to more than one email id from excel

filter data and send mail to all particular party together. I tried using by AutoShowCount and AutoShowField but cannot success. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT

Re: $$Excel-Macros$$ Sum value of closing balance of date

Thank you Mr.Vaibhav:) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, Mar 13, 2015 at 1:28 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Check cell D20 for formula.. On Fri, Mar 13, 2015 at 12

$$Excel-Macros$$ Sum value of closing balance of date

Dear experts, I need function to sum only closing value of particular date, pls see attached file for example. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

Re: $$Excel-Macros$$ Mail from excel using gmail

the reason if you know, otherwise it's ok. Thanks. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Mar 9, 2015 at 12:59 PM, Vaibhav Joshi v...@vabs.in wrote: Hi The script which you gave

$$Excel-Macros$$ Mail from excel using gmail

...@something.nl .From = YourName re...@something.nl .Subject = Important message .TextBody = strbody .Send End With End Sub Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness

Re: $$Excel-Macros$$ Mail from excel using gmail

I checked it, that's not a problem, data browsing and downloading is doing smoothly. On Sun, Mar 8, 2015 at 8:48 AM, Ashish Kumar kumar.ashish...@gmail.com wrote: I think your internet connection is slow. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's

Re: $$Excel-Macros$$ Mail from excel using gmail

Hi.Mr.Ashish Kumar, I tried of changing port number, incoming server popup and also enable smtp/imap service in google account, but still receive error of connection failure. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread

Re: $$Excel-Macros$$ Function for Data validataion

Thanks Mr. Paul for excellent easy condition and your description to understand the issue everytime is also excellent. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Mar 2, 2015 at 8:08 PM, Paul

Re: $$Excel-Macros$$ Re: Query in IF formula on sheet deactivation event

Thanks Mr.Michael, it's work. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Sun, Mar 1, 2015 at 11:08 PM, michael vinoth michaelvino...@gmail.com wrote: Hi Ashish, Please find the attached macro

$$Excel-Macros$$ Query in IF formula on sheet deactivation event

is zero. Kindly see attached file to solve my query, I tried different way in codding but did't get result. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

Re: $$Excel-Macros$$ Function for Data validataion

please make it short or easy. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Sat, Feb 28, 2015 at 11:19 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear Mr.Paul, Thanks to reply. But problem

Re: $$Excel-Macros$$ Function for Data validataion

Dear Mr.Paul, Thanks to reply. But problem of third criteria is still not fulfill as per your condition of 'ISTEXT(MID(A1,1,1)' The output is same 'TRUE' whether entered value is alpha or numeric. Please give me a solution for it or macro also preferred if possible. Regards. Ashish Bhalara

Fwd: $$Excel-Macros$$ Function for Data validataion

-- Forwarded message -- From: Ashish Bhalara ashishbhalar...@gmail.com Date: Fri, Feb 27, 2015 at 9:20 AM Subject: $$Excel-Macros$$ Function for Data validataion To: excel-macros@googlegroups.com Dear experts, I want to formula for data validation to fulfill below conditions

$$Excel-Macros$$ Function for Data validataion

Dear experts, I want to formula for data validation to fulfill below conditions. 1. Total character should be 11 degit 2. Last 7 character should be numeric 3. First 4 character should be Alphabatic (A to Z) Please see attached file in which 3rd criteria I can't make it. P*Please do

Re: $$Excel-Macros$$ Please solve this

Hello, Kindly explain particular detail what result you need, there are not any logic fulfill from your sum in output, though I try to understand your output and solve it, see attached file. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary

Re: $$Excel-Macros$$ Require function for lookup value on condition.

Thanks Mr.Vaibhav Mr.Sandeep, that's exactly what i need:) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 9, 2015 at 10:39 AM, Sandeep Sharma sandeepsharma4...@gmail.com wrote: Thanks

$$Excel-Macros$$ Page footer for last page only.

Dear sir, Kindly suggest to written texts in footer on last page only in excel, if page more than one and print on first page if only one page to print. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness

$$Excel-Macros$$ Require function for lookup value on condition.

Dear experts, I require function to lookup value on consider of two particular condition. Pls. see attached file for example. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT

Re: $$Excel-Macros$$ problem in code fpr data copied from text to number format

Thank you Mr.Paul to suggest me best in coding. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Feb 3, 2015 at 5:50 PM, Paul Schreiner schreiner_p...@att.net wrote: The problem is: When you

$$Excel-Macros$$ Copy Paste only particular to another sheet

Dear Vaibhavji, Thanks to reply, my query to check duplicate value is solved, i was wrong in variable defination. My other query is that I have sheet containing formulas. I want copy paste only those cell which not containing error. Please see attached file for data. Regards. Ashish Bhalara

Re: $$Excel-Macros$$ Loop to check duplicate value

I have to remove q = q + 1 to check every line. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 2, 2015 at 6:17 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Thank you very much

Re: $$Excel-Macros$$ Copy Paste only particular to another sheet

Thank you very muc Mr.Vaibhav Mr.Gaurav Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 2, 2015 at 5:58 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: And Please check the filter again

Re: $$Excel-Macros$$ Loop to check duplicate value

Thank you very much Mr.Paul, my solution is in your last line. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 2, 2015 at 6:04 PM, Paul Schreiner schreiner_p...@att.net wrote: From what I

$$Excel-Macros$$ Loop to check duplicate value

+ 1 Next q Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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

Re: $$Excel-Macros$$ Loop to check duplicate value

Please tell me what's wrong in code. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Feb 2, 2015 at 4:57 PM, Sunil Kumar Yadav sk.yadav7...@gmail.com wrote: Hello Friends, i have checked many

$$Excel-Macros$$ problem in code fpr data copied from text to number format

. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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$$ Wrong entry of a number

Dear experts, I enter number 296100210001856 in cell of excel in number format but after given enter the number change to 296100210001850. I checked all the way but not found any solution, pls check n reply for solution. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless

Re: $$Excel-Macros$$ Wrong entry of a number

I checked it in version of 2007 2003. And also checked same sheet by opening in another PCs and also by creating new sheet. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, Jan 30, 2015 at 3:36

Re: $$Excel-Macros$$ Wrong entry of a number

Yes, I doing same, but is there any solution to type in number format more than 15 digit? Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, Jan 30, 2015 at 3:50 PM, Vaibhav Joshi v...@vabs.in

Re: $$Excel-Macros$$ Data Copy from one sheet (or Form) to another sheet

Data copied perfectly as my requirement but not drag needed field as described in previous mail, I using loop for it but still not success, pls try to edit my code for it. Thanks. On 23-Jan-2015 7:04 PM, Vaibhav Joshi v...@vabs.in wrote: Dear Ashish Bhalara, Is it resolved? ᐧ On Sat, Jan 17

$$Excel-Macros$$ Problem Autofilter Date Range

Range(D11).AutoFilter Field:=4, Criteria1:=r FDate = Range(J1) Ldate = Range(J2) Range(C11).AutoFilter Field:=3, Criteria1:== FDate, Operator:=xlAnd, Criteria2:== Ldate End Sub Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

Thanks Mr.Ashish Kumar, your sharing file of ListPicker is very useful for me. :) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Sat, Jan 17, 2015 at 9:32 PM, Ashish Kumar kumar.ashish...@gmail.com

$$Excel-Macros$$ Data Copy from one sheet (or Form) to another sheet

Dear experts, Please see the attached file in which data copy to Record sheet, there are error occur Object Require, I can't understand. Kindly help for require out put as mention in Record sheet, also guide if it is possible to create Form for DataEntry sheet. Regards. Ashish Bhalara

Re: $$Excel-Macros$$ Data Copy from one sheet (or Form) to another sheet

. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, Jan 16, 2015 at 10:05 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Ashish Bhalara, PFA Regards Ashish -- Are you =EXP(E:RT

$$Excel-Macros$$ Macro for Autofilter

Dear experts, Please provide Macro for autofilter for criteria of Date range exact matching of code as per in attached sheet. Column of C contain date and filter as per range given in J1 to J2. Second filter on column D with exact match in cell J4. Regards. Ashish Bhalara 9624111822 P*Please do

Re: $$Excel-Macros$$ Happy New 2015

A very very Happy New Year to all Group members. On Wed, Dec 31, 2014 at 7:54 PM, Vaibhav Joshi v...@vabs.in wrote: Joyous January –Fabulous February Magical March –Adorable April Magnificent May –Jolly June Jubilant July –Awesome August ScintillatingSeptember –Outstanding October

Re: $$Excel-Macros$$ Need looping to hide row

Thank you very much...Cheers!! Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Dec 30, 2014 at 12:26 PM, Vaibhav Joshi v...@vabs.in wrote: check this i m not getting any error.. + *I

$$Excel-Macros$$ Need looping to hide row

Range(A16).Value Then Rows(16:16).EntireRow.Hidden = False End If End Sub Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ Need looping to hide row

Hi Vaibhavji, The Syntex error occur in IF formula. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Dec 29, 2014 at 7:07 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Try this: Private Sub

Re: $$Excel-Macros$$ Need looping to hide row

I was wrong, error occur of 'Sub of Function not defined. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Dec 30, 2014 at 10:24 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Hi Vaibhavji

$$Excel-Macros$$ Help on coding to change cell value after every printing

till EndRow (L13, L14, .)* If Range(Preview) Then ActiveSheet.PrintPreview Else ActiveSheet.PrintOut End If Next i End Sub Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread

$$Excel-Macros$$ Help on coding to change cell value after every printing

Dear experts, I want to change cell value on every automatic printing as per series given, please see attached file in which describe in detail. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness

Re: $$Excel-Macros$$ Need function help for output of particular list on matching data

Thanks... you are always rock in excel..Cheers!! Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Thu, Dec 25, 2014 at 10:50 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Check this... Cheers

$$Excel-Macros$$ Need function help for output of particular list on matching data

Hello Mr.Vaibhav As per trial mail, you solved my function query to display data on matching code, but could you please edit this function to display only those data which matching with code Date, example is mention in attached sheet. Regards. Ashish Bhalara 9624111822 P*Please do not print

Re: $$Excel-Macros$$ Need function help for output of particular list on matching data

Hi Mr.Vaibhav Ones again thank you so much for your tremendous job to help me. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Dec 23, 2014 at 2:31 PM, Vaibhav Joshi v...@vabs.in wrote: Hi

$$Excel-Macros$$ Need function help for output of particular list on matching data

(SaleData!$A$2)+2),ROWS($B$22:B22)))} Please see attached file for better understanding, kindly solve this query, thanks in Advance. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT

Re: $$Excel-Macros$$ How to extract only numbers

, Mid$(sSpecialChars, i, 1), ) Next removeSpecialAdd = sInput End Function Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Dec 23, 2014 at 11:17 AM, Ashu k direct2as...@gmail.com wrote: vba

Re: $$Excel-Macros$$ Macro for Ageing of Inventory

Mr.C.G.Kumar See attached file as your require function. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Dec 22, 2014 at 9:44 AM, C.G.Kumar kumar.bemlmum...@gmail.com wrote: Hi, I have

$$Excel-Macros$$ Date query for conditional format

Dear experts, I have series of date in which only sunday should be highlighted, please see attached file for example. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP

$$Excel-Macros$$ need function to get data on exact match

Dear experts, I need function to receive data on fulfill particular cell data, the demo is attached herewith, thanks in advance. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT

Re: $$Excel-Macros$$ need macro add Rows

Thank you very much Mr.Vaibhav, ones again u do a marvelous job for me. I also learn new things from your code. Cheers :) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Sep 15, 2014 at 1:52 PM

$$Excel-Macros$$ need macro add Rows

under last series i.e. last series 10, then insert new 5 rows after 10 with writing series 11,12,13,14,15. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

$$Excel-Macros$$ Date in concatenate function

Dear experts, I am using Concatinate function to merge different text but date field not shown as a date in function. Kindly suggest require changes to merge text and date. See the attached file. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely

$$Excel-Macros$$ Help in function to show only valid data

Dear experts, I need a function help in attached sheet, in which Output result display only if value is not equal to zero, if data contain zero value, data should not display in output. Thanks in advance. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely

Re: $$Excel-Macros$$ Help in function to show only valid data

Dear Paul, thanks to reply, I don't want to simple filter. The data source is from same Sheet and data should be automatic filter in the same sheet output by changing date. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental

$$Excel-Macros$$ Change date format

. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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://www.facebook.com

Re: $$Excel-Macros$$ Change date format

Oh Thanks to both of you, its very easy...Cheers!! Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Wed, Jul 16, 2014 at 12:29 PM, Amresh Maurya amreshkushw...@gmail.com wrote: see the attachment

$$Excel-Macros$$ enable Data Validation Insert menu in Developer menu

Dear experts, I want add command button but somehow Insert menu turn to disable in Developer menu, the Data Validation also not work, kindly know me how reset it. Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental

$$Excel-Macros$$ enable Insert menu in Developer menu

Dear experts, I want add command button but somehow Insert menu turn to disable in Developer menu, kindly know me how to enable it. Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you

Re: $$Excel-Macros$$ Autofill Macro

See the attachment of your solution. Use this function... =IF(A2=,,CONCATENATE(COLUMN(),,,ROW())) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Sat, May 10, 2014 at 1:59 PM, Vaibhav Joshi v

$$Excel-Macros$$ if error function

Dear experts, I want to add another function if the result of first function is error, so please know me the function. for example =if function=error, ifanother fuction=error, another function,Value Iferror function cannot use because its contain only 1 argument. Thanks regards. Ashish

Re: $$Excel-Macros$$ if error function

Thanks, thats exactly what i found :) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, May 9, 2014 at 6:49 PM, Vaibhav Joshi v...@vabs.in wrote: Hi You need to use =if ( ISERROR(fn)=True

$$Excel-Macros$$ Need help in Mid function

regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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$$ need solution by IF and lookup fundtion

Dear experts, Please see the attached file, Input sheet contain selection and Output sheet is a result from Input sheet. I need output in yellow cell as per selection in Input sheet by function of IF or any else. Thanks in advance Regards. Ashish Bhalara 9624111822 P*Please do not print

$$Excel-Macros$$ Need help to filter text by function

Dear experts I have a text as per below. Matting, Mud Flap-Vista, , , ,,, I want remove extra comma from the end as below result by function. Matting, Mud Flap-Vista Kindly suggest proper function for it. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless

Re: $$Excel-Macros$$ Need help to filter text by function

Thanks to reply but the Mud Flap-Vista is a complete word, there are no need comma between Mud Flap-Vista. I want to remove only last commas, kindly suggest if possible. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental

$$Excel-Macros$$ Help to merge text from difference cell

Dear experts, I want merge cell containing text value and want comma(,) between all cell value in cocatenate function but my query is that when cell value is blank, the comma should not be display. Is it possible, kindly guide regarding this. Thanks regards. Ashish Bhalara 9624111822 P*Please

$$Excel-Macros$$ Error occured during opening the file

as [Repaired] file. This file contain many sheets and conditions of also linking of each sheets. To complete the task of copy paste in new work book is so hard to write all conditions macros. Kindly give the proper solution regarding this matter. Thanks regards. Ashish Bhalara 9624111822 P*Please do

$$Excel-Macros$$ Error occured during opening the file

from /xl/printerSettings/printerSettings5.bin part (Print options)/removedRecord /removedRecords /recoveryLog Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP

Fwd: $$Excel-Macros$$ Show links which to other Data source

-- Forwarded message -- From: Ashish Bhalara ashishbhalar...@gmail.com Date: Tue, Apr 1, 2014 at 1:23 PM Subject: $$Excel-Macros$$ Show links which to other Data source To: excel-macros@googlegroups com excel-macros@googlegroups.com Dear experts, My workbook containing large

Fwd: $$Excel-Macros$$ Show links which to other Data source

-- Forwarded message -- From: Ashish Bhalara ashishbhalar...@gmail.com Date: Wed, Apr 2, 2014 at 4:10 PM Subject: Fwd: $$Excel-Macros$$ Show links which to other Data source To: excel-macros@googlegroups com excel-macros@googlegroups.com -- Forwarded message

$$Excel-Macros$$ Show links which to other Data source

Dear experts, My workbook containing large no. of sheets formulas, but I want to show those formulas which containing links to other data source of file. Kindly know me how to check it. -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary

Re: $$Excel-Macros$$ Re: Copy data from multiple sheets into single sheet.

...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless

Re: $$Excel-Macros$$ Fwd: Need VBA coding for vlookup function

OK, I got it, Thank you very much Mr.Ravinderji. On Wed, Mar 19, 2014 at 2:33 PM, Ravinder ravindervbacli...@gmail.comwrote: Pfa… put correct formula for B4 and B5 in vba code…. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Ashish Bhalara

Re: $$Excel-Macros$$ Date of Retirement.

/opt_out. -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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

Re: $$Excel-Macros$$ VLOOKUP Query

/groups/opt_out. -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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

$$Excel-Macros$$ Filter Data of Bold letter

Dear experts, I have a data columnar and want filter only bold letter data, is it possible, if yes please tell me how it done. Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP

Re: $$Excel-Macros$$ Filter Data of Bold letter

PM, अनिल नारायण गवली gawlianil8...@gmail.com wrote: Dear Ashish, Pl share the workbook with us. Warm Regards, Gawli Anil. Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Sep 11, 2013 at 1:20 PM, Ashish Bhalara ashishbhalar

Re: $$Excel-Macros$$ Re: Excel file corrupt in Outlook

Thanks for reply sir, but my problem is still there, i did setting as you say but there are not solve my problem, kindly suggest another solution, Regards Ashish Bhalara On Wed, Jan 9, 2013 at 3:58 PM, Lalit Mohan Pandey mohan.pande...@gmail.com wrote: Hi Ashish, Here is the fix

$$Excel-Macros$$ Formula need to calculate sum on conditional base

. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like

Fwd: $$Excel-Macros$$ Re: Formula need to calculate sum on conditional base

: Formula need to calculate sum on conditional base To: excel-macros@googlegroups.com, Ashish Bhalara ashishbhalar...@gmail.com Pls find attched sheet for you reference. Regards, Gawli Anil On Fri, Nov 30, 2012 at 12:16 PM, Ashish Bhalara ashishbhalar...@gmail.comwrote: i need the formula for text

Re: $$Excel-Macros$$ K.A. Mr.Rajan Verma: Help need to get multiple values by vlookup

@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Ashish Bhalara *Sent:* 08 November 2012 4:25 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ K.A. Mr.Rajan Verma: Help need to get multiple values by vlookup Hi Mr.Rajan Thanks to sharing

Re: $$Excel-Macros$$ Fillup data in cell

Hello everyones, Could anybody solve my query please. Ashish On Sat, Oct 6, 2012 at 4:54 PM, Ashish Bhalara ashishbhalar...@gmail.comwrote: Dear experts, I need to fill data in downward selected cell from upward cell as mention in attached file, is there possible. Thanks regards

$$Excel-Macros$$ Fillup data in cell

Dear experts, I need to fill data in downward selected cell from upward cell as mention in attached file, is there possible. Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Join official

Re: $$Excel-Macros$$ Need help

to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness

Re: $$Excel-Macros$$ EXCEL ADD-IN for reconciling two Data Tables

you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Thanks regards. Ashish Bhalara 9624111822 P*Please do

  1   2   >