Re: $$Excel-Macros$$ 16th digit show zero in excel

use the following format On Friday, June 29, 2018, 2:52:10 PM GMT+5, Ali Abbas wrote: Dear All, when I entered 16th digit in excel excel automatically shows it zero. I need enter 16 or 17 digit in single cell. Plz guide how to fix this issue.  -- Are you =EXP(E:RT) or =NOT(EXP

$$Excel-Macros$$ Re: Search any Specific word in all excel tabs

See the result inside the workbook -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like

$$Excel-Macros$$ Re: Need Help in IF formula

-- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, For

$$Excel-Macros$$ Re: Microsoft Excel help needed for newbe

There are so many website which not only teaches excel but also provide the example, some of them are mentioned below, this forum also helps a lot, you may learn advanced excel and macro from this site and also ask question. http://www.contextures.com/ https://people.highline.edu/mgirvin/exceli

Re: $$Excel-Macros$$ CODE FOR RANGE

Thanks for your help -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

$$Excel-Macros$$ Re: Values are not calculating in number format

Please find the attach for solution -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ Excel Macro Help

look at the attachment, I can do only this. -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titl

$$Excel-Macros$$ Re: How to Shift Chart Table Legend on Right Hand Side

If like this, then I'm using excel 2013 -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles,

$$Excel-Macros$$ Re: Excel VBA Training

I'm from Pakistan, if I'm interested in this course, how do i pay the amount in easiest way, please informed me. second is there any outline of the course. -- 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 foru

$$Excel-Macros$$ Re: Automation for copy a voucher from one sheet to another

Hi friends please do the needful -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like

$$Excel-Macros$$ Re: Automation for copy a voucher from one sheet to another

It seems that my brothers are annoyed with me -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread ti

$$Excel-Macros$$ Re: Creating Repetitive Dynamic Graph in multiple worksheet using VBA

for more details you may also see this site http://www.utteraccess.com/wiki/Tables_in_Excel -- 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/discussexcel FORUM RULES 1) Use

$$Excel-Macros$$ Re: Creating Repetitive Dynamic Graph in multiple worksheet using VBA

I don't know what you mean by "repetitive" dynamic graphs. but if you convert the ranges into Excel tables and build the charts off the tables, the charts will be dynamic. -- 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

$$Excel-Macros$$ Re: To automate the transformation of a data column to a two dimensional table

Sir, Please do the needful... -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Plea

$$Excel-Macros$$ Re: automation of transfer of data from several sheets to one sheet

Thank you once again -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

$$Excel-Macros$$ Re: automation of transfer of data from several sheets to one sheet

Hi Mr Pascal Thank you very much for you help, but there is slightly moving the row below the destination location, please see the attachment . -- 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$$ Re: automation of transfer of data from several sheets to one sheet

HI FRIENDS AND BROTHERS PLEASE DO ME A FAVOR -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread tit

$$Excel-Macros$$ Re: Custom Formatting in Excel

> > look at the sheet, may be you required this. -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thre

Re: $$Excel-Macros$$ When Excel Save then below message show

go to google and type the following sentence without quote "with reference to unsaved documents" -- 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/discussexcel FORUM RULES 1)

Re: $$Excel-Macros$$ GOAL SEEK

Sir, You are superb,thank you very very very much. -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thre

Re: $$Excel-Macros$$ GOAL SEEK

Sir, Please one more favor -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ GOAL SEEK

OH THAT'S REALLY GREAT, WHAT A ANSWER THANK YOU VERY MUCH SIR regarding solver I have another one could you please look at it. -- 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$$ GOAL SEEK

Thanks Mr Sandeep Kumar Baranwal, I know this but I need the formula ok if there is no formula then can we do it thru SOLVER, if there is any possibility then can you do it, thanks in advance. I'm sure we can do thru SOLVER by applying different parameters *but the problem is what are those pa

Re: $$Excel-Macros$$ Transpose macro

Thank you Gowri for you help -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ automation for advanced filter

That's really great and thanks a ton -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, lik

Re: $$Excel-Macros$$ automation for advanced filter

Hi gowri Thank you very much for your help, but there is a problem when I run it by pressing F5 key it works perfectly first time but when i run it again by pressing F8 key it does not show the proper result for more details please see the attachment' I'm using excel 2013 OR secondly when I ch

Re: $$Excel-Macros$$ advanced formula

Thank you Mr Swapnil Palande -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Pleas

Re: $$Excel-Macros$$ advanced formula

Thank you very much for your help, can you please do it through formula because if you see my question I've mentioned use formula instead pivot table. -- 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$$ automation

Hi JAYAVELU SUN Sir, Thank you very much for your help and hope to continue in future as well. -- 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/discussexcel FORUM RULES 1

$$Excel-Macros$$ Re: inventory update

sir Paul, would you please look into this matter. -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor threa

Re: $$Excel-Macros$$ changing required in the attach macro

First Thank you very much for your suggestion, I'll try my best to describe the title as accurate as possible, since I'm new in macro so there are chances to not define the title as accurate as possible but I'll try my best Second Thank you for your help in the question -- Are you =EXP(E:RT)

Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES

That's great, Thank you very much for your help -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread

$$Excel-Macros$$ Re: MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES

Hi Paul Sir, I'm waiting for you good help -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titl

Re: $$Excel-Macros$$ something wrong with the attach macro

That's working for me as well, thank you -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ converting sheet to macro

I think there is some misunderstanding, actually I need a macro for column A:F, I want to create the same i.e. column A:F thru macro, because if you see column A:F created thru formulas and the source of references has been taken from column I:L, so column I:L are just for references and nothing

Re: $$Excel-Macros$$ converting sheet to macro

sometime when you have to learn a new function or formula, for this purpose one must have a file on which the same function or formula must be applied so I need a data set for my learning about a new function or new formula, I have created it thru function but the same I want to create thru macr

Re: $$Excel-Macros$$ copy only yellow cells

Thank you sir -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

Re: $$Excel-Macros$$ move sheets to a workbook

Sir, I am really very sorry for that, and you are really really kind person, I really really appreciate your efforts you have made and once again I'm sorry. thank you very much sir, you have done a very good job "may GOD bless you always" -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ move sheets to a workbook

Hi Mr Paul in view of your answer i tried to solve the question but could not, there are chances that I may not explain my question, but you may see the second time explanation, please do the needful, it is very important, I appreciate the efforts you have made. -- Are you =EXP(E:RT) or =NOT(E

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

Hi Pual would be please see my question as well. -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

Hi Experts, I have mentioned question in my workbook, thanks -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titl

Re: $$Excel-Macros$$ Some changes required

Hi sourav devrani That's really very great, thank you very much for your help. -- 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/discussexcel FORUM RULES 1) Use concise, accu

$$Excel-Macros$$ Re: transforming data from multiple columns to two columns

> > Sir, > Thank you very much, that's really great and I really appreciate your efforts. -- 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/discussexcel FORUM RULES 1) Use

$$Excel-Macros$$ Re: transforming data from multiple columns to two columns

I would request from all my brothers, if there is no formula, would you please write a macro for this. Thanks in advance -- 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/discu

$$Excel-Macros$$ Re: transforming data from multiple columns to two columns

would anyone kindly consider my request thanks in advance -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Po

Re: $$Excel-Macros$$ how to remove password

I tried it myself and I succeeded, if you i say I can share the URL for the site. This URL enabled my file without password within a minute -- 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://ww

Re: $$Excel-Macros$$ how to remove password

Hi Mr Paul How r u, thanks for your response, First, if the forum do not allow this, would you please give me your email address so that I can send the same file on that. Second, I tried the googling but could not find a free software, please do the needful. Hi Mr Oussama Sahri, I open the U

$$Excel-Macros$$ Re: how to remove password

sir, I need your help -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ macro to be edit

Sir, Thanks you very much for your help. Would you please suggest the best way for learning Macro and the videos, I have watched so many videos on macros but those videos are not so advanced. Thanks once again. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME

Re: $$Excel-Macros$$ macro to be edit

you may see the attachment, I have made some changes in it, and then running the same but still not working. Would you please change it and then send it to me the changed copy, please don't mention in the email because I'm not so expert in macro NOTE: I'm using excel 2013 -- Are you =EXP(E:R

$$Excel-Macros$$ Re: MATCH and INDEX function instead NESTED IF function

the same as the meaning of zero rated sales tax and exempt sales tax sorry I'm just joking, actually I downloaded this template from somewhere, they were using this, and I did not bother to ask from the person what does this mean. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you w

Re: $$Excel-Macros$$ MATCH and INDEX function instead NESTED IF function

I understand your formula of vlookup but would you please tell me is there any chances of using the MATCH and INDEX function, if we change the pattern of the sheet, for more please see the attachment, because vlookup seach only the data on the right but what about if the data is on the left --

Re: $$Excel-Macros$$ changes required in the attach macro

Thank you very much for your immediate solution and cooperation. -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread tit

Re: $$Excel-Macros$$ MACRO NOT WORKNIG

Thank you very much Mr. Mihai Ghilea -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, lik

$$Excel-Macros$$ Re: how to sum colored cell only

Mr Mahesh Patil look at it I have done it but thanks for you suggestion -- 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/discussexcel FORUM RULES 1) Use concise, accurate t

$$Excel-Macros$$ Re: how to sum colored cell only

I did according to the answer given by Mr Sachin but that is not working so I would like to draw the attention of Mr Sachin once again please check the attachement what's wrong i have done. -- 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

$$Excel-Macros$$ Re: how to sum colored cell only

I have applied the formula but not working, you may see the result in the attachment. -- 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/discussexcel FORUM RULES 1) Use conci

Re: $$Excel-Macros$$ Macro not working

Thanks brother that's great -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Macro not working

working perfectly, thank you very much for your help one more question, if I have figures in column A as shown in the sheet and I want to take the 17% in column B of the amount of column A as shown in the attachment then how do I automate this task whenever i put a figure in column A and run

Re: $$Excel-Macros$$ Macro not working

> > Sir > Thanks for your follow up, I enable which you have mentioned in the last mail but there is another message please see the attachment right now I have three version of excel i.e. 2007,2010 & 2013, I opened the file in excel 2010 and I also have Microsoft outlook 2010 -- Are you =EXP(

Re: $$Excel-Macros$$ Macro not working

Sir I'm waiting for your reply very anxiously -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread t

Re: $$Excel-Macros$$ Macro is not working

THANK YOU VERY MUCH MR GAURAV DEVRANI AND ALSO THANKS FOR MR XLS S for a new way of doing the same. -- 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/discussexcel FORUM RULES

$$Excel-Macros$$ Re: formula proble

Once again thanks all of you. -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Pleas

Re: $$Excel-Macros$$ formula proble

Thank you very much for your quick reply and correction of formula once again thank you very much -- 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/discussexcel FORUM RULES 1

$$Excel-Macros$$ Re: Extracting S

Thank you very much for your help -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like P

Re: $$Excel-Macros$$ date problem

I did this (custom formatting) in my computer but not working, actually I got this file from a system where the date format of the system was mm/dd/ -- 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$$ formula required

According to the condition the formula is perfect but if you have few more minutes can you please explain this formula thank you very much for this -- 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 @ ht

Re: $$Excel-Macros$$ addition of 10% thru macro

That's great, thank you very much sir -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, li

Re: $$Excel-Macros$$ SUM

Thank you very much for your consideration and the result but if I need a formula in the same cells in which we are getting the sum of three column without the formula, is there any possibility which shows the formula in the three cells, because in this way we may press F2 and check the cell re

Re: $$Excel-Macros$$ failed to run the macro

Thank you very much for your information -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ extracting numbers

Hi Abhi thanks for you help, in view of your formula i've tried to extract the one you left by putting the following formula =MID(A4,FIND("iap",A4)+3,1) once again thank you very much for your help -- 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

$$Excel-Macros$$ Re: How to calculate total hour by using formula

subtract time out from time in -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Plea

Re: $$Excel-Macros$$ code requried

first No I have not done vba programming before secondly the destination workbook will be new, there is no datasheet in it, just blank sheets as usual, third Yes I'm taking the data from the source workbook to the destination workbook. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ OVERFLOW message in VBA

> > Sir > > you are right but I'm not so expert in the macro, I'm in the learning process, and as per the following note I don't know what is this let me learn more but right now i need to change these code so that I get the result of 5000 rows, can you please help me in this regard. Integer d

$$Excel-Macros$$ Re: Vlookup with match or Indirect or Index

look at the attachment if you get some idea for your requirements -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread ti

Re: $$Excel-Macros$$ Query regarding auto hide rows in excell

http://www.techrepublic.com/blog/windows-and-office/excels-auto-outline-quickly-hides-data-details-to-simplify-viewing/ go to the above url or watch the following url on youtube https://www.youtube.com/watch?v=8j6KX6WDgEM -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

$$Excel-Macros$$ Re: GOAL SEEK

HI I DID KNOW THE WAY THE PERSON SHOWING IN THE VIDEO BUT HOW DO I DO IF I HAVE ONE HUNDRED THOUSAND STUDENTS AND WANT TO EXTRACT A CERTAIN PERCENTAGE FOR ALL THE INDIVIDUAL AT THE SAME TIME NOT INDIVIDUALLY. I THINK IT IS POSSIBLE THROUGH SOLVER BUT I DONT KNOW THE WAY FOR FINDING THE PERCEN

Re: $$Excel-Macros$$ Making a mistake in the formula

Thank you very much for your time -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ personal macro workbook

Thank you very much for your help. -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, l

$$Excel-Macros$$ Re: Need Excel Macro Training

on the internet there so many videos from which you may learn by your own pace no need to worry to take admission in any institute it totally depends on you how do you search these videos -- 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 off

Re: $$Excel-Macros$$ Date formula for Age Calculation

LOOK AT THE ATTACHMENT -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ removes the jpeg extension

HI Thank you very much Mr. Ravinder Negi, that's really great -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titl

Re: $$Excel-Macros$$ removes the jpeg extension

FIRST Thank you very much for your reply, consideration and code actually I dont know a lot about macros, may be 10% out of 100%, so please do it for me the code i sent to your with the file is not typed by me but taken from somewhere i.e. from internet source, the source was also failed to do t

Re: $$Excel-Macros$$ macro for custom views

Oh that's really great thank you very much for your help > > -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles

$$Excel-Macros$$ Re: formula for creating numbers

OK I DID IT AND THANK YOU VERY MUCH FOR YOUR KINDNESS -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor

$$Excel-Macros$$ Re: formula for creating numbers

Hi Mandeep I saw you result but it is not fulfilling my requirements for your convenience I'm sending the same sheet but with a little different way please open and check it. thank you Mandeep for your efforts for me. secondly Mr Satendra Kumar also sent the sheet but nothing special it is s

$$Excel-Macros$$ Re: formula for creating numbers

THANK YOU VERY MUCH FOR YOUR HELP I'VE ONE MORE QUESTION, CAN YOU PLEASE SEE IT AND SOLVE IT in the attachment, there is no figure in column F, in column N there is an average, if i need the averages as per my requirements then how can I get through solver, please show the steps.. *NOTE:* ke

Re: $$Excel-Macros$$ QUESTION FOR DAYS DIFFERENCE

Thank you for your help On Monday, 11 January 2016 10:11:15 UTC+5, Abhi wrote: > > When you are subtracting, you are excluding the start date. > > > > On Mon, Jan 11, 2016 at 10:30 AM, Izhar > > wrote: > >> Please open the attachment see the question. >> Thanks in advance. >> >> -- >> Are you =

Re: $$Excel-Macros$$ QUESTION FOR DAYS DIFFERENCE

but if we subtract 4-2 we get 2 and and then add the same two into 2 we get 4 then why in the date if I take a loan from a bank, the banker wont include the first date in view of applying markup rate on my loan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIM

$$Excel-Macros$$ Re: macro for hard copy of formulas

IT IS WORKING THANK YOU VERY MUCH FOR YOUR HELP > > > -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor

$$Excel-Macros$$ Re: Assigning names to sheet

Thank you very much for your quick response, I really appreciate it Thank you very much once again -- 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/discussexcel FORUM RULES 1

$$Excel-Macros$$ Re: duplicate value thru randbetween

Is there anyone who can reply for the question thanks in advance On Wednesday, 9 December 2015 16:36:43 UTC+5, GENIUS wrote: > > in the attach sheet, I have choosen six cell, in which I have put a > formula of RANDBETWEEN when I press F9 key four or five times, you may > obse

$$Excel-Macros$$ Re: Introduce Yourself !!

Hi everyone I'm izhar, from Karachi-Pakistan, working as an accountant,47 years old. -- 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/discussexcel FORUM RULES 1) Use concise,

Re: $$Excel-Macros$$ PERSONAL MACRO WORKBOOK

THANK YOU VERY MUCH FOR YOUR HELP On Friday, 27 November 2015 14:07:00 UTC+5, ashish wrote: > > check this out > http://www.rondebruin.nl/win/personal.htm > > On Fri, Nov 27, 2015 at 1:33 PM, Izhar > > wrote: > >> >> I've downloaded macro codes for this file and these codes are only run on >> th

$$Excel-Macros$$ Re: keyboard shortcut by dragging for copying

ALT+H+FI+F (for excel 2013) I think the above one is more easy then the one you suggested, i use yours one but it does not work with my excel, yes the key ALT+E+I+S opens up the SERIES dialogue box but then we have to work more so it takes a lot of time and you know very well we use keyboard

$$Excel-Macros$$ Re: keyboard shortcut by dragging for copying

Suppose I want to copy it till 500,000 rows then how is it possible, if there is possibility then first select the range (i.e. 500,000 rows) and the press CTRL+D but i dont want to select the range, I just press the cona of the cell so that it copies till A50, I think you understand my poin

$$Excel-Macros$$ Re: help required

> Hi Sam > Thank you very much for your quick response > Later i researched on the particular question and i concluded a result > which may be seen in the attach workbook...but thank you very much for your > quick response > > -- > *Izhar Ul Haq* > > > > Cell# 009203069072597 > -- Are

$$Excel-Macros$$ Re: HELP REQUIRED

n the end, due to your way of searching I've succeeded in my mission so thank your very much for your help. On Saturday, 24 October 2015 17:26:18 UTC+5, GENIUS wrote: > > Is there any macro for searching a text inside the workbook if I have 100 > workbook in a folder, I'm us

$$Excel-Macros$$ Re: FORMULA REQUIRED

Thank you Mr Paul that's really great On Saturday, 24 October 2015 17:07:35 UTC+5, GENIUS wrote: > > Thanks for your reply, but let me clear as you may see if we put more data > in the rows we may have the sum of all the rows at one place, look at the > sheet, but i need only

$$Excel-Macros$$ Re: FORMULA REQUIRED

only not the others. On Friday, 23 October 2015 20:38:38 UTC+5, GENIUS wrote: > > > As you may see I have already used different cell reference for summing up > the UNIT and COST but I need a formula from which when I type and take the > reference of all the cell i.e. A3:H3 un

  1   2   >