e("00:00:03") ' wait 3 seconds
DoEvents
'IN ACROBAT :
'SELECT ALL
SendKeys "^a"
'COPY
SendKeys "^c"
'EXIT (Close & Exit)
SendKeys "^q"
'Wait some time
Application.Wait Now + TimeValue("00:00:03") ' wait 3 se
Hello Kaushik,
I am sorry, but can you send me what you had posted before? I have lost the
original description of you needs.
Thanks, David
On Sun, Apr 29, 2018 at 4:25 PM, wrote:
> excel-macros@googlegroups.com
> <https://groups.google.com/forum/?utm_source=digest&utm_medium
Is this group no longer for asking questions about Excel VBA? I see nothing
but hiring information and nothing about VBA.
Thanks, David
On Wed, Apr 25, 2018 at 4:23 PM, wrote:
> excel-macros@googlegroups.com
> <https://groups.google.com/forum/?utm_source=digest&utm_medium=email
These are examples of using several line breaks. I hope they will help:
1)
qurl = "http://finance.google.com/finance/historical?q="; & Sym
qurl = qurl & "&startdate=" & MonthName(Month(StartDate), True) & _
"+" & Day(StartDate) & "+" & Year(StartDate) & _
"&enddate=" & MonthName(Month(End
Can you specify the number of decimal places you want? Or does that change
and if so can you specify the conditions that will give specific decimal
places?
Thanks, David
On Sat, Feb 24, 2018 at 3:32 PM, wrote:
> excel-macros@googlegroups.com
> <https://groups.google.com/forum/?u
On Fri, 2/2/18, 'Liberty Stringer' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Pivot Help
To: excel-macros@googlegroups.com
Date: Friday, February 2, 2018, 4:20 AM
On Wed, 1/3
On Tue, 1/30/18, 'Storey Thomas' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Pivot Help
To: excel-macros@googlegroups.com
Date: Tuesday, January 30, 2018, 2:58 PM
On Tue, 1/30
On Fri, 1/12/18, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ macros won't run as written
To: excel-macros@googlegroups.com
Date: Friday, January 12, 2018, 4:27 AM
-
he above,
assuming the data is in the
addresses
used.
Thanks,
David
On
Saturday, December 23, 2017 at
1:39:57
AM UTC-8, Aamir
Shahzad wrote:Friends,
I want to concatenate all below
data in one cell without any
space.
Formula please.
data148351,1837
How about simply copy and paste values and do it to the the whole sheet?
Sub CopyPastVal()
Cells.Copy
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
End Sub
Thanks, David
On Tue, Dec 19, 2017 at 3:31 PM, wrote:
> excel-mac
On Thu, 9/21/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ reconiling large data in excel
To: excel-macros@googlegroups.com
Date: Thursday, September 21, 2017, 3:28 PM
On Sun, 7/30/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Help on Week Formula
To: excel-macros@googlegroups.com
Date: Sunday, July 30, 2017, 3:31 PM
On Sun
The key piece that I seem to be struggling with is using a cell location as
a reference to cut / paste.
The idea is if there is a value in a cell on a row within a range, do
something.
What it does depends on the attributes of that cell. I will build a loop to
go through different options
On Thu, 7/6/17, Puttu * wrote:
Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value
To: "MS EXCEL AND VBA MACROS"
Date: Thursday, July 6, 2017, 4:44 PM
Hi Swapnil,
Thanks you so much
appreciate your time and help on gettin
On Wed, 7/5/17, 'Yu Spain' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value
To: excel-macros@googlegroups.com
Date: Wednesday, July 5, 2017, 2:43 AM
I want to search rows within a range (D1:J100) in sheet1.
If there is a value in a cell within the row, reference a separate cell on
the same row but outside of the range, which identifies the type of content.
The reference column is a fixed location (B1:B100)
Based on the type of content, select
On Sat, 6/17/17, amar takale wrote:
Subject: Re: $$Excel-Macros$$ Re: Required break chart in excel
To: excel-macros@googlegroups.com
Date: Saturday, June 17, 2017, 7:10 AM
no,I have
got it but how to done it?I will try but not success,if
poss
On Fri, 6/2/17, 'Yu Spain' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.
To: excel-macros@googlegroups.com
Date: Friday, June 2, 2017, 4:22 AM
-
It seems the first question must be "what is purpose, what are you trying
to accomplish?" thanks, David
On Mon, May 29, 2017 at 4:26 PM, wrote:
> excel-macros@googlegroups.com
> <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/excel-macros/top
On Sun, 4/9/17, 'Martin George' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot
To: excel-macros@googlegroups.com
Date: Sunday, April 9, 2017, 2:02 AM
On
Hi,
Can any one please help me to arrange a formula, so that if the number in a
selected cell increases, the corresponding answer in another cell will
increase accordingly.
How do i arrange the formula in Excel, so that if Q35(cell number)=1, the
answer (in cell C5) is 0;
Hi Champs,
Please solve this query.
Regards,
--
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 threa
Thank you very much
On Tuesday, September 8, 2015 2:17 AM, Swapnil Palande
wrote:
Great...Learned somthing new today...
Thanks Abhishek.
Regards,Swapnil Palande
On Tue, Sep 8, 2015 at 11:33 AM, Abhishek Jain wrote:
Just one correction, if I may:
Countif(A1:A100,"(IRE)") would only
rmula that will count
(IRE), (GB), etc etcAny help would be appreciated.
Thanks,David Lanne
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use co
Hi
I'm David Miller from Tamilnadu, my company name is Crystal broadband
networks, i need your help in an excel file which can reduce my work if i
can use a macro, i have mentioned below the file which i will download in
excel format from my CRM and it looks
Hello,
I have several excel files with active links to a PowerPoint file. I need
to combine the Excels into one, but any way i try to do so breaks the
links. Is there a way to combine the files whilst maintaining the links?
Thanks in advance
David
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
--
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, F
Slaying Excel Dragons by Mike Girvin is a good book. I still can't figure out
all the language stuff. But what helped me was recording marcos doing simple
stuff, (ex renaming sheets, sorting data, etc) then stepping into the marco and
I could see what its doing, which helped down the line when I
Hiya,
Can anyone please recover the VBA password(s) for this file, I have
recovered the excel (2010 macro enabled workbook) workbook and worksheet
passwords.
https://drive.google.com/file/d/0Bw6W1WHEetl7LUZyWC13WWw5cUU/edit?usp=sharing
I have tried a few freeware VBA password recovery programm
http://bit.ly/1jgNIu9
--
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,
Perhaps you have more than one sheet selected.
Regards
David Grugeon
On 28 May 2013 14:37, Prabhu Pinky wrote:
> hi experts
>
> I have one excel, from that excel I am unable to copy and paste the data
> to new excel..even a single cell..am getting "this command is cannot
I think you would do better to use a pivot table. Dates can be based on
weeksfor the summarisation.
Regards
David Grugeon
On 28 May 2013 12:17, Yogesh Vyas wrote:
> Hi Team,
>
> I need IF/Nested IF Formula for Supplier Aging Analysis. Please find
> attach data for the
might be possible if you have it rght aligned in a cell and put
the horizontal text, a space, and the first letter of the vertical text, an
Alt-return, the next vertical letter, and so on like this
*fred F*
*R*
*E*
*D*
Regards
David Grugeon
On 27 May 2013 16:59, Prathap wrote:
> Hi Expe
Bulloo Shire Council in Thargomindah Queensland Australia.
Regards
David Grugeon
On 27 May 2013 16:13, VBA VABZ wrote:
> hey
>
> for which co you work.
>
> thx
>
>
> On Mon, May 27, 2013 at 7:20 AM, Bv Dileep wrote:
>
>> Hello,
>>
>&g
roduce the entire code for you that is a consulting job. I currently
charge my clients AUD 140 per hour for such services. If you do it
yourself you will be better placed to cope with other issues in the future.
Regards
David Grugeon
On 27 May 2013 11:50, Bv Dileep wrote
cel-macros+unsubscr...@googlegroups.com 'cvml', 'excel-macros%2bunsubscr...@googlegroups.com');>.
> To post to this group, send email to
> excel-macros@googlegroups.com 'excel-macros@googlegroups.com');>
> .
> Visit this group at http://groups.goog
the process. I think the processing time and memory used will be
> more during that period.the problem can only be dealt with specifically if
> only we know what exactly is causing the problem.
>
> Regards,
> VIJAYKUMAR
>
>
> On Thu, May 23, 2013 at 5:23 PM, Prabhu Pink
Also do you have macros which are run when changes are made to the sheets.
It may be possible to reorganise them so they run faster or are not
triggered so readily.
Regards
David Grugeon
On 23 May 2013 21:47, David Grugeon wrote:
> Try setting the calculation to Manual. Then see if Cut
worksheets, or by keeping calculation turned off and pressing F9 when you
want it to calculate.
Regards
David Grugeon
On 23 May 2013 21:26, Prabhu Pinky wrote:
> thanks vijay, lemme try this too.
>
> but my doubt is if already "Use all the processors on this computer"
> op
Can't guess without seeing the file. Can you attach it?
Regards
David Grugeon
On 23 May 2013 16:49, Prabhu Pinky wrote:
> Hi experts,
> I have one excel file. Size is below 1mb. Even though it is very slow
> working in that file. If I do copy paste any single cell, it takes t
Can they open the files through the network manually while the files are on
you computer
On Wednesday, 22 May 2013, Chaya wrote:
> Dear experts,
>
>
> I have more then three excel (Say A, B, C) file in under folder
> (D:\Master File). Now I have a single workbook know as “Master file”. In
> t
p and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com 'cvml', 'excel-macros%2bunsubscr...@googlegroups.com');>.
> To post to this group, send email to
> excel-macros@googlegroups.com 'excel-macros@googlegroups.com')
Excel can do it but unfortunately the restriction not to use VBA prevents
it. Perhaps you should talk to your IT department and ask them how to
solve it.
Regards
David Grugeon
On 19 May 2013 07:02, santosh subudhi wrote:
> Hi Group,
>
> Attached is the sample sheet where in the comm
e done and what it is doing
wrong. If there are any error messages write them down exactly and tell
us, if it is possible to find out, what line the error occurred on.
Above all, just keep writing and testing code and you will soon be one of
the ones giving the answers on the list.
Regards
Dav
Did you mean to attach the file?
Regards
David Grugeon
On 17 May 2013 14:32, P.VIJAYKUMAR wrote:
> Respected Prabhu,
>
> Hope this file will be of little help to u.
>
>
> Regards,
> VIJAYKUMAR
>
>
> On Tue, May 14, 2013 at 9:08 PM, Prabhu Pinky wrote:
>
>
need on row 7
If(A7="","",the formula)
I hope this is clear.
Regards
David Grugeon
On 17 May 2013 10:50, Christopher Kevin wrote:
> David, thank you it worked perfectly, however, when I use the fill handle
> to drag and fill down I ended up with 0, #NA and 0/01/190
End Sub
Regards
David Grugeon
On 17 May 2013 07:44, David Grugeon wrote:
> The main issue is where the references point. If they are pointing within
> the block you are copying, there is no issue as they will continue to point
> to the appropriate cells within the block. If th
MyConvertFormulas()
Dim oRange As Range
Dim c as Range
Set oRange = Selection
for each c in oRange
c.Formula = Application.ConvertFormula(Formula:=c.Formula, _
fromreferencestyle:=Application.ReferenceStyle,
toabsolute:=xlAbsolute)
End Sub
Regards
David Grugeon
On 17 May 2013 01:22, Chris
Sorry - Attachment here
Regards
David Grugeon
On 16 May 2013 13:12, David Grugeon wrote:
> Easier with formulas - see attached. I had to change the ID for ABC from
> FR002 to FR001 to match the details. Also I did not get the swapped items
> in the last 2 rows shown in your
Easier with formulas - see attached. I had to change the ID for ABC from
FR002 to FR001 to match the details. Also I did not get the swapped items
in the last 2 rows shown in your combined.
Regards
David Grugeon
On 16 May 2013 12:38, Christopher Kevin wrote:
> Dear Experts,
>
> C
The formula refers to 34 in B5 but B5 is 36, not 34
Regards
David Grugeon
On 15 May 2013 16:41, P.VIJAYKUMAR wrote:
> Respected Experts,
>
> My exact requirement is that if 12(or any constant number specific to
> login) is typed in Cell B4 of the attachment it should displa
It is possible using VBA. Please supply a sample workbook so we can
understand exactly how your data is organised and how you want to look it
up.
Regards
David Grugeon
On 15 May 2013 13:51, Prabhu Pinky wrote:
> Nope. it is not possible..
>
>
> On 15 May 2013 01:14, santosh s
You cannot filter horizontally. You could have a macro to hide all columns
from column d onwards which were not Week1, if that is what you want.
Regards
David Grugeon
On 10 May 2013 16:28, Amit Desai (MERU) wrote:
> Dear Friends,
>
> ** **
>
> Please help.
>
&g
>From the data available there is no way to determine how many users have 3
or more channels.
Regards
David Grugeon
On 10 May 2013 15:34, Sri Jai wrote:
> Thanks david for the response
> I think i confused you uncessarilly..(Apologies)As attached in the
> word docum
terms "CCG", "Channel", and "Impression" mean, it may be feasible for me or
another member (ideally a statistician) to help you further.
Regards
David Grugeon
On 10 May 2013 13:47, Sri Jai wrote:
> Dear Experts,
>
> Need your help on the below
>
ink.follow.
Regards
David Grugeon
On 10 May 2013 06:42, Mathan wrote:
> Sorry, please refer to this screenshot. Thanks
>
>
> On Fri, May 10, 2013 at 2:11 AM, Mathan wrote:
>
>> Hi David,
>>
>> Please refer to the attached screenshot. I believe you would get my point
, I think.
Or you could upload the file to Google Apps or Office 365 and then open
that in a browser.
Regards
David Grugeon
On 9 May 2013 16:31, Mathan wrote:
> Hi David/Anil,
>
> We are trying to upload the excel file through excel vba.
>
> The files are from common shared fo
he file is located.
We also need to know why VBA code is required, rather than simply a
hyperlink.
Regards
David Grugeon
On 9 May 2013 06:56, Mathan wrote:
> Hi Experts,
>
> I'm trying to upload a file from shared folder (directory) to the internet
> explorer.
>
> Need a
Priti, You are absolutely right. It is up to the person who raised the
query to test sugestested solutions and respond. If it is not working to
say in what respect it is not working, If it is working to acknowledge
that.
Regards
David Grugeon
On 8 May 2013 22:16, priti verma wrote:
> D
You are more likely to get a response if you use a meaninful heading and
include the details of your problem in the body of the post.
Regards
David Grugeon
On 3 May 2013 03:33, SAJID MEMON wrote:
> I have attached a file, please give me vba code of my problem which i have
> explained
ows("102:" & k).Delete Shift:=xlUp
Regards
David Grugeon
On 30 April 2013 13:56, excel learner wrote:
> this particular line it is Just skipping Rows("102:" & k).Select
>
> and deletion line also not performed.
>
>
>
>
> On Mon, Apr 29, 2
lection.
What does it do? Are the rows still selected? If not, where is the active
cell after this line is run?
Regards
David Grugeon
On 28 April 2013 16:36, excel learner wrote:
> hi David,
>
> I tried step by step execution but still it is executing fine without any
> error
You have highlighted 5 lines
Try stepping through the code and finding out which line does not work as
required.
Regards
David Grugeon
On 28 April 2013 16:25, wrote:
> Hi Experts,
>
> i have come across an issue where in auto filter code is skipping over
> without performing
7;excel-macros%2bunsubscr...@googlegroups.com');>.
> To post to this group, send email to
> excel-macros@googlegroups.com 'excel-macros@googlegroups.com');>
> .
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://gro
Thank you for the tip. Moving to cell A3 works, except when my only data
is in C3 & D3. My goal is to reset the worksheet without the users losing
the formulas.
On Wednesday, April 24, 2013 8:10:58 PM UTC-4, David H wrote:
>
>
>
> I am using an excel spreadsheet in conjuncti
I am using an excel spreadsheet in conjunction with Loftware. which
requires headers in cells A1 and B1. I have formulas in A2 and B2
calculating data from C2 and D2. I'll enter data in columns C & D and then
copy the formula down in columns A and B.
My problem is when I reset the worksh
;);>.
> To post to this group, send email to
> excel-macros@googlegroups.com 'excel-macros@googlegroups.com');>
> .
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
os%2bunsubscr...@googlegroups.com');>.
> To post to this group, send email to
> excel-macros@googlegroups.com 'excel-macros@googlegroups.com');>
> .
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.g
Sorry. Dont use that use this one
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
Application.EnableEvents = False
Worksheets(5).PrintOut
Application.EnableEvents = True
End Sub
Regards
David Grugeon
On 19 March 2013 22:08, David Grugeon wrote:
> Put this in
Put this in the ThisWorkbook module
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
Application.EnableEvents = False
Worksheets(5).PrintOut
End Sub
Regards
David Grugeon
On 19 March 2013 21:50, Shrinivas Shevde wrote:
> Dear All
> I have a excel work book in which
I cannot understand your question. you will have to be much more explicit.
If you cannot explain in English, perhaps you know someone who can help
you.
Please put the explanation in the body of the email, not in a spreadsheet.
Regards
David Grugeon
On 19 March 2013 21:40, amar takale wrote
o excel-macros+unsubscr...@googlegroups.com 'cvml', 'excel-macros%2bunsubscr...@googlegroups.com');>.
> To post to this group, send email to
> excel-macros@googlegroups.com 'excel-macros@googlegroups.com');>
> .
> Visit this group at http://groups.goog
The problem is that you are replacing a string with another string when you
want to replace it with a formula
So Try
ActiveCell.formula =Replace(ActiveCell.Value,"#","=",1,,vbTextCompare)
Regards
David Grugeon
On 16 March 2013 04:10, André D'Avila wrote:
>
It works perfectly on my spreadsheet.
I think you filled the dates using a formula. Change xlFormulas to
xlValues.
It would also be good to put Dim r as Range at the head of the macro.
Regards
David Grugeon
On 15 March 2013 23:47, Prashant Pednekar wrote:
> Dear Dave, and other frie
trying to force you to use the cloud, they then
think that the cloud is an unsafe place so disable macros by default.
Regards
David Grugeon
On 15 March 2013 07:28, Wayne Field wrote:
> I moved up to Excel 13 less than a month ago with functioning
> spreadsheets. Last night Microsoft wip
In the This Workbook module put the following Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheet1.TextBox1.Text = ""
ThisWorkbook.Save
End Sub
Regards
David Grugeon
On 14 March 2013 19:37, Umesh Gupta wrote:
>
>
> --
> From: u
o excel-macros+unsubscr...@googlegroups.com 'cvml', 'excel-macros%2bunsubscr...@googlegroups.com');>.
> To post to this group, send email to
> excel-macros@googlegroups.com 'excel-macros@googlegroups.com');>
> .
> Visit this group at http://groups.google.co
It is just a case of illiteracy. Sales recruiter evidently cannot read or
he/she would see that the rules include:
5) Jobs posting is not allowed.
Regards
David Grugeon
On 13 March 2013 14:20, अनिल नारायण गवली wrote:
> Dear SalesRecruiter,
>
> What we do
This works
Application.OnTime Now() + TimeValue("00:00:05"), Sheets("Test").CodeName &
".CommandButton1_Click"
Regards
David Grugeon
On 11 March 2013 21:52, Santosh V wrote:
> Waiting for reply..
>
>
> On Mon, Mar 11, 2013 at 2:07 PM, San
the name of the file in the brackets you double up the quotes so two double
quotes. VBA will treat them as a single double quote when it interprets
the string.
I haven't tested this but I think it is about right.
Regards
David Grugeon
On 11 March 2013 04:26, Santosh V wrote:
> Private Su
p may have plenty of time to spare and be willing
to donate that time.
Regards
David Grugeon.
Regards
David Grugeon
On 11 March 2013 16:33, karthikeyan sankaran wrote:
> Hi,
>
> Thanks for your reply.
> I need Active cell Row&Column. Whenever open the workbook it will show
&
group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.goo
m the help file, or is it just wrong?
Regards
David Grugeon
--
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. P
**googlegroups.com.
>>>>>>> To post to this group, send email to excel-...@googlegroups.com.
>>>>>>>
>>>>>>> Visit this group at http://groups.google.com/**
>>>>>>> group/excel-macros?hl=en<http://groups.google.c
Why did you post this?
Rule 5) Jobs posting is not allowed.
You have done this before. Please do not do it ever again.
Regards
David Grugeon
On 5 March 2013 12:15, pankaj sangotra wrote:
> Job Description
> * Should have good knowledge of Work force management * Prepare
the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com 'cvml', 'excel-macros%2bunsubscr...@googlegroups.com');>.
> To post to t
Wow That is neat. Thanks I need to try and remmember that.
On Thursday, July 26, 2012 12:56:39 AM UTC-4, अनिल नारायण गवली wrote:
> Dear Tony,
>
> U can use without macro
> Just select the range and press ctl+G of press F5 function key .
> Then click to blank cell and use Alt+E+D select the
=SUMIF(A2:A7,F9,OFFSET(A2:A7,0,CODE(F8)-64))
Regards
David Grugeon
On 1 March 2013 11:50, Venkat CV wrote:
> Hello Everyone,
>
> I have enclosed sample file were i required formula assistance If I
> select 2 Criteria's and needs to sum up based on ROW&Column criteria&#x
This thread makes me think you are typing in the names of your named
ranges. It is bettter to press F3 and double click the name to add it.
Makes sure there are no typos in the name.
Regards
David Grugeon
On 28 February 2013 18:03, Bé Trần Văn wrote:
> Go to Insert> Name> Defin
xcel-macros%2bunsubscr...@googlegroups.com');>.
> To post to this group, send email to
> excel-macros@googlegroups.com 'excel-macros@googlegroups.com');>
> .
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https
open sub has not run.
Regards
David Grugeon
On 27 February 2013 16:49, amar takale wrote:
> Dear All,
> Can anyone tell me how I can allocate an F-key to open a particular
> worksheet.I will try but not successful. Pls see below link,same issue.
>
>
> https://group
=sumif(C2:C50,"<6500",C2:C50)+countif(C2:C50,">=6500)*6500
Regards
David Grugeon
On 23 February 2013 20:36, Ranjeet Negi wrote:
> Dear Sir,
>
> I have a data in Range (C2:C50). There are values. I want to sum all
> value upto or equal to 6500, wherein
Assuming the first value is in A2
In B2 put =left(A2,1)
In C2 put =mid(A2,2,4)
Drag these formulas down.
Regards
David Grugeon
On 23 February 2013 16:14, Harkesh Kumar wrote:
>
>
>
> Please solve this Problem
>
>
>
> Please Seperate Special character and number
&
number.
0.1770833 or thereabouts.
When we apply a time format h:mm to this it displays as 4:15.
QED
Regards
David Grugeon
On 22 February 2013 21:30, David Grugeon wrote:
> try this
>
> If the value is in B3 use then formula
>
> =(int(B3)+mod(B3,1)/.6)/24
> then format as h:mm
&
try this
If the value is in B3 use then formula
=(int(B3)+mod(B3,1)/.6)/24
then format as h:mm
Regards
David Grugeon
On 22 February 2013 20:36, The Viper wrote:
> excel will not hold a value as 2.30 with full decimal(2). We
> can derive the desired result by formula if you intend.
&
u want it to apply
to)
PasteSpecial/Formats
It should be easier but I could not get it to work to just apply
conditional formatting to the range.
Regards
David Grugeon
On 21 February 2013 01:50, solsbee wrote:
> I have a spreadsheet that the data is keyed in one cell, then multiple
>
Hi Paul - OOPS! I didnt see you had finished it. Sorry.
Regards
David Grugeon
On 20 February 2013 07:08, David Grugeon wrote:
> Hi Paul
>
> What i think the OP wants is
>
> If a person started in the year he wants the end date of the year (31
> December) minus Start
the year and ended after the year he wants 365
or 366 in that year column.
Regards
David Grugeon
On 19 February 2013 22:42, Paul Schreiner wrote:
> I'm really very sorry, but your explanation continues to make no sense.
> Basically, it's this:
> You want the number of day
tax =
value*1.392+value*1.392*0.06
=value *1.392*1.06
=value*1.47552
so the Custom duty, plus the Sales tax plus the income tax is
Value*0.47552
This is the formula you need in the single cell if the value is in A3
*=A3*0.47552*
Regards
David Grugeon
On 19 February 2013 17:48
Hi Anton
How are you calling the sub?
Regards
David Grugeon
On 20 February 2013 04:40, Anton Jopko wrote:
> Hi David,
> I tried your suggestion but still no luck. I may have to get a VBA book
> that is simpler than the one i have.
> Thanks for looking at my macro though,
> an
1 - 100 of 309 matches
Mail list logo
