date:20120801

Re: $$Excel-Macros$$ Excel 2010 Remove Duplication

2012-08-01 Thread Kuldeep Singh

Hi Sajal,

Please find the attached .xlsx. I hope it will help to you.

Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

On Wed, Aug 1, 2012 at 12:45 PM, Kuldeep Singh wrote:

>
> Hi Sajay,
>
> You can try Paste Link Option. Shortcut Key : - Alt+H+V+N OR, Sum Product
> Formula.
>
>
> Regards,
> Kuldeep Singh
> Phone.: +91-120-4763789, Extn.: 789
> naukrikuld...@gmail.com || www.naukri.com
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
> On Wed, Aug 1, 2012 at 12:04 PM, Sajay Yesodharan wrote:
>
>> the said file is a very complex one involving simultaneous function..
>> the concept is same
>>
>>
>> *A BC*
>>  1 TEST1 =B2  2 TEST2 =B3  3 TEST3 =B4  4 TEST4 =B5  5 TEST2 =B6  6 TEST5
>> =B7
>>
>> The *B* column will have names on alternative days and can be
>> repetitive. and *C* column is actually located below the actual range.
>> and it is summary of unique names above...(preferably links for first
>> occurrence)
>>
>>
>>
>>
>> YOurs..sajay
>>
>>
>>
>>
>>
>>
>> On Wed, Aug 1, 2012 at 11:00 AM, Kuldeep Singh 
>> wrote:
>>
>>>
>>> Okay Sajay,
>>>
>>> Please share a excel file.
>>>
>>> Regards,
>>> Kuldeep Singh
>>> Phone.: +91-120-4763789, Extn.: 789
>>>
>>> naukrikuld...@gmail.com || www.naukri.com
>>> *Please* *Consider the environment. Please don't print this e-mail
>>> unless you really need to.*
>>>
>>> On Wed, Aug 1, 2012 at 10:54 AM, Sajay Yesodharan wrote:
>>>
 thanks Kuldeep

 I was rather showing an abnormal function or may be bug. When tried
 with a macro the results seen erroneous so manually checked what 
 happened...

 Mine is more of a data entry requirement than reporting so each time
 these cells need alteration and summarizing...

 YOurs..sajay

 On Tue, Jul 31, 2012 at 5:30 PM, Kuldeep Singh >>> > wrote:

>
> You can try this functions:
>
> Pivot Table
> Remove Duplicates
> Countif
> Vlookup
> any more..
>
> Regards,
> Kuldeep Singh
>
> On Tue, Jul 31, 2012 at 2:34 PM, sajays  wrote:
>
>> Hi.. anobody noticed this?
>> if you try to remove duplicate fields via "Data -> Remove
>> Duplicates"  in formulas the result is erroneous..
>>
>> Just like this
>> A BC
>>  1 TEST1 =B2  2 TEST2 =B3  3 TEST3 =B4  4 TEST4 =B5  5 TEST2 =B6  6
>> TEST5 =B7
>>
>> if we try to find duplicates in C and get corresponding 'links' to B
>> it will work fine on clicking remove duplicate till this message
>>  #duplicate values found and removed; # unique values remain
>> then it will go wrong
>>
>>
>> YOurs..sajay
>>
>> --
>>
>
>
>

 --
 YOurs,

 sajay

  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.

 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com

>>>
>>
>>
>> --
>> YOurs,
>> sajay
>>
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+

$$Excel-Macros$$ help required

2012-08-01 Thread °•¤a®µn¤•°™

Dear Members,
Need a macro for converting one subtotal part into diffrent sheets from a
workbook.
10x & regards
Arun

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ help required

2012-08-01 Thread अनिल नारायण गवली

pl share us with some files..
Regards,
Gawli Anil.

On Wed, Aug 1, 2012 at 2:36 PM, ARUN(°•¤a®µn¤•°™) <> wrote:

> Dear Members,
> Need a macro for converting one subtotal part into diffrent sheets from a
> workbook.
> 10x & regards
> Arun
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

-- 
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Can anybody tell me about Indirect

2012-08-01 Thread Manoj Kumar

Hi,

Please provide value from use Indirect..



Regard
Manoj

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Book6.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ help required

2012-08-01 Thread NOORAIN ANSARI

Pls share a sample workbook with group

On Wed, Aug 1, 2012 at 2:36 PM, ARUN(°•¤a®µn¤•°™)
wrote:

> Dear Members,
> Need a macro for converting one subtotal part into diffrent sheets from a
> workbook.
> 10x & regards
> Arun
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.blogspot.com
http://accesssqclinic.blogspot.in/

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Curser not moving while editing

2012-08-01 Thread sharad jain

Hi All,

I can not move my curser directly in excel while editing.

In the attached example, if I want to make B2 to A2. I can not do it
directly. I have to actually type it in place of B2.

Can someone help?

Thanks.
Sharad

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Example.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Curser not moving while editing

2012-08-01 Thread NOORAIN ANSARI

Dear Sharad,

It is working on my system. once again Please  press on scrolllock button.

On Wed, Aug 1, 2012 at 4:38 PM, sharad jain  wrote:

> Hi All,
>
> I can not move my curser directly in excel while editing.
>
> In the attached example, if I want to make B2 to A2. I can not do it
> directly. I have to actually type it in place of B2.
>
> Can someone help?
>
> Thanks.
> Sharad
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.blogspot.com
http://accesssqclinic.blogspot.in/

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ How to calculate Days and Time. (Formula Req.)

2012-08-01 Thread Ashish kumar

Dear All,



Thanks for your help...!

Days will be calculating properly but how much (Time) Hrs/Min/Sec. will
consumed in the process according days, was not calculating. kindly provide
solution by formula or VBA & pls find the attached query sheet.





Thanks

Ashish kumar

-- Forwarded message --
From: vijayajith VA 
Date: 31 July 2012 22:49
Subject: Re: $$Excel-Macros$$ How to calculate Days and Time.
To: excel-macros@googlegroups.com


Please ignore.. showing wrong answer


On Wed, Aug 1, 2012 at 11:15 AM, vijayajith VA wrote:

> Hi kumar,
>
> Try this..
>
> =DATEDIF(A3,E3,"md")
> =TEXT(B3+F3,"[HH]:MM")
>
>
> On Tue, Jul 31, 2012 at 11:48 PM, xlstime  wrote:
>
>> PFA THE ATTACHED MAY BE SOLUTION
>>
>>
>>
>> On Tue, Jul 31, 2012 at 11:35 PM, Ashish kumar > > wrote:
>>
>>> Dear Champs,
>>>
>>> I need to consider the time difference between both the countries. I
>>> want to calculate the overall time consumed for the dispatch to be
>>> delivered, kindly find the attached example sheet of query.
>>>
>>>
>>>
>>> Thanks
>>> Ashish
>>>
>>> On 31 July 2012 10:58, ashish koul  wrote:
>>>
 can you attach the sample file


 On Tue, Jul 31, 2012 at 11:26 PM, kumar.ashish861 <
 kumar.ashish...@gmail.com> wrote:

> Dear Champs,
>
> I need to consider the time difference between both the countries. I
> want to calculate the overall time consumed for the dispatch to be
> delivered.
>
>
> Thanks
> Ashish
>
>
>
>
> On Monday, July 30, 2012 10:55:20 AM UTC-7, Paul Schreiner wrote:
>>
>>  What kind of solution are you looking for?
>> A formula or VBA?
>>
>>
>>
>>
>> *Paul*
>>
>> --**---
>> *“Do all the good you can,
>> By all the means you can,
>> In all the ways you can,
>> In all the places you can,
>> At all the times you can,
>> To all the people you can,
>> As long as ever you can.” - John Wesley
>> *--**---
>>
>>
>>  --
>> *From:* kumar.ashish861 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Mon, July 30, 2012 1:40:26 PM
>> *Subject:* $$Excel-Macros$$ How to calculate Days and Time.
>>
>>
>>
>> Hi Champs,
>>
>> Please help regarding how to implement Time Consumed formula. Thanks
>> in Advance.
>>
>>
>> Courier Dispatch from Delhi  Courier Received in USA
>> Time Consumed
>> Time  /   Date   Time /
>>  Date  Days  / (Time) in Hrs/Min/Sec
>> 11:30 AM /  8-Jul-20121:45 PM /   17-Jul-2012
>>  _
>>
>>
>>
>>
>> Thanks
>> Ashish kumar
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum
>> in signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>> --**--**
>> --**
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to excel-macros+unsubscribe@**
>> googlegroups.com 
>>
>>
>>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
>
> --
> To post to th

Re: $$Excel-Macros$$ Some Help

2012-08-01 Thread Varatharaj A

*please stop subcribes*
*

Thanks & Records
Varatharaj.a
  Unnal Mudiyum...
*
*** *
*
*

On Tue, Jul 24, 2012 at 6:52 PM, ashjain2...@yahoo.co.in <
ashjain2...@yahoo.co.in> wrote:

> We want to use data validation... Please see the attachment
>
> Ashok Maroti
>
> --
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Re: Employee Attendance Tracker with Utilization - Format

2012-08-01 Thread Ashish kumar

Dear Noorain,

This Attendance Tracker is very useful but whenever I'hve click on
Attendance Calculator Button and fill the Emp Id. field, the status was not
generated automatically. kindly explain it. & thanks for sharing it.

Thanks
Ashish



On 30 July 2012 20:38, NOORAIN ANSARI  wrote:

> Dear Hemant,
>
> Please find attached Attendance Tracker, Hope it will help to you.
>
>
> On Tue, Jul 31, 2012 at 12:10 AM, hemanath dhanasekar  > wrote:
>
>> Dear Ashish,
>>
>> How will I mark leave, I have Sick Leave, Un Planned Leave , Planned
>> Leave , Vacation?
>>
>> On Mon, Jul 30, 2012 at 11:26 PM, kumar.ashish861 <
>> kumar.ashish...@gmail.com> wrote:
>>
>>> Dear Hemanath.D
>>>
>>> Pls find the attached Excel Sheet.
>>>
>>>
>>> Thanks
>>> Ashish kumar
>>>
>>>
>>>
>>> On Monday, July 30, 2012 10:24:15 AM UTC-7, hemanath dhanasekar wrote:

 Friends,

 Can any one help me in providing Employee Attendance tracker format
 with Employee utilization in Excel?

 --
 Thanks
 Hemanath.D




>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>
>>
>>
>>
>>  --
>> Thanks
>> HemanatH
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.blogspot.com 
> http://accesssqclinic.blogspot.in/
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
*Thanks & Regards*
*Ashish Kumar*
*9990624516*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to thi

$$Excel-Macros$$ Help needed

2012-08-01 Thread francis vinod

Hello Team, 


Could you please help me in the below scenario.
I have two different reports from which I have to prepare a single report for 
reporting purpose.
In sheet 1 the reports contains tracking#, HW details etc. & and sheet 2 the 
report contains the values of the HW, tracking # etc

The report which I want should have the details of both Shee1 & Sheet 2 for 
which I have used the Vlookup formula and its fine.  The issue what I am facing 
is a single tracking # can have multiple line items and in the equipment report 
the equipments are split into seperate rows.  For eg, If a tracking # has 5 
different equipments with discreptions in 5 lineitems then when I use a VLookup 
formula it only shows the detail of equipment in 1st line.

So I want your help on this so that I get all the 5 equipment details in my 
report.  


Please find attached the excel file with an example.

If you could guide me it would be a great help and learning for me.

 
Thanks & Regards,
Francis

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Scenario.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Download 66 different Dashboards

2012-08-01 Thread Hilary Lomotey

Hi Guys,
For those interested in dashboards, pls see the link below to download 66
different dashboards from Chandoo's excel contest. thanks

http://chandoo.org/wp/2012/07/30/excel-salary-survey-contest-results/


All Dashboard zipped
http://img.chandoo.org/contests/ssc/files/all.zip

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Macro Needs Minor Fix

2012-08-01 Thread Bill Q

It now works perfectly. 
 
Many thanks Ashish !!!
 

On Wednesday, August 1, 2012 1:40:15 PM UTC-4, ashish wrote:

> check the attachment see if it works 
>
> i have made few changes in this module only
>
>
> *"Private Sub SportExchangeQuery()"*
>
>
>
>
>
> On Wed, Aug 1, 2012 at 9:05 PM, Bill Q  wrote:
>
>> Hi, 
>>  
>> I am not a programmer and the person that originally did this macro for 
>> me is no longer available. 
>>  
>> I have been using the attached macro to scrape from various webpages with 
>> no issues until now. The current webpage that I want to scrape is not 
>> being imported properly after the first cycle. It is timed to cycle every 
>> minute and place the most recent data directly below the last cycle. The 
>> first cycle is fine. However all consequential cycles place the data in a 
>> different area. 
>>  
>> My thought is that the issue has to do with the very last piece of data 
>> being brought in (see cell D63 in "TEST" tab). I beleive that if the 
>> date/time in row A continued to cell A63 that the issue would be fixed. I 
>> just do not know how to do this. 
>>  
>> Any takers ? 
>>  
>> Thanks,
>>
>> -- 
>> FORUM RULES (986+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>>  
>> 4) Acknowledge the responses you receive, good or bad.
>>  
>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited. 
>>  
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>> owners and members are not responsible for any loss.
>>  
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>  
>> To unsubscribe, send a blank email to 
>> excel-macros+unsubscr...@googlegroups.com
>>  
>>  
>>
>
>
>
> -- 
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/*
>
> P Before printing, think about the environment.
>
>  
>
>  

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Some Help

2012-08-01 Thread Seraj Alam

Please see attached solved your query.



On Wed, Aug 1, 2012 at 5:03 AM, Varatharaj A  wrote:

> *please stop subcribes*
> *
>
>
>
> Thanks & Records
> Varatharaj.a
>   Unnal Mudiyum...
> *
> *** *
> *
> *
>
>
>
>
>
> On Tue, Jul 24, 2012 at 6:52 PM, ashjain2...@yahoo.co.in <
> ashjain2...@yahoo.co.in> wrote:
>
>> We want to use data validation... Please see the attachment
>>
>> Ashok Maroti
>>
>> --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
Thanks & Regards
Seraj Alam
*+91 989 130 1776*

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Ashok_ Solved.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Curser not moving while editing

2012-08-01 Thread sharad jain

Finally had the answer for this.

for 2007 version -

Office Button - Excel Options - Advanced - Enable fill handle and cell
drag-and-drop.

Best,
Sharad

On Thu, Aug 2, 2012 at 11:01 AM, Sj  wrote:

> Hi Noorain,
>
> It is not working for me...I think I have changed some settings.
>
> See in the below picture, I can not see the dots at corners cell which
> allow anyone to change / drag the cell directly. I have go to formula bar
> and do it.
>
> Please help.
>
> Thanks
> Sharad
>
>
>
>
> On Wednesday, August 1, 2012 4:41:00 PM UTC+5:30, NOORAIN ANSARI wrote:
>>
>> Dear Sharad,
>>
>> It is working on my system. once again Please  press on scrolllock button.
>>
>>
>> On Wed, Aug 1, 2012 at 4:38 PM, sharad jain wrote:
>>
>>> Hi All,
>>>
>>> I can not move my curser directly in excel while editing.
>>>
>>> In the attached example, if I want to make B2 to A2. I can not do it
>>> directly. I have to actually type it in place of B2.
>>>
>>> Can someone help?
>>>
>>> Thanks.
>>> Sharad
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>> --**--**
>>> --**
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to excel-macros+unsubscribe@**
>>> googlegroups.com 
>>>
>>>
>>>
>>
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// excelvbaclinic.**
>> blogspot.com 
>> http://accesssqclinic.**blogspot.in/ 
>>
>>
>>
>>
>>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Excel 2010 Remove Duplication

$$Excel-Macros$$ help required

Re: $$Excel-Macros$$ help required

$$Excel-Macros$$ Can anybody tell me about Indirect

Re: $$Excel-Macros$$ help required

$$Excel-Macros$$ Curser not moving while editing

Re: $$Excel-Macros$$ Curser not moving while editing

Re: $$Excel-Macros$$ How to calculate Days and Time. (Formula Req.)

Re: $$Excel-Macros$$ Some Help

Re: $$Excel-Macros$$ Re: Employee Attendance Tracker with Utilization - Format

$$Excel-Macros$$ Help needed

$$Excel-Macros$$ Download 66 different Dashboards

Re: $$Excel-Macros$$ Macro Needs Minor Fix

Re: $$Excel-Macros$$ Some Help

Re: $$Excel-Macros$$ Curser not moving while editing

15 matches

Site Navigation

Mail list logo

Footer information