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
blank 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 off
cells 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
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
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
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) or
rence. Please help.
*With regards,*
*Pravin Gunjal*
On Tue, Dec 5, 2017 at 5:51 PM, Paul Schreiner
wrote:
> Sure,
> the "trick" is that you have to start at the last row and work your way
> "up".
>
> because otherwise, when you delete a row, the "next&qu
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.
>
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 ---
Hi, Can any look in to this request please.
*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*
-- Forwarded message --
From: Pravin Gunjal
Date: Fri, Nov 24, 2017 at 10:09 AM
Subject: $$Excel-Macros$$ Microsoft Office Opens Very Slow in Windows 10
To: MS EXCEL AND
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
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
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 Gu
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, he
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 wrote:
> Hi Friends
>
> Greetings!
>
> I have attached two files viz. Sample Source & Sample Target.
> I wa
n 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
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.
*With
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,
,**Pravin Gunjal*
*Mobile: 77100 *
*97250*
On Wed, Aug 17, 2016 at 4:05 PM, Gaurav Devrani
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
> Gaurav Devrani
>
> On W
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
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
=TI
Thanks for reply. The path and file is unique. One sheet was hidden at the
time of screenshot taken on other computer.
*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*
On Wed, Jun 8, 2016 at 5:14 PM, B Sharma wrote:
> Hiii Pravin,,
> From your screen shot I think that both the
Hi Experts,
May I have any solution on this subject please.
On 30 May 2016 16:55, "Pravin Gunjal" wrote:
> Dear Friend,
>
> Greetings!
>
> I have 3-4 computers in shared network. In one of them there is an excel
> file which contains data with 184 rows and 19 colum
Thanks Abhishek..
*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*
On Fri, May 13, 2016 at 3:15 PM, Abhishek Jain
wrote:
>
> http://www.get-digital-help.com/2012/07/18/create-links-to-all-sheets-in-a-workbook/
>
> On Fri, May 13, 2016 at 3:06 PM, Pravin Gunjal wr
Thanks.
*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*
On Mon, May 9, 2016 at 8:05 PM, Paul Schreiner
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 computer and saves the file
> in .xl
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
wrote:
> http://excelribbon.tips.
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
wrote:
>
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
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, Ap
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
Perfect... Thanks!
*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*
On Mon, Apr 25, 2016 at 1:17 PM, Abhishek Jain
wrote:
> Try this:
>
>1. Right-click a cell in the pivot table
>2. Click on PivotTable options
>3. Click on the Data tab
>4. In the Re
Not relevant..
*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*
On Mon, Apr 25, 2016 at 12:41 PM, Satendra kumar
wrote:
> Hi,
>
> you can check name spelling or space.
>
> thanks
> satendra
>
> On Mon, Apr 25, 2016 at 12:32 PM, Pravin Gunjal wrote:
>
&g
;).Value
> RecID = RecID & "_" & Sheets("Sheet1").Cells(NumRow, "C").Value
>
> If (Dict_Data.exists(RecID)) Then
> Sheets("Sheet1").Cells(NumRow, "E").Value =
> Dict_Data.Item(RecID)
>
Hi,
Greetings!
I want the data in *column E (Sr.No.)* of sheet1 from sheet2, if column B,
C & D are matches in both sheets. PFA file.
Look forward for good formula. Thanks,
Regards,
*Pravin Gunjal*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TI
computers & access, but other can't access mine
though it is shared. Kindly help. Thanks,
Following is the screenshot:
*With regards,*
*Pravin Gunjal*
*Mobile: 77100 *
*97250*
--
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
Hi
I have some macro in file and suppose i want to remove them after 4 days.
So is there any such macro available which can work on my requirements.
Thanks
Pravin Gunjal.
On Dec 24, 2015 5:53 PM, "jayaraj metta" wrote:
> "Existing macro on certain Date"
>
> Can yo
nts
> vbcom.remove Vbcomponent:=_
> vbcom.item("Module1")
> End sub
>
> If you find any difficulties please let me know
> On Dec 23, 2015 7:45 PM, "Pravin Gunjal" wrote:
>
>> Hi Expert,
>>
>> Can i get a macro which can remove all existing macros from
Yes exactly. On specific date.
On Dec 24, 2015 3:53 PM, "jayaraj metta" wrote:
> Hello Pravin Gunjal,
> Do you want to delete modules in a project using a macro?
> Can you please elaborate it ?
> On Dec 23, 2015 7:45 PM, "Pravin Gunjal" wrote:
>
>> Hi
Hi any update on this plz.
On Dec 23, 2015 7:45 PM, "Pravin Gunjal" wrote:
> Hi Expert,
>
> Can i get a macro which can remove all existing macros from a file on
> certain date..
>
> Kindly share the same. Thanks.
>
> Regards
> Pravin Gunjal
>
> --
Hi Expert,
Can i get a macro which can remove all existing macros from a file on certain
date..
Kindly share the same. 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) ! Join official Facebook page of this
Hi Friend
could you plz helm me out on the issue.
Thanks in advance.
Regards
Pravin Gunjal
-- Forwarded message --
From: "Pravin Gunjal"
Date: Oct 26, 2015 4:02 PM
Subject: VBA to pick up current date in last column
To: "Excel Macros" , "Mandeep Baluja
one manual entry in row no. 7.
Could you please help me out to fulfil the requirement.
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/discussex
Hi
Greetings!
Getting an attached error while opening files of VBA.
Kindly help me to resolve the same.
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
Hi Friend
pl help me out to replace a macro in all sheets of the same file. Or any
other solution may welcome.
Thanks
Pravin Gunjal
On Oct 22, 2015 1:09 PM, "Pravin Gunjal" wrote:
> Can anyone help me on this issue plz.
> On Oct 21, 2015 3:26 PM, "Pravin Gunjal" wrote:
Can anyone help me on this issue plz.
On Oct 21, 2015 3:26 PM, "Pravin Gunjal" wrote:
> Hi Mandeep
>
> The code you have replaced in this mail has to be replaced in other
> sheets also of the same file.. file is attached for your immediate
> reference.
>
> Pl
Dear Mandeep
Thank you so much.. it works fantastic.
Can you tell me one more thing, how to modify the vba code in all sheets...
Regards,
Pravin Gunjal.
On Oct 20, 2015 2:47 PM, "Mandeep Baluja" wrote:
> check this out !!
>
>
>
>
> Private Sub Worksheet_Change
Hi,
Greetings,
I have used a simple macro in an attached file
But while pasting or deleting the data in multiple cells, getting following
error:
Run-time error '13':
Type mismatch
Kindly help me out on this. Thank you,
Regards
Pravin Gunjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)
Hi,
Greetings,
I have used a simple macro in an attached file
But while pasting or deleting the data in multiple cells, getting following
error:
Run-time error '13':
Type mismatch
Kindly help me out on this. Thank you,
Regards
Pravin Gunjal
--
Are you =EXP(E:RT) or =NOT(EXP
Sep 19, 2015 at 3:04 PM, Pravin Gunjal wrote:
>
>> Hi, Can anyone help me on this subject?
>>
>> On Saturday, September 19, 2015 at 1:45:12 PM UTC+5:30, Pravin Gunjal
>> wrote:
>>>
>>> Hi,
>>>
>>> I am getting an above mentioned error
Hi, Can anyone help me on this subject?
On Saturday, September 19, 2015 at 1:45:12 PM UTC+5:30, Pravin Gunjal wrote:
>
> Hi,
>
> I am getting an above mentioned error message while running any macro on
> my computer, while the same macro could run in other computer.
>
> Cou
Hi,
I am getting an above mentioned error message while running any macro on my
computer, while the same macro could run in other computer.
Could you please help me out on this. Thanks,
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Hi Vabs
Thank you much. It works good as required.
Pravin.
On Tue, Mar 17, 2015 at 1:51 PM, Vaibhav Joshi wrote:
> Check this...
>
>
> Cheers!!
>
> On Tue, Mar 17, 2015 at 11:35 AM, Pravin Gunjal wrote:
>
>> Hi,
>>
>> I have an excel format 2007 for
Hello,
Can anyone help me to modify & save DBF files in Excel 2007.
Pravin.
On Saturday, March 14, 2015 at 1:01:39 PM UTC+5:30, Pravin Gunjal wrote:
>
> Hi,
>
> I tried working on it but could not do the same.
>
> Could you please explain me how to do it or is there any
for which I i would like to give next C serial then I would
type C in cell D8 and then then next number 1327 must come in E8
automatically.
Hope you understand the requirement. Please do the need.
Thank you,
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
Hi,
I tried working on it but could not do the same.
Could you please explain me how to do it or is there any other solution for
this. Please do share.
Thank you
Regards
Pravin Gunjal
On Tuesday, February 3, 2015 at 9:45:31 PM UTC+5:30, Paul Schreiner wrote:
>
> That usually is a p
Hi Vabs
Any updates on this please.
Regards
Pravin Gunjal
On Wednesday, February 11, 2015 at 5:00:32 PM UTC+5:30, Pravin Gunjal wrote:
>
> Hi Vabs
>
> Following is the code:
>
> Function savedbf() As Boolean
> Dim filename As Variant
> Dim temp As Variant
>
he good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can." - John Wesley*
> -
>
>*From:* Pravin Gunjal
> *To:* exc
*Hello Friends,*
*I need to have a file which may record the Login & Logout time of
computer. I am using Windows XP.*
*Thanks in anticipation.*
*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 offi
Thank you so much.
This is what I was looking for...
On Tue, Feb 17, 2015 at 10:31 AM, Mandeep Baluja
wrote:
> check this worksheet event.
>
> regards,
> Mandeep
> On Monday, February 16, 2015 at 7:49:23 PM UTC+5:30, Pravin Gunjal wrote:
>>
>> Hi Mr Paul
>>
--
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
t As Boolean
hasDecimal = False
On Error Resume Next
For Each c In r.Cells
If c.row > 1 Then
t = val(c.Text) <> Int(val(c.Text))
If Err.Number = 0 And t Then
hasDecimal = True
Exit For
End If
E
Hi,
The user name to be picked up by formula in the column *L* once the value
is entered in column *K*
I have entered few names manually. Please help.
*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
.
Thanks,
Pravin Gunjal.
On Tuesday, February 3, 2015 at 9:45:31 PM UTC+5:30, Paul Schreiner wrote:
>
> That usually is a problem with "References".
>
> try these steps:
>
> Stop execution of macro
> in VB Editor, select Tools-> References...
>
> you'
[image: Inline image 1]
Hi,
Suddenly I am getting the above error while opening the excel file and
macro is not running.
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
Hi,
Please help me out on the above subject.
Thank you
Pravin.
--
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
Thanks.
On Thu, Jan 22, 2015 at 5:00 PM, Ashish Kumar
wrote:
> Hi,
>
> Hardly it's take 3 second for showing Batch Details.
>
> Did you checked the count of Batch Data which was in the user form. The
> Count is more than 5000. It's heavy..!!
>
>
>
> Yes We have two more Alternate Options for it
Hi Good Evening
I am working with foxpro and unable to save DBF files in excel 2007 while
saving it's asking to save in current formats of excels.
Can you tell me is there anyway to overcome from this issue / any solution
because I do not have 2003 version and having only 2007.
Thanks,
P
Hi
I am working with it and observed that while opening the window for batches
it's taking much time. Can we do something for it.
On Tue, Jan 20, 2015 at 7:28 PM, Ashish Kumar
wrote:
> Thanks. Pravin ...!!
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIM
Good Morning,
It's fantastic...
On Mon, Jan 19, 2015 at 9:13 PM, Ashish Kumar
wrote:
> Dear Pravin jee
>
> PFA
>
>
>
> Regards
> Ashish
>
> --
> 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:
Dear Ashish jee
Its fine and working good as per requirement. Thank you.
But it would be much better, if any pop-up will appear here in Batch column
to select the batches out of many. In pop-up if we type any starting
letter then only those batches should appear which contains that typed
letter
don
On Sat, Jan 17, 2015 at 5:55 PM, Ashish Kumar
wrote:
> Share the password ...?
>
> --
> 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)
It's *Lot Number (column D)*
On Sat, Jan 17, 2015 at 5:28 PM, Ashish Kumar
wrote:
> which field you want to pick as batch in GGRN sheet from Batch sheet.
>
> --
> 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 th
*Hi, Can I expect a reply from anyone..*
On Friday, January 16, 2015 at 4:13:20 PM UTC+5:30, Pravin Gunjal wrote:
>
> Hi,
>
> I have attached an excel file contains 4 sheets..
>
> I am entering mu data in fourth sheet viz. GRRN Entry -which has connected
> with first thre
4:A21"), Range("D4:D21"),
> Range("G4:G21"), Range("J4:J21"), Range("M4:M15"))
>
> ᐧ
>
> On Wed, Jan 14, 2015 at 5:44 PM, Pravin Gunjal wrote:
>
>> Hi Vabs
>>
>> Set rng = Application.InputBox("Select cell/rang
rds
Pravin Gunjal
On Wed, Jan 14, 2015 at 1:39 PM, Vaibhav Joshi wrote:
> Pravin,
>
> Chek this...Logic for fetching data remains same..
>
> Also i have added one more functionality, just doubl click on chq. count
> to see it..
>
> Cheers!!
> ᐧ
>
> On Wed, Jan
blank against "Cheque No." those no. of entries I erquired in Main Sheet
under "CHQ" filed before Ambika Agencies. So the No. will come as 1 in main
sheet in cell : "C5".*
*I hope it is possible. Kindly help me out on this subject. It can be
very very helpful for
Thank you everyone.
On Fri, Nov 14, 2014 at 5:42 PM, Ashish Kumar
wrote:
> Hi Pravin,
>
> PFA!!
>
>
> Edit your data in Pending CN and Highlight the row which you want to paste
> in Party Wise and hit the macro.
>
>
>
> Regards
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E
*Hi Paul :* If I add this code in my code it creates new sheet and deletes
immediately. Pl look in to this.
*Hi Ashish :* Your file is creating new sheet every time but I want the
same sheet to be overwritten with changes.
Thank you,
On Thu, Nov 13, 2014 at 7:46 PM, Ashish Kumar
wrote:
> Hi P
in to this and arrange a solution to overwrite the data second time in
the same sheet: "Party Wise" Hope the matter is clear. Thank you in
anticipation.Sub Paryt_Wise()'' Paryt_Wise Macro' Pravin Gunjal''
Sheets("Pending CN").SelectSheets(&q
with any of the background colors.
Kindly do the needful. 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/discussexcel
FORUM RUL
Any idea on this !!
-- Forwarded message --
From: Pravin Gunjal
Date: Thu, Jul 3, 2014 at 11:03 AM
Subject: Drop Down Option - reg.
To: excel-macros@googlegroups.com
Hello,
I have three sheets in the attached file.
I have created a name manager in master sheet for "
the system
must display only those divisions parties which comes under "Veritaz" &
"Both"
Likewise if I select the drop down in "Hospin" sheet, then the party list
should come which comes under of "Hospin" & "Both" division.
Thank you,
attached test file for the same.
Thank you in anticipation.
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 RULES
1) Use co
Hello,
I would like to email the attached data once for all in a single click from
column A to H to the respective customers as per email id mentioned in
column I.
Kindly help me on this matter. Pl find attached test file for the same.
Thank you in anticipation.
Regards
Pravin Gunjal
This is working perfectly as per my requirement.
Thanks.
Regards
Pravin Gunjal.
On Sun, Jun 15, 2014 at 10:54 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA
MACROS wrote:
> Hi Pravin ...
>
> You can go to Format cell and custom the format of the date which ever
> result you
dd.mm.
>
> If by doing so if date format does not change then select single column
> then press Data tab in Menu then press Next 2 times then select Date (DMY)
> and press finish button.
>
> Cheers!!
>
>
> On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal wrote:
>
&
Dear Pramod,
Thank you for your reply. But I found it is not giving result for all
cells.
Please do the needful.
On Thu, Jun 12, 2014 at 4:22 PM, Pramod Singh wrote:
> Hi
> Pravin Gunjal,
>
> PFA
>
> Hope This will fine for you..
>
>
>
>
> Warm Reg
Hi,
I wanted to convert the dates in this format *DD.MM.*
Now it is not in system's date format ( MM/DD/ ) and it is displayed as
DD/MM/ or as D/M/.
Kindly help.
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=T
Hello, Do I get any updates on this?
-- Forwarded message --
From: Pravin Gunjal
Date: Fri, Jun 6, 2014 at 6:01 PM
Subject: Date wise amount & Invoice Nos. wanted to merge
To: excel-macros@googlegroups.com
Dear Friends
Good Evening,
I have attached a working file and
Date*
*Amount*
*Inv No*
*Party Name*
17.06.2014
59,245.00
1579001280/1579001281/1579001307/1579001316
Annapurna Distributo - Latur
Please help.
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 Faceboo
Hello,
I have attached an excel file. The data is already entered in this file.
The "Qty" column must be multiple of "Pack" column. If it is correct then
it should display: "Correct" otherwise "Incorrect" in "Result" column.
Hope you would he
"Result" column.
Hope you would help me. 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/discussexcel
FORUM RULES
1) Use co
Dear Vabz
It can be moved by a button.
On Tuesday, May 13, 2014 12:35:15 PM UTC+5:30, Vabz wrote:
>
> what is trigger for moving?
>
>
> On Tue, May 13, 2014 at 12:22 PM, Pravin Gunjal
> > wrote:
>
>> Dear Friends,
>>
>> I would like to update the da
Thanks Ravinder
Also would like to do it *BOLD*. Pl help.
On Thu, May 8, 2014 at 4:32 PM, Ravinder wrote:
> Pfa for your solution
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Pravin Gunjal
> *Sent:* Thursday,
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 RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Hel
Greetings!
I am having a data containing a word called "ACTIV". And would like to
highlight only this word out of the cell with a *specific color (BLUE) *and
*BOLD*
(only this word and not other words in the same cell)
Could you please help me on this issue.
Regards
Pra
Hello,
Is there any new updates on this subject? As periodically it's changing.
Please suggest a good company and let me know what are all the accessories
and other facilities should I check before buy.
Look forward to hear from all experts.
Thank you,
Regards
Pravin G
This also can be used: =COUNTA(D2:D15)
Regards
Pravin Gunjal.
On Sat, Nov 2, 2013 at 7:46 PM, Robert Barnes wrote:
> You are a GENIUS!!!
>
>
> On Fri, Nov 1, 2013 at 6:41 PM, Sam Mathai Chacko wrote:
>
>> Are you looking for this?
>>
>> =COUNTIF($D$2:$D$15,
*May crores of lamps lighten up your life,*
* With endless happiness, richness,*
*Health & wealth forever,
Wishing you and your family a very **Happy Diwali.***
* *
*[image: image005.jpg]*
* *
*With regards,**
**Pravin Gunjal**
***
*Veritaz Healthcare Ltd, Hyderabad*
*
*
*Con
gt; =INDIRECT(E$2&"!BT5")
>>
>> .........
>>
>> Enjoy
>> Team XLS
>>
>>
>>
>> On Fri, Oct 18, 2013 at 10:59 AM, Pravin Gunjal wrote:
>>
>>> *Hi,*
>>>
>>> * *
>>>
>>>
1 - 100 of 237 matches
Mail list logo
