subject:"RE\: $$Excel\-Macros$$ Fwd\: Need Help"

Re: $$Excel-Macros$$ Fwd: Need help on a formula

2012-08-25 Thread ashish koul

see if it helps


On Sun, Aug 26, 2012 at 9:40 AM, hemant shah  wrote:

> Dear Experts,
>
> I haven't  yet received solution for my query below.
>
> Please help.
>
> Regards,
>
> -- Forwarded message --
> From: hemant shah 
> Date: Sun, Aug 19, 2012 at 12:56 PM
> Subject: Need help on a formula
> To: excel-macros 
>
>
> Dear Experts,
>
> I am stuck up which my work in an excel. I need a help on a formula in the
> attached sheet.
>
> I have given a complete details & explanation in the attached sheet.
>
>  Need your help to come out of this situation.
>
> For any question or details please revert back.
>
> Thanks in advance.
>
> Regards,
> Hemant
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send 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.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Point Based formula.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Fwd: Need help on data

2012-05-10 Thread Lokesh Loki

Yes i need user form in sheet1 and database should be storage in sheet2, as
it is there in the cbre payplus sheet(i.e row wise).

If it is possible help me on this.

Regards
Lokesh.M

On Thu, May 10, 2012 at 1:49 AM, Asa Rossoff  wrote:

> Hello Bé Trần,
>
> I believe that is what Lokesh meant (sheet1 = data entry form; sheet2 =
> database record storage) -- but I am replying just to provide the
> suggestion that you type your replies at the top of messages -- I often
> have difficulty finding your comments, since they are buried down below the
> old messages.  Also, the mailing list automatically puts the rules for the
> group at the bottom of all messages, further obscuring the location of your
> message replies.  I think more people will notice your comments if you put
> them at the top of your messages :)
>
> ** **
>
> Wishing you a great day!
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Bé Tr?n Van
> *Sent:* Wednesday, May 09, 2012 8:40 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Fwd: Need help on data
>
> ** **
>
> ** **
>
> 2012/5/9 Lokesh Loki 
>
> Hai Anil,
>
> Thanks for resolving the query and thanks for advising me about the user
> form.
>
> Once again thank a lot experts.
>
> Regards
> Lokesh.M 
>
> ** **
>
> On Wed, May 9, 2012 at 2:42 PM, Anil Gawli 
> wrote:
>
> Attached is the workbook and go to Calculation worksheet.
>
>  
>
>  
>
>  
>
>  
>
>
>  
>
> On Wed, May 9, 2012 at 6:01 AM, David Grugeon 
> wrote:
>
> Hi Lokesh 
>
> ** **
>
> I do not think you will get a reply from this group to to your question as
> it is.  What you are asking for is more in the nature of application design
> and that is not a quick and simple answer to a question. This group exists
> to help people who are having problems with VBA in Excel.  Whilst you may
> need VBA to fill your form (which is not a 'user form' but a spreadsheet
> set up as an input form) the design of the form and the linking of that
> form to the relevant spreadsheet is something you will need to do.  If your
> company does not have the relevant skills to do this they may need to hire
> a contractor to do it.
>
> ** **
>
> To give you a start, I would be looking at using a unique identifier
> (Employee ID for example) to identify the row on sheet two that you want to
> use in sheet 1. Then I would probably use a macro to copy the data for one
> line from Sheet 2 to the form, add a button for OK when the changes were
> done and copy it back to Sheet 2.
>
> ** **
>
> We can help you with the macros but the design of the "Beautiful" form is
> entirely up to you
>
> ** **
>
> You will need to think about what information a user can enter to identify
> the relevant row of sheet 2.
>
> ** **
>
> You will need to think about what operations you need to do create buttons
> for.  I would think Edit (Load), Add, Delete, OK and Cancel at least.
>
> ** **
>
> You will also need to specify all the validation rules for any cell which
> needs them.
>
> ** **
>
> When you have done as much work as you can on the form and have identified
> the answers to all the questions come back to the group for more help with
> the VBA.
>
> ** **
>
> ** **
>
> On 9 May 2012 00:29, Lokesh Loki  wrote:
>
> Hi Experts,
>
> Still i am not receiving any results in the group, could you please help
> on us for the below query.
>
> I need a beautiful form, when i am selecting the name it contains all the
> data which is already there in sheet2. So based on i need a user form in
> sheet1.
>
> Please do the needful.
>
> Thanks in advance.
>
> Regards
> Lokesh.M
>
> -- Forwarded message --
> From: *Lokesh Loki* 
> Date: Sun, May 6, 2012 at 8:28 PM
> Subject: Need help on data
> To: excel-macros@googlegroups.com
>
>
> Hi Experts,
>
> Please find the attached excel sheet and i need user form for this team
> data.
>
> Here in the second sheet i have a data, i need user form in the first
> sheet.
>
> Regards
> Lokesh.M
>
> ** **
>
> --
> 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) D

RE: $$Excel-Macros$$ Fwd: Need help on data

2012-05-09 Thread Asa Rossoff

Hello Bé Trần,

I believe that is what Lokesh meant (sheet1 = data entry form; sheet2 = 
database record storage) -- but I am replying just to provide the suggestion 
that you type your replies at the top of messages -- I often have difficulty 
finding your comments, since they are buried down below the old messages.  
Also, the mailing list automatically puts the rules for the group at the bottom 
of all messages, further obscuring the location of your message replies.  I 
think more people will notice your comments if you put them at the top of your 
messages :)

 

Wishing you a great day!

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Bé Tr?n Van
Sent: Wednesday, May 09, 2012 8:40 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Fwd: Need help on data

 

 

2012/5/9 Lokesh Loki 

Hai Anil,

Thanks for resolving the query and thanks for advising me about the user form.

Once again thank a lot experts.

Regards
Lokesh.M 

 

On Wed, May 9, 2012 at 2:42 PM, Anil Gawli  wrote:

Attached is the workbook and go to Calculation worksheet.

 

 

 

 


 

On Wed, May 9, 2012 at 6:01 AM, David Grugeon  wrote:

Hi Lokesh 

 

I do not think you will get a reply from this group to to your question as it 
is.  What you are asking for is more in the nature of application design and 
that is not a quick and simple answer to a question. This group exists to help 
people who are having problems with VBA in Excel.  Whilst you may need VBA to 
fill your form (which is not a 'user form' but a spreadsheet set up as an input 
form) the design of the form and the linking of that form to the relevant 
spreadsheet is something you will need to do.  If your company does not have 
the relevant skills to do this they may need to hire a contractor to do it.

 

To give you a start, I would be looking at using a unique identifier (Employee 
ID for example) to identify the row on sheet two that you want to use in sheet 
1. Then I would probably use a macro to copy the data for one line from Sheet 2 
to the form, add a button for OK when the changes were done and copy it back to 
Sheet 2.

 

We can help you with the macros but the design of the "Beautiful" form is 
entirely up to you

 

You will need to think about what information a user can enter to identify the 
relevant row of sheet 2.

 

You will need to think about what operations you need to do create buttons for. 
 I would think Edit (Load), Add, Delete, OK and Cancel at least.

 

You will also need to specify all the validation rules for any cell which needs 
them.

 

When you have done as much work as you can on the form and have identified the 
answers to all the questions come back to the group for more help with the VBA.

 

 

On 9 May 2012 00:29, Lokesh Loki  wrote:

Hi Experts,

Still i am not receiving any results in the group, could you please help on us 
for the below query.

I need a beautiful form, when i am selecting the name it contains all the data 
which is already there in sheet2. So based on i need a user form in sheet1.

Please do the needful.

Thanks in advance.

Regards
Lokesh.M

-- Forwarded message --
From: Lokesh Loki 
Date: Sun, May 6, 2012 at 8:28 PM
Subject: Need help on data
To: excel-macros@googlegroups.com


Hi Experts,

Please find the attached excel sheet and i need user form for this team data.

Here in the second sheet i have a data, i need user form in the first sheet. 

Regards
Lokesh.M

 

-- 
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





 

-- 
David Grugeon

-- 
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 p

Re: $$Excel-Macros$$ Fwd: Need help on data

2012-05-09 Thread Bé Trần Văn

2012/5/9 Lokesh Loki 

> Hai Anil,
>
> Thanks for resolving the query and thanks for advising me about the user
> form.
>
> Once again thank a lot experts.
>
> Regards
> Lokesh.M
>
> On Wed, May 9, 2012 at 2:42 PM, Anil Gawli wrote:
>
>> Attached is the workbook and go to Calculation worksheet.
>>
>>
>>
>>
>>
>>
>> On Wed, May 9, 2012 at 6:01 AM, David Grugeon wrote:
>>
>>> Hi Lokesh
>>>
>>> I do not think you will get a reply from this group to to your question
>>> as it is.  What you are asking for is more in the nature of application
>>> design and that is not a quick and simple answer to a question. This group
>>> exists to help people who are having problems with VBA in Excel.  Whilst
>>> you may need VBA to fill your form (which is not a 'user form' but a
>>> spreadsheet set up as an input form) the design of the form and the linking
>>> of that form to the relevant spreadsheet is something you will need to do.
>>>  If your company does not have the relevant skills to do this they may need
>>> to hire a contractor to do it.
>>>
>>> To give you a start, I would be looking at using a unique identifier
>>> (Employee ID for example) to identify the row on sheet two that you want to
>>> use in sheet 1. Then I would probably use a macro to copy the data for one
>>> line from Sheet 2 to the form, add a button for OK when the changes were
>>> done and copy it back to Sheet 2.
>>>
>>> We can help you with the macros but the design of the "Beautiful" form
>>> is entirely up to you
>>>
>>> You will need to think about what information a user can enter to
>>> identify the relevant row of sheet 2.
>>>
>>> You will need to think about what operations you need to do create
>>> buttons for.  I would think Edit (Load), Add, Delete, OK and Cancel at
>>> least.
>>>
>>> You will also need to specify all the validation rules for any cell
>>> which needs them.
>>>
>>> When you have done as much work as you can on the form and have
>>> identified the answers to all the questions come back to the group for more
>>> help with the VBA.
>>>
>>>
>>> On 9 May 2012 00:29, Lokesh Loki  wrote:
>>>
 Hi Experts,

 Still i am not receiving any results in the group, could you please
 help on us for the below query.

 I need a beautiful form, when i am selecting the name it contains all
 the data which is already there in sheet2. So based on i need a user form
 in sheet1.

 Please do the needful.

 Thanks in advance.

 Regards
 Lokesh.M

 -- Forwarded message --
 From: Lokesh Loki 
 Date: Sun, May 6, 2012 at 8:28 PM
 Subject: Need help on data
 To: excel-macros@googlegroups.com


 Hi Experts,

 Please find the attached excel sheet and i need user form for this team
 data.

 Here in the second sheet i have a data, i need user form in the first
 sheet.

 Regards
 Lokesh.M

 --
 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

>>>
>>>
>>>
>>> --
>>> David Grugeon
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> Thanks & Regards,
>> Gawli Anil Narayan
>> Software Developer,
>> Abacus Software Services Pvt

Re: $$Excel-Macros$$ Fwd: Need help on data

2012-05-09 Thread Lokesh Loki

Hai Anil,

Thanks for resolving the query and thanks for advising me about the user
form.

Once again thank a lot experts.

Regards
Lokesh.M

On Wed, May 9, 2012 at 2:42 PM, Anil Gawli  wrote:

> Attached is the workbook and go to Calculation worksheet.
>
>
>
>
>
>
> On Wed, May 9, 2012 at 6:01 AM, David Grugeon wrote:
>
>> Hi Lokesh
>>
>> I do not think you will get a reply from this group to to your question
>> as it is.  What you are asking for is more in the nature of application
>> design and that is not a quick and simple answer to a question. This group
>> exists to help people who are having problems with VBA in Excel.  Whilst
>> you may need VBA to fill your form (which is not a 'user form' but a
>> spreadsheet set up as an input form) the design of the form and the linking
>> of that form to the relevant spreadsheet is something you will need to do.
>>  If your company does not have the relevant skills to do this they may need
>> to hire a contractor to do it.
>>
>> To give you a start, I would be looking at using a unique identifier
>> (Employee ID for example) to identify the row on sheet two that you want to
>> use in sheet 1. Then I would probably use a macro to copy the data for one
>> line from Sheet 2 to the form, add a button for OK when the changes were
>> done and copy it back to Sheet 2.
>>
>> We can help you with the macros but the design of the "Beautiful" form is
>> entirely up to you
>>
>> You will need to think about what information a user can enter to
>> identify the relevant row of sheet 2.
>>
>> You will need to think about what operations you need to do create
>> buttons for.  I would think Edit (Load), Add, Delete, OK and Cancel at
>> least.
>>
>> You will also need to specify all the validation rules for any cell which
>> needs them.
>>
>> When you have done as much work as you can on the form and have
>> identified the answers to all the questions come back to the group for more
>> help with the VBA.
>>
>>
>> On 9 May 2012 00:29, Lokesh Loki  wrote:
>>
>>> Hi Experts,
>>>
>>> Still i am not receiving any results in the group, could you please help
>>> on us for the below query.
>>>
>>> I need a beautiful form, when i am selecting the name it contains all
>>> the data which is already there in sheet2. So based on i need a user form
>>> in sheet1.
>>>
>>> Please do the needful.
>>>
>>> Thanks in advance.
>>>
>>> Regards
>>> Lokesh.M
>>>
>>> -- Forwarded message --
>>> From: Lokesh Loki 
>>> Date: Sun, May 6, 2012 at 8:28 PM
>>> Subject: Need help on data
>>> To: excel-macros@googlegroups.com
>>>
>>>
>>> Hi Experts,
>>>
>>> Please find the attached excel sheet and i need user form for this team
>>> data.
>>>
>>> Here in the second sheet i have a data, i need user form in the first
>>> sheet.
>>>
>>> Regards
>>> Lokesh.M
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> David Grugeon
>>
>> --
>> 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
>>
>
>
>
> --
> 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 Pro

Re: $$Excel-Macros$$ Fwd: Need help on data

2012-05-08 Thread David Grugeon

Hi Lokesh

I do not think you will get a reply from this group to to your question as
it is.  What you are asking for is more in the nature of application design
and that is not a quick and simple answer to a question. This group exists
to help people who are having problems with VBA in Excel.  Whilst you may
need VBA to fill your form (which is not a 'user form' but a spreadsheet
set up as an input form) the design of the form and the linking of that
form to the relevant spreadsheet is something you will need to do.  If your
company does not have the relevant skills to do this they may need to hire
a contractor to do it.

To give you a start, I would be looking at using a unique identifier
(Employee ID for example) to identify the row on sheet two that you want to
use in sheet 1. Then I would probably use a macro to copy the data for one
line from Sheet 2 to the form, add a button for OK when the changes were
done and copy it back to Sheet 2.

We can help you with the macros but the design of the "Beautiful" form is
entirely up to you

You will need to think about what information a user can enter to identify
the relevant row of sheet 2.

You will need to think about what operations you need to do create buttons
for.  I would think Edit (Load), Add, Delete, OK and Cancel at least.

You will also need to specify all the validation rules for any cell which
needs them.

When you have done as much work as you can on the form and have identified
the answers to all the questions come back to the group for more help with
the VBA.

On 9 May 2012 00:29, Lokesh Loki  wrote:

> Hi Experts,
>
> Still i am not receiving any results in the group, could you please help
> on us for the below query.
>
> I need a beautiful form, when i am selecting the name it contains all the
> data which is already there in sheet2. So based on i need a user form in
> sheet1.
>
> Please do the needful.
>
> Thanks in advance.
>
> Regards
> Lokesh.M
>
> -- Forwarded message --
> From: Lokesh Loki 
> Date: Sun, May 6, 2012 at 8:28 PM
> Subject: Need help on data
> To: excel-macros@googlegroups.com
>
>
> Hi Experts,
>
> Please find the attached excel sheet and i need user form for this team
> data.
>
> Here in the second sheet i have a data, i need user form in the first
> sheet.
>
> Regards
> Lokesh.M
>
>  --
> 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
>

-- 
David Grugeon

-- 
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

RE: $$Excel-Macros$$ Fwd: Need help on data

2012-05-08 Thread Asa Rossoff

Hello Lokesh,

You may want to try Debra Dalgleish and Dave Petersen's method detailed
here: http://contextures.com/exceldataentryupdateform.html

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: Tuesday, May 08, 2012 7:30 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fwd: Need help on data

 

Hi Experts,

Still i am not receiving any results in the group, could you please help on
us for the below query.

I need a beautiful form, when i am selecting the name it contains all the
data which is already there in sheet2. So based on i need a user form in
sheet1.

Please do the needful.

Thanks in advance.

Regards
Lokesh.M

-- Forwarded message --
From: Lokesh Loki 
Date: Sun, May 6, 2012 at 8:28 PM
Subject: Need help on data
To: excel-macros@googlegroups.com


Hi Experts,

Please find the attached excel sheet and i need user form for this team
data.

Here in the second sheet i have a data, i need user form in the first sheet.


Regards
Lokesh.M

 

-- 
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

-- 
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

Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

2012-02-03 Thread Darwin Chan

Sorry for the late reply, Rajan could you explain your code for pivot
table? where can i find / download the BU list.xlsx?

2012/1/23 rekha siri 

> Rajan i could able to find out the root cause.
>
> i deleted sub delete module below and call delete function line
> now its working fine
>
> Thanks,
> Rekha
>
>
> On Sun, Jan 22, 2012 at 11:10 PM, rekha siri wrote:
>
>> rajan i dint remove summary sheet and raw data sheet but still its not
>> executing.
>>
>> only rest of sheets were deleted bt its opening bu list and stopping there
>>
>>
>> On Sun, Jan 22, 2012 at 6:10 PM, Rajan_Verma wrote:
>>
>>> Hi rekha.
>>>
>>> I clearly mention that don’t delete the summarySheet..
>>>
>>> Rajan.
>>>
>>> ** **
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *rekha siri
>>> *Sent:* Jan/Sun/2012 04:47
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ Fwd: Need help in building pivot using
>>> vba
>>>
>>> ** **
>>>
>>> Rajan,
>>>
>>> ** **
>>>
>>> i Tried removing the sheets and tried executing this macro bt it is not
>>> executing.
>>>
>>> ** **
>>>
>>> Please fix this...
>>>
>>> ** **
>>>
>>> Thanks alot for your help in this concern.
>>>
>>> On Sun, Jan 22, 2012 at 3:13 PM, Rajan_Verma 
>>> wrote:
>>>
>>> Hi Rekha
>>>
>>> See the attached sheet..
>>>
>>> Don’t delete SUmmarySheet
>>>
>>>  
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *rekha siri
>>> *Sent:* Jan/Sat/2012 08:51
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ Fwd: Need help in building pivot using vba**
>>> **
>>>
>>>  
>>>
>>> can any one kindly help on this please.
>>>
>>> -- Forwarded message --
>>> From: *rekha siri* 
>>> Date: Wed, Jan 18, 2012 at 9:59 PM
>>> Subject: Need help in building pivot using vba
>>> To: excel-macros@googlegroups.com
>>>
>>>
>>> hi experts,
>>>
>>>  
>>>
>>> Please provide the code to build pivot using vba
>>>
>>>  
>>>
>>> this macro is provided to me in past by rajan really  thank full for the
>>> concern. 
>>>
>>>  
>>>
>>> adding to that i need to prepare pivot for  west bu  from attached macro
>>> raw data sheet.
>>>
>>>  
>>>
>>> pivot format is also attached it should be as per West december2011
>>> file's pivot manner.
>>>
>>>  
>>>
>>> attached are macro and west december workbooks which contain pivot ..***
>>> *
>>>
>>>  
>>>
>>>  
>>>
>>>  
>>>
>>> kindly help in this concern thanks.
>>>
>>>  
>>>
>>> Rekha
>>>
>>>  
>>>
>>> --
>>> 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
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread ti

Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

2012-01-22 Thread rekha siri

Rajan i could able to find out the root cause.

i deleted sub delete module below and call delete function line
now its working fine

Thanks,
Rekha

On Sun, Jan 22, 2012 at 11:10 PM, rekha siri wrote:

> rajan i dint remove summary sheet and raw data sheet but still its not
> executing.
>
> only rest of sheets were deleted bt its opening bu list and stopping there
>
>
> On Sun, Jan 22, 2012 at 6:10 PM, Rajan_Verma wrote:
>
>> Hi rekha.
>>
>> I clearly mention that don’t delete the summarySheet..
>>
>> Rajan.
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *rekha siri
>> *Sent:* Jan/Sun/2012 04:47
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Fwd: Need help in building pivot using
>> vba
>>
>> ** **
>>
>> Rajan,
>>
>> ** **
>>
>> i Tried removing the sheets and tried executing this macro bt it is not
>> executing.
>>
>> ** **
>>
>> Please fix this...
>>
>> ** **
>>
>> Thanks alot for your help in this concern.
>>
>> On Sun, Jan 22, 2012 at 3:13 PM, Rajan_Verma 
>> wrote:
>>
>> Hi Rekha
>>
>> See the attached sheet..
>>
>> Don’t delete SUmmarySheet
>>
>>  
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *rekha siri
>> *Sent:* Jan/Sat/2012 08:51
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Fwd: Need help in building pivot using vba***
>> *
>>
>>  
>>
>> can any one kindly help on this please.
>>
>> -- Forwarded message --
>> From: *rekha siri* 
>> Date: Wed, Jan 18, 2012 at 9:59 PM
>> Subject: Need help in building pivot using vba
>> To: excel-macros@googlegroups.com
>>
>>
>> hi experts,
>>
>>  
>>
>> Please provide the code to build pivot using vba
>>
>>  
>>
>> this macro is provided to me in past by rajan really  thank full for the
>> concern. 
>>
>>  
>>
>> adding to that i need to prepare pivot for  west bu  from attached macro
>> raw data sheet.
>>
>>  
>>
>> pivot format is also attached it should be as per West december2011
>> file's pivot manner.
>>
>>  
>>
>> attached are macro and west december workbooks which contain pivot ..
>>
>>  
>>
>>  
>>
>>  
>>
>> kindly help in this concern thanks.
>>
>>  
>>
>> Rekha
>>
>>  
>>
>> --
>> 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
>>
>> --
>> 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.
>>
>

Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

2012-01-22 Thread rekha siri

rajan i dint remove summary sheet and raw data sheet but still its not
executing.

only rest of sheets were deleted bt its opening bu list and stopping there

On Sun, Jan 22, 2012 at 6:10 PM, Rajan_Verma wrote:

> Hi rekha.
>
> I clearly mention that don’t delete the summarySheet..
>
> Rajan.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *rekha siri
> *Sent:* Jan/Sun/2012 04:47
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba
> 
>
> ** **
>
> Rajan,
>
> ** **
>
> i Tried removing the sheets and tried executing this macro bt it is not
> executing.
>
> ** **
>
> Please fix this...
>
> ** **
>
> Thanks alot for your help in this concern.
>
> On Sun, Jan 22, 2012 at 3:13 PM, Rajan_Verma 
> wrote:
>
> Hi Rekha
>
> See the attached sheet..
>
> Don’t delete SUmmarySheet
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *rekha siri
> *Sent:* Jan/Sat/2012 08:51
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Fwd: Need help in building pivot using vba
>
>  
>
> can any one kindly help on this please.
>
> -- Forwarded message --
> From: *rekha siri* 
> Date: Wed, Jan 18, 2012 at 9:59 PM
> Subject: Need help in building pivot using vba
> To: excel-macros@googlegroups.com
>
>
> hi experts,
>
>  
>
> Please provide the code to build pivot using vba
>
>  
>
> this macro is provided to me in past by rajan really  thank full for the
> concern. 
>
>  
>
> adding to that i need to prepare pivot for  west bu  from attached macro
> raw data sheet.
>
>  
>
> pivot format is also attached it should be as per West december2011 file's
> pivot manner.
>
>  
>
> attached are macro and west december workbooks which contain pivot ..
>
>  
>
>  
>
>  
>
> kindly help in this concern thanks.
>
>  
>
> Rekha
>
>  
>
> --
> 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
>
> --
> 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
>
> ** **
>
> --
> 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.
>
>

RE: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

2012-01-22 Thread Rajan_Verma

Hi rekha.

I clearly mention that don't delete the summarySheet..

Rajan.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rekha siri
Sent: Jan/Sun/2012 04:47
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

 

Rajan,

 

i Tried removing the sheets and tried executing this macro bt it is not
executing.

 

Please fix this...

 

Thanks alot for your help in this concern.

On Sun, Jan 22, 2012 at 3:13 PM, Rajan_Verma 
wrote:

Hi Rekha

See the attached sheet..

Don't delete SUmmarySheet

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rekha siri
Sent: Jan/Sat/2012 08:51
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

 

can any one kindly help on this please.

-- Forwarded message --
From: rekha siri 
Date: Wed, Jan 18, 2012 at 9:59 PM
Subject: Need help in building pivot using vba
To: excel-macros@googlegroups.com


hi experts,

 

Please provide the code to build pivot using vba

 

this macro is provided to me in past by rajan really  thank full for the
concern. 

 

adding to that i need to prepare pivot for  west bu  from attached macro raw
data sheet.

 

pivot format is also attached it should be as per West december2011 file's
pivot manner.

 

attached are macro and west december workbooks which contain pivot ..

 

 

 

kindly help in this concern thanks.

 

Rekha

 

-- 
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

-- 
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

 

-- 
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

-- 
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

Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

2012-01-22 Thread rekha siri

Rajan,

i Tried removing the sheets and tried executing this macro bt it is not
executing.

Please fix this...

Thanks alot for your help in this concern.

On Sun, Jan 22, 2012 at 3:13 PM, Rajan_Verma wrote:

> Hi Rekha
>
> See the attached sheet..
>
> Don’t delete SUmmarySheet
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *rekha siri
> *Sent:* Jan/Sat/2012 08:51
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Fwd: Need help in building pivot using vba
>
> ** **
>
> can any one kindly help on this please.
>
> -- Forwarded message --
> From: *rekha siri* 
> Date: Wed, Jan 18, 2012 at 9:59 PM
> Subject: Need help in building pivot using vba
> To: excel-macros@googlegroups.com
>
>
> hi experts,
>
> ** **
>
> Please provide the code to build pivot using vba
>
> ** **
>
> this macro is provided to me in past by rajan really  thank full for the
> concern. 
>
> ** **
>
> adding to that i need to prepare pivot for  west bu  from attached macro
> raw data sheet.
>
> ** **
>
> pivot format is also attached it should be as per West december2011 file's
> pivot manner.
>
> ** **
>
> attached are macro and west december workbooks which contain pivot ..
>
> ** **
>
> ** **
>
> ** **
>
> kindly help in this concern thanks.
>
> ** **
>
> Rekha
>
> ** **
>
> --
> 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
>
> --
> 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
>

-- 
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

Re: $$Excel-Macros$$ Fwd: Need Help

2011-04-06 Thread Prathima R

Thanks alot Daniel

On Mon, Apr 4, 2011 at 2:38 PM, Daniel  wrote:

> Hi,
>
> Paste this macro in the first workbook. Open it manually and run the “Test”
> macro.
>
>
>
> Sub test()
>
> Dim lgRow As Long, sh As Worksheet, c As Range, rg As Range
>
> Const strPath As String = "D:\Donnees\Daniel\mpfe\Prathima R\" 'to be
> modified
>
> Dim inCalculationMode As Integer
>
> Application.ScreenUpdating = False
>
> inCalculationMode = Application.Calculation
>
> Application.Calculation = xlCalculationManual
>
> Set sh = Sheets("Data")
>
> lgRow = [Data!B65536].End(xlUp).Row + 1
>
> Workbooks.Open strPath & _
>
> "Supplier_Maintenance_170_Data_without_SAP_Document_Number.xls"
>
> With Sheets("Data")
>
> .Range(.[Q3], .Cells(65536, 2).End(xlUp)).Copy sh.Cells(lgRow, 2)
>
> End With
>
> ActiveWorkbook.Close False
>
> With sh
>
> .Range("T1").EntireColumn.Insert
>
> .Range("T2").Value = "Region"
>
> .Range("T1").EntireColumn.WrapText = True
>
> End With
>
> 'Global Company Code List (3).xls
>
> Workbooks.Open strPath & _
>
> "Global Company Code List (3).xls"
>
> Set sh1 = Sheets("Markets_Comp Code")
>
> With sh1
>
> Set rg = .Range(.[A2], .[C65536].End(xlUp))
>
> For Each c In sh.Range(sh.[S3], sh.[S65536].End(xlUp)).Offset(, 1)
>
> c.Value = Application.VLookup(c.Offset(, -1) * 1, rg, 3, 0)
>
> Next c
>
> End With
>
> ActiveWorkbook.Close False
>
> Application.Calculation = inCalculationMode
>
> Application.ScreenUpdating = True
>
> End Sub
>
>
>
> Regards.
>
>
>
> Daniel
>
>
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part d**e* Prathima R
> *Envoyé :* lundi 4 avril 2011 13:16
> *À :* excel-macros@googlegroups.com; ayush jain; ashish koul
> *Objet :* $$Excel-Macros$$ Fwd: Need Help
>
>
>
>
>
>
>
>
> Hi experts,
>
> I am not good at excel vba, i just tried recording macro but i am
> unsuccessful.. please help me i have two excel work books
>
> 1) SM_MV170R_Q0001_170_Data_with_SAP_Doc_Number
>
> 2) Supplier_Maintenance_170_Data_without_SAP_Document_Number
>
>
> i will first open the SM_MV170R_Q0001_170_Data_with_SAP_Doc_Number
> and go to end of the blank row  then open the second work book
> Supplier_Maintenance_170_Data_without_SAP_Document_Number
> copy the entire data and paste it in first work book which is
> SM_MV170R_Q0001_170_Data_with_SAP_Doc_Number
>
> Then insert one column and name the column as Region after the company code
> format the excel sheet using wrap text and grid lines.
> Then using the company code will be pulling the Region name from Global
> Company Code List with help of Vlookup.
>
> Please help me in preparing the macro
>
> Thanks alot in advance.
>
> Regards,
> Prathima
>
>
>
> --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Fwd: Need Help

2011-04-04 Thread Daniel

Hi,

Paste this macro in the first workbook. Open it manually and run the “Test”
macro.

 

Sub test()

Dim lgRow As Long, sh As Worksheet, c As Range, rg As Range

Const strPath As String = "D:\Donnees\Daniel\mpfe\Prathima R\" 'to be
modified

Dim inCalculationMode As Integer

Application.ScreenUpdating = False

inCalculationMode = Application.Calculation

Application.Calculation = xlCalculationManual

Set sh = Sheets("Data")

lgRow = [Data!B65536].End(xlUp).Row + 1

Workbooks.Open strPath & _

"Supplier_Maintenance_170_Data_without_SAP_Document_Number.xls"

With Sheets("Data")

.Range(.[Q3], .Cells(65536, 2).End(xlUp)).Copy sh.Cells(lgRow, 2)

End With

ActiveWorkbook.Close False

With sh

.Range("T1").EntireColumn.Insert

.Range("T2").Value = "Region"

.Range("T1").EntireColumn.WrapText = True

End With

'Global Company Code List (3).xls

Workbooks.Open strPath & _

"Global Company Code List (3).xls"

Set sh1 = Sheets("Markets_Comp Code")

With sh1

Set rg = .Range(.[A2], .[C65536].End(xlUp))

For Each c In sh.Range(sh.[S3], sh.[S65536].End(xlUp)).Offset(, 1)

c.Value = Application.VLookup(c.Offset(, -1) * 1, rg, 3, 0)

Next c

End With

ActiveWorkbook.Close False

Application.Calculation = inCalculationMode

Application.ScreenUpdating = True

End Sub

 

Regards.

 

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Prathima R
Envoyé : lundi 4 avril 2011 13:16
À : excel-macros@googlegroups.com; ayush jain; ashish koul
Objet : $$Excel-Macros$$ Fwd: Need Help

 

 




Hi experts,

I am not good at excel vba, i just tried recording macro but i am
unsuccessful.. please help me i have two excel work books 

1) SM_MV170R_Q0001_170_Data_with_SAP_Doc_Number

2) Supplier_Maintenance_170_Data_without_SAP_Document_Number


i will first open the SM_MV170R_Q0001_170_Data_with_SAP_Doc_Number
and go to end of the blank row  then open the second work book
Supplier_Maintenance_170_Data_without_SAP_Document_Number
copy the entire data and paste it in first work book which is
SM_MV170R_Q0001_170_Data_with_SAP_Doc_Number

Then insert one column and name the column as Region after the company code
format the excel sheet using wrap text and grid lines.
Then using the company code will be pulling the Region name from Global
Company Code List with help of Vlookup.

Please help me in preparing the macro

Thanks alot in advance.

Regards,
Prathima

 

-- 

--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Fwd: need help

2011-01-19 Thread lucky singh

thanx ashish will try this code

i also wanted formula to extract only the 10 digit mobile numbers from the
data list

   +  022-2 Ex-6432341 ~+  9870188646   +  022-2 Ex-6487723  +  022-2
Ex-6658518 ~+  9821916656   +  022-2 Ex-6795123  +  0251- Ex-2311543 ~+
9869478989  ~+  2311543   +91 (022) 9920283747  ~+91 (91) 9221201496   +
(0832) 2217393  ~+91 (0) 9049914155  ~+91 (0) 9850687476  ~+91 (0)
9820194010   + (033) 9831556578  ~+91 (033) 9477092032

Regards,
Lucky



On Wed, Jan 19, 2011 at 1:55 PM, ashish koul  wrote:

> codes
>
>
> Sub clear()
>
>
>
> Sheets("Score").Cells(3, 2).Value = ""
>
>
>
> Sheets("Score").Cells(4, 2).Value = ""
>
>
>
> Sheets("Score").Cells(5, 2).Value = ""
>
>
>
> Sheets("Score").Cells(6, 2).Value = ""
>
>
>
> Sheets("Score").Cells(7, 2).Value = ""
>
>
>
> End Sub
>
>
>
>
>
> Sub update()
>
> Dim z, k, s As Long
>
>
>
>
>
> For i = 1 To Sheets("Summary").Range("b65356").End(xlUp).Row
>
> If Sheets("score").Cells(2, 2).Value = Sheets("Summary").Cells(i, 2).Value
> Then
>
>
>
> z = i
>
> Exit For
>
>
>
> End If
>
> Next i
>
> Sheets("Summary").Select
>
> Sheets("Summary").Cells(z + 1, 2).Select
>
> k = Selection.End(xlToRight).Column + 1
>
>
>
>
>
> Sheets("Summary").Cells(z + 1, k).Value = Sheets("score").Cells(10,
> 2).Value
>
>
>
> Sheets("Summary").Cells(z + 2, k).Value = Sheets("score").Cells(14,
> 2).Value
>
>
>
> Sheets("Summary").Cells(z + 3, k).Value = Sheets("score").Cells(18,
> 2).Value
>
> Sheets("Summary").Cells(z + 4, k).Value = Sheets("score").Cells(22,
> 2).Value
>
>
>
> Sheets("Summary").Cells(z + 4, k).Value = Sheets("score").Cells(22,
> 2).Value
>
> Sheets("Summary").Cells(z + 5, k).Value = Sheets("score").Cells(26,
> 2).Value
>
>
>
> Sheets("Summary").Cells(z + 6, k).Value = Sheets("score").Cells(30,
> 2).Value
>
> Sheets("Summary").Cells(z + 7, k).Value = Sheets("score").Cells(34,
> 2).Value
>
>
>
> For s = z To z + 7
>
>
>
> If Sheets("Summary").Cells(s + 1, k).Value = "GOOD" Then
>
> Sheets("Summary").Cells(s + 1, k).Value = 10
>
> ElseIf Sheets("Summary").Cells(s + 1, k).Value = "AVERAGE" Then
>
> Sheets("Summary").Cells(s + 1, k).Value = 5
>
> ElseIf Sheets("Summary").Cells(s + 1, k).Value = "POOR" Then
>
> Sheets("Summary").Cells(s + 1, k).Value = 0
>
> ElseIf Sheets("Summary").Cells(s + 1, k).Value = "YES" Then
>
> Sheets("Summary").Cells(s + 1, k).Value = 10
>
> ElseIf Sheets("Summary").Cells(s + 1, k).Value = "NO" Then
>
> Sheets("Summary").Cells(s + 1, k).Value = 5
>
> Else
>
> Sheets("Summary").Cells(s + 1, k).Value = ""
>
> End if
>
> Next s
>
> End Sub
>
>
>   On Wed, Jan 19, 2011 at 10:28 AM, lucky singh wrote:
>
>>
>> sorry ashish,
>>
>> the file is not working when i click on update it opens a pop up says read
>> only, notify & cancel...
>>
>>
>> Regards,
>>
>>
>>
>>
>> On Tue, Jan 18, 2011 at 8:56 PM, ashish koul wrote:
>>
>>> check  the attachment
>>>
>>> On Tue, Jan 18, 2011 at 12:20 PM, lucky singh wrote:
>>>

 Hello,

 Guys Need your help urgently

 please

 Regrads

 -- Forwarded message --
 From: lucky singh 
 Date: Tue, Jan 18, 2011 at 10:51 AM
 Subject: need help
 To: excel-macros@googlegroups.com



 Hi Guys need your help,

 I have 25 agenst overall & I have to record & listen to 12 calls per
 agent,

 While rating a call i'll put scores in sheet one & automatically it
 should get updated in sheet 3 i.e. summary sheet & all the scores shuld get
 accumulated...

 Thanx in advance

 Regards,
 Lucky

 --

 --
 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
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *akoul*.*blogspot*.com 
>>> *akoul*.wordpress.com 
>>> My Linkedin Profile 
>>>
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>> --
>>>
>>> --
>>> 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
>>> 3. Excel tutorials at http://www.excel-macros.blo

Re: $$Excel-Macros$$ Fwd: need help

2011-01-18 Thread lucky singh

sorry ashish,

the file is not working when i click on update it opens a pop up says read
only, notify & cancel...


Regards,




On Tue, Jan 18, 2011 at 8:56 PM, ashish koul  wrote:

> check  the attachment
>
> On Tue, Jan 18, 2011 at 12:20 PM, lucky singh wrote:
>
>>
>> Hello,
>>
>> Guys Need your help urgently
>>
>> please
>>
>> Regrads
>>
>> -- Forwarded message --
>> From: lucky singh 
>> Date: Tue, Jan 18, 2011 at 10:51 AM
>> Subject: need help
>> To: excel-macros@googlegroups.com
>>
>>
>>
>> Hi Guys need your help,
>>
>> I have 25 agenst overall & I have to record & listen to 12 calls per
>> agent,
>>
>> While rating a call i'll put scores in sheet one & automatically it should
>> get updated in sheet 3 i.e. summary sheet & all the scores shuld get
>> accumulated...
>>
>> Thanx in advance
>>
>> Regards,
>> Lucky
>>
>> --
>>
>> --
>> 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
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Fwd: need help

2011-01-18 Thread ashish koul

check  the attachment

On Tue, Jan 18, 2011 at 12:20 PM, lucky singh  wrote:

>
> Hello,
>
> Guys Need your help urgently
>
> please
>
> Regrads
>
> -- Forwarded message --
> From: lucky singh 
> Date: Tue, Jan 18, 2011 at 10:51 AM
> Subject: need help
> To: excel-macros@googlegroups.com
>
>
>
> Hi Guys need your help,
>
> I have 25 agenst overall & I have to record & listen to 12 calls per agent,
>
>
> While rating a call i'll put scores in sheet one & automatically it should
> get updated in sheet 3 i.e. summary sheet & all the scores shuld get
> accumulated...
>
> Thanx in advance
>
> Regards,
> Lucky
>
> --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Assessment_Sheet(1).xlsm
Description: Binary data

Re: $$Excel-Macros$$ Fwd: need help

2011-01-08 Thread Prathima R

Thanks alot ashish its excellent..




On Sat, Jan 8, 2011 at 3:10 PM, ashish koul  wrote:

> check the attachment see if it helps
>
>
> On Sat, Jan 8, 2011 at 11:12 AM, Rajasekhar Praharaju <
> rajasekhar.prahar...@gmail.com> wrote:
>
>> Please find the attached sheet i could able to build formula for single
>> line item
>>
>> But i want if the criteria is having mulitple line items the results
>> should display as
>>
>> Date description, Date description, Date description.
>>
>> Please help me in this concern,
>>
>> Thanks,
>> Raj
>>
>>
>> On Sat, Jan 8, 2011 at 10:49 AM, Rajasekhar Praharaju <
>> rajasekhar.prahar...@gmail.com> wrote:
>>
>>>
>>>
>>> Hi ,
>>>
>>> Please help me in this concern,
>>>
>>>  In this sheet i am trying to place vlookup for multiple fields yaar
>>>
>>> it should through the description and date in AG column basing on list of
>>> activities.
>>> but i should get this in horizontal basis..
>>>
>>> can anyone  plz help me in this concern.
>>>
>>> for example
>>> if one activity is performed twice which is shown on top left hand
>>> corner.
>>>
>>> IRS Publications  activity has two line items then it should come as
>>> against the J102 which is IRS Publications it should through up the
>>> description and date in this manner
>>>
>>>pdf28 Monday, January 03, 2011,pdf24 Monday, January 03, 2011
>>>
>>> --
>>> -Thanks,
>>> Raj
>>>
>>
>>   --
>>
>> --
>> 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
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>  --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Fwd: need help

2011-01-08 Thread ashish koul

check the attachment see if it helps

On Sat, Jan 8, 2011 at 11:12 AM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:

> Please find the attached sheet i could able to build formula for single
> line item
>
> But i want if the criteria is having mulitple line items the results should
> display as
>
> Date description, Date description, Date description.
>
> Please help me in this concern,
>
> Thanks,
> Raj
>
>
> On Sat, Jan 8, 2011 at 10:49 AM, Rajasekhar Praharaju <
> rajasekhar.prahar...@gmail.com> wrote:
>
>>
>>
>> Hi ,
>>
>> Please help me in this concern,
>>
>>  In this sheet i am trying to place vlookup for multiple fields yaar
>>
>> it should through the description and date in AG column basing on list of
>> activities.
>> but i should get this in horizontal basis..
>>
>> can anyone  plz help me in this concern.
>>
>> for example
>> if one activity is performed twice which is shown on top left hand corner.
>>
>> IRS Publications  activity has two line items then it should come as
>> against the J102 which is IRS Publications it should through up the
>> description and date in this manner
>>
>>pdf28 Monday, January 03, 2011,pdf24 Monday, January 03, 2011
>>
>> --
>> -Thanks,
>> Raj
>>
>
>   --
>
> --
> 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
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


query_with_formula(1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Fwd: need help

2011-01-07 Thread Rajasekhar Praharaju

Please find the attached sheet i could able to build formula for single line
item

But i want if the criteria is having mulitple line items the results should
display as

Date description, Date description, Date description.

Please help me in this concern,

Thanks,
Raj

On Sat, Jan 8, 2011 at 10:49 AM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:

>
>
> Hi ,
>
> Please help me in this concern,
>
>  In this sheet i am trying to place vlookup for multiple fields yaar
>
> it should through the description and date in AG column basing on list of
> activities.
> but i should get this in horizontal basis..
>
> can anyone  plz help me in this concern.
>
> for example
> if one activity is performed twice which is shown on top left hand corner.
>
> IRS Publications  activity has two line items then it should come as
> against the J102 which is IRS Publications it should through up the
> description and date in this manner
>
>pdf28 Monday, January 03, 2011,pdf24 Monday, January 03, 2011
>
>  --
> -Thanks,
> Raj
>

-- 
--
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
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


query with formula.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Fwd: Need help on a formula

Re: $$Excel-Macros$$ Fwd: Need help on data

RE: $$Excel-Macros$$ Fwd: Need help on data

Re: $$Excel-Macros$$ Fwd: Need help on data

Re: $$Excel-Macros$$ Fwd: Need help on data

Re: $$Excel-Macros$$ Fwd: Need help on data

RE: $$Excel-Macros$$ Fwd: Need help on data

Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

RE: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

Re: $$Excel-Macros$$ Fwd: Need help in building pivot using vba

Re: $$Excel-Macros$$ Fwd: Need Help

RE: $$Excel-Macros$$ Fwd: Need Help

Re: $$Excel-Macros$$ Fwd: need help

Re: $$Excel-Macros$$ Fwd: need help

Re: $$Excel-Macros$$ Fwd: need help

Re: $$Excel-Macros$$ Fwd: need help

Re: $$Excel-Macros$$ Fwd: need help

Re: $$Excel-Macros$$ Fwd: need help

20 matches

Site Navigation

Mail list logo

Footer information