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

Hi Everyone I'm Izhar and from Karachi-Pakistan and want to be master in excel I search different sites for excel, I have joined this group for improving my excel with macros so I'm very much interested to learn excel. I am working as an Accountant and 45 years old, and thankful to Mr. Ayush

$$Excel-Macros$$ Re: Date Format Query

look at the result -- 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: Shortcut key for Border

very easy just create ALL BORDER in the quick access toolbar and choose the key assigned by excel to that toolbar On Wednesday, 12 October 2011 12:19:29 UTC+5, ankit wrote: Dear All, I need shortcut key for all border.plz help me. Regards, Ankit -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

$$Excel-Macros$$ Re: Want to learn Microsoft Access

I'm also new like you, and I'm doing the following for this purpose, I've downloaded an ebook from torrent, the name of the book is MICROSOFT ACCESS 2013 BIBLE the following are the URL for downloading the book and exercise files from the first one you may download the book and from the second

$$Excel-Macros$$ Re: How to convert PDF file into excel sheet correctly with same column width rows

just use Adobe Acrobat XI pro, it may convert your pdf into excel On Tuesday, 4 November 2014 17:36:21 UTC+5, MRafique Ujjan wrote: Dear Experts! Hi, I have a problem while i copy data from pdf file to excel... it doesn't copy in same columns rows as shown in pdf file. Therefore please

$$Excel-Macros$$ Re: WANT TO open FILE frequently

On Tuesday, 26 May 2015 15:25:58 UTC+5, sonu wrote: Team, I want to open some file frequently. is any option available in excel 2013 to create a symbol in menu bar .when ever I open excel same symbol appear on menu bar and when I clicked on the symbol .my file get open. [image: Inline

$$Excel-Macros$$ Re: Need to print text properly alligned in excel

for this purpose you may use TEXT TO COLUMN from DATA ribbon On Friday, 3 July 2015 15:41:43 UTC+5, MRafique Ujjan wrote: Dear Excel Experts! I am facing a problem while print 100s of payslips, problem is that its data is written in one cell which contains text and numerical data. they

Re: $$Excel-Macros$$ HELP REQUIRED

THANK YOU VERY MUCH FOR YOUR HELP On Monday, 17 August 2015 16:43:38 UTC+5, Paul Schreiner wrote: In the autofilter panel, you are selecting cells that begin with M. In the next box, choose cells that do NOT begin with MN [image: Inline image] *Paul*

Re: $$Excel-Macros$$ help required in petty cash transanction

The formula you have sent is working but the problem over here is the date when i copy 02/06/2015 from another sheet and paste the same in TRANSANCTION sheet, then it is over write on the previous one. Now I'm sending 4 days transanction to you just apply such a formula when i copy

Re: $$Excel-Macros$$ help required in petty cash transanction

THANK YOU VERY MUCH FOR YOUR HELP On Saturday, 22 August 2015 10:16:25 UTC+5, GENIUS wrote: The formula you have sent is working but the problem over here is the date when i copy 02/06/2015 from another sheet and paste the same in TRANSANCTION sheet, then it is over write on the previous

Re: $$Excel-Macros$$ FORMULA REQUIRED

Thank you very much for your quick response, I really appreciate it. once again thank you for your help On Thursday, 30 July 2015 20:43:01 UTC+5, Pankaj Sharma wrote: use this =INDEX($L$2:$R$87,MATCH($B2,$K$2:$K$87,0),MATCH($C2,$L$1:$R$1,0)) or if you don't want to see #N/A error so use

$$Excel-Macros$$ Re: HELP REQUIRED

. In 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 using windows 7 e

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

$$Excel-Macros$$ Re: Power pivot in Excel 2013

go to FILE choose OPTIONS choose ADD-INS then from the MANAGE dro p down choose COM ADD-INS press GO then check the mark of MICROSOFT OFFICE POWER PIVOT FOR EXCEL 2013 On Thursday, 15 October 2015 16:50:04 UTC+5, Amit Desai (MERU) wrote: > > Can someone please help? Please let me know the

Re: $$Excel-Macros$$ VLOOKUP NOT WORKING

SORRY FOR MISUNDERSTANDING On Friday, 9 October 2015 22:12:08 UTC+5, GENIUS wrote: > > > > On Wednesday, 7 October 2015 16:03:31 UTC+5, Paul Schreiner wrote: >> >> Is this related to "VLOOKUP NOT WORKING"? >> >> I suspect you've "hijacked"

Re: $$Excel-Macros$$ VLOOKUP NOT WORKING

On Wednesday, 7 October 2015 16:03:31 UTC+5, Paul Schreiner wrote: > > Is this related to "VLOOKUP NOT WORKING"? > > I suspect you've "hijacked" Izhar's thread. > > see forum rules #2: > > 2) Don't post a question in the thread of another member. > > I'll be glad to help, but don't wish to

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

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 Macro in Excel before use it. Regards Ashish Bhalara On Thu, Aug 27, 2015 at 12:20 PM, Izhar izhar...@gmail.com

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

, GENIUS izhar...@gmail.com javascript: 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 Macro in Excel before use it. Regards Ashish Bhalara On Thu, Aug 27

Re: $$Excel-Macros$$ terms

On Tuesday, 8 September 2015 16:47:00 UTC+5, Paul Schreiner wrote: > > First of all, learning by yourself is admirable! > There are lots tools that help. > > The one I use the absolute MOST is the HELP within the VBA editor. > > In the upper right of the editor window, you'll see a box that says

Re: $$Excel-Macros$$ terms

you can.” - John Wesley* > - > > -- > *From:* GENIUS <izhar...@gmail.com > > *To:* MS EXCEL AND VBA MACROS <excel-...@googlegroups.com > > *Cc:* schrein...@att.net > *Sent:* Wednesday, September 9,

$$Excel-Macros$$ Re: Populate a calendar from a table

CAN YOU PLS DO IT FOR ME NOT WITH THE MACRO BUT FORMULA > *Izhar Ul Haq* > > > > Cell# 009203069072597 > -- 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

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

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

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

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

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

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

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.

$$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:*

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

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

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

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

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

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,

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

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

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

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

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

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

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

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

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

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 @

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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,

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

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

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

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

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

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 @

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,

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

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

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

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

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?

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  1   2   >