Dear siti Vi,
Brillient!
Could you please give me some VBA assignments, so that i can try myself and
can improve my VBA skill.
Thank you once again for your kind help, hope it will continue...!
Many Thanks,
Sreekanth M
Mobile:9916941744
On Tue, Oct 12, 2010 at 8:56 AM, siti Vi wrote:
> pl
Hi Michael,
It would be easy for anyone in the group to respond, if you can send a set
of sample data.
Regards,
Andy
On Tue, Oct 12, 2010 at 5:35 AM, MikeMikeMike wrote:
> First of all thank you for any effort put in this direction. I am
> having problems with a couple excel formulas that I rea
sample data pls
On Tue, Oct 12, 2010 at 5:33 AM, DEF wrote:
> I have a file that is gl accts and $$ amts with a subtotal at the
> bottom. I need to copy down and then over and then come back up off
> of the subtotal line. I tried offset and resize but couldn't get it
> to do a row instead
Use pivot table. don't use vba for easy work like this.
On Mon, Oct 11, 2010 at 5:43 PM, sreekanth m
wrote:
> Hi All,
>
> Can someone help me to resolve the attached issue, to paste the unique
> records to Report sheet!
>
> I want to have the answer like the below one. But I am unab
if your list of data (some data = duplicated data) are stored in C3:C26
then *The Count of Unique Values *is
*=SUM(1/(COUNTIF(C3:C26,C3:C26)))*
best regards
siti
On Tue, Oct 12, 2010 at 7:13 AM, MikeMikeMike
wrote:
>
> I am having a problem with a forumla I am hoping someone out there can
>
Hi,
what about a hidden sheet?
On Mon, Oct 11, 2010 at 11:23 PM, hemant shah wrote:
> Hi All,
>
> Can you please help me with my query regarding the password change in VBA.
>
> Thanks in advance.
>
> Waiting for the resolution on my query.
>
> Regards,
> Hemant Shah
>
> --
>
>
Hi
I'm trying to have an interactive text box which I could input some
words and at the same time refer to a few different data cells in the
spreadsheet. I'm not familiar with VBA thus is there any easy way?
Many Thanks
--
--
I have a file that is gl accts and $$ amts with a subtotal at the
bottom. I need to copy down and then over and then come back up off
of the subtotal line. I tried offset and resize but couldn't get it
to do a row instead of a cell.
--
---
First of all thank you for any effort put in this direction. I am
having problems with a couple excel formulas that I really need to get
right for a client.
Here is the deal:
WORKSHEET 1
Column1 = email address
Column2 = ***This column I want the sum of events on new years but
having problems (St
I am having a problem with a forumla I am hoping someone out there can
help me with.
What I am trying to do is use a vlookup to give me the amount of
unique stores attributed to an email address. OR if it is better to
use one of the many SUM options (which one?) to create an additional
column to
updated one
On Mon, Oct 11, 2010 at 10:41 PM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> refer the attachment
>
> Srinivasan
>
>
> On Mon, Oct 11, 2010 at 10:21 PM, Rajesh K R
> wrote:
>
>> HI ALL EXPERRTS
>>
>> IS THERE ANY WAY TO FILTER THE DATA 1/10/10 TO 10/10/10
refer the attachment
Srinivasan
On Mon, Oct 11, 2010 at 10:21 PM, Rajesh K R wrote:
> HI ALL EXPERRTS
>
> IS THERE ANY WAY TO FILTER THE DATA 1/10/10 TO 10/10/10 IN EXCEL,
>
> THANKS IN ADVANCE TO HELP ME.
>
> RAJESH KAINIKKARA
>
> --
>
>
HI ALL EXPERRTS
IS THERE ANY WAY TO FILTER THE DATA 1/10/10 TO 10/10/10 IN EXCEL,
THANKS IN ADVANCE TO HELP ME.
RAJESH KAINIKKARA
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
The trick here is to understand that Excel doesn't know anything
about "dates" and "time".
What it does is take the number of days since 1/1/1900
and INTERPRETS it as days and fraction of days.
So..
10/11/2010 @ 6:37pm is actually
40462 days since 1/1/1900
and .775694 of another day,
or 40462.7
hi excel experts i have a small problem
MY DATE AND TIME FORMAT IS "mm/dd/ hh:mm am/pm"
I WANT
TO CHANGE COL: A CHANGED IN TO COL:A"
=
col:a col:a
=
10/11/2010 18:37
How are you calling the function?
I copied your function to a module.
I changed it to:
Function DeviceForm(rng As Range) As String
If UCase(rng.Value) = "X" Then
MsgBox "Row: " & rng.Row
End If
End Function
so that I didn't have to create a userform.
then put a "X" in A2.
in B2 I
I have a simple function that looks at a single cell for it's value.
If it's an X, then i'd like for a form to appear. I'd like to pass
the value rng.row to the form so I can know which row I'm
manipulating. I've failed so far in my attempts to do just that. Any
tips would be awesome.
Function
Dear,
Please find herewith VBA vlookup
one
Value look up in column 1 6
Value look up in column 2 vlookup2(F10, F11, tLookupDemo, 3) Result
Option Explicit
''
Dear Alan
Apply tis formula and your problem will be over.
VlOOKUP Function needs 4 parameters your 1st,2nd,& 4th parameters are
correct but in the 3rd parameter (Column no.) you supplied the column
address that is $E:$E. I have just changed it to column no. 2 which is
second column of your table w
Dear Alan
Apply tis formula and your problem will be over.
VlOOKUP Function needs 4 parameters your 1st,2nd,& 4th parameters are
correct but in the 3rd parameter (Column no.) you supplied the column
address that is $E:$E. I have just changed it to column no. 2 which is
second column of your table w
Hi Alfred,
Please don't apologise for your English. We are quite tolerant here.
Have a look at the attached. First click on the 'Subject' buttons. You will
notice that clicking any one of them puts a "Yes" in it's Row, and changes the
other Rows to "No".
Use these buttons to select which subj
21 matches
Mail list logo
