Hi all
I'm trying to learn how to connect to SQL Server and extract information
from Excel.
The code below is one I got it from one of site and modified a bit (After
reading a book about ADO)
When I run the code, I get the following error
Complie error:
User-defined type not defined
Then
Hi Daniel
Works perfect. I am very pleased with your help.
Regards
Charlie
On Wed, Jul 20, 2011 at 10:04 PM, Daniel wrote:
> My last effort ; see attached file.
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Cab Boose
> *Envoyé
Dear All,
I Have attached data sheet with Login Logout timings..i want how much time
they were in work...Pure Login hrs
have tried one formula...it's working for first 2 Employess not working for
all...
Please suggest any formula or VBA code...
Example:
Data:
User Name Status Login & Lo
Hi Haseeb,
A sort of masking. Simple and excellent!
However, if a 'Yes' appears in the last column, the count is incorrect by 1.
You could possibly include an If statement to test for this.
Or you could modify the formula slightly:
=SUMPRODUCT(--(A2:T2="Yes"),--(B2:U2<>"Yes"))
This works, but requ
I have multiple columns (around 140) of data and need to conditionally
format the data as apposed to looping through.
For instance I have the following data in column A and B.
A B
1 10
2 1
8 4
4 3
5 6
Here is basically what I'm trying to do:
If Column A has a value Greater than Column B then cha
Hello Azeema,
Use this formula, say in V2 & copy down.
=COUNTIFS(A2:S2,"Yes",B2:T2,"<>Yes") This will only work XL2007 or later.
If you want to work with XL 2003 or prior use SUMPRODUCT
=SUMPRODUCT(--(A2:S2="Yes"),--(B2:T2<>"Yes"))
See the attached
HTH
Haseeb
--
--
Thanks to both Ashish and GoldenLance. Problem solved.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ htt
There is incompatibility in the way both versions are handling pivots. If
you are to design pivots with Excel 2007 for Excel 2003 users, you should
run Excel 2007 in compatibility mode.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de
Hi Anish,
Please find attached the sample file with one row filled.
And Column "C" & Column "H" concatenate should give us unique value so if
this is repeated then we need to have below requested feature.
Hope this would be more clear now.
Thanks
Harish
On 20 July 2011 21:32, Anish Shrivastava
Dear Ashish,
Pls help,
Whenever i am creating a pivot table in Excel 2007 and using some calculated
fields into that, after that if i am saving that file into Excel 2003, so
all the pivots are getting past special automatically.
Pls help with this issue,
--
Pankaj Pandey
Bhopal
--
---
How do I edit my preferences such that I do not receive a message everytime
someone posts a discussion with $$Excel-Macros$$ tagged?
H3lue
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Hi Anwar,
Please run the below code and see if it works fine..
--
Sub conc_test()
Dim main_word As String
'cell_pointer = 0
lastrow = Sheets(1).Range("A2").End(xlDown).Row
counter = 3
While counter <= lastrow
Set present_cell = Range("E" & counter)
Set present_cell1 =
One sample sheet would be helpful to us to see the data structure.
However, for this "*Also identifiy if there is any row duplicated and
highlight them and paste them into another sheet" * There must be any
particular data field which has to be checked against others in order to
find duplicates.
Hi,
I had a macro file which was able to consolidate small files but now I have
a requirement to consolidate 30 workbooks saved in a share drive and this
data may even cross 66000 row after consolidation. Can someone help me in
creating a macro which picks all the file from shared folder and
conso
hi anwar,
plz clarify ur query
On Jul 19, 10:56 pm, john wrote:
> I sorta see from the notes below the data what you are trying to do,
> but the sample results do not seem to match the data. ??? please
> check it for correctness or explain further how you reached those
> results
>
> On Jul 19,
This is Free on internet, Please search
EXCEL Charts.and.Graphs.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Tuesday, July 19, 2011 11:38 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Books
Hi,
I need
Thanks Ankur
On Wed, Jul 20, 2011 at 7:19 PM, ankur wrote:
> hi kaushik
> plz use this formula
> =SUM(IF(A2=1,A2,0),IF(B2=3,B2,0),IF(OR(C2=1,C2=2),C2,0),IF(D2=1,D2,0))
> sample file is attached for ur reference
>
>
> On 20/07/2011, Aindril De wrote:
>> Hi Kaushik,
>>
>> The criteria that you hav
See if it help
I have create a Toggle Button For You ..
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of bpascal123
Sent: Wednesday, July 20, 2011 4:26 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ excel user form o
hi kaushik
plz use this formula
=SUM(IF(A2=1,A2,0),IF(B2=3,B2,0),IF(OR(C2=1,C2=2),C2,0),IF(D2=1,D2,0))
sample file is attached for ur reference
On 20/07/2011, Aindril De wrote:
> Hi Kaushik,
>
> The criteria that you have mentioned is not clear enough. Please clarify the
> critera properly.
> Do
Hi Azeema,
Here comes the macro for this. (see the attached file)
*Hey Dave,*
Have seen your post after a really long time. :)
Cheers
On Wed, Jul 20, 2011 at 6:16 PM, Dave Bonallack
wrote:
> Hi Azeema,
> Have a look at the attached to see if it meets your needs. The formula is
> really cumber
Nice one Dave!
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
Dear Vijay,
Please provide sample sheet
On Wed, Jul 20, 2011 at 5:49 PM, vijayajith VA wrote:
> Hi,
>
>
> 1;
> I have several names in two sheets..i need to merge it in one sheet...is
> this possible using formula..
>
> Thanks
>
>
>
> --
>
> -
To get round the formula length problem I've used 2 helper columns
Cell U2 contains the formula
=IF(B2="yes",1,0)+IF(AND(B2="yes",C2="yes"),0,IF(AND(B2="no",C2="yes"),1,0))+IF(AND(C2="yes",D2="yes"),0,IF(AND(C2="no",D2="yes"),1,0))+IF(AND(D2="yes",E2="yes"),0,IF(AND(D2="no",E2="yes"),1,0))+IF(AND
Hi,
1;
I have several names in two sheets..i need to merge it in one sheet...is
this possible using formula..
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
I'm trying to write a macro that detects when a chart is clicked on in
any sheet in any workbook. This would include charts within a sheet
and charts in a separate sheet by themselves.
I understand how to catch application level events and was thinking
that the SheetSelectionChange event would giv
Hi Azeema,
Have a look at the attached to see if it meets your needs. The formula is
really cumbersome, but it's all I can think of at the moment.
Regards - Dave.
From: aze...@gmail.com
Date: Tue, 19 Jul 2011 23:44:14 -1000
Subject: $$Excel-Macros$$ adding adjacent (contagious) cells only
To: ex
Thanks Ashish,
Is it possible to attach the picture saved in computer??
Like, If I will mention the path of the image file in column E, and
excel will send that image in the body of outlook mail.
Also suggest me, I want to restrict the person, So they can not reply
and forward my mail.
As the opt
Dear Experts:
Let me see if I can explain this to you.
I am working on a research project which relates to time use from 6am to 12
pm, by different activities. (see attached data for a selected no of
respondents for Unpaid Work only). I would like to calculate "segments of
time" or unbroken chain
Would you please attached Workbook.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Cab Boose
Sent: Wednesday, July 20, 2011 2:10 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Data Input Sheet - Deleting Entries - all added
data deletes
Hi everyone
Excel 2000 Win7
I am using code below to enter data onto a sheet. The sheet works well in
entering data, but when you go back to an entry above and delete the current
data and put in the correct data, on the delete key it deletes all data
entered and user has to start over again.
Ho
You're a godsend!
On Wed, Jul 20, 2011 at 12:57 AM, Anish Shrivastava wrote:
> Tracking sheet.. I see.. I will have a look and try my best to give one
> dummy dashboard by tomorrow.
>
> On Wed, Jul 20, 2011 at 1:16 PM, Adam Hamilton
> wrote:
>>
>> However, I get your point, the data is not raw i
Tracking sheet.. I see.. I will have a look and try my best to give one
dummy dashboard by tomorrow.
On Wed, Jul 20, 2011 at 1:16 PM, Adam Hamilton wrote:
> However, I get your point, the data is not raw if I am adding a sum of
> spend based on resource allocation and budgetary spend.
>
> The 'ti
However, I get your point, the data is not raw if I am adding a sum of
spend based on resource allocation and budgetary spend.
The 'time tracking' sheet is supposed to be the 'raw' data, but since
it has been altered, I guess I have none..
On Wed, Jul 20, 2011 at 12:44 AM, Adam Hamilton wrote:
>
The 'time tracking' sheet is where all of the data are pulled to
populate the erroneous amount of fluff that you see in my xls
On Wed, Jul 20, 2011 at 12:35 AM, Anish Shrivastava wrote:
> Hi Adam,
>
> Great thing.
> I would request you again to send me only those sheets which you think are
> raw
Hi Adam,
Great thing.
I would request you again to send me only those sheets which you think are
raw data.
Your workbook contains many sheets (includin pivot sheets) which makes me
unsure that which sheet should I consider as a raw data sheet for dashboard.
As you said, your management wants to
35 matches
Mail list logo