--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
Its working fine just correct the position of then of if
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhu Pinky
Sent: Wednesday, September 11, 2013 10:52 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ am getting compile error
Hi
Pls provide example file for more clarification.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rashid memon
Sent: Wednesday, September 11, 2013 2:19 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help Required : How i import Data in
Use below formula or attached file.may be u r looking for this..
=IF(A2=,,MONTH(A2)000SUM((MONTH($A$2:A2)=MONTH(A2))*1))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rashid memon
Sent: Wednesday, September 11, 2013 2:19 PM
To:
PLS PROVIDE LINK OF THAT WEBSITE.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Murali prasad
Sent: Tuesday, September 17, 2013 12:29 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Stock prices data fetching through VBA
im trying to
Try this code.
Sub unprotecsheet()
Dim wb As Workbook
Dim sh As Worksheet
Set wb = ThisWorkbook
For Each sh In wb.Sheets
sh.Unprotect AAABAABABBAR
Next
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhakar S H
Sent:
=SUM(IF(FREQUENCY(IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,),
),IFERROR(--SUBSTITUTE((C2=$A$2:$A$12)*($B$2:$B$12),0,),)),1))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Tuesday, September 17, 2013 6:00 PM
To:
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rejeeb Abdulrahiman
Sent: Tuesday, September 17, 2013 10:06 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Check Box In Excel
Hi Friends,
In Excel 2010, I would like to create a
am trying to get count of unique records based on multi
conditions where I know what is Condition1 but I will be not knowing what
would be condition2.
Thanks,
Chandra
On Wed, Sep 18, 2013 at 12:30 PM, Ravinder ravinderexcelgr...@gmail.com
wrote:
=SUM(IF(FREQUENCY(IFERROR(--SUBSTITUTE((C2
Image is not there, please send again with example excel file.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Waseem Saifi
Sent: Friday, September 20, 2013 2:57 PM
To: excel-macros
Subject: $$Excel-Macros$$ Auto Filter too short
In My Excel, Auto
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
PFA:-
=INDEX($H$1:$H$29, SMALL(IF(($P$4=$F$4:$F$29)*10,ROW($F$4:$F$29)),3)) FOR
3RD
=INDEX($H$1:$H$29, SMALL(IF(($P$4=$F$4:$F$29)*10,ROW($F$4:$F$29)),3)) FOR
4TH
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Muralidhar E
Sent: Saturday,
=SUM(IF(FREQUENCY(MATCH(A2:A595,A2:A595,0),MATCH(A2:A595,A2:A595,0)),1))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ashish Kumar
Sent: Monday, September 23, 2013 11:49 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Total Count of
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Monday, September 23, 2013 9:47 PM
To: excel-macros
Subject: Re: $$Excel-Macros$$ How to split Alphabetic Numeric data in
different cells
=SUMPRODUCT(1/COUNTIF(A2:A595,A2:A595))
Actually this formula first count the all values (a2:a595)in full range
(a2:a595) then divide 1 by count of all values and add those with help of
sumprduct
Just like simple eg:- if count of any value is 4 so countif formula will
calculate {4;4;4;4}
experts help ***URGENT***
Hi Experts / Ravinder / Anil,
I need a small update on that file, which you guys had updated.
I need to collect data from almost 500 + files, and the macro is doing it's
job pretty well. :)
But facing a new issue, suppose I am collecting this data from
I don’t know more about this. U can use like below;
=SQRT((x2 – x1)^2 + (y2 – y1)^2 + (z2 – z1)^2)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Debasish Sahu
Sent: Monday, September 23, 2013 6:36 PM
To: excel-macros@googlegroups.com
Subject:
Not able to access website and not getting how its working.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Menaka Balakrishnamoorthy
Sent: Tuesday, September 24, 2013 2:42 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to paste all
Try this one..for getting number and character and u can use UDF given by
Ravi for get character
From: Ravinder [mailto:ravinderexcelgr...@gmail.com]
Sent: Tuesday, September 24, 2013 10:02 AM
To: 'excel-macros@googlegroups.com'
Cc: Soum (quote.ex...@gmail.com)
Subject: RE: $$Excel-Macros
Give us more information..for this.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sandes Bagwe
Sent: Tuesday, September 24, 2013 8:56 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ I need help on one Macro creation
Hello All,
I
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of sridher sharma
Sent: Wednesday, September 25, 2013 3:58 PM
To: excel-macros
Subject: $$Excel-Macros$$ for due date
i m taken a loan from bank witch have due date 16 day after 1st date (
29/04/2013
But where u want to paste those formula means which range all sheets have
the same format..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mukesh Kumar
Sent: Thursday, September 26, 2013 3:10 PM
To: excel-macros@googlegroups.com
Subject:
Website...
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Menaka Balakrishnamoorthy
Sent: Saturday, September 28, 2013 11:34 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to take the data from the webpage table and
paste it in the
For Each cell In Selection
With cell.Characters(Start:=3, Length:=1).Font
.Color = vbRed
End With
Next
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Sunday, September 29, 2013 10:00 PM
To: excel-macros@googlegroups.com
=TODAY()+B2-A2
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Waseem Saifi
Sent: Monday, September 30, 2013 3:29 PM
To: excel-macros
Subject: $$Excel-Macros$$ Difference between time
Dear Experts,
I want to know total working time basis on in time
recipient you are hereby notified
that any disclosure, copying, distribution or taking any action in reliance
on the contents of this information is strictly prohibited and may be
unlawful.
On Thu, Oct 3, 2013 at 12:07 PM, Ravinder ravinderexcelgr...@gmail.com
wrote:
Try this udf or pfa
=MIN(IF($B$2:$B$10=C2,$A$2:$A$10))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Tuesday, October 01, 2013 7:58 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Min based on condtions
Hello,
am trying to get
Query is not clear..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: Friday, October 04, 2013 7:05 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Complicated Formula (automatic add back)
Dear Experts
Pls solution my
U want this in which event like when u change value of sheet or do some
calculation or open file or activate sheet or any specific time ?
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bill Q
Sent: Monday, October 07, 2013 2:05 AM
To:
a dynamic spreadsheet that monitors different stock prices that
is refreshed ever x amount of minutes.
On 07-10-2013 16:23, Ravinder wrote:
U want this in which event like when u change value of sheet or do some
calculation or open file or activate sheet or any specific time ?
From: excel-macros
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bill Q
Sent: Monday, October 07, 2013 2:05 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Email Trigger ?
Hi,
I am using Excel 2007 and have Gmail as my primary email account.
=IF(TODAY()$F$3,,IF(ISERROR(IF(MOD(D6,G6)=0,(D6/G6)*H6,ROUNDDOWN(D6/G6,0)
*H6)),,(IF(MOD(D6,G6)=0,(D6/G6)*H6,ROUNDDOWN(D6/G6,0)*H6
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Grkrishna Naidu
Sent: Monday, October 07, 2013 1:32 PM
To:
Use Cells(4, iPasteCol).address)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jewel Sharma
Sent: Tuesday, October 08, 2013 1:08 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Writing a string to a particular cell
Hi,
This should
I think u did not mentioned BITUMEN' in second sheet
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kannan Excel
Sent: Tuesday, October 08, 2013 1:41 PM
To: Google
Subject: $$Excel-Macros$$ INDEX MATCH DOUBT
HI,
PLS FIND THE ATTACHED FILE AND DO
, anybody help me
On Tue, Oct 8, 2013 at 2:25 PM, Ravinder ravinderexcelgr...@gmail.com
wrote:
I think u did not mentioned BITUMEN' in second sheet
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kannan Excel
Sent: Tuesday, October 08, 2013 1:41 PM
'!$A$2:$AQ$65000,MATCH($F$4,'MASTER
DATA'!$D$2:$D$65000,0),MATCH($B18$C$17,'MASTER DATA'!$A$1:$AQ$1'MASTER
DATA'!$A$2:$AQ$2,0)+COLUMN()-3)
On Tue, Oct 8, 2013 at 2:53 PM, Ravinder ravinderexcelgr...@gmail.com
wrote:
I think this one help u
From: excel-macros@googlegroups.com
:-)
THANK U BOSS, THANKS A LOT :-) ITS WORKING. :-)
On Tue, Oct 8, 2013 at 3:21 PM, Ravinder ravinderexcelgr...@gmail.com
wrote:
There may be different total number of rows in ur file
Try this
=INDEX('MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER
DATA'!$D$2:$D$65000,0),MATCH($B18
U can use this coding also in single line
Sub Rectangle1_Click()
Application.SendKeys (%mfvlookup%g~)
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dr
Sent: Thursday, October 10, 2013 5:29 PM
To: excel-macros@googlegroups.com
Subject:
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Thursday, October 10, 2013 5:45 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: RE: $$Excel-Macros$$ Display Vlookup dialog box with vba code
pfa
E2=1-((1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2)
E4=1-((1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: Saturday, October 12, 2013 2:23 AM
To: excel-macros@googlegroups.com
Subject:
Give some example..with xlsx file.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of garfin.in...@gmail.com
Sent: Monday, October 14, 2013 11:09 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Two spreadsheets , compare and produce a
Give some data...in which you want to work even dummy data.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of alisha malhotra
Sent: Tuesday, October 15, 2013 11:21 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help needed in creating a
PFA. IF u r looking for this.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Avinash
Sent: Thursday, October 17, 2013 2:07 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ week selection by criteria
hi all,
i want criteria based
Pfa, if u like to use this...
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Wednesday, October 16, 2013 8:38 PM
To: excel-macros
Subject: Re: $$Excel-Macros$$ Data validation - Need help to prevent
Duplicate Entry
try this
Pls use this if you like this. (sorry missed attachment in last mail)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Wednesday, October 16, 2013 8:38 PM
To: excel-macros
Subject: Re: $$Excel-Macros$$ Data validation - Need help to
=INDIRECT(E$2!BTROW()+1)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pravin Gunjal
Sent: Friday, October 18, 2013 11:00 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to take values from other sheets with single
formula or VBA
PFA , If data in same format in all PFD so u can use this also.
You have to put acrobat reader exe path in coding.
MyPath = C:\Program Files\Adobe\Reader 11.0\Reader\AcroRd32.exe
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jocky Beta
Sent:
PFA OR
=IFERROR(VLOOKUP(A2,CHOOSE({1,2},Contacts!$B$2:$B$13,Contacts!$A$2:$A$13),2,
0),UNKNOWN NUMBER)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of M.Rafique MRU
Sent: Sunday, October 27, 2013 9:57 PM
To: excel-macros
Subject: $$Excel-Macros$$
Try this one.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sagar Kasangottuwar
Sent: Monday, October 28, 2013 1:06 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro for consolidate worksheets from various
workbook to specific
various
workbook to specific workbook
Dear Ravindra,
Run time error 9 is showing after running macro. Kindly send me the macro
for copy sheets from various workbooks to single workbook.
Thanks ,
Sagar
On Mon, Oct 28, 2013 at 2:26 PM, Ravinder ravinderexcelgr...@gmail.com
wrote
PFA OR BELOW CODE
Sub putspace()
Dim rng As Range
Set rng = Application.InputBox(Please Select Range, Type:=8)
For Each T In rng
k = T
For i = 1 To Len(T)
j = Mid(T, i, 1)
If j = UCase(j) Then
k = WorksheetFunction.Substitute(k, j,j)
End If
T.Offset(0, 1) = WorksheetFunction.Trim(k)
PFA OR BELOW CODE
Sub putspace()
Dim rng As Range
Set rng = Application.InputBox(Please Select Range, Type:=8)
For Each T In rng
k = T
For i = 1 To Len(T)
j = Mid(T, i, 1)
If j = UCase(j) Then
k = WorksheetFunction.Substitute(k, j,j)
End If
T.Offset(0, 1) =
PFA OR BELOW CODE
Sub putspace()
Dim rng As Range
Set rng = Application.InputBox(Please Select Range, Type:=8)
For Each T In rng
k = T
For i = 1 To Len(T)
j = Mid(T, i, 1)
If j = UCase(j) Then
k = WorksheetFunction.Substitute(k, j,j)
End If
T.Offset(0, 1) =
Pls give some example file so
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rupesh Patil
Sent: Tuesday, October 29, 2013 10:43 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Validation Micro
Hi exports
I have sheet with some
HAPPY DIWALI TO ALL FRIENDS..
From: excelvbacli...@googlegroups.com
[mailto:excelvbacli...@googlegroups.com] On Behalf Of Dharmendra Upadhyay
Sent: Friday, November 01, 2013 11:06 AM
To: excelvbacli...@googlegroups.com
Subject: Re: [XL-VBA Clinic] Happy Diwali.
Same to u your family
On
What information you want to get
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bill Q
Sent: Saturday, November 02, 2013 3:12 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Web Query Issues
Hi,
Not sure if this is the proper
PFA with two solution, if you are looking for this.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ali Abbas
Sent: Saturday, November 02, 2013 2:33 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Formula for calculate max number for
PFA, r u looking for this...?
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Nemi Gandhi
Sent: Tuesday, November 05, 2013 11:23 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Querry-serial no
A excel sheet is
Pfa, try this one.. if help you
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Hilary Lomotey
Sent: Tuesday, November 05, 2013 10:48 PM
To: excel-macros
Subject: $$Excel-Macros$$ Advanced Filter Not Working Properly
Hello Experts,
i need your
Could you pls give small data and your query and desired output with
calculation.so we can try
From: Kashan Abbas [mailto:kashanabbas...@hotmail.com]
Sent: Thursday, November 07, 2013 10:36 AM
To: excel-macros@googlegroups.com; xlst...@gmail.com;
ravinderexcelgr...@gmail.com
Subject: FW:
Pfa, I think you r looking for this..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Hilary Lomotey
Sent: Thursday, November 07, 2013 12:39 AM
To: excel-macros
Subject: $$Excel-Macros$$ loop to copy items one by one
Hello Experts,
i need
I think problem with yello highlighted color code. Pls try this if help
(PFA)
Sub RoundedRectangle1_Click()
Dim rng As Range
Sheet2.Range(a1:a9).Select
Set rng = Selection.Find(What:=b, After:=Range(a1), LookIn:=xlFormulas,
_
LookAt:=xlPart, SearchOrder:=xlByRows,
PM
To: excel-macros@googlegroups.com
Cc: 'Soum'; Soum
Subject: Re: $$Excel-Macros$$ How to retrieve multiple or single data from a
single column like (A1) to different required columns like (D1, D2, D3
.)
Dear Ravinder Sory there is only one problem in my worksheet which i have
mentioned
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bill Q
Sent: Sunday, November 10, 2013 10:55 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup - Price List
Hi Guys,
This seems simple and I am pretty certain that it is -
=(INDEX($A$1:$A$51,SMALL(IF(($G2=$B$2:$B$51)*(K$1=$D$2:$D$51)*ROW($B$2:$B$51
)0,ROW($A$2:$A$51)),COLUMN($A$1
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajan sharma
Sent: Monday, November 11, 2013 3:42 PM
To: excel-macros@googlegroups.com
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajan sharma
Sent: Monday, November 11, 2013 3:42 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Formula Error
Dear experts,
I have wrote formula in the attached file, but
Sheets(New).Select
On Error Resume Next
For i = 2 To ActiveSheet.UsedRange.Rows.Count
If Cells(i, 14) 25 Then
Cells(i, 16) = 2
Endif
If cells(I,14)25 then
Cells(i,16)=5
Endif
next
From: excel-macros@googlegroups.com
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: Wednesday, November 20, 2013 5:11 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup query
Dear All
Please find attached query.
Is it possible to write
at 5:19 PM, Ravinder ravinderexcelgr...@gmail.com
wrote:
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: Wednesday, November 20, 2013 5:11 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup query
Dear
Pfa.put coloumn name 1 and 2 like A for first column and b is for second
coloumn
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Santy
Sent: Thursday, November 21, 2013 10:56 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Scurb two columns
U wants download pdf file form outlook account or you have saved thses files
in a folder and then need to open and save in a specific folder
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: Monday, November 25, 2013 1:25 PM
To:
Pfa examples file
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amit Desai (MERU)
Sent: Thursday, November 28, 2013 10:49 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Column Reference to change when we move to
next row
Can
Pfa.
Button 1 is for getting the all files names in excel from a specific folder.
Button 2 is for rename the files from A to C column values.
You can put name manually also in column a and then use rename(2) button or
get all files from specific folder then put new name in column B if you
Pfa..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: Thursday, November 28, 2013 11:53 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Comments
Waiting for Reply
On Wed, Nov 27, 2013 at 2:18 PM,
Try this coding for hide the sheet. this will not allow to unhide from
excel, only can unhide using vba coding
Sub hidesheet_()
ThisWorkbook.Sheets(1).Visible = xlVeryHidden
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ali Abbas
Sent:
Pls share file and website from where you are picking values if possible
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anoop kumar
Sent: Wednesday, November 27, 2013 6:56 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Want help in
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajesh Agarwal
Sent: Wednesday, November 27, 2013 3:14 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ conditional formatting
Dear Friend
How to put conditional formatting in column
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anon
Sent: Wednesday, November 27, 2013 2:45 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Conditional Formatting
Attached.
On Tuesday, 26 November 2013 18:06:00 UTC, ashish
=DAY(B2)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Dhaval Shah ( Ahd )
Sent: Thursday, November 28, 2013 5:44 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need formula help
Want to choss Day only from date pls refer
PFA, IF OK.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of TIWARI
Sent: Saturday, November 30, 2013 4:27 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ urgent need solution
Dear Sir,
I am attaching a file . We need a totally in file
It made using macro..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pravin Gunjal
Sent: Saturday, December 07, 2013 11:19 AM
To: excel-macros@googlegroups.com
Subject: Fwd: $$Excel-Macros$$ Re: I appreciate your help :-)
Dear Ravinder,
It's
give some examples
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of B.N.Chethan Kumar
Sent: Monday, December 09, 2013 6:13 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ VBA to send excel file using outlook
I have to send excel as
I think u r looking for this.
=IF(B2=Platinum,INT(C2/3),IF(B2=Gold,INT(C2/12000),IF(B2=Silver,IN
T(C2/6000
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shaikh Iqbal
Sent: Friday, December 13, 2013 4:07 PM
To: excel-macros@googlegroups.com
YES
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shaikh Iqbal
Sent: Friday, December 13, 2013 4:38 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need - formula help
Ravinder,
is it correct
=IF(B2=Platinum,INT(C2/3
PFA, may be helpful for you, first select path where you want to save file.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pmyk
Sent: Friday, December 13, 2013 4:58 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Please Help
Try
May be you r looking for this. =IF(AND(A9A8,A90),A9,B8)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajesh Agarwal
Sent: Monday, December 16, 2013 4:01 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ formula query
--
Rajesh
PFA, first select paths.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kartik Dale
Sent: Tuesday, December 17, 2013 1:54 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need a macro to open copy data from a given path
Hello Experts,
Pls clear your query. With example if possible
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anand S
Sent: Tuesday, December 17, 2013 4:10 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ folder check
Hi
I have multiple folders
What is the lookup value
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajesh Agarwal
Sent: Tuesday, December 17, 2013 5:34 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ vlookup query
--
Rajesh Kumar Agarwal
9811063001
--
Please forum members don’t pay attention on this totally fraud……….mail….
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Basole
Sent: Tuesday, December 17, 2013 7:15 PM
To: excel-macros@googlegroups.com
Cc: philip...@yahoo.com
Subject: $$Excel-Macros$$
-Macros$$ folder check
Hi Ravinder,
I have multiple folders with different folder names.(main folder), each main
folder having multiple sub folders with different names and each sub folder
having multiple workbooks. Workbooks are having different worksheet names.
These reports are Automated
What problem you are facing you select main folder in which ur subfolders
are available. This will give only sheet and file name of empty sheets.
From: ANAND S [mailto:anand...@gmail.com]
Sent: Wednesday, December 18, 2013 3:20 PM
To: Ravinder
Cc: excel-macros@googlegroups.com; Soum
Subject
Provide website and data you want to extract.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of B.N.Chethan Kumar
Sent: Thursday, December 19, 2013 4:19 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Ie
Hi
I am trying to connect IE 9
report.
On Dec 19, 2013 10:35 AM, Ravinder ravinderexcelgr...@gmail.com wrote:
Provide website and data you want to extract.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of B.N.Chethan Kumar
Sent: Thursday, December 19, 2013 4:19 AM
To: excel-macros
Your look up value is K2 however your range is starting from A2, So formula
should be =vlookup(a2,a2:k494,6,false)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rupesh Patil
Sent: Thursday, December 19, 2013 1:54 PM
To: excel-macros@googlegroups.com
HTML code in excel macro. I am trying to login
into a tool and pull a report in PDF format.
Regards
Ck
On Dec 21, 2013 12:46 AM, B.N.Chethan Kumar chetankumar1...@gmail.com
wrote:
Thanks. It worked.
On Dec 19, 2013 11:44 AM, Ravinder ravinderexcelgr...@gmail.com wrote:
Try this if looking
=IF(TEXT(date_rng,ddd)=SAT,C60-1,IF((TEXT(date_rng,ddd)=SUN),
date_rng -2, date_rng))
Or pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Robinson Boreh
Sent: Friday, January 03, 2014 3:25 PM
To: excel-macros
Subject: $$Excel-Macros$$ Date after
What is your search criteria ISBN, PRODUCT NUMBER or any URL please provide
some ISBN or PRODUCT url which price you want to extract
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Basole
Sent: Tuesday, January 07, 2014 4:27 AM
To:
Pls provide some data with example fiel
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rupesh Patil
Sent: Thursday, January 09, 2014 11:17 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ About Create Report
Hello Expert
I need
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deepak Rawat
Sent: Thursday, January 09, 2014 10:55 AM
To: excel-macros
Subject: $$Excel-Macros$$ Macro Code??
Dear All,
I need macro to update multiple sheets from one sheet
Ref data is
1 - 100 of 248 matches
Mail list logo