Hi,
You can try below link/
http://www.brainbell.com/tutorials/ms-office/excel/Create_A_Speedometer_Chart.htm
On Tue, Apr 2, 2013 at 12:22 AM, Midhun Thampan midhun.tham...@gmail.comwrote:
hi anyone have an idea of how to use a sppeometer in excel.
kindly provide me some details and how to
Hi ,
http://gautamg.wordpress.com/2013/03/30/creating-a-speedometer-in-excel/?goback=%2Egde_82527_member_227695807
On Tue, Apr 2, 2013 at 12:27 AM, vijayajith VA vijayajith...@gmail.comwrote:
Hi,
You can try below link/
http://www.brainbell.com/tutorials/ms-office/excel
Hi
=IFERROR(VLOOKUP(A2,'Cost Center1'!$A$2:$A$21,1,0), ) .if you want blank
in place of N/A
On Fri, Feb 15, 2013 at 2:20 PM, vatspoojav...@gmail.com wrote:
Hi All,
I seek your guidance in the attached sheet, wherein, currently I am
updating manually the column: I Correct Cost Centre
--
*From: * vijayajith VA vijayajith...@gmail.com
*Sender: * excel-macros@googlegroups.com
*Date: *Fri, 15 Feb 2013 15:08:39 +0530
*To: *excel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ Query collation of data ignoring #n
Hi Chauan,
Use ths UDF..
Function RevStr(Rng As Range)
RevStr = StrReverse(Rng.Text)
End Function
On Fri, Feb 15, 2013 at 4:23 PM, neeraj chauhan
neerajchauhan...@gmail.comwrote:
Dear Experts,
kindly find the attached sheet and send the formula in excel for reverse
value
--
Are you
Hi Kuldeep,
Where did you got ths information. pls share. i dont have idea.
Thr is no Ylookup in excel..thanks
On Sat, Feb 16, 2013 at 12:00 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi Experts,
What is *Ylookup in Excel*. I know only Vlookup, Hlookup
you really need to.*
On Sat, Feb 16, 2013 at 12:48 PM, vijayajith VA
vijayajith...@gmail.comwrote:
Hi Kuldeep,
Where did you got ths information. pls share. i dont have idea.
Thr is no Ylookup in excel..thanks
On Sat, Feb 16, 2013 at 12:00 PM, Kuldeep Singh
Hi,
Right click on Home Image.
Click on Assign macro ..
Sheets(Home).select...
end sub
same thing for exit arrows..
On Sat, Feb 9, 2013 at 1:00 PM, amar takale amartak...@gmail.com wrote:
Dear All Champs,
I want to VBA Code for Home tab I put detail in attached sheet
Amar
HI Santhuash,
=IFERROR(IF(FIND( ,A2)-1 1,VLOOKUP(LEFT(A2,FIND(
,A2)-1)*,Database!A:A,1,0),),)
Try this. hope it helps you, Thanks
On Wed, Feb 6, 2013 at 7:39 PM, Santhosh Kumar M K mks@gmail.comwrote:
Hi Friends,
Need a help to create macro in a Data tab where it can recongnize a
Hi,
Instead of Macro, you can try using match or search function. ,
On Wed, Feb 6, 2013 at 7:39 PM, Santhosh Kumar M K mks@gmail.comwrote:
Hi Friends,
Need a help to create macro in a Data tab where it can recongnize a word
either by first/middle/last name if not with full name.
for
Hi Sandhosh.
Sub Splitsht()
ChDir C:\Documents and Settings\user\Desktop\folder
Dim wrksht As Worksheet
For Each wrksht In ThisWorkbook.Worksheets
wrksht.Select
wrksht.Copy
ActiveWorkbook.SaveAs Filename:=wrksht.Name .xlsx
ActiveWindow.Close
Next
End Sub
Thanks
HI Amar,
use below code..or Could you just share your workbook..
Sub method1()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim wb As Workbook
Dim ws As Worksheet
Set wb = ThisWorkbook
Set ws = wb.Worksheets(Feuil)
Dim rng As Range
Dim wdApp As New
Chage yourworksheet name .. as per your worksheet
On Sat, Jan 19, 2013 at 11:38 AM, vijayajith VA vijayajith...@gmail.comwrote:
HI Amar,
use below code..or Could you just share your workbook..
Sub method1()
Application.ScreenUpdating = False
Application.Calculation
with Example File.Pls see it.I used Excel 2003.
I thinking VBA code is making as I change table range only paste it
word (with formatting) bcos if I used it diffrent table in Excel.
Regards
Amar
On Sat, Jan 19, 2013 at 11:39 AM, vijayajith VA vjayajithi...@gmail.com
wrote:
Chage yourworksheet name
Hi Shiva,
Use below forumula.
Just change numbers how ever you want,,,
=IF(C2=1,Tat Complete ,IF(C2=5,Above Tat,IF(C2=2, In Progress not
completed,IF(C2=7,Above tat in progess,not complete,IF(C2=0,NA)
On Sat, Jan 12, 2013 at 12:02 PM, Shiva Prasad shivaprasad1...@gmail.comwrote:
Dear
For text use inverted commas..
On Sat, Jan 12, 2013 at 2:36 PM, Shiva Prasad shivaprasad1...@gmail.comwrote:
dear vijay,
this is wrong if b2=na (b2-a2)=value recived on eroor ineed that one also
On Sat, Jan 12, 2013 at 2:00 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi Shiva,
Use
Hi santhosa,
Press Alt +11
Use below --code..
Change accordingly..
Sub Macro1()
ChDir Your Path
Dim wrksht As Worksheet
For Each wrksht In ThisWorkbook.Worksheets
wrksht.Select
wrksht.Copy
ActiveWorkbook.SaveAs Filename:= your path wrksht.Name .xlsx
ActiveWindow.Close
wrksht.Name
.xlsx
ActiveWindow.Close
Next
End Sub
Thanks
Regards.
Vijay M
On Wed, Nov 28, 2012 at 7:27 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi santhosa,
Press Alt +11
Use below --code..
Change accordingly..
Sub Macro1()
ChDir Your Path
Dim wrksht
Hi Rajan,
I have question here..
Just wanted to know..what is the use of ROW(A1) A2 a3..etc etcc...
HERE..
=IFERROR(IFERROR(INDEX($C$2:$J$2,0,ROW(A1)),INDEX($C$3:$J$3,0,ROW(A1)-COUNTA($C$2:$J$2))),INDEX($C$4:$J$4,0,ROW(A1)-COUNTA($C$2:$J$3)))
On Fri, Nov 23, 2012 at 11:53 PM, Excel
done
On Sat, Nov 10, 2012 at 12:43 PM, Pravin Gunjal isk1...@gmail.com wrote:
Done.
On Sat, Nov 10, 2012 at 11:40 AM, Ayush Jain jainayus...@gmail.comwrote:
Dear group,
I have created a small formula quiz to test your formula knowledge. This
quiz has 10 questions related to excel
Congrats noorain Brother..
On Sun, Sep 2, 2012 at 11:22 AM, rao raomb...@gmail.com wrote:
Congrats, u are the live wire of this group.please do continue the same.
Cheers,
Prabhakar
On Sun, Sep 2, 2012 at 10:44 AM, in.vaib...@gmail.com wrote:
**
Congrats Noorain..
Rgds
Hi Noorain,
Isna(vlookup)
On Fri, Aug 31, 2012 at 1:16 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Group,
If any have more example except it please share, we have to make it for 50
types.
Please share if any one have examples...
On Fri, Aug 31,
Hi Zibrean,,
Please use below formula
=TRIM(RIGHT(SUBSTITUTE(LEFT(A4,FIND( ,A4 ,FIND(@,A4))-1), ,REPT(
,99)),99))
On Tue, Aug 28, 2012 at 2:50 PM, Zibraan lucky60...@gmail.com wrote:
Hi Team,
I am looking for a formula to separate Company's name and email address
from IDs.
Please refer
Hi all,
Please help me on attached file. Thanks
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
of the email
If you attach a file (good) then fully explain with examples
If you want a macro send a macro enabled file (xlsM)
You don’t say how you want your macro to fire. Why not just filter
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
*From:* vijayajith
hi,
Try below Ashish code...
Sub m()
Dim i, j, k, s As Long
s = Sheets.Count
For i = 1 To s
Sheets(i).Select
'change upper row here in this case it will start copying from second row
j = 2
' it will copy till last used row automatically
k = ActiveSheet.UsedRange.Rows.Count
Rows(j : k).Copy
HI Prince,,,
To avoid 0 s na please use below formula
=IF(VLOOKUP(F4,B4:D9,2,0)=0,,VLOOKUP(F4,B4:D9,2,0))
On Thu, Aug 16, 2012 at 10:52 PM, Prince Dubey prince141...@gmail.comwrote:
Please see the attachment
regards
prince
On Thursday, August 16, 2012 3:39:08 PM UTC+5:30, amar takale
HI Muneer,,,
I think Few days back noorain rajan had answered for same questions
On Wed, Aug 15, 2012 at 11:28 AM, Mohammed Muneer mmun...@ccc.com.qawrote:
**
Dear Group,
Please highlight the text in column B based on Friday.
Regards,
Muneer,
CC
--
Join official facebook page
Hi kenil,
Pls change accordg to your data.
=MAX(IF(B1:B70,B1:B7))
=MIN(IF(A1:A70,A1:A7))
On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala keni...@yahoo.com wrote:
hi all,
i have a query for finding maximum and minimum values.
i have written my query in the excel sheet attached. pls help me
Congratulations Noorain bayya!!
On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain jainayus...@gmail.com wrote:
Dear members,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
July'12. He has posted 143 posts in July 2012 and helped many forum members
through his
Hi ,,
Use Ctrl Shift enter for Priti_Verma s formula...
Thanks
On Sat, Aug 4, 2012 at 1:17 PM, amar takale amartak...@gmail.com wrote:
Pls help me all experts.I attached file.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
strAppName would be available to entire VBProject and its value
can’t be changed. *
* *
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *vijayajith VA
*Sent:* 01 August 2012 10:46
Hi Gurus,
Please could you explain what is the use of Public public const in vba
macros.
could you provide me one simple example...
Thanks
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent,
Hi kumar,
Try this..
=DATEDIF(A3,E3,md)
=TEXT(B3+F3,[HH]:MM)
On Tue, Jul 31, 2012 at 11:48 PM, xlstime xlst...@gmail.com wrote:
PFA THE ATTACHED MAY BE SOLUTION
On Tue, Jul 31, 2012 at 11:35 PM, Ashish kumar
kumar.ashish...@gmail.comwrote:
Dear Champs,
I need to consider the time
Please ignore.. showing wrong answer
On Wed, Aug 1, 2012 at 11:15 AM, vijayajith VA vijayajith...@gmail.comwrote:
Hi kumar,
Try this..
=DATEDIF(A3,E3,md)
=TEXT(B3+F3,[HH]:MM)
On Tue, Jul 31, 2012 at 11:48 PM, xlstime xlst...@gmail.com wrote:
PFA THE ATTACHED MAY BE SOLUTION
On Tue
CongratsASHISH *DILIP...
On Mon, Jul 2, 2012 at 9:18 PM, chhajersand...@gmail.com wrote:
**
Congratulation Ashish and Dilip.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
--
*From: * Sam Mathai Chacko samde...@gmail.com
*Sender: *
Ban Her.
On Fri, Jun 8, 2012 at 5:13 PM, Mangesh Dayne mangesh.da...@gmail.comwrote:
Such people should be ban for lifetime from this group. And I request you
to please do needful.
Thanks.
Mangesh
On Fri, Jun 8, 2012 at 5:08 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Congrats ..Rajan ...
On Mon, Jun 4, 2012 at 9:00 AM, Lalit_Mohan mohan.pande...@gmail.comwrote:
Congratulation Rajanonce again you rock...
Regards,
Lalit Mohan
On Sunday, 3 June 2012 23:12:31 UTC+5:30, Ayush Jain wrote:
Hello Everyone,
Rajan Verma has been
for Blanks also.
I wish to show Blank for Blanks.
On Saturday, June 2, 2012 12:12:39 PM UTC+4, vijayajith VA wrote:
Hi Rashid
As you requested.. Please find ...attached file...Thanks
On Sat, Jun 2, 2012 at 1:14 PM, Rashid Khan prkha...@gmail.com wrote:
Hello All
I am enclosing two files viz
Hi ...
Please attach sample file.
Thanks
On Sat, Jun 2, 2012 at 1:02 AM, Babak H babak...@gmail.com wrote:
Hello,
I am new to this group and I am unsure if this topic was covered in the
past so I apologize in advance.
*Problem*: I have external worksheets that i get on a montly basis
Hi all,
Please find the attached query..Thanks
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be
-Gtalk]*
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *vijayajith VA
*Sent:* 26 May 2012 4:15
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ doubt
** **
Hi all,
Please find the attached query..Thanks
--
FORUM
in the posting as well as in the
attached file.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* vijayajith VA vijayajith...@gmail.com
*Sent:* Saturday, May 26, 2012 5:44 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ doubt
Hi all,
Please find
Hi
Try ths
=VLOOKUP(E3,Sheet1!E3:G20,3,FALSE)
On Wed, May 23, 2012 at 5:16 PM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Experts
VLOOKUP is not working in attached file, can anyone help me why its not
working and what will be right formula?
Pls help me here.
Regards
Amit
--
FORUM
Please share sample sheet
On Fri, May 11, 2012 at 5:45 PM, Shekhar Sharma shekhar1...@gmail.comwrote:
Hey guys,
First of all thanks so much for helping me with resolutions.
I have two sheets within an excel spreadsheet and I need to lookup a name
from the first sheet and pull data through
Hi,
I want to know about Name Manager.. .. what is the use of Name
manager.how to use it..
Can any one explain me with examples...or any nice links ..Thanks
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Please share your sample sheet.. Thanks
On Tue, May 8, 2012 at 8:59 AM, rohit patel rohit81438...@gmail.com wrote:
On Thu, Apr 16, 2009 at 10:46 AM, rohit patel rohit81438...@gmail.comwrote:
i just want to link dis 1 sheet (Vendor April .09 demo) to Receiving
status(supplier)mar.09 demo,
Hi Loki
Please try below..code try to edit.. how you want...
---(code is From Rajan verma)
Declare Sub Sleep Lib kernel32 (ByVal dwMilliseconds As Long)
Sub Start()
Dim St As String
Dim Cell As Range
Set Cell = Range(L5)
St = Cell.Value
St = Trim(St)
St = St
HI
Please try below one
=IFERROR(VLOOKUP(D2,'Utilization and Closing stock'!A2:C19,3,FALSE), )
On Sun, May 6, 2012 at 2:38 PM, Smitha S R sperdwo...@gmail.com wrote:
On Sun, May 6, 2012 at 2:37 PM, Smitha S R sperdwo...@gmail.com wrote:
Hi,
Any one please help:
PFA the
HI All,
Is thr any other short cut key for COPY Paste (except ctrl c v).Thanks
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not
DON ROCKS...!CONGRATS.
On Sat, Apr 14, 2012 at 2:06 PM, Ayush Jain jainayus...@gmail.com wrote:
Dear members,
Don Guillett has been selected as 'Most Helpful Member' for the month of
March'12
He has been helping forum members from long time consistently and we are
@googlegroups.com] *On Behalf Of *vijayajith VA
*Sent:* Apr/Sun/2012 06:23
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Access..
** **
Hi All,
** **
Can you provide me MS ACCESS. LINKS(WEBSITES).Thanks
** **
** **
--
FORUM RULES (986+ members already BANNED
Hi
Can yu pls attached sample worksheet ?
On Sat, Apr 7, 2012 at 10:55 PM, joseph.cam...@gmail.com wrote:
Hi,
I want to reorder products by rank in a particular order. It works fine
when the rank is unique. But when there are two products of same rank then
it does not. Please help.
I
Hi All..
I have created few macros.i need to add it in Add in...Can you please
tell me how to do it ? Thanks
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
Hi ,
12/2/2001 12:00 PM --- How to remove time ? i need only date .. is
thr any formula ..Thanks in advance
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
= VBA.Left(mycell, VBA.InStr(1, mycell, ) - 1)
Selection.NumberFormat = m/d/
endif
Next
End Sub
On Thu, Apr 5, 2012 at 9:24 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi ,
12/2/2001 12:00 PM --- How to remove time ? i need only date ..
is thr any formula ..Thanks
Hi Cayne,
Sub rowinsertcola()
Dim i, j, k, z, h As Long
j = 1
z = 1
Range(a65356).Select
Selection.End(xlUp).Select
k = ActiveCell.Row
For i = 5 To k + z Step 1
If (i Mod j = 0) Then
ActiveSheet.Cells(i + z, 1).Select
Selection.EntireRow.Insert
z = z + 1
End
awesome !! Great !!!11
On Wed, Apr 4, 2012 at 10:20 AM, Maries talk2mar...@gmail.com wrote:
Hi,
PFA. Use below Array formula,
=IFERROR(INDEX($B$4:$E$4,MATCH(B$9,OFFSET($A$4,MATCH($A10,$A$5:$A$7,0),1,1,4),0)),)
Regards,
MARIES.
On Wed, Apr 4, 2012 at 7:16 AM, rekha siri
Mathai Chacko
On Sat, Mar 31, 2012 at 10:38 PM, vijayajith VA
vijayajith...@gmail.comwrote:
Hi,
Set sourcerange = Columns(D).SpecialCells(xlCellTypeBlanks)
Can any one explain above code?
what does it mean?
Thanks in advance
--
FORUM RULES (986+ members already BANNED
at 11:11 PM, vijayajith VA
vijayajith...@gmail.comwrote:
Thanks sam
means same range suppose a1(blank cell) will search for a1 in other
workbook get filled rite...
On Sat, Mar 31, 2012 at 10:43 PM, Sam Mathai Chacko
samde...@gmail.comwrote:
It means that all blank cells
) = Cells(1, 1) Then Rows(i).Delete
Next i
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* vijayajith VA vijayajith...@gmail.com
*Sent:* Friday, March 02, 2012 12:44 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ help
Hi
HI ,
Can you pls attach sample file.. send it to us..Thanks
On Fri, Mar 16, 2012 at 11:21 PM, Brian brianfosterbl...@gmail.com wrote:
I am using Excel 2007
Depending on the squad number I select in a worksheet I have set up some
formulas so I can find the reference for the first cell and
HI ranjan,
go to tools in vb editor.. in reference select microsoft outlook
options... run the program it works fine
Thanks...
On Thu, Mar 15, 2012 at 4:54 PM, Deba Ranjan drdeva...@gmail.com wrote:
*
*
Dear Expert,
Please help to create a programing such that the attached file
HI Don,
is this possible in pivot table ? .. i have three columns..a b c.
a b --having some order nos.. invoice no
C is date..--todays, toms earilier date..
if its earlier date -order nos invo no.. should changeto red..
todays date - blue toms date --green colr.. order no
HI Hamed,
Attachment is missing...
On Sun, Mar 11, 2012 at 12:43 PM, Gulam Hameed gulamham...@gmail.comwrote:
Dear Noorain experts
** **
I want make invoice in easy shortcut method like eg: order number 8241
2012, it has 12 items codes, Description, Price Qty Total Amount,
Hi learn excel..
Please send it with attachment.. it will be helpful.Thanks///
On Wed, Mar 7, 2012 at 8:16 AM, LearnExcel sendse...@gmail.com wrote:
help with code
Dim ws As Worksheet
can someone tell me why the follwowing code wont work
For Each ws In ThisWorkbook.Worksheets
i think... its not possible...
On Wed, Mar 7, 2012 at 10:11 AM, danial mansoor danial_...@hotmail.comwrote:
i used this macro and assigned it a shortcut key for my conveniance for
paste special values,but i can not undo last actions is that possible to
undo last 2 actions after modification
Hi
Please find the attached query///
Thanks
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not
at 12:14 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi
Please find the attached query///
Thanks
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem
hi shaik.
Sorry. i need code for ths..
On Fri, Mar 2, 2012 at 12:38 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi Sahik,,
Sorry ..i need required code for ths .. Thanks''
On Fri, Mar 2, 2012 at 12:35 PM, Shaik Waheed waheedb...@gmail.comwrote:
Hi,
PFA solved, hope this is what u
Hi,
Is thr good future in learning Imacros?
Thanks
On Fri, Feb 17, 2012 at 11:12 PM, xlstime xlst...@gmail.com wrote:
Hi Amit,
iMacros is the *only* software that can *automate both Internet Explorer
and Firefox.* You can control both web browsers directly from Excel.*iMacros
works with
Hi ,,
Please share your workbook.Thanks
On Sat, Feb 11, 2012 at 2:15 AM, Mayank mayanksupadh...@gmail.com wrote:
Team,
I have master file having 10 sheets.
1st sheet having summarize data (populated using formulas) of other 9
sheets and these 9 sheets contains data from 6 different files
Hi
Question asked in interview
i have nearly 30 pivot tablein 30 sheets i need to enter
data in master sheetat a time i need to refresh alll the pivot table...
how to link the pivot table... Please help me.i dont have any
workbook.. question asked in
pivots too get refreshed.*
On Sat, Feb 11, 2012 at 9:41 AM, vijayajith VA vijayajith...@gmail.comwrote:
Hi
Question asked in interview
i have nearly 30 pivot tablein 30 sheets i need to enter
data in master sheetat a time i need to refresh alll the pivot table...
how
Congrats Noorain,..
On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Jan'12
He has posted 175 posts in Jan'12 and helped many people through his
expertise. He has been
/
-- Forwarded message --
From: vijayajith VA vijayajith...@gmail.com
Date: Sun, Dec 25, 2011 at 3:01 PM
Subject: $$Excel-Macros$$ help
To: excel-macros@googlegroups.com
Hi ,
i have some data like 1) floo see r eree s seer(A23),seruo serereserrser
seeess kke(A89
Hi Noorain,
Please find the attached sheet.
Thanks
On Fri, Feb 3, 2012 at 10:30 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi Noorain ansari,
Data will be floo see r eree s seer(A23),seruo serereserrser seeess
kke(A89 ) =I need ans answer as A23,A89
but if i use your formula i am
= Application.WorksheetFunction.Trim(rs)
End Function
See attached sheet
On Fri, Feb 3, 2012 at 10:34 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi Noorain,
Please find the attached sheet.
Thanks
On Fri, Feb 3, 2012 at 10:30 PM, vijayajith VA
vijayajith...@gmail.comwrote:
Hi Noorain ansari
Hi mansoor,
sub tex()
selection.value = selection.value
end sub
On Fri, Feb 3, 2012 at 9:08 PM, danial mansoor danial_...@hotmail.comwrote:
i have a big file with many sheets i want to convert formula in values,if
i do individually it will take lotes of time can any one tell me the macro
Hello sir,
Just i want to know about use relative reference in vb developer tab.?
What is use of that ?
Thanks in advance
'
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
Hi Gurus,
Please find the attached querY
Thanks in adv.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or
HI Van,
Thanks for your info.Can you give some examples with attached file.
Thanks
On Sun, Dec 25, 2011 at 1:17 AM, Bé Trần Văn betnmtdongna...@gmail.comwrote:
2011/12/25 vijayajith VA vijayajith...@gmail.com
Hello sir,
Please i want to know about getpivotdata . can you give me some
Hi ,
i have some data like 1) floo see r eree s seer(A23),seruo serereserrser
seeess kke(A89)
2) folow re e ser se ser(S89)
I want to extract only nos inside the bracket
please suggest me for some formula or code
Thanks
--
FORUM RULES (934+ members already
Of *vijayajith VA
*Sent:* 25 December 2011 03:02
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ help
** **
Hi ,
** **
i have some data like 1) floo see r eree s seer(A23),seruo serereserrser
seeess kke(A89)
2) folow re e ser
seeess kke(A25)
=A89,A25
On Sun, Dec 25, 2011 at 4:18 PM, vijayajith VA vijayajith...@gmail.comwrote:
Thanks
HI Rajan,
I need only A23,A89 --for 1st one
S89 for second one
Thanks
On Sun, Dec 25, 2011 at 3:08 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
What will be your
Hello sir,
Please i want to know about getpivotdata . can you give me some examples.?
Thanks
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Sat, Dec 17, 2011 at 11:44 AM, vijayajith VA
vijayajith...@gmail.comwrote:
Hello sir,
Please i
Hello sir
Can you tell me what is shortcut key for data clear(filter)?
Thanks
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not
:
Hi
Try this:
http://dmcritchie.mvps.org/excel/shortx2k.htm
Cheers,
andy
On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA
vijayajith...@gmail.comwrote:
Hello sir
Can you tell me what is shortcut key for data clear(filter)?
Thanks
--
FORUM RULES (934+ members already BANNED
AM, vijayajith VA
vijayajith...@gmail.comwrote:
Hello sir
Can you tell me what is shortcut key for data clear(filter)?
Thanks
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help
Hello sir,
Please i want to know about Add ins .Can you give me some examples?
Thanks
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Sat, Dec 3, 2011 at 9:32 AM, vijayajith VA vijayajith...@gmail.comwrote:
Hi
I have two workbooks.sheet1 and sheet2. I want to find
Hi
I have two workbooks.sheet1 and sheet2. I want to find duplicates data from
sheet1 to sheet2.Is this possible to record a macro.for this?
Thanks
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent,
Thanks ankit.
On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Hello All,
In our daily life we calculate so many thing use different calculator.
Here is one excel file which contain almost all calculator.
Calculate enjoy !!!
Regards,
Ankit
--
Hi Gurus,
Is this possible to do data validation from one workbook to another
workbook ?
Can you give me one example?
Thanks
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
Hi anil,
I am not getting. can you attach a sample file .?
Thank you
On Sat, Nov 12, 2011 at 2:06 PM, anil kumar kmr7a...@gmail.com wrote:
Hi experts,
I have a queary I have 10 branches in differents citys. and I gate report
daily in excel about their daily work. so I want to know that
--
*From: * vijayajith VA vijayajith...@gmail.com
*Sender: * excel-macros@googlegroups.com
*Date: *Thu, 10 Nov 2011 19:41:37 +0530
*To: *excel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ help me
hi
I have
End If
Next lngLoop
End Sub
Regards,
Sam Mathai Chacko
On Thu, Nov 10, 2011 at 7:42 PM, vijayajith VA vijayajith...@gmail.comwrote:
hi
I have tried using pastespecial its NOT WORKING
its copying only two cells
can you help me please ?
Pleas find the attachment
Thank
hi
I have tried using pastespecial its NOT WORKING
its copying only two cells
can you help me please ?
Pleas find the attachment
Thank you
On Thu, Nov 10, 2011 at 7:41 PM, vijayajith VA vijayajith...@gmail.comwrote:
hi
I have tried using pastespecial but its not working
its copying
, dguillett1 dguille...@gmail.com wrote:
Are both files in the same folder? Is the source file named *VA_*book1.xls
or book1.xls ?
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* vijayajith VA vijayajith...@gmail.com
*Sent:* Monday, November 07, 2011 9:17 AM
*To:* excel
1 - 100 of 134 matches
Mail list logo
