Check the attached file.
Praveen
On Fri, Feb 5, 2010 at 11:27 AM, ashish koul wrote:
> any help
> On Thu, Feb 4, 2010 at 8:46 PM, ashish koul wrote:
>
>> hi
>>
>> i have a input in sheet 1 and its not limited
>>
>> and want result in sheet2 like in col1
>>
>>
>> regards
>>
>> ashish
>>
>
> -
Dear Harpreet ,
If you open the file in 2007 and File>Save As to 2003 format
that will solve the issue.
You can take your friends help who have 2007
Sanjoy
On Sat, Feb 6, 2010 at 8:01 AM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:
> Hi Group,
>
> I work on Office 2003, and
Dear Suresh,
Please find the solution
Sanjoy
On Fri, Feb 5, 2010 at 5:11 PM, Sivakumar E.S wrote:
> Hi
>
> Find attached solution for your problem.
>
> Regards
> Sivakumar ES
>
>
>
>
>
> On Fri, Feb 5, 2010 at 3:32 PM, suresh k wrote:
>
>> Hi,
>>
>> I have the very large data to consolidat
Dear Nick ,
you should use the cde to unprotect the sheet
ThisWorkbook.Unprotect (Password)
'do all your tasks
'then finally
ThisWorkbook.Protect (Password)
This will resolve your issue
Sanjoy
On Fri, Feb 5, 2010 at 5:56 PM, Nick wrote:
> Hello all,
>
> I have small problem after
Hi Group,
I work on Office 2003, and it becomes a problem to work on a xls made in
office 2007. Any ideas to convert into office 2003. Please suggest
Harpreet Gujral
--
--
Some important links for excel users:
1. Fo
The comparison:
if (list(i) > list(i+1))
is an ALPHANUMERIC comparison.
that is, it compares characters left-to-right and checks the ASCII value of
each character.
So, in the case of Sheet10 and Sheet2,
S=S
h =h
e=e
e=e
t=t
1<2
so it stops here, because it does not recognize "10" as a discrete "n
Thanks Alot for your support, that means alot
Hugs & One Love
On Fri, Feb 5, 2010 at 11:52 AM, Sanjoy Nath wrote:
> Dear janet dickson,
> Your problem is solved.
> I am sending the file attached herewith.
>
> Sanjoy
>
>
>
> On Thu, Feb 4, 2010 at 11:17 PM, janet dickson wrote:
>
>> Hello frends.
Hi
Check on this link
http://www.ozgrid.com/Excel/run-macro-on-time.htm
On 2/5/10, Ashok Renga wrote:
>
>
>
>
> hi all
>
>
> iam posting my query to one of the best group in google groups, excel dons
> please help me
>
>
>
>
> my query is , i want to copy column a and b at 11 am time everyday
Private Sub Workbook_Open()
Application.OnTime TimeValue("21:59:00"), "time1"
End Sub
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Application.OnTime TimeValue("11:00:00"), "time1"
End Sub
Sub time1()
Application.OnTime
TimeValue ("11:00:00"), "time1"
Column
thx for your code. Is that While part of a Do While Loop. I want to
look at your code more closely after the weekend. I took your advice
and I added more pages to the workbook, about 10, with varying names
and the results were slightly unpredictable. I left some of the sheets
with their default nam
Hi Madajah,
Attached is the updated solution with the new condition.
Best regards,
Ayush Jain
Group Owner
On Fri, Feb 5, 2010 at 5:43 PM, Putta Madaiah wrote:
> Hi Ayush,
>
> Thanks for the formulas. It will be great also if you can consider only for
> "N" under column 'Doc Type'.
>
> Regards-
dear sirs
thanks of lot
very helpful ur guide
regards
kavi
On Feb 4, 4:54 pm, Alokeshwar Tiwary
wrote:
> PFA from vbaexpress.com
>
> Regards,
> Alokeshwar
> +1 617 710 8441
>
> _____
> "There are known
hi all
iam posting my query to one of the best group in google groups, excel dons
please help me
my query is , i want to copy column a and b at 11 am time everyday to
another sheet
is it possible
thanks
ashok
--
Hello all,
I have small problem after writing a code that hides/unhides certain
rows based on cell with a drop down list of variables. I find that
when i password protect the sheet and select from the drop down list,
the rows do not get hidden according to the selected variable. So in
essence, the
Hi Ayush,
Thanks for the formulas. It will be great also if you can consider only for
"N" under column 'Doc Type'.
Regards- Madaiah
On Thu, Feb 4, 2010 at 8:19 PM, ayush jain wrote:
> Hi Madaiah,
>
> Attached is the solution for you. I have used countifs formula for the
> solution.
> Let us kn
Hi
Find attached solution for your problem.
Regards
Sivakumar ES
On Fri, Feb 5, 2010 at 3:32 PM, suresh k wrote:
> Hi,
>
> I have the very large data to consolidate. To consolidate I need a formula.
>
> Below is the example.
>
> My Input data will be
>
> *Input*
> Hari
> Yes
> Hari
Hi Suresh,
Please use pivot Table.
On Fri, Feb 5, 2010 at 4:09 PM, Sanjoy Nath wrote:
> Please give the file attached
> I will make it for you.
>
>
>
> On Fri, Feb 5, 2010 at 3:32 PM, suresh k wrote:
>
>> Hi,
>>
>> I have the very large data to consolidate. To consolidate I need a
>> formula.
Hi Sanjay,
Pls find sample file and let me know if you could help me on this.
On Fri, Feb 5, 2010 at 4:09 PM, Sanjoy Nath wrote:
> Please give the file attached
> I will make it for you.
>
>
>
> On Fri, Feb 5, 2010 at 3:32 PM, suresh k wrote:
>
>> Hi,
>>
>> I have the very large data to conso
Please give the file attached
I will make it for you.
On Fri, Feb 5, 2010 at 3:32 PM, suresh k wrote:
> Hi,
>
> I have the very large data to consolidate. To consolidate I need a formula.
>
> Below is the example.
>
> My Input data will be
>
> *Input*
> Hari
> Yes
> Hari
> No
> Hari
>
Hi,
I have the very large data to consolidate. To consolidate I need a formula.
Below is the example.
My Input data will be
*Input*
Hari
Yes
Hari
No
Hari
Yes
Hari
No
Hari
No
Girish
Yes
Girish
No
Girish
Yes
Girish
Yes
Girish
Yes
Girish
No
Girish
No
And output data s
Dear Paul,
If you set the important calculations with Macro , then people will
become bound to enable macros.That will help you to achieve your motive.
Sanjoy
On Thu, Feb 4, 2010 at 9:44 PM, PWS wrote:
> Interesting situtaion which I sure others have come across before. I
> cannot think of
Dear Ramesh,
Please save the file in 2003 format ans send.
I will Solve the problem for you.
Sanjoy
On Thu, Feb 4, 2010 at 6:46 PM, Ramesh-Hyderabad wrote:
> Hi Gurus,
>
> I have a requirement where I have to check for the minimum date and
> maximum date instances for each employee and concat
22 matches
Mail list logo
