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
y wrote:
>
> No david..that sheet contains no macros, even very less formula. Only the
> thing is some cells have formatted...
>
> Prabhu R
> On May 23, 2013 5:20 PM, "David Grugeon" wrote:
>
> Also do you have macros which are run when changes are made to the sheets.
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
;);>.
> 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
=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
Hi Anton
How are you calling this sub? You are probably calling it without
specifying Target.
You might need to start it like (untested)
Private Sub Accounting_type2()
Dim Target as range
Set Target = ActiveSheet.ActiveCell
Regards
David Grugeon
On 19 February 2013 00:58, Anton Jopko
Following message posted direct to Anton by mistake. It worked.
Regards
David Grugeon
-- Forwarded message --
From: David Grugeon
Date: 17 February 2013 07:16
Subject: Re: $$Excel-Macros$$ how to get cumulative sum in a cell
To: anton
Have a look at this link. The solution
e workbook to avoid
this.
Regards
David Grugeon
On 18 February 2013 15:30, अनिल नारायण गवली wrote:
> Dea Orabakar,
>
> Pl find attached herewith . Password is hide.
>
> Regards,
> Gawli Anil
>
> On Mon, Feb 18, 2013 at 9:18 AM, Prabhakar S H wrote:
>
>> Hi,
>
rkbook was issued (and after it came back to me if relevant).
If you have an earlier version of Excel you can do the same things but
someone else may need to tell you where to find the tools.
Regards
David Grugeon
On 18 February 2013 13:48, Prabhakar S H wrote:
> Hi,
>
> I have different
r...@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.google.com/
Perhaps it is an employment test. Anyone who knew Excel would know there
is no Ylookup. Someone who was not familiar with excel might invent a
meaning for it!
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
Perhaps it is an employment test. Anyone who knew Excel would know there
is no Ylookup. Someone who was not familiar with excel might invent a
menaing for it!
Regards
David Grugeon
On 16 February 2013 18:57, Rajan_Verma wrote:
> *I have year only two dimension in excel. One is verti
I suggest restarting the computer. In win8 it is not obvious how to do
this. I type the Windows key and then type Shutdown. this brings up the
shutdown App. Then you click Commands in the menu and restart.
Regards
David Grugeon
On 16 February 2013 03:23, anton wrote:
> Hi Dave,
>
ooglegroups.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.com/group/excel-macros?h
change in server paths on your network could
be responsible.
Regards
David Grugeon
On 15 February 2013 02:52, sreekanth m wrote:
> Dear Experts,
>
> I have an Excel tool which takes data from ALM(HP) tool and prepare the
> reports.
>
> *Now very frequently the TOOL is getting cr
You are much more likely to get a response if you use an appropriate
subject line and explain much more fully what you want. I, for one, cannot
understand the question and therefore I am not going to waste my time
trying to answer it.
Regards
David Grugeon
On 12 February 2013 21:39, Prabhakar
t; Thanks & Regards,
> Prajakt Pande
> +971551388482
> **
>
>
> On Mon, Feb 11, 2013 at 11:28 AM, David Grugeon
>
> > wrote:
>
>> There is some actual vba code
>> On the MS website at
>> http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q21
EXE file. as per
> company policy.
>
> Please help. if it is keyboard shortcut it will be very good.
>
> Thanks & Regards,
> Prajakt Pande
> +971551388482
> **
>
>
> On Sun, Feb 10, 2013 at 4:29 PM, David Grugeon wrote:
>
> I tried it and it works fine. After
Hi Joseph
It is certainly possible. I don't really have the time to do it right now.
I am very busy at work but someone else may be able to help.
On Sunday, 10 February 2013, joseph camill wrote:
> can I get the same in vba
>
>
> On Sun, Feb 10, 2013 at 5:18 AM, David Grug
green
square, it inserts the text after the number.
Regards
David Grugeon
On 10 February 2013 21:51, Prajakt Pande wrote:
> I tried this also but doesn't work.
>
>
>
>
> Thanks & Regards,
> Prajakt Pande
> +971551388482
> **
>
>
> On Sun, Feb 10, 2013 a
It looks as though you right click on the number and then click "spell
Number"
Regards
David Grugeon
On 10 February 2013 21:10, Prajakt Pande wrote:
> Dear David,
>
> I install but i didn't understand following sentence.
>
> Do not forget! The ''Sp
try semicolons instead of commas
Regards
David Grugeon
On 10 February 2013 20:08, Sreejith K.V wrote:
> Hi There,
>
> I have tried adding the below number format code in the custom tool bar.
> But i not getting the desired result. Can someone help me in fixing this
> and let me
Hi Prajakt Pande
Go to this web link and download.the com add-in
http://cpap.com.br/orlando/WordSpellNumberMore.asp?IdC=OMKtPlc
If you have problems with it let us know and we will try to help.
Regards
David Grugeon
On 10 February 2013 19:59, Prajakt Pande wrote:
> Dear David,
>
&g
en dollars only) June 2013"
If you give some more though to exactly what you want aqnd get back to us
someone will be able to assist you.
Regards
David Grugeon
On 10 February 2013 15:01, black panther wrote:
> Dear Team,
>
> Please help in this.
>
> On Thursday, February 7,
you want.
Regards
David Grugeon
On 1 February 2013 14:26, joseph camill wrote:
>
>
> database.xlsx<https://docs.google.com/file/d/0B3PqgZIh0KQSMnhNY3RLWVRDcW8/edit>
>
> Hi,
>
> Attached is the excel, for which I need some help.
>
> I want to paste data fro
these items.
Regards
David Grugeon
On 7 February 2013 23:14, FreeRangeJ wrote:
> I'm building a template for processing supplier billing data with the
> corresponding process documentation for someone else to use the template on
> a monthly basis.
>
> It's based on mob
No
Your request was to copy product codes from the excel cells to the word doc.
Regards
David Grugeon
On 5 February 2013 10:19, wrote:
> **
> Can we pull excel tables, charts and smart art diagram using mail merge!!
>
> Looking for some advice
> Thanks
> Harneet
> Sent o
his 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 this group, send email to
> excel-macros@googlegroups.com 'excel-macros@googlegroups.com')
://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
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 f
1 for 1 match
with the input descriptions (although in a different order)?
4) are you going to want to do any arithmetic within the report or is it
just a case of reordering the input for each region?
Regards
David Grugeon
On 3 February 2013 17:01, David Grugeon wrote:
> Hi Joseph
>
&
solution.
1)
Regards
David Grugeon
On 3 February 2013 16:43, wrote:
> **
> Does anyone in the group does not have solution to check its row heading
> and column heading and paste the data.
>
> Sent on my BlackBerry® from Vodafone
> --
> *From: * jo
k, save it
somewhere, and then restore it, but I suspect that is not possible.
Regards
David Grugeon
On 2 February 2013 15:56, pawel lupinski wrote:
> Hi All,
> I've macro like:
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> If Not Intersect(Target,
There are Microsoft office specialist exams in each product in office. You
can just do the excel one. It is not an online exam but is conducted in
various centres. See the Microsoft website for details.
Regards
David Grugeon
On 1 February 2013 00:58, Manjunath Narayanappa
fully.
Regards
David Grugeon
On 1 February 2013 04:27, santhosh qatester wrote:
> Hi,
>
> I have the value as below in one cell which should assign the
> Today's date to particular value
>
> WHERE( ImportDate= Today())
>
> How to assign today's date to the
if there is any doubt
(or things don't work).
It looked a bit like saying x=worksheet("Sheet1").value to me.
Anyhow it looks like a minor change has caused you some recoding. Good
luck!
Regards
David Grugeon
Regards
David Grugeon
On 29 January 2013 07:06, Paul Schreiner wrote:
&g
Put
Learn . net
into Google and you will get about 74 million possibles
Regards
David Grugeon
On 30 January 2013 17:52, hanumant shinde wrote:
> Hi friends,
>
> i dont know ANYTHING about .net. and now want to learn it does anybody
> know how shud i start with it.
> Any si
your logon or else
gicve the scheduler logon access to all the resources needed.
You probably have set up a user for the Scheduler. Try logging on as that
user and then open the file and test the macro.
Regards
David Grugeon
On 29 January 2013 09:49, Richard wrote:
> I have a workbook whi
Check on that machine that the reference to Excel is ticked.
Check that Excel or office is installed on that machine.
Regards
David Grugeon
On 29 January 2013 05:19, hanumant shinde wrote:
> Hello Friends,
>
> set xyz = new Excel.Application
>
> I am getting error no. 48 (E
1 - 100 of 245 matches
Mail list logo
