Hi Abhishek
Thanks a lot, this is the exactly whatI wanted...
Thanks a lot once again.
On Thu, May 26, 2016 at 6:35 PM, Abhishek Jain
wrote:
> Plz see attached
>
> On Thu, May 26, 2016 at 5:26 PM, Vaibhav Joshi
> wrote:
>
>> Dear Experts
>>
>> I want to calcu
s-3
Months-6 & 0 days )
Specimen file is enclosed for your reference.
Regards
Vaibhav Joshi
--
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
put this formula in I2 & drag down:
=IF(COUNTIF($B$2:B2,B2)=1,RANDBETWEEN(420,480)/1440,RANDBETWEEN(I1*1440+TIME(0,31,0)*1440,I1*1440+TIME(0,55,0)*1440)/1440)
Cheers!!
On Wed, Nov 25, 2015 at 1:44 AM, Bill Q wrote:
>
>
> I gave this my best shot - but I am not satisfied with it.
>
> PSA.
>
> *
was macro was enabled on your system?
On Tue, May 5, 2015 at 1:14 AM, mburkett wrote:
> One more oddity. I opened the file on another computer on our network and
> it worked perfectly. Both have the same rights so there must be some
> setting within Excel? Ideas?
>
>
> On Monday, May 4, 2015 at
Change 1st line to..
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cheers!!
On Mon, May 4, 2015 at 10:32 PM, mburkett wrote:
> I have some very simple code that I put in the workbook's BeforeSave
> event. When I click save the code doesn't run. Any ideas? I've never used
> these private
when you do filter, in criterion put is equal to...
also when you do search thru Control plus f ( ctr + f) click on options &
tick on match entire cell content ..
On Sat, May 2, 2015 at 12:52 PM, Zafar Iqbal wrote:
> Dear Experts,
>
> I am trying to use (SEARCH and Vlookup) formula to filter ou
Author need formula & i guess this is already answered for similar
question..
On Sun, May 3, 2015 at 7:37 PM, Rajesh Agarwal wrote:
> please provide me the formula.
>
> --
> *Rajesh Kumar Agarwal*
> *9811063001*
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>
you dont need access, you can continue using excel & thru DAO you can
retrieve data from closed workbook too..
On Wed, Apr 29, 2015 at 10:35 AM, Nasir Saikh wrote:
> r8 Pramod access is very easy and taking very less time than excel on huge
> data you can use it till 2 GB data.
>
> On Tuesday, A
Which version of excel you are using?
Are both file on same machine or they are on Network?
On Tue, Apr 28, 2015 at 11:34 AM, Mandeep Baluja
wrote:
> My mmaster file is large and i just want to do lookup on my sheet from
> master file without opening my master file as it is of huge mb around 25
hi
What do you mean by "when sometime no record of LF found then other data
past on state sheet with error"??
You mean no additional data found ?
On Fri, Apr 24, 2015 at 7:35 PM, Sunil Kumar Yadav
wrote:
> Dear Team,
>
> i have read this type query on many sites but not understand properly,
>
Check this..
http://www.ozgrid.com/forum/showthread.php?t=66164
On Thu, Apr 16, 2015 at 5:43 PM, Nasir Saikh wrote:
> Hi Guys,
>
> Please help i am stuck on a code that if nodbody is using excel then the
> current workbook should close in 10 second with popup of
> 10,9,8,7,6,5,,4,3,2,1.
> I hav
Check this...
Add two helper column & see formula in Green, i have tested for both of
sample data given by you & its working..
Cheers!!
On Tue, Apr 14, 2015 at 5:39 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hello Mandeep,
>
> Formula does not work when Column B is General Fie
Hi Janaki
welcome to Excel Macros..
If you have any query start separate thread..
Cheers!!
On Sat, Apr 11, 2015 at 4:46 PM, Janaki Dalvi
wrote:
> Thanks Ayush for giving us this forum, Have been through some of the posts
> and it has been a lot of help thus far. To introduce myself, I am Jana
ain, this is now completed.
>
> Bob Engler
>
> --
> *From:* Vaibhav Joshi
> *To:* "excel-macros@googlegroups.com"
> *Sent:* Wednesday, April 1, 2015 3:20 AM
>
> *Subject:* Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end
> of row of
check this...
On Wed, Apr 1, 2015 at 8:45 PM, Prabhu Pinky wrote:
> Experts,
>
> Any update on my below query..
> On 31-Mar-2015 5:45 PM, "Prabhu Pinky" wrote:
>
>> Hi experts,
>>
>> Please share vba code to copy outlook mails subject name, sender name,
>> Date into excel sheet.
>>
>> Code has
check sheet after updating formula...
On Wed, Apr 1, 2015 at 12:49 PM, Vaibhav Joshi wrote:
> HI
>
> Note cell range & dollar sign, it is $B$1:$B1<>$B$2:$B2
>
>
>
> On Tue, Mar 31, 2015 at 10:42 PM, bobengler
> wrote:
>
>> Here is a test of after I a
HI
Note cell range & dollar sign, it is $B$1:$B1<>$B$2:$B2
On Tue, Mar 31, 2015 at 10:42 PM, bobengler wrote:
> Here is a test of after I added the 2 rules. Can you see if I missed a
> step?
>
> Thanks,
>
> Bob
>
>
> ------
>
character which you see may not be the same which you type, press F2 & copy
characters & then you can do Find replace copied character with unique
character like underscore or so & after that goto data text to column..
On Tue, Mar 31, 2015 at 12:22 AM, Bill Q wrote:
> Thanks, but I must be doing
Check this...
On Tue, Mar 31, 2015 at 12:43 PM, Dhaval Shah
wrote:
> PFA
>
> Warm Regards,
>
> Dhaval Shah
> M) 98240 35253
> *E-mail : todhavals...@gmail.com *
>
>
> --
> 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 pa
Hi Bob,
Check attachment,
Copy formula from G2 & Select A2 to D12 ( or larger range) & goto
conditional formatting, select manage rules & select new rule, after that
select use formula to determine which cells to format..paste formula, click
format & select color you want to give...
After that C
his
> manually but the Excel they just sent me has over 1,000 rows and most of
> the field 2s are non repeating.
>
> Thank you,
>
> Bob Engler
>
>
>
> --
> *From:* Vaibhav Joshi
> *To:* excel-macros@googlegroups.com
> *Sent:* Tues
Check this for help..
http://www.vbaexpress.com/kb/getarticle.php?kb_id=427
On Sun, Mar 22, 2015 at 4:33 PM, Don Bowyer wrote:
> In Excel 2003 on Windows 7 I have created a custom toolbar using VBA.
>
> The toolbar has about 7 buttons each of which activates a separate macro.
>
> This is the
Hi
There are many ways to do it, few are:
http://excel.tips.net/T003005_Condensing_Multiple_Worksheets_Into_One.html
http://support.microsoft.com/en-us/kb/214270
http://www.bighungrygeek.com/merge-worksheets-in-excel/
http://www.rondebruin.nl/win/addins/rdbmerge.htm
Cheers!!
On Mon, Mar 30
hi
without any application in front coding can not be set for 3rd party app..
On Fri, Mar 27, 2015 at 2:17 AM, Avinash wrote:
> Hi Experts,
>
> i want a macro which can copy data from another application to excel.
>
> below is the code which i am trying to use. i dont have any workbook to
> ex
Hi
This is pertaining to Group "Important Jobs & Walkin Updates", i haven't
recd any such emails from Excel VBA Group..
On Mon, Mar 30, 2015 at 1:09 PM, Prabhu Pinky
wrote:
> Why this kind of mails in this group???
> On 30-Mar-2015 1:00 PM, "Sajini" wrote:
>
>> * Do you want to marry? View S
Your first rule works fine, you can add 2nd rule via conditional formatting
mange rule..
check this file i have added rule for your reference.
Cheers!!
On Fri, Mar 27, 2015 at 8:34 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA
MACROS wrote:
> Dear Team,
>
> i need to check my updates are correct ag
Hi
You can use simple vlookup formula, but you need to reverse the table,
check attachment & formula is in col G.
Cheers!!
On Fri, Mar 27, 2015 at 11:41 AM, Rajesh thrissur <
rajeshkainikk...@gmail.com> wrote:
> Hi Experts
> please check the attached table , there i have to select a value from
try this...
On Fri, Mar 27, 2015 at 12:55 PM, Mandeep Baluja
wrote:
> put this formula in h2 it will give you large from alternate columns
>
> =LARGE(IF(MOD(COLUMN(A2:G2),2)<>0,A2:G2),2)
>
> Press control+ shift +enter to create array formula.
>
> Regards,
> Mandeep
>
>
>
>
> On Friday, March
Try this for finding 2nd largest value, this works even if you have zeros &
duplicate nos in range, its array formula...
=MAX(IF(A1:A10<>MAX(A1:A10),A1:A10))
Cheers!!
On Fri, Mar 27, 2015 at 12:34 PM, Pramod Singh wrote:
> Hi All.
>
> Good question came from amit.
>
> Excel expert. Can anyone
Check this for an alternate way...
If you wan all code to remained in Sheet module then you can take only
Public variable in separate Module.
Cheers!!
On Wed, Mar 25, 2015 at 4:48 PM, Vaibhav Joshi wrote:
> Hi
>
> your method is correct, only error you did is u showed it in worksheet
Hi
can you share website link?
On Sat, Mar 21, 2015 at 10:48 PM, ldenholl wrote:
> Hi all,
>
> I'm an intermediate Excel/Access user and have an inquiry for you all.
>
> You know how when you buy tickets for a big event online and you can
> select which seats you want in the process of buying?
ow code to avoid error on path not written in cell. but though
> same error is occur, pls do something in coding.
>
> If ws.Range("F2") <> Chr(48) Then
> .addattachment rngAttach1.Value
> End If
>
>
> On Mon, Mar 23, 2015 at 6:30 PM, Va
Hi
your method is correct, only error you did is u showed it in worksheet
module (which is pvt module by default), you need to create separate module
and add code in to it..
See attachment.
Cheers!!
On Wed, Mar 25, 2015 at 4:19 PM, Rohit Jadhav wrote:
> Thanks a lot. It definitely solves my p
Try this:
Option Explicit
Dim myarray(1) As Variant
Sub PublicArrayExample()
'Dim myarray(2) As String
'Fill the array MyArray with values.
myarray(0) = "Hello"
myarray(1) = "Goodbye"
'Run the TestPublicArrayExample macro to display MyArray.
Call TestPublicArrayExample
End Sub
Sub TestPublicArr
0e_digest_top>
>> Query in code of email send with attachment from excel
>> <http://groups.google.com/group/excel-macros/t/35938998bb63993e?utm_source=digest&utm_medium=email>
>> Ashish Bhalara : Mar 23 05:00PM +0530
>>
>> Dear experts,
>>
>>
check formula in col E, If there are more than 2 case of overlap then 1st
will be shown as ok & second will be as error.
In case it is more than 2 case of overlap then 1st will be shown as ok &
rest all will be shown as error..
Cheers!!
On Wed, Mar 25, 2015 at 2:01 PM, Vaibhav Josh
can you explain one example..
On Wed, Mar 25, 2015 at 1:45 PM, Sunil Kumar Yadav
wrote:
> Hello,
>
> Please solve this query!!!
>
> --
> Thanks & Regards
> *Sunil Kumar Yadav*
> * Sr. Executive - *MIS (Billing Deptt.)
> Skype ID: sunil.yadav7186
>
> On Tue, Mar 24, 2015 at 5:27 PM, Sunil Kumar Y
Ayush Jain is Group Manager you can contact him.
On Tue, Mar 24, 2015, 9:24 PM Prabhu Pinky wrote:
> Hi, anyone please let me know who is the admin for this group.
>
> Thanks & Regards,
> Prabhu R
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,
Before adding att check if attachment exists or not, if its null then you
will get error...
Cheers!!
On Mon, Mar 23, 2015 at 5:00 PM, Ashish Bhalara
wrote:
> Dear experts,
>
> See the attached file of email sending from excel. Normally mail send
> successfully to all together from database. I n
Great Cheers!!
On Thu, Mar 19, 2015, 7:34 PM Stephen E. Hale
wrote:
> Thank you so much Vabz, that is just what i was looking for. I really
> appreciate you help.
>
> On Thursday, March 19, 2015 at 1:30:02 AM UTC-7, Vabz wrote:
>
>> Try This:
>>
>> Sub CopyRename()
>> Dim sName As String
>>
Try This:
Sub CopyRename()
Dim sName As String
Dim wks As Worksheet
'Worksheets("Master").Copy after:=Sheets(Worksheets.Count)
ActiveSheet.Copy after:=Sheets(Worksheets.Count)
Set wks = ActiveSheet
sName = Application.InputBox _
(Prompt:="Enter new worksheet name"
Check this..
Cheers!!
On Thu, Mar 12, 2015 at 1:43 PM, Mandeep baluja
wrote:
> Quuery for autofit
>
> --
> 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
>
> F
Check this...
Cheers!!
On Tue, Mar 17, 2015 at 11:35 AM, Pravin Gunjal wrote:
> Hi,
>
> I have an excel format 2007 for daily data entry, as attached.
>
> I used to select Party Names through drop down list in column F and need
> to type the invoice numbers in cloumn E based on the letter in c
Try this macro:
https://sites.google.com/site/thexlwiz/files/SaveDBF.zip?attredirects=0
On Tue, Mar 17, 2015 at 12:22 PM, Pravin Gunjal wrote:
> 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 G
Hi
Check col D for solution..
Cheers!!
On Sun, Mar 15, 2015 at 10:23 AM, rameshwari shyam <
rameshwarish...@gmail.com> wrote:
> Dear Team,
>
> Can any one help on this.
>
> Thanks,
> Rameshwari
> -- Forwarded message --
> From: rameshwari shyam
> Date: Fri, Mar 13, 2015 at 10:0
Cheers!!
On Mon, Mar 16, 2015 at 4:53 PM, Vijayendra Rao
wrote:
> Dear Vaibhav,
>
> Thank you very much for your quick support. This is very helpful.
>
> Regards,
> Vijayendra
>
> 2015-03-13 20:27 GMT+05:30 Vaibhav Joshi :
>
>> PFA with #N/A handler...
>
Hi Mandeep,
Logic used in macro is rilli cool...
Cheers!!
On Mon, Mar 16, 2015 at 1:46 PM, Mandeep baluja
wrote:
> Check the *result sheet* in the attachment . for single single row this
> formula will work with helper column.
>
>
>
>
>
>
> On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will So
Hey Will
Check this attachment..in any of given columns it will check occurrence of
10 , 13 & 17 in any order...
Hope you like it,.,.
Cheers!!
On Mon, Mar 16, 2015 at 5:34 PM, Will Sob wrote:
> Gosh l like this method thanks a lot. This is the best l have seen most
> appreciated
>
> On Mon,
You can also try this non array formula..
=INDEX(C4:I4,MATCH(TRUE,INDEX((C4:I4<>0),0),0))
Cheers!!
On Fri, Mar 13, 2015 at 8:49 PM, André D'Avila
wrote:
> Thank you very much
>
> André Luiz D´Avila
>
> 2015-03-13 12:13 GMT-03:00 Vaibhav Joshi :
>
> Check
Check formula in col k..
Cheers!!
On Fri, Mar 13, 2015 at 8:04 PM, André D'Avila
wrote:
> Dear experts,
>
> I can't figure out how to create a fórmula to this problem.
>
> In the first hand seems simples, but i couldn't sove without creating a
> excel macro.
>
> Is it possible to create a fórmu
PFA with #N/A handler...
On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao
wrote:
> Dear Experts,
>
> Can you please help me to put vlookup or any other formula for the the
> second row. Attached is the my file and request you to help on the same.
>
> Regards,
> Vijayendra
> 94491 67631
>
> --
> A
CHeers!!
On Fri, Mar 13, 2015 at 3:10 PM, Ashish Bhalara
wrote:
> Thank you Mr.Vaibhav:)
>
> Regards.
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>
> On Fri, Mar 13,
check this..
Cheers!!
On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao
wrote:
> Dear Experts,
>
> Can you please help me to put vlookup or any other formula for the the
> second row. Attached is the my file and request you to help on the same.
>
> Regards,
> Vijayendra
> 94491 67631
>
> --
> Ar
Hi
Check cell D20 for formula..
On Fri, Mar 13, 2015 at 12:43 PM, Vaibhav Joshi wrote:
> Hi
>
> Use this array formula =SUM(IF(A3:A17<>A2:A16,D2:D16,0))
>
> Cheers!!
>
> On Thu, Mar 12, 2015 at 3:34 PM, Ashish Bhalara > wrote:
>
>> Dear experts,
>>
Hi
Use this array formula =SUM(IF(A3:A17<>A2:A16,D2:D16,0))
Cheers!!
On Thu, Mar 12, 2015 at 3:34 PM, Ashish Bhalara
wrote:
> Dear experts,
>
> I need function to sum only closing value of particular date, pls see
> attached file for example.
>
> Regards.
> Ashish Bhalara
> 9624111822
> P*Plea
Suppose you have value in cell A1 then type follo. formula in A2 & dont
press enter & press F9, you will get result in curly bracket, after = sign
enter CONCATENATE( & press enter to get result
=TRANSPOSE(IF(EXACT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),
I did not found any method, however you can use Macro to achieve the same..
On Tue, Mar 3, 2015 at 10:21 PM, Bill Q wrote:
> Anyone ?
>
>
> On Wednesday, 25 February 2015 11:41:47 UTC-5, Bill Q wrote:
>>
>> Hi,
>>
>> I can do this as an object - but quite frankly it is more hassle than
>> what i
Use Data==> Filter to get non zero values...
On Wed, Mar 11, 2015 at 1:34 PM, Harish P Y wrote:
> Hi,
>
> Needed help with the file attached file.I want to get the data of only the
> non zero elements from abstract sheet to abstract 2 sheet.
> kindly help me in this regard. tried pivot table but
Thanks.
>
> Regards.
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>
> On Mon, Mar 9, 2015 at 12:59 PM, Vaibhav Joshi wrote:
>
>> Hi
>>
>> The script which
Also this link is also working...
http://www.excelforum.com/excel-programming-vba-macros/335820-listview-and-colored-line.html
also check attachment..
On Tue, Mar 10, 2015 at 5:13 PM, Vaibhav Joshi wrote:
> check this http://vbnet.mvps.org/index.html?code/comctl/lvledger.htm
>
> On M
need to colorize with vbblue, the background of cell Item 3 of column
>> DUE, not the color font of cell (i know the way to do it).
>>
>>
>> 2015-03-09 12:27 GMT+01:00 Vaibhav Joshi :
>>
>>> Hi
>>>
>>> can you share sample data with user
ug* but
>>> Il 07/mar/2015 17:09 "Sal Sal" ha scritto:
>>>
>>> Simply, colorize a cell background in Row 2 Column 5.
>>>> Naturally the cell is in un a userform listview.
>>>> Note:
>>>> Not the colorfont bug the background c
Hi
Refer this:
https://msdn.microsoft.com/en-us/library/cc793964(v=office.12).aspx
On Mon, Mar 9, 2015 at 4:36 PM, divya karkera
wrote:
> Dear Experts,
>
> I am held up with the small problem facing with my excel project.
>
> I need to update the Data from different sheets on to one of the sh
Ok, from where you are fetching Line1, Line2 etc..?
On Sun, Mar 8, 2015 at 5:10 AM, AndyB wrote:
> Hi Vabz
>
> Nope, grateful if you can help me.
>
> On Tuesday, 3 March 2015 20:32:36 UTC, AndyB wrote:
>>
>> Hi everyone,
>>
>> Hope you're well. Looking for some help with an email macro.
>>
>> S
>> Naturally the cell is in un a userform listview.
>> Note:
>> Not the colorfont bug the background color.
>>
>> Il 07/mar/2015 10:21 "Vaibhav Joshi" ha scritto:
>> >
>> > Can you explain with example through excel workbook?
>> >
&g
Use above code in conjunction with auto-filter code.
On Sun, Mar 8, 2015 at 4:22 PM, Eugene Bernard
wrote:
>
> Dear Vaibhav,
>
> When I hit the button, I am getting the below error.
>
> [image: Inline image 1]
> Regards
> Eugene
>
>
> On Sat, Mar 7, 2015
website.
> Kindly solve my query by either send using gmail or add connection of
> gmail in outlook. Thanks.
> On 07-Mar-2015 6:49 PM, "Vaibhav Joshi" wrote:
>
>> Hi
>>
>> change port no. to 465 also you need to enable smpt / imap services for
>> your G
Check this:
http://www.exceltrick.com/how_to/sum-cells-based-on-background-color/
cheers!!
On Mon, Mar 9, 2015 at 10:05 AM, wrote:
>
> --
> 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
Hi
change port no. to 465 also you need to enable smpt / imap services for
your Google account
Cheers
On Mar 7, 2015 5:48 PM, "Ashish Bhalara" wrote:
> Dear experts,
>
> I want mail from excel using gmail ID. I want to mail from data sheet by
> filtering data of mail receivers. I find the code
Its really good!!
Cheers!!
On Tue, Mar 3, 2015 at 8:02 AM, Nilkanth Raval
wrote:
> Hi Friends,
>
> Find attached some examples of VBA Macro
>
> *Thanks,*
> *Nilkanth Raval*
> *+91 900 428 0 428*
> *+91 808 000 1620*
> *Think Before You Print.Consider ENVIRONMENT.*
> *“SAVE TREES, SAVE EARTH” *
gt;
> *P* *Think green!**. Do you really need to print this email?*
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Vaibhav Joshi
> *Sent:* 2 martie 2015 12:23
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Exc
Hi
check this :
http://superuser.com/questions/635094/scheduled-and-recurring-email-in-outlook
http://www.mrexcel.com/forum/excel-questions/731321-run-outlook-visual-basic-applications-macro-specific-time-day.html
Cheers!!
On Wed, Mar 4, 2015 at 5:34 PM, sharath chandra <
sharath.c.sambr...@gma
Hi Andy
Is it solved?
On Wed, Mar 4, 2015 at 2:02 AM, AndyB wrote:
> Hi everyone,
>
> Hope you're well. Looking for some help with an email macro.
>
> So I have an excel sheet (similar copy attached).
>
> Once run, the macro should read from (the first sheet) Data - Column I to
> understand wha
Check this..
Cheers!!
On Fri, Mar 6, 2015 at 5:04 PM, Ashish Kumar
wrote:
> Hi Eugene,
>
>
> PFA, Filter your data then after hit the button
>
>
> 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 Faceboo
Do let us know if you need any help..
Cheers!!
On Sat, Mar 7, 2015 at 3:42 PM, Mukesh Gupta wrote:
> Thanks
> On 7 Mar 2015 14:46, "Vaibhav Joshi" wrote:
>
>> Hi
>>
>> check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/
>>
>> Chee
Can you explain with example through excel workbook?
On Fri, Mar 6, 2015 at 1:46 AM, Sal Sal wrote:
> I know the way to colorize a font in a vba for excel listview but to
> colorize the background of cell in a listview?
> For example the cell in row 3, column 4??
>
> --
> Are you =EXP(E
Hi
I have already shared one macro with file name "Macro import data from
multiple files - 2 one sheets" in this group.
Cheers!!
On Thu, Mar 5, 2015 at 9:59 PM, Paul Schreiner
wrote:
> Are the file names always the same? or do they change when they
> are updated?
>
> Do you open ALL the file
Hi
check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/
Cheers!!
On Fri, Mar 6, 2015 at 8:02 AM, Mukesh Gupta wrote:
> Dear Friedns,
>
> Kindly help me in creating a conditional formating calander just like
> goole calander.
>
> My basis needs are as follows:-
>
>
> 1. Start Date
Create new excel file with 3-5 sheets & do same switching which you
mentioned in your email...
If this happens then you must have save above macro in personal.xlsb file
which will be working on all workbook rather on specific workbook.
cheers!!
On Wed, Mar 4, 2015 at 1:03 PM, Yahya Muhammad wro
Try this...
Press Alt + F8 & Run macro, on prompt enter date for which you are updating
data..macro will copy data from daily data sheet to main sheet...
Cheers!!
On Mon, Mar 2, 2015 at 3:53 PM, Dhaval Shah wrote:
> ANY OTHER WAY TO USE OPTION OF PIVOT TABLE ??
>
> Warm Regards,
>
> Dhaval Sh
Hi
Goto Name Manager & select LIST & press edit there after change refers to
address ..
Cheers!!
On Mon, Mar 2, 2015 at 3:01 PM, Mihai Ghilea
wrote:
> Hi experts,
>
> I found this EXCEL book on your forum and I want to use it, but I d’ont
> now where I can change source of ListBox data.
>
> A
type ctr + ; in excel cell, format which you get is default date format...
On Fri, Feb 27, 2015 at 6:33 PM, amar takale wrote:
> I have no access to see.Pls see print shot.
>
> On Fri, Feb 27, 2015 at 6:26 PM, Vaibhav Joshi wrote:
>
>> what default date format of your machin
Both is working good ..
On Fri, Feb 27, 2015 at 11:55 AM, Mayank Mishra
wrote:
> Try
> =DATE("20"&RIGHT(A1,2),MID(A1,4,2),MID(A1,2,2))
>
> It will convert the string as date
>
> On 2/27/15, Sam Mathai Chacko wrote:
> > =--TEXT(RIGHT(A1,6),"00\/00\/00")
> > On 27 Feb 2015 11:47, wrote:
> >
> >>
>> WORKING PERFECTLY
>>>
>>> On Thu, Feb 26, 2015 at 12:01 PM, amar takale
>>> wrote:
>>>
>>>> pls look sheet where sheetl1 not change as per you saying. Pls explain
>>>> me
>>>>
>>>> On Thu, Feb 26
you saying. Pls explain me
>
> On Thu, Feb 26, 2015 at 10:58 AM, Vaibhav Joshi wrote:
>
>> Dear Amar
>>
>> Data in col b date only, you just need to change format of col B to date
>> by selecting col b & pressing ctr+shift+3
>>
>> Cheers!!
>>
hi Dhamu..
post query in separate post, this thread is for introduction only.
Cheers!!
On Sun, Feb 22, 2015 at 9:05 PM, dhamu handsome
wrote:
> hi,
>
> i need a macro to take the screenshot of the PDF Doument and paste in the
> outlook email . can u please help me regarding this issue
>
>
> On
Hey sandeep..
Good to see you man..
On Mon, Feb 16, 2015 at 10:38 AM, Sandeep Sharma <
sandeepsharma4...@gmail.com> wrote:
> Hi,
>
> Myself Sandeep Sharma from Punjab, i am working in Steel manufacturing
> company as accounts officer. I want to learn VBA macros through this group.
>
> Regards
Hi Vidhuraj..
good to see you..
On Mon, Feb 16, 2015 at 1:25 AM, vidhu raj wrote:
> Hi , How are you ?
>
> I am Vidhuraj from Kerala,
>
> I am working as an accountant at ITL World Travel Management Company In
> KSA,
>
>
>
>
> Regards,
> Vidhuraj M.
>
> On Friday, June 8, 2012 at 10:21:59 PM
e for date issue not converted in same format
> as per your trick,why? i always use text to column operation trick for same
> format.
>
> On Wed, Feb 25, 2015 at 3:46 PM, Vaibhav Joshi wrote:
>
>> Cheers Chandan & Gaurav
>>
>> On Tue, Feb 24, 2015 at 11:57 AM,
This is superb MV
Cheers!!
On Wed, Feb 25, 2015 at 7:25 PM, michael vinoth
wrote:
> Hi Sal Sal ,
>
> Please find the attached updated macro file.
>
> Regards,
> MV
>
> On Wednesday, February 25, 2015 at 1:41:10 AM UTC+5:30, Sal Sal wrote:
>
>> hummm
>> but i dont see any and paticular effec
ce...
>>
>> Thankx & Rgds,
>>
>> Chandra Singh Bisht
>>
>>
>>
>> On Mon, Feb 23, 2015 at 8:36 PM, Vaibhav Joshi wrote:
>>
>>> Convert all date in same format:
>>>
>>> While receiving data from different sources
Hi
Try this..put this code in worksheet module for which this to be work, this
will delete content of column 3, you can set to desired column:
*Private Sub Worksheet_SelectionChange(ByVal Target As
Range)Columns(3).ClearContents 'clears content of column 3End Sub*
*Cheers!!*
*O*n Tue, Feb 24
Convert all date in same format:
While receiving data from different sources many time it happens that data
received is not in same format due to various reason.
One of the tedious activity is to transforming data to same format.
I will share very good technique to convert all dates to same for
I mean free file..
On Fri, Feb 13, 2015 at 8:39 PM, Gaurav Devrani
wrote:
> Hi Vaibhav,
>
> What is FF? Can you please tell me ? Dont have any idea about that please.
>
>
> On Fri, Feb 13, 2015 at 8:04 AM, Vaibhav Joshi wrote:
>
>> Cheers, also you could have c
Cheers, also you could have created FF & save it as .doc.
On Fri, Feb 13, 2015 at 8:21 PM, Gaurav Devrani
wrote:
> Cool. :)
>
> On Fri, Feb 13, 2015 at 7:06 AM, Eugenio Grant
> wrote:
>
>> Thaks for the complete answer, it works like a charm!
>>
>> On Thu, Feb 12, 2015 at 7:18 AM, Gaurav Devr
chek this..I am not sure if it matches what you are looking for...
On Fri, Feb 13, 2015 at 6:19 PM, Ahmad Mustfa wrote:
> I want to count how many have attended the event both days in each class.
> On 13 Feb 2015 08:26, "Vaibhav Joshi" wrote:
>
>> what values do
r radio button
>>> with value for example ocgatichennai i want to select. and then submit the
>>> page.
>>>
>>> >> value="OC_GATI_CHENNAI_" type="radio" id="1">
>>> >> value="OC-DEL-SHAHDARA" type=&
<
itpabdulg...@gmail.com> wrote:
> but how ?
>
> On Fri, Feb 13, 2015 at 1:41 PM, Vaibhav Joshi wrote:
>
>> You can protect sheet/wb and disable cut/copy /paste..
>>
>> On Fri, Feb 13, 2015 at 11:50 AM, ITP Abdulgani Shaikh <
>> itpabdulg...@gmail.com&
ay, February 13, 2015 at 2:12:01 PM UTC+5:30, Vabz wrote:
>>
>> This works withe me..
>>
>> IE.document.getElementsByName("selectedCode").Item(0).Checked = True
>>
>> Cheers!!
>>
>> On Fri, Feb 13, 2015 at 1:50 PM, Vaibhav Josh
This works withe me..
IE.document.getElementsByName("selectedCode").Item(0).Checked = True
Cheers!!
On Fri, Feb 13, 2015 at 1:50 PM, Vaibhav Joshi wrote:
> can you share webpage url where you are performing this?
>
>
> On Fri, Feb 13, 2015 at 1:06 AM, Mandeep Baluja
1 - 100 of 961 matches
Mail list logo
