Re: $$Excel-Macros$$ Screenshot in different designs

2016-04-27 Thread Pravin Gunjal
Thanks.. On Wednesday, April 27, 2016 at 12:50:04 PM UTC+5:30, Abhi wrote: > > Try searching for something like "screen capture with effects" > > BTW, the TNT Screen Capture tool has paper-tear effects like the one in > your example. > > > > On Wed, Apr 27,

$$Excel-Macros$$ Screenshot in different designs

2016-04-27 Thread Pravin Gunjal
Dear Friends, This is apart from excel knowledge, I would like to know to how to take such different designs screenshots: Attached one example. Please confirm. Thanks, Regards Pravin Gunjal -- 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

Re: $$Excel-Macros$$ Problem in Pivot Table

2016-04-25 Thread Pravin Gunjal
Perfect... Thanks! *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* On Mon, Apr 25, 2016 at 1:17 PM, Abhishek Jain <abhishek@gmail.com> wrote: > Try this: > >1. Right-click a cell in the pivot table >2. Click on PivotTable options >3. Click o

Re: $$Excel-Macros$$ Hyperlink for multiple sheets

2016-05-13 Thread Pravin Gunjal
Thanks Abhishek.. *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* On Fri, May 13, 2016 at 3:15 PM, Abhishek Jain <abhishek@gmail.com> wrote: > > http://www.get-digital-help.com/2012/07/18/create-links-to-all-sheets-in-a-workbook/ > > On Fri, May 13, 2016

Re: $$Excel-Macros$$ Remove all macros from all the excel files on a computer

2016-05-02 Thread Pravin Gunjal
Thanks but I want to remove macros not only from a workbook but also from all the excel files available in that computer. *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* On Tue, May 3, 2016 at 10:57 AM, Abhishek Jain <abhishek@gmail.com> wrote: > http://excelribbon

Re: $$Excel-Macros$$ Remove all macros from all the excel files on a computer

2016-05-02 Thread Pravin Gunjal
Thanks Mr.Abhishek but it's not helpful. Is there any file or something else by opening that all the macros from all excel files will be removed once in all. Pravin. *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* On Mon, May 2, 2016 at 6:07 PM, Abhishek Jain <abhishek@gmail.

$$Excel-Macros$$ Remove all macros from all the excel files on a computer

2016-05-02 Thread Pravin Gunjal
Hi, Good Evening I would like to know whether is there any provision to remove all macros from all the excel files on a computer? Kindly share your inputs. Thank you, Regards Pravin Gunjal -- 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$$ Remove all macros from all the excel files on a computer

2016-05-10 Thread Pravin Gunjal
Thanks. *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* On Mon, May 9, 2016 at 8:05 PM, Paul Schreiner <schreiner_p...@att.net> wrote: > The only way I can think of immediately is to use Excel 2010 or 2013 and > have a macro that opens all excel files on a compute

$$Excel-Macros$$ How to unhide columns in Office 2010 - Windows 10

2016-08-08 Thread Pravin Gunjal
Hi Friend Greetings! Could you please assist me on how to unhide shortcut of "Ctrl+Shift+0" as it's not working in Windows 10 with Office 2010. Thanks, *With regards,**Pravin Gunjal* *​​* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,

$$Excel-Macros$$ Data moving from one file to other as required

2017-02-06 Thread Pravin Gunjal
terial" should be added with comma, whereas "Doctor Name" & "Patient Name" should come only once for an invoice) e.g. I have taken up the data for Invoice No.8137000290 from source file to target. Could you please help me to get it done with any VB / Formula. *

$$Excel-Macros$$ Fetching Matches Data

2017-02-06 Thread Pravin Gunjal
olumn serial may differs but name is the same in both the file, for ready reference I have given Pink Background color for identification. Can someone help me out on this please. Find attached both the files. Regards Pravin Gunjal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

$$Excel-Macros$$ Re: Data moving from one file to other as required

2017-02-07 Thread Pravin Gunjal
Hi, Can anyone help me out on this subject, please. *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* On Tue, Feb 7, 2017 at 11:40 AM, Pravin Gunjal <isk1...@gmail.com> wrote: > Hi Friends > > Greetings! > > I have attached two files viz. Sample Source &

$$Excel-Macros$$ Re: Fetching Matches Data

2017-02-07 Thread Pravin Gunjal
Hi Buddy's Any solution on this please. Regards Pravin. On Tuesday, February 7, 2017 at 12:50:51 PM UTC+5:30, Pravin Gunjal wrote: > > Hi Everyone, > > I need to have some data which I could take by doing VLOOKUP but there are > multiple rows with same requirement, hence e

$$Excel-Macros$$ Rename all sheets of one excel file in single shot with different names

2016-08-17 Thread Pravin Gunjal
are to be replaced) 3. Make one button in that sheet - once the button is hit the all the sheets are renamed. Regards Pravin Gunjal -- 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$$ Rename all sheets of one excel file in single shot with different names

2016-08-23 Thread Pravin Gunjal
,**Pravin Gunjal* *Mobile: 77100 * *97250* On Wed, Aug 17, 2016 at 4:05 PM, Gaurav Devrani <gauravdev1...@gmail.com> wrote: > Hi Pravin, > > I think this query was already posted few weeks back. Please check the > attachment. Let me know if that does not work. > > Regards >

Re: $$Excel-Macros$$ Rename all sheets of one excel file in single shot with different names

2016-08-23 Thread Pravin Gunjal
Hi Gaurav Checked once again and it's working fine. Thanks :) Need one more help with the same subject. In "Tab-Names" sheet, can we insert B1 cell of all the sheets along with sheet names in a column. *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* On Tue, Aug 23, 2016

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

2017-10-11 Thread Pravin Gunjal
Dear Friends, Greetings! I need to calculate SUM OR COUNT formula's for column D & E but it seems these values are not in number format. Could you please guide me how to convert them in number. As there is *space & comma *given before all the values. *With regards,**Pravin Gunjal*

$$Excel-Macros$$ Microsoft Office 2016 Opens Very Slow in Windows 10

2017-11-24 Thread Pravin Gunjal
Hi, Can any look in to this request please. *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* -- Forwarded message -- From: Pravin Gunjal <isk1...@gmail.com> Date: Fri, Nov 24, 2017 at 10:09 AM Subject: $$Excel-Macros$$ Microsoft Office Opens Very Slow in W

$$Excel-Macros$$ Microsoft Office Opens Very Slow in Windows 10

2017-11-23 Thread Pravin Gunjal
en, even for blank file also.* Could anyone let me have solution for this please. Thank you. Regards, Pravin Gunjal. -- 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/disc

$$Excel-Macros$$ Re: Microsoft Office 2016 Opens Very Slow in Windows 10

2017-11-29 Thread Pravin Gunjal
Hi Experts, Need your advises. Regards, Pravin. On Friday, November 24, 2017 at 5:45:08 PM UTC+5:30, Pravin Gunjal wrote: > > Hi, Can any look in to this request please. > > > *With regards,**Pravin Gunjal* > > > -- Forwarded message ---

$$Excel-Macros$$ Re: Microsoft Office Opens Very Slow in Windows 10

2017-12-04 Thread Pravin Gunjal
Dear *Experts* Awaiting for your help on the above subject. Regards, Pravin Gunjal On Friday, November 24, 2017 at 10:09:56 AM UTC+5:30, Pravin Gunjal wrote: > > Dear Friends, > > Greetings, > > I have Windows 10 Pro with 3 GB Ram & 64 Bit OS x64 Processor Desktop. >

$$Excel-Macros$$ Microsoft Office 2013 OR 2016

2017-11-04 Thread Pravin Gunjal
Hi Everyone I would like to know whether any of these Microsoft Office 2013 OR 2016 are available for free download with nay product key to activate. If so, kindly share the links to download. Thanks, Pravin Gunjal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Delete some rows from Excel as per condition

2017-12-07 Thread Pravin Gunjal
. Please help. *With regards,* *Pravin Gunjal* On Tue, Dec 5, 2017 at 5:51 PM, Paul Schreiner <schreiner_p...@att.net> wrote: > Sure, > the "trick" is that you have to start at the last row and work your way > "up". > > because otherwise, when

$$Excel-Macros$$ Numbers to Words by Formula or Macro

2017-12-11 Thread Pravin Gunjal
Dear Experts Kindly help me by sharing a formula or Macro to convert numbers to words in attached file. It is required up to the last number mentioned in excel file. (Some higher numbers are not displayed by excel in number format) *With regards,* *Pravin Gunjal* -- Are you =EXP(E:RT

$$Excel-Macros$$ Windows 10 Updates - reg.

2018-03-13 Thread Pravin Gunjal
in between) 2) Slow opening of MS Office (Word, *Excel*, Outlook etc.) I would be very happy if you could help me to sort out these issues. Thank you, *With regards,**Pravin Gunjal* -- 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$$ Update Formula to Value by VBA

2018-12-11 Thread Pravin Gunjal
where there is no date, but have formula) Can anyone help me on this please.. Regards, Pravin Gunjal -- 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: Forum rules : Please adhere else you will be BANNED

2018-12-05 Thread Pravin Gunjal
Hello Mr.Ayush, It seems now a days many people are posting job vacancies on our group. Some action need to be taken.. Regards, On Saturday, July 23, 2011 at 5:50:06 PM UTC+5:30, Ayush Jain wrote: > > Hello everyone, > > Please adhere to below rules of the forum. You will be banned without

$$Excel-Macros$$ Re: Remove blank table or create table based on final data only

2020-09-23 Thread Pravin Gunjal
Hi Friends, Any update please. On Monday, September 21, 2020 at 3:30:16 PM UTC+5:30 Pravin Gunjal wrote: > Hi Friends, > > I have attached two excel files as follows:- > > 1) ZSRLNO File No.1 (This is system downloaded file) > 2) ZSRLNO File No.2 (This is after use of m

$$Excel-Macros$$ Macro to create a table for changeable data

2020-09-21 Thread Pravin Gunjal
rows. So I want these blank rows are to be deleted at the end. So can you help me to do it so? Or else let me know any other solution for it. Thank you! Regards, Pravin Gunjal. -- 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

<    1   2   3