Hi,
Usr adodb recordset object and sql query to retrive data. And use
"copyfromrecordset" method to add data in excel.
Regards,
Swapnil
On Feb 3, 2013 3:17 PM, "rekha siri" wrote:
> hi Group,
>
> Need your expertise help i along with my friends uploaded some excel file
> into Access .
>
> Now
Hi experts,
Please check the macro here ,my workbook have 31 sheets each page
represents particular days in the month.I want work the macro in all
the pages one by one . I don't know how to write a loop for this,
Kindly help me.
Sub Macro1()
Range("H2").Select
ActiveCell.FormulaR1C1 = "abc
I think u are using Excel 2003 or lower version in which max. row no. is
65536.
So, Try with Excel 2007 or Higher version..
Regards,
utpal
On Sun, Feb 3, 2013 at 3:16 PM, rekha siri wrote:
> hi Group,
>
> Need your expertise help i along with my friends uploaded some excel file
> into Access
I agree with Paul in most respects.
I would do one macro which does all 3 things.
I would start from the top rather than from the bottom because the macro
would be accumulating the two subtotals as it ran and then inserting the
two rows, colouring them and populating them.
I am assuming that the
it looks good,
On Thu, Feb 7, 2013 at 5:47 AM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
> Dear Experts,
>
>
>
> I been to one of the academy to enquiry above VBA & Macros, please find
> the attached broacher
>
> I'm not aware anything abt it & I want to learn VBA & Macros.
SORRY FOR LONG FORMULA, BUT INSTANT
=INDEX(Database!$A$2:$A$23,IF(MAX(IFERROR(MATCH(TRIM(MID(SUBSTITUTE(A2,"
",REPT("
",LEN(A2))),((ROW($1:$4)-1)*LEN(A2))+1,LEN(A2))),Database!$A$2:$A$23,0),"-"))=0,NA(),MAX(IFERROR(MATCH(TRIM(MID(SUBSTITUTE(A2,"
",REPT("
",LEN(A2))),((ROW($1:$4)-1)*LEN(A2))+1,LEN(
Dear Experts,
Can someone please provide me below ppt
Thanks
Manjunath
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Manjunath Narayanappa
Sent: 05 February 2013 10:30
To: 'excel-macros@googlegroups.com'
Subject: $$Excel-Macros$$ Macro
Dear Experts,
C
Hi Experts
Can i perform machine learning techniques on Excel...if so can i have copy
and understand how to use it.
Thanks you so much in adv
Sri
--
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 @
This only finds the first character. That's not what is needed. The
function needs to check the availability of any of the nth word in the
sentence. So in the example, ANNA GRATTON LTD should have returned GRATTON.
Your formula only looks up the first word.
On Thu, Feb 7, 2013 at 7:18 PM, vijay
I often tell people that VBA and Excel can do ANYTHING.
all it takes is time (and $$)
So, given that.
The question isn't CAN it do it, but how easy is it to do?
The first macro is simple.
You really start from the bottom up and insert the two rows when the value
changes.
mainly because when you
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 wrote:
> Hi Friends,
>
> Need a help to create macro in a "Data" tab where it can recongnize a word
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 mobile phone numbers and the supplier information has
multiple rows against any one mobile number, but against700 to
Hi Excel Lerner,
Change your Top margin 0.85 centimeters.
If you use HP Laser Jet 1020. Please find below URL:
http://h10032.www1.hp.com/ctg/Manual/c00264334.pdf
[image: Inline image 1]
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 971661553
Hi Rekha,
There one very simple way that you can try. Drag and drop the table (which
you want to export into excel) in a excel spreadsheet.
This also can be done through programming. Please let us know the above
mentioned tip doesn't work for you.
Thanks and regards,
Shekhar
On Sunday, 3
Dear Team,
*I know this is a excel group.*
But still i want to ask if any *one knows how to download add-ins for
microsoft word.*
my question is:-
After entering number it should be convert into text.
For example 123 (one hundred twenty three dollars only)
Aayushji:- please don't block me
T
Hi Kuldeep Sir
I didnt find any advance options in my printer settings.I am using HP laser
jet 1020 Plus
--
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
Yes Viper, your formula is totalling perfect
On Thu, Feb 7, 2013 at 2:19 PM, The Viper wrote:
> did you try =SUM(1/COUNTIFS(A2:A10,A2:A10,B2:B10,B2:B10,C2:C10,C2:C10))
> with CSE ???
>
>
> On Thu, Feb 7, 2013 at 2:44 PM, Smitha S R wrote:
>
>> Hi,
>> Required is :
>>
>>
>> Count of names matchi
did you try =SUM(1/COUNTIFS(A2:A10,A2:A10,B2:B10,B2:B10,C2:C10,C2:C10))
with CSE ???
On Thu, Feb 7, 2013 at 2:44 PM, Smitha S R wrote:
> Hi,
> Required is :
>
>
> Count of names matching product 'A' and Id '1S' is 4
> and count of names matching product 'A' and ID '2B' is 4
>
>
> On Thu, Feb 7,
Hi,
Required is :
Count of names matching product 'A' and Id '1S' is 4
and count of names matching product 'A' and ID '2B' is 4
On Thu, Feb 7, 2013 at 2:40 PM, Aamir Shahzad wrote:
> check now
>
> =COUNTIFS($A$2:$A$10,A5,$B$2:$B$10,B5,$C$2:$C$10,C5)
>
> On Thu, Feb 7, 2013 at 1:58 PM, Smitha S
check now
=COUNTIFS($A$2:$A$10,A5,$B$2:$B$10,B5,$C$2:$C$10,C5)
On Thu, Feb 7, 2013 at 1:58 PM, Smitha S R wrote:
> Hi,
> This formula does not suit my requirement. I have to count the names
> matching the product and ID.
>
>
> On Thu, Feb 7, 2013 at 2:09 PM, Aamir Shahzad
> wrote:
>
>> You c
Hi,
This formula does not suit my requirement. I have to count the names
matching the product and ID.
On Thu, Feb 7, 2013 at 2:09 PM, Aamir Shahzad wrote:
> You can use:
>
> =COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,B2)
>
> Aamir Shahzad
>
> On Thu, Feb 7, 2013 at 1:36 PM, Smitha S R wrote:
>
>> Hi,
>
use =SUM(1/COUNTIFS(A2:A10,A2:A10,B2:B10,B2:B10,C2:C10,C2:C10)) with CSE
On Thu, Feb 7, 2013 at 2:09 PM, Aamir Shahzad wrote:
> You can use:
>
> =COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,B2)
>
> Aamir Shahzad
>
> On Thu, Feb 7, 2013 at 1:36 PM, Smitha S R wrote:
>
>> Hi,
>>
>> Please help me in findin
You can use:
=COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,B2)
Aamir Shahzad
On Thu, Feb 7, 2013 at 1:36 PM, Smitha S R wrote:
> Hi,
>
> Please help me in finding the count of unique values matching criteria as
> in the attachment.
>
> Regard
> Smitha
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Ex
Hi,
Please help me in finding the count of unique values matching criteria as
in the attachment.
Regard
Smitha
--
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
24 matches
Mail list logo
