Hi Experts,
can some one please advise me the process or code to delete the records
from sheet 2 and specified dates in sheet 1 criteria .
i am attaching sample data please advise me how to use vba macros in this
regards.
Thanks for your help.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Hi Friends,
Please need your expert help in building 4 quadrant graph help.
Below is data for which 4 quadrant graph is required.
Company
Spend
Risk
A
10
5%
B
10
30%
C
40
60%
D
100
5%
i am attaching word doc in which i have drawn graph which looks like.
Please help in this
Hi Excel experts,
Wish you a very happy and prosperous New year.
i am trying to build Gantt chart if any one have such template please share.
As per previous group mails from Sam i referred to Chandoo.org template.
Like wise please if any one has such templates do share it.
Thanks,
Rekha
--
Hi Experts,
I am trying to split my Access data base using split option which is around
1.99gb. after splitting size is reduced to 1.01Gb. creating backup of
tables in New database and Orginal database remained with links to tables
and queries.
i am using MS Office 2007 version
can any one
Application.CutCopyMode = False
End Sub
Thanks,
Rekha
On Fri, Jun 28, 2013 at 11:57 AM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dear Rekha,
Pl see the attached workbook.
Warm Regards,
Gawli Anil
On Fri, Jun 28, 2013 at 10:36 AM, rekha siri rekha.siri2...@gmail.comwrote
Hi Experts,
Please help in this concern
i am attaching sample data spread from Column A TO H
in H Column i want to update Status as per below criteria
1) Filter Reference column -- custom filter -- Begins with ROD OR
Begins with ROY
Update the Status as Excluded for visible cells in
Hi Friends,
i tried piece of code for auto filter criteria , i succeeded in condition
for
autofilter for which criteria is equal to...
but does not equal to condition i am not getting proper result.
Basically i want to place a condition that 15th column in Bex file sheet
should be filter
Hi Experts,
Just wanted to know the purpose these VBA code , can any one please explain
what does this outer loop and inter loop means ...
For Outerloop = 8 To i
j = macro.Cells(Outerloop, Columns.Count).End(xlToLeft).Column
FileName = macro.Cells(Outerloop, 1)
Set NewFile = Workbooks.Add
hi Group,
Need your expertise help i along with my friends uploaded some excel file
into Access .
Now the Access is having around 1lac records .
Need help in exporting from access to excel all the 1lac records.
i tried exporting it to excel from access but it is throughing only 65000
records.
If Cells(r, 5).Value = LATAM Then
Cells(r, 45).Value = Excluded
End If
Next r
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
On Fri, Sep 21, 2012 at 7:37 PM, rekha siri rekha.siri2...@gmail.comwrote:
hi experts,
please help me
hi experts,
please help me in this concern, i have data spread from A to AB columns
from one of the column i want to apply filter select one region in column e
against that region i want to place as excluded in another column AS.
can any one help me with vba code in this.
i am attaching
forum.
As its name indicates this forum is about Excel Macros.
On 4 August 2012 02:24, rekha siri rekha.siri2...@gmail.com wrote:
Hi Experts,
Please assist in this concern i deal with xlius earlier now we are
using only power point dashboard presentation.
is there any possibility
Of *NOORAIN ANSARI
*Sent:* 13 August 2012 10:20
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Power pivot
Hi Rekha,
Please see attached study materials.
On Mon, Aug 13, 2012 at 6:55 PM, rekha siri rekha.siri2...@gmail.com
wrote:
hi Team,
Please share if anyone
hi Team,
Please share if anyone is having PPT tutorial on Power pivot, usuage of
sparklines/slicer in Excel 2010.
Thanks,
Rekha
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise,
Hi Experts,
Please assist in this concern i deal with xlius earlier now we are using
only power point dashboard presentation.
is there any possibility to place the scrolling marquee kind of text as
Headings of power point slides.
which needs to be scrolling continously.
Thanks,
Rekha
--
can any one please advise the below concern
-- Forwarded message --
From: rekha siri rekha.siri2...@gmail.com
Date: Sun, May 27, 2012 at 3:16 PM
Subject: $$Excel-Macros$$ compatability issues with 2007 VS 2010
To: excel-macros@googlegroups.com
Hi Experts,
can any one help me
hi experts,
could you please provide vba code which refreshes the SAP bex query or to
executes the bex query.
Thanks,
Rekha
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
Thanks a lot Marie ...
On Wed, Apr 4, 2012 at 11:56 PM, Haseeb A haseeb.avarak...@gmail.comwrote:
Good One Maries :)
As you know OFFSET is volatile. A non volatile formula,
=IFERROR(INDEX($B$4:$E$4,MATCH(B$9,INDEX($B$5:$E$7,MATCH($A10,$A$5:$A$7,0),0),0)),)
___
HTH, Haseeb
--
, 2012 at 10:27 AM, rekha siri rekha.siri2...@gmail.comwrote:
hi Ashish,
Thanks for your link however i am unable to download macro file it is
stating
Macro file not found.
Can you please forward that macro file.
Thanks,
Rekha
On Sun, Apr 1, 2012 at 6:33 PM, ashish koul koul.ash
Hi I need assistance in finding the right formula to substitute the value
to dates in countif
[image: Alexei De Guzman][image: Just Joined]
*Alexei De Guzman https://thehub.thomsonreuters.com/people/0143599* Apr
3, 2012 9:03 PM
Hi,
I am trying to come up with the formula to pull up dates from
-to-powerpoint-6.html
On Sun, Apr 1, 2012 at 3:04 PM, rekha siri rekha.siri2...@gmail.comwrote:
hi Experts,
i am attaching a macro which copies the two charts from excel and pastes
in ppt.
but can some one help to modify this code to paste two charts in one
slide instead of two slides.
Thanks
)
But this revision worked fine:
AppActivate newPowerPoint.Caption
** **
Asa
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *rekha siri
*Sent:* Sunday, March 11, 2012 12:20 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel
Greetings to one and all,
please provide a vba code for copying text frame from excel and to paste
in bottom of power point slide.
i have macro code in attached note pad in which macro pastes the text frame
on right hand side of slide
but can any one provide code to paste text frame in bottom
hi Experts,
please provide if condition formula for attached sheet.
Thanks,
Rekah
--
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
1]
On Mon, Mar 5, 2012 at 12:41 AM, rekha siri rekha.siri2...@gmail.comwrote:
hi Experts,
I Am excel trainer, just wanted to know how can we place this kind of
animation in mail for excel functions or training's
Use CTRL + Enter To Enter Same Data in to Multiple Cells(Quick Tip
can any one please assist my query...
On Tue, Feb 14, 2012 at 1:02 AM, rekha siri rekha.siri2...@gmail.comwrote:
hi Raj,
Thanks for your macro but i am sorry this is not performing vlookup
function inthis.
can you please look into this
On Tue, Feb 14, 2012 at 12:37 AM, Raj
automatically will give you your output
for any further queries, please feel free to revert
Thanks Regards
Rajesh Mahapatra
On Mon, Feb 13, 2012 at 5:29 PM, rekha siri rekha.siri2...@gmail.comwrote:
hi experts,
please help me in provinding code .
i am attaching sop and files in download
I've been using Google Talk and thought you might like to try it out.
We can use it to call each other for free over the internet. Here's an
invitation to download Google Talk. Give it a try!
---
rekha siri wants to stay
to new workbook
2) in that new work book i want to build the pivot .
On Fri, Jan 27, 2012 at 3:07 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Rekha,
Please find the code to build pivot using vba
On Fri, Jan 27, 2012 at 10:53 AM, rekha siri rekha.siri2...@gmail.comwrote:
Need
regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Fri, Jan 27, 2012 at 4:12 PM, rekha siri rekha.siri2...@gmail.comwrote:
hi Experts,
i require a popup box if cell
Need pivot macro assistance..
On Wed, Jan 18, 2012 at 9:59 PM, rekha siri rekha.siri2...@gmail.comwrote:
hi experts,
Please provide the code to build pivot using vba
this macro is provided to me in past by rajan really thank full for the
concern.
adding to that i need to prepare
SUmmarySheet
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *rekha siri
*Sent:* Jan/Sat/2012 08:51
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Fwd: Need help in building pivot using vba
** **
can any one kindly
the summarySheet..
Rajan.
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *rekha siri
*Sent:* Jan/Sun/2012 04:47
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba
Rajan i could able to find out the root cause.
i deleted sub delete module below and call delete function line
now its working fine
Thanks,
Rekha
On Sun, Jan 22, 2012 at 11:10 PM, rekha siri rekha.siri2...@gmail.comwrote:
rajan i dint remove summary sheet and raw data sheet but still its
, 1))) 91 Then
GiveNumeric = GiveNumeric Asc(UCase(Mid(rngVal.Value, intI, 1)))
- 64
End If
Next
End Function
** **
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *rekha siri
*Sent:* 27
hi experts,
please advise the formula to convert the alphabets to numbers.
for example
a =1
b= 2
c=3
acb =132
like this for each alphabet it should convert text to number.
Thanks for your help
Regards,
Rekha
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise,
higher than 26:
=CODE(UPPER(A1))-64
Although the above could be modified to return an error for other
characters, if that's important, the FIND() method is probably simpler and
faster.
Asa
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *rekha siri
Cells.Replace What:=--, Replacement:=, LookAt:=xlPart,
SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False
End Sub
Sam
On Nov 29, 11:28 pm, rekha siri rekha.siri2...@gmail.com wrote:
subjectimporting text to excelmailed-bygmail.com
hide details 11:47
hi Experts,
Please advise is there any option to schedule for particular time to macro
for execution on its on own without manual intervention.
if so please advise in this concern.
Thanks,
Rekha
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread
:30:00),ProcedureName
end sub
it means after 30 minute from now procedure ProcedureName will Execute.
On Sun, Dec 4, 2011 at 5:39 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Search the net for Application.OnTime
Regards,
Sam Mathai Chacko
On Sun, Dec 4, 2011 at 3:25 PM, rekha siri
sorry for confusion . it is done thanks alot
On Sun, Dec 4, 2011 at 10:04 PM, rekha siri rekha.siri2...@gmail.comwrote:
i did it by bringing line up it ran well ... but it did not delete the
records passed step.
On Sun, Dec 4, 2011 at 9:45 PM, dguillett1 dguille...@gmail.com wrote
41 matches
Mail list logo