$$Excel-Macros$$ macro required for finding uniques

[Sara Lee]

I have a excel  file which has 3 tabs by name A,B,C and then another
excel file with tab D - both the files are in server in same location.

All 4 tabs in both the files have one common column called as Chas

Can any one help me please to get a macro which can create a unique(no
duplicates) list of all
values for column Chas from all 4 tabs in both files.

Please send a file which has a macro in it. thank  u much

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ excel modelling and simulation

[Sara Lee]

hi

Can somebody help me with excel modelling assignment... some simulation
required immediately

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ excel VBA solution - offered at reasonable price

[Sara Lee]

Does any one need help in Excel VBA  project or may be entire project to be
completed?

Let me know. You will get the solution at a reasonable price whether u in
US or in India.

I am in US right now.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ excel macro help on regular basis required- on weekly payment/hourly basis

[Sara Lee]

I neeed excel macro help on a regualr basis...can pay in dollars every
week. if you have time this week, can you pleas reply to me?

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Re: bubbel chart help required.

[Sara Lee]

it worked for me with my data set.

On Fri, Mar 22, 2013 at 10:07 AM, rajan verma wrote:

> do you really think that will work what you have in excel?? think again.
>
>  On Fri, Mar 22, 2013 at 9:02 AM, Sara Lee  wrote:
>
>>  This is already present in excel on tool bar.. no need of code actually
>>
>>  On Fri, Mar 22, 2013 at 7:49 AM, Rajan_Verma 
>> wrote:
>>
>>> I have ready code for this
>>>
>>> http://excelpoweruser.wordpress.com/2012/09/03/bubble-chart/
>>>
>>>
>>>
>>> On Thursday, 21 March 2013 00:46:03 UTC-6, midhun wrote:
>>>>
>>>> hi all;
>>>>
>>>> i want to create the bubble chart of the following data.
>>>> not able to create as all the data is not reflecting.
>>>> also the x axis should display high ir low instead of the number.
>>>> kindly help me out.
>>>>
>>>> --
>>>> Midhun Thampan.
>>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/excel-macros/iCK8rG__1Uw/unsubscribe?hl=en
>> .
>> To unsubscribe from this group and all its topics, send an email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
>
> --
> Regards
> Rajan verma
> +91 9158998701
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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.
>

Re: $$Excel-Macros$$ Re: bubbel chart help required.

[Sara Lee]

This is already present in excel on tool bar.. no need of code actually

On Fri, Mar 22, 2013 at 7:49 AM, Rajan_Verma wrote:

> I have ready code for this
>
> http://excelpoweruser.wordpress.com/2012/09/03/bubble-chart/
>
>
>
> On Thursday, 21 March 2013 00:46:03 UTC-6, midhun wrote:
>>
>> hi all;
>>
>> i want to create the bubble chart of the following data.
>> not able to create as all the data is not reflecting.
>> also the x axis should display high ir low instead of the number.
>> kindly help me out.
>>
>> --
>> Midhun Thampan.
>>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ add in for chart

[Sara Lee]

hi

is there a macro or add in for an CONTROL Charts in Excel? please advise

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ pivot need macro

[Sara Lee]

i have a pivot in excel. this pivot table in current format displays data
in plain number format. I want to display the numbers as "% of row" format.

i know there is an excel feature under options. but i want to add a toggle
which can have users change between number and %of row format, by clicking
or non clicking the toggle or list boxso need a macro

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

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Re: Highlight Worked Cells only if the Employee has worked in both areas

[Sara Lee]

Rajan

can u please explain this code in detail? becuase $b1 is a column heading
and can never be ec ? right?

On Sun, Sep 16, 2012 at 7:07 AM, Prince Dubey wrote:

> Hi Rajan,
>
> I like your solution, But i feel you have to modify it so that it can work
> for the dynamic name ranges as rasid mentioned in his last post.
>
>
> regards
> prince
>
>
> On Sunday, September 16, 2012 12:30:09 PM UTC+5:30, Rajan_Verma wrote:
>
>> *It can be done without code **J***
>>
>> * *
>>
>> *See the attached file..*
>>
>> * *
>>
>> *I am using custom conditional formatting with the below function *
>>
>> * *
>>
>> *=OR(AND($B2="Ec",$B3="RTG",G2=G3,G2<>"",G3<>""),AND($B1="Ec"
>> ,$B2="RTG",G1=G2,G1<>"",G2<>""))*
>>
>> * *
>>
>> *On Range  =$G$2:$AC$117*
>>
>> * *
>>
>> *Hope it will be helpful.*
>>
>> * *
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> * *
>>
>> *From:* excel-...@googlegroups.com [mailto:excel-...@**googlegroups.com]
>> *On Behalf Of *Vabz
>>
>> *Sent:* 16 September 2012 11:17
>> *To:* excel-...@googlegroups.com
>>
>> *Subject:* $$Excel-Macros$$ Re: Highlight Worked Cells only if the
>> Employee has worked in both areas
>>
>>
>>
>> Hi
>>
>>
>>
>> Check this..
>>
>>
>>
>> Cheerz..
>>
>>
>>
>> Regards//Vabs
>>
>>
>> On Saturday, September 15, 2012 11:16:57 PM UTC+5:30, prkhan56 wrote:
>>
>> Hello Prince Dubey,
>>
>> Your solution works.
>>
>> But as I mentioned in my original post the data will be in different
>> areas of the sheet
>>
>> Not in A1:AK117 always...which is where your code will work.
>>
>>
>>
>> Can you please change your code so that it runs on any selected range
>> only.
>>
>> Thanks for your time and help.
>>
>> Rashid
>>
>>
>> On Saturday, September 15, 2012 8:03:53 PM UTC+4, Prince Dubey wrote:
>>
>> Hi Rashid,
>>
>>
>>
>> Please see the attachment, Hope this will help you.
>>
>>
>>
>> Note : For testing the solution first set any other color for the cell
>> where the your specified criteria matched and then press the button
>> Highlight.
>>
>>
>>
>> regards
>>
>> prince
>>
>> On Saturday, 15 September 2012 17:22:57 UTC+5:30, prkhan56 wrote:
>>
>> Hello Experts,
>>
>> I am using Excel 2010 and have the following problem.
>>
>> If an employee no. is duplicate and he has worked in both Work Areas
>> viz EC and RTG then I wish to highlight only those Worked Cells with Yellow.
>>
>>
>>
>> I have done it manually to demonstrate my requirement in yellow.
>>
>>
>>
>> As the data shown in the attached file is part of a big work area, I
>> would like to RUN the macro only on the Selected Range after I have
>> selected that Range.
>>
>>
>>
>> Thanks in advance
>>
>> Rashid Khan
>>
>> --
>> 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-...@googlegroups.com.
>> To unsubscribe from this group, send email to excel-macros...@**
>> googlegroups.com.
>>
>>
>>
>>  --
> 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, s

Fwd: $$Excel-Macros$$ FW: macro for pivot

[Sara Lee]

---**

*From:* Sara Lee [mailto:lee.sar...@gmail.com]
*Sent:* 09 September 2012 7:41
*To:* Rajan_Verma
*Subject:* Re: macro for pivot

** **

once i copy and paste into a new module, how to run  this macro?

how do i link this code to the spreadsheet i am working on?

Can you please give exact steps

On Sun, Sep 9, 2012 at 8:14 AM, Rajan_Verma 
wrote:

*You can copy paste this code , if dost not  work , post you query on group
then with your original data. **J*

* *

* *

*Regards*

*Rajan verma*

*+91 7838100659 [IM-Gtalk]*

* *

*From:* Sara Lee [mailto:lee.sar...@gmail.com]
*Sent:* 09 September 2012 6:39
*To:* Rajan_Verma
*Subject:* Re: macro for pivot

 

Can i copy and paste this code on any file with pivot and slicers. If not ,
how would i change the code accordingly? i am null with VB. please advise***
*

On Sun, Sep 9, 2012 at 8:04 AM, Sara Lee  wrote:

Thank you. i will posit it from here on.

 

On Sun, Sep 9, 2012 at 8:03 AM, Rajan_Verma 
wrote:

*See the attached file..*

*You can also post this on group *

* *

* *

*Regards*

*Rajan verma*

*+91 7838100659 [IM-Gtalk]*

* *

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

Fwd: $$Excel-Macros$$ pls help urgent- need data in the format as required

[Sara Lee]

 Please advise a formula to get the data in the attached format. i need a
transpose to the data attached.

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

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




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

$$Excel-Macros$$ pls help urgent- need data in the format as required

[Sara Lee]

example attached.  i have multiple columns and rows. Please advise a
formula to get the data in the attached format.

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




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

$$Excel-Macros$$ Re: pls help with matching postal codes

[Sara Lee]

pls help with this-- can you put in the formula?

On Mon, May 7, 2012 at 12:09 AM, Sara Lee  wrote:

>
>
> --
>
> *col i *in Sheet 2 needs to be filled up
>
> by looking up *col h *in sheet 2 in  sheet 1 *col c* value- either exact
> or next closest- i.e for every value in col h sheet 2, i need nearest 3
> digit value that is present in entire col c in sheet 1
>
>

-- 
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$$ pls help with matching postal codes

[Sara Lee]

actually, if there is no exact value, it should give me next smallest or
largest value- which ever is closest. i tried vlook up with true-  but a
lot of cases, it is not the closest.   pls check out after u use  vlookup
true.  It is not always the closest

Best case scenario is exact and then next case scenario is closest 3 digit
no.

thanks for assistance again

On Mon, May 7, 2012 at 5:07 AM, NOORAIN ANSARI wrote:

> Hi Sara,
>
> You can also you use..
>
> *=IFERROR(LOOKUP(H2,Sheet1!$C$1:$C$72),"")*
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Mon, May 7, 2012 at 9:39 AM, Sara Lee  wrote:
>
>>
>>
>> --
>>
>> *col i *in Sheet 2 needs to be filled up
>>
>> by looking up *col h *in sheet 2 in  sheet 1 *col c* value- either exact
>> or next closest- i.e for every value in col h sheet 2, i need nearest 3
>> digit value that is present in entire col c in sheet 1
>>
>>  --
>> 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

$$Excel-Macros$$ match 2 columns

[Sara Lee]

hi
 i would like to have wgt column in sheet 1 updated based on whenever there
is a match on ozip and dzip columns in sheet1 and sheet 2. Can u pls give
exact formula?

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


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

Re: $$Excel-Macros$$ data needed in this format

[Sara Lee]

it s working- Thank you so much .. appreciate it.

On Sun, Apr 29, 2012 at 1:55 PM, dguillett1  wrote:

>   Really good
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* ╰» ℓαℓιт мσαнη 
> *Sent:* Sunday, April 29, 2012 12:25 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ data needed in this format
>
>  *Hi Sara *
> *
> *
> *PFA*
>
> *Regards,*
> *Lalit Mohan*
>
>
>
> On Sun, Apr 29, 2012 at 12:38 PM, Sara Lee  wrote:
>
>> Attached is the file with 2 sheets - input and output.
>> output i require is based on input tab--- i need every reference value to
>> be listed as columns and then list down the load nos in which these
>> reference values exist  in the input tab.example
>>
>>
>>reference7151865O  is in 2 load nos below
>>
>>  load 0241 load 0243
>> --
>> 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

$$Excel-Macros$$ data needed in this format

[Sara Lee]

Attached is the file with 2 sheets - input and output.
output i require is based on input tab--- i need every reference value to
be listed as columns and then list down the load nos in which these
reference values exist  in the input tab.example


 reference7151865O  is in 2 load nos below

 load 0241  load 0243

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


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

Re: $$Excel-Macros$$ formula required for count or count if

[Sara Lee]

no but this takes duplicates into consideration.. I would need count of
only unique values for every load no

On Fri, Apr 27, 2012 at 7:39 AM, Shaik Waheed  wrote:

> Hi Sara,
>
> PFA, Hope this is what you are looking for...
>
> On Fri, Apr 27, 2012 at 4:33 PM, Sara Lee  wrote:
>
>> Anil
>>
>> it s not the count of loads.. i need the count of distinct values for
>> every load no
>>
>> ie Load 0241
>> 7151865O  7154687O  7175843O  7202990O  7212856O  7253406O
>> has 6 values both from top row and bottom row..  so 6 should be the
>> output for load 0241
>>
>> in some case as u see,  some loads have 3 rows of data... i want to calc
>> count  of  unique values in all three
>>
>> file attached again
>>
>> hope that helps
>>
>>
>>
>>
>> On Fri, Apr 27, 2012 at 5:43 AM, anil panchal wrote:
>>
>>> Dear Sara,a
>>>
>>> Its Working Fine please find the attached file.
>>>
>>> Thanks & Regards
>>> Anil Kumar
>>> 113784
>>>
>>>  On Fri, Apr 27, 2012 at 2:52 PM, Darwin Chan <
>>> darwin.chankaw...@gmail.com> wrote:
>>>
>>>> See if you understand array formula.
>>>>
>>>> http://www.excelfunctions.net/Excel-Array-Formulas.html
>>>>
>>>>
>>>> 2012/4/27 Sara Lee 
>>>>
>>>>> thee are two similar rows with same load no---this is not working
>>>>>
>>>>>  On Fri, Apr 27, 2012 at 4:06 AM, anil panchal 
>>>>> wrote:
>>>>>
>>>>>> you can use
>>>>>>
>>>>>> =SUMPRODUCT(--($A$2:$A$23=AB2))
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee wrote:
>>>>>>
>>>>>>> yes i need count of distinct records for each load no-- sample output
>>>>>>>
>>>>>>> load 02416
>>>>>>> load 02423
>>>>>>> load 02452
>>>>>>> load 02462
>>>>>>>
>>>>>>>
>>>>>>> On Fri, Apr 27, 2012 at 3:45 AM, Abhishek Jain <
>>>>>>> abhishek@gmail.com> wrote:
>>>>>>>
>>>>>>>> Actually count of values stored in adjacent columns of each load
>>>>>>>> number is required. For Load 0241 - there are 6 values so the formula
>>>>>>>> should return 6.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Fri, Apr 27, 2012 at 1:09 PM, Darwin Chan <
>>>>>>>> darwin.chankaw...@gmail.com> wrote:
>>>>>>>>
>>>>>>>>> Hi Sara,
>>>>>>>>>
>>>>>>>>> Seems formula COUNTIF can solve your problem simply.
>>>>>>>>>
>>>>>>>>>   2012/4/27 Sara Lee 
>>>>>>>>>
>>>>>>>>>> hi
>>>>>>>>>>
>>>>>>>>>> i have data as in the attached data. i need count of unique
>>>>>>>>>> values of column A i.e i need output as in column AB, AC... pls 
>>>>>>>>>> advise
>>>>>>>>>> a formula 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.
>>>>>>>>>>
>>>>

Re: $$Excel-Macros$$ formula required for count or count if

[Sara Lee]

Anil

it s not the count of loads.. i need the count of distinct values for every
load no

ie   Load 0241
7151865O  7154687O  7175843O  7202990O  7212856O  7253406O
has 6 values both from top row and bottom row..  so 6 should be the output
for load 0241

in some case as u see,  some loads have 3 rows of data... i want to calc
count  of  unique values in all three

file attached again

hope that helps




On Fri, Apr 27, 2012 at 5:43 AM, anil panchal  wrote:

> Dear Sara,a
>
> Its Working Fine please find the attached file.
>
> Thanks & Regards
> Anil Kumar
> 113784
>
> On Fri, Apr 27, 2012 at 2:52 PM, Darwin Chan 
> wrote:
>
>> See if you understand array formula.
>>
>> http://www.excelfunctions.net/Excel-Array-Formulas.html
>>
>>
>> 2012/4/27 Sara Lee 
>>
>>> thee are two similar rows with same load no---this is not working
>>>
>>>  On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote:
>>>
>>>> you can use
>>>>
>>>> =SUMPRODUCT(--($A$2:$A$23=AB2))
>>>>
>>>>
>>>>
>>>>
>>>> On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee  wrote:
>>>>
>>>>> yes i need count of distinct records for each load no-- sample output
>>>>>
>>>>> load 02416
>>>>> load 02423
>>>>> load 02452
>>>>> load 02462
>>>>>
>>>>>
>>>>> On Fri, Apr 27, 2012 at 3:45 AM, Abhishek Jain >>>> > wrote:
>>>>>
>>>>>> Actually count of values stored in adjacent columns of each load
>>>>>> number is required. For Load 0241 - there are 6 values so the formula
>>>>>> should return 6.
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Fri, Apr 27, 2012 at 1:09 PM, Darwin Chan <
>>>>>> darwin.chankaw...@gmail.com> wrote:
>>>>>>
>>>>>>> Hi Sara,
>>>>>>>
>>>>>>> Seems formula COUNTIF can solve your problem simply.
>>>>>>>
>>>>>>>   2012/4/27 Sara Lee 
>>>>>>>
>>>>>>>> hi
>>>>>>>>
>>>>>>>> i have data as in the attached data. i need count of unique values
>>>>>>>> of column A i.e i need output as in column AB, AC... pls advise a
>>>>>>>> formula 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
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Best Regards,
>>>>>>> Darwin Chan
>>>>>>> darwin.chankaw...@gmail.com
>>>>>>> kw42c...@yahoo.com.hk
>>>>>>>
>>>>>>>  --
>>>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>>>
>>>>>>> 1) Use concise, accurate thread titles. Poor thread 

Re: $$Excel-Macros$$ formula required for count or count if

[Sara Lee]

thee are two similar rows with same load no---this is not working

On Fri, Apr 27, 2012 at 4:06 AM, anil panchal  wrote:

> you can use
>
> =SUMPRODUCT(--($A$2:$A$23=AB2))
>
>
>
>
> On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee  wrote:
>
>> yes i need count of distinct records for each load no-- sample output
>>
>> load 02416
>> load 02423
>> load 02452
>> load 02462
>>
>>
>> On Fri, Apr 27, 2012 at 3:45 AM, Abhishek Jain wrote:
>>
>>> Actually count of values stored in adjacent columns of each load number
>>> is required. For Load 0241 - there are 6 values so the formula should
>>> return 6.
>>>
>>>
>>>
>>> On Fri, Apr 27, 2012 at 1:09 PM, Darwin Chan <
>>> darwin.chankaw...@gmail.com> wrote:
>>>
>>>> Hi Sara,
>>>>
>>>> Seems formula COUNTIF can solve your problem simply.
>>>>
>>>>   2012/4/27 Sara Lee 
>>>>
>>>>> hi
>>>>>
>>>>> i have data as in the attached data. i need count of unique values of
>>>>> column A i.e i need output as in column AB, AC... pls advise a formula
>>>>> 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
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Best Regards,
>>>> Darwin Chan
>>>> darwin.chankaw...@gmail.com
>>>> kw42c...@yahoo.com.hk
>>>>
>>>>  --
>>>> 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

Re: $$Excel-Macros$$ formula required for count or count if

[Sara Lee]

should i paste in AB2?

On Fri, Apr 27, 2012 at 4:52 AM, Darwin Chan wrote:

> sara,
>
> the formula should workfirst highlight the range you want to implement
> this formula, then you should try Ctrl + Shift + Enter.
>
>
> 2012/4/27 Sara Lee 
>
>> it is not working-- anybody else can help here
>>
>>
>> On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote:
>>
>>> you can use
>>>
>>> =SUMPRODUCT(--($A$2:$A$23=AB2))
>>>
>>>
>>>
>>>
>>> On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee  wrote:
>>>
>>>> yes i need count of distinct records for each load no-- sample output
>>>>
>>>> load 02416
>>>> load 02423
>>>> load 02452
>>>> load 02462
>>>>
>>>>
>>>> On Fri, Apr 27, 2012 at 3:45 AM, Abhishek Jain 
>>>> wrote:
>>>>
>>>>> Actually count of values stored in adjacent columns of each load
>>>>> number is required. For Load 0241 - there are 6 values so the formula
>>>>> should return 6.
>>>>>
>>>>>
>>>>>
>>>>> On Fri, Apr 27, 2012 at 1:09 PM, Darwin Chan <
>>>>> darwin.chankaw...@gmail.com> wrote:
>>>>>
>>>>>> Hi Sara,
>>>>>>
>>>>>> Seems formula COUNTIF can solve your problem simply.
>>>>>>
>>>>>>   2012/4/27 Sara Lee 
>>>>>>
>>>>>>> hi
>>>>>>>
>>>>>>> i have data as in the attached data. i need count of unique values
>>>>>>> of column A i.e i need output as in column AB, AC... pls advise a
>>>>>>> formula 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
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Best Regards,
>>>>>> Darwin Chan
>>>>>> darwin.chankaw...@gmail.com
>>>>>> kw42c...@yahoo.com.hk
>>>>>>
>>>>>>  --
>>>>>> 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 an

Re: $$Excel-Macros$$ formula required for count or count if

[Sara Lee]

it is not working-- anybody else can help here

On Fri, Apr 27, 2012 at 4:06 AM, anil panchal  wrote:

> you can use
>
> =SUMPRODUCT(--($A$2:$A$23=AB2))
>
>
>
>
> On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee  wrote:
>
>> yes i need count of distinct records for each load no-- sample output
>>
>> load 02416
>> load 02423
>> load 02452
>> load 02462
>>
>>
>> On Fri, Apr 27, 2012 at 3:45 AM, Abhishek Jain wrote:
>>
>>> Actually count of values stored in adjacent columns of each load number
>>> is required. For Load 0241 - there are 6 values so the formula should
>>> return 6.
>>>
>>>
>>>
>>> On Fri, Apr 27, 2012 at 1:09 PM, Darwin Chan <
>>> darwin.chankaw...@gmail.com> wrote:
>>>
>>>> Hi Sara,
>>>>
>>>> Seems formula COUNTIF can solve your problem simply.
>>>>
>>>>   2012/4/27 Sara Lee 
>>>>
>>>>> hi
>>>>>
>>>>> i have data as in the attached data. i need count of unique values of
>>>>> column A i.e i need output as in column AB, AC... pls advise a formula
>>>>> 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
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Best Regards,
>>>> Darwin Chan
>>>> darwin.chankaw...@gmail.com
>>>> kw42c...@yahoo.com.hk
>>>>
>>>>  --
>>>> 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$$ formula required for count or count if

[Sara Lee]

yes i need count of distinct records for each load no-- sample output

load 02416
load 02423
load 02452
load 02462

On Fri, Apr 27, 2012 at 3:45 AM, Abhishek Jain wrote:

> Actually count of values stored in adjacent columns of each load number is
> required. For Load 0241 - there are 6 values so the formula should return 6.
>
>
>
> On Fri, Apr 27, 2012 at 1:09 PM, Darwin Chan 
> wrote:
>
>> Hi Sara,
>>
>> Seems formula COUNTIF can solve your problem simply.
>>
>>  2012/4/27 Sara Lee 
>>
>>> hi
>>>
>>> i have data as in the attached data. i need count of unique values of
>>> column A i.e i need output as in column AB, AC... pls advise a formula
>>> 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
>>>
>>
>>
>>
>> --
>> Best Regards,
>> Darwin Chan
>> darwin.chankaw...@gmail.com
>> kw42c...@yahoo.com.hk
>>
>>  --
>> 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

$$Excel-Macros$$ formula required for count or count if

[Sara Lee]

hi

i have data as in the attached data. i need count of unique values of
column A i.e i need output as in column AB, AC... pls advise a formula
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


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

Re: $$Excel-Macros$$ Pivot table

[Sara Lee]

Hi

So do i have to copy and paste this formula?

On Sun, Apr 15, 2012 at 4:32 PM, Maries  wrote:

> Hi,
>
> In that case, Dynamic range is good solution.
>
> I have used Name Range "rng" refers 
> as*=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1))
> *
> Regards,
>
> MARIES.
> *
> *
> On Mon, Apr 16, 2012 at 12:14 AM, Sara Lee  wrote:
>
>> thanks it is good but one change required--- when i add more records into
>> my base sheet , and then refresh the pivot, that column % does not get
>> updated automatically;; also when i delete records,  that column shows up
>> 0  even though there are no records to left
>>
>>
>> On Sun, Apr 15, 2012 at 3:41 PM, Maries  wrote:
>>
>>> Hi,
>>>
>>> Try this formula,
>>>
>>> =B4/OFFSET($A$3,COUNTA(A:A)-1,2)
>>>
>>> Regards,
>>>
>>> MARIES.
>>>
>>>
>>> On Sun, Apr 15, 2012 at 10:20 PM, Sara Lee  wrote:
>>>
>>>> i have created a pivot table in excel in sheet 4 out of sheet 1 data.
>>>> Now i have added a calculation column - right most column of the pivot...
>>>>
>>>> now when i delete the row of the data in sheet 1 say mumbai row, and
>>>> then refresh the pivot... then the last column gets messed up showing
>>>> div/0  error
>>>>
>>>> is therer any way to correct that last column formula in the pivot so
>>>> that it updates itself when data is refresehed. 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
>>>>
>>>
>>>  --
>>> 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.
&g

Re: $$Excel-Macros$$ Pivot table

[Sara Lee]

thanks it is good but one change required--- when i add more records into
my base sheet , and then refresh the pivot, that column % does not get
updated automatically;; also when i delete records,  that column shows up
0  even though there are no records to left

On Sun, Apr 15, 2012 at 3:41 PM, Maries  wrote:

> Hi,
>
> Try this formula,
>
> =B4/OFFSET($A$3,COUNTA(A:A)-1,2)
>
> Regards,
>
> MARIES.
>
>
> On Sun, Apr 15, 2012 at 10:20 PM, Sara Lee  wrote:
>
>> i have created a pivot table in excel in sheet 4 out of sheet 1 data. Now
>> i have added a calculation column - right most column of the pivot...
>>
>> now when i delete the row of the data in sheet 1 say mumbai row, and then
>> refresh the pivot... then the last column gets messed up showing div/0
>> error
>>
>> is therer any way to correct that last column formula in the pivot so
>> that it updates itself when data is refresehed. 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
>>
>
>  --
> 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

$$Excel-Macros$$ Pivot table

[Sara Lee]

i have created a pivot table in excel in sheet 4 out of sheet 1 data. Now i
have added a calculation column - right most column of the pivot...

now when i delete the row of the data in sheet 1 say mumbai row, and then
refresh the pivot... then the last column gets messed up showing div/0
error

is therer any way to correct that last column formula in the pivot so that
it updates itself when data is refresehed. 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


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

$$Excel-Macros$$ pls fill up this sheet with this pattern

[Sara Lee]

 i have two columns...  zip code and the weights... i need to complete this
sheet . i.e zip codes with starting from 1001 to 9 should come up in
the sheet and for each zip code, those five weights should come up.

please advise

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


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

$$Excel-Macros$$ formulas to get the week in the month and week of the year

[Sara Lee]

hi

i have a column in excel with the following date format--

ship date
20110801
20110823
20110903

I need another column adjacent to it which gives me the following results
for every respective date above-- basically calcualate month and the week
in that particular month in below format... Also the week column should
give the week no in the year . for example 20110801 might represent 32 nd
week in the year . so i need to fill up 2 columns

week-monthweek
08-1 week
08- 4 week
09 -1 week

what formulas should i use to generate both the columns

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

$$Excel-Macros$$ access query to run into excel

[Sara Lee]

hey

is there a macro to run access query inside excel 2007. and excel data
should refresh with any change in access query data.

-- 
FORUM RULES (925+ 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$$ filter out the cells with a particular formula

[Sara Lee]

Thanks Ashish... but how do i filter out column I such that i extract values
similar to a ( which use 0) and not b. Say suppose column I has 2cell
records ... ?

On Thu, Aug 18, 2011 at 9:05 PM, ashish koul  wrote:

> see if it helps
>
>
> On Fri, Aug 19, 2011 at 6:24 AM, Sara Lee  wrote:
>
>> hi
>>
>> how do i filter out those cells in a column which has a particular vlookup
>> formula in them... for example in one column in a table, i have vlook up
>> fomula set up for the entire column ... some of the cells have vlook up(
>> with true parameter) and some with (false parameter) How do i filter
>> only those cells which have true parameter? any macro ?
>>
>> Thanks
>>
>> --
>>
>> --
>> 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 <http://akoul.blogspot.com/>
> http://akoul.posterous.com/
>  *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> 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

$$Excel-Macros$$ filter out the cells with a particular formula

[Sara Lee]

hi

how do i filter out those cells in a column which has a particular vlookup
formula in them... for example in one column in a table, i have vlook up
fomula set up for the entire column ... some of the cells have vlook up(
with true parameter) and some with (false parameter) How do i filter
only those cells which have true parameter? any macro ?

Thanks

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

$$Excel-Macros$$ Re: assistance needed; open to pay a fees

[Sara Lee]

Thank You so much. It is a great start. You are gwonderful!!!.   Do i have
to keep the source sheet (data) in the same file as the macro? or can i
seperate them and put them in different files but in a common folder ?

On Sun, Aug 7, 2011 at 10:29 PM, ashish koul  wrote:

>
> try this
>
> we can make few changes in it
>
> On Sun, Aug 7, 2011 at 10:47 PM, Sara Lee  wrote:
>
>> Hi Ashish
>>
>> i think you got me wrong. user does not have to enter new values. he will
>> select one of the values from the table i sent you.
>>
>> excel will  ask for the volume , the user will enter 1X , then the excel
>> should return the rest of row information for 1X in column form ... For
>> example corresponding to 1x, the savings could be 100,000,  scenario no
>> could  be 1RR  so o/p will be
>>
>> savings10
>> scenario no   1RR
>> locationhebron ky
>>
>> am i clear?
>>  no addition of data, just the excel should extract data from this table
>> based on user inupts in the Columnar form like above
>>
>>
>>
>> ideal inputs that user is asked to enter 1) volume  2) no of
>> locations  3) no of consolidations   4) parmeters 5) scenario
>>
>> outputs--- savings, damage( i will add this and other column in the table)
>>
>> Excel should be able to extract the output even if the user enters one of
>> the inputs and none of the other four..
>>
>> please advise
>>
>>
>> On Sun, Aug 7, 2011 at 10:19 AM, ashish koul wrote:
>>
>>> hi try this
>>>
>>>
>>> i have created a user form  go to macro run it it will show the user form
>>>  to enter the value then you can change the
>>> column names accordingly also u can ad text boxes , etc.
>>>
>>> use fill down option to copy the formula from above cell.
>>>
>>>
>>> if you are not able to do it tell me
>>>
>>> volume  - which col a, b , or c,etc
>>>
>>> location
>>>
>>> building
>>>
>>> if any formula need to copy from above  cell  " for which columns then"
>>>
>>>
>>>
>>>
>>>
>>> On Sun, Aug 7, 2011 at 6:20 PM, Sara Lee  wrote:
>>>
>>>> hello
>>>>
>>>> i have the table in the below format and  4 columns as below  in excel
>>>>
>>>> volumelocation   builds   saving
>>>>
>>>>
>>>>
>>>> Now i want the user to be prompted for three values.... which will be
>>>> volume, location, builds and the excel should give the user corresponding
>>>> savings and the o/p should be in *vertical format* with all the inputs.
>>>> o/p should be
>>>>
>>>> volume: [ value entered by user]
>>>> location:[ value entered by user]
>>>> builds:[ value entered by user]
>>>> saving: corresponding value in the table for that row of inputs
>>>>
>>>> is there a template or a macro or a dashboard... can you pls hlep.
>>>>
>>>> thanks
>>>>
>>>>
>>>> same thing;;; above is simplified
>>>>
>>>>
>>>> On Sun, Aug 7, 2011 at 8:27 AM, Sara Lee  wrote:
>>>>
>>>>> Hi Ashish
>>>>>
>>>>> I am attaching a table  which has all the inputs.  i need a macro /
>>>>> or a template/buttons in excel where
>>>>> the user is asked  to enter the following input
>>>>>
>>>>> Scneario NO:  user will enter either 1 , or 2 or 3 --- any value
>>>>> from column A
>>>>>
>>>>> once he enters the value, the o/p should be following in the below
>>>>> format one below the other for whatever scenario he or she enters
>>>>>
>>>>> volume : excel should get the value from column d
>>>>> # of location : similarly from column m
>>>>> inbound consolidation:
>>>>> parmeters
>>>>> savings :
>>>>>
>>>>>
>>>>> there might be other columns that i might be adding to the table, if i
>>>>> have to get other columns generated in ouput, could you also please 
>>>>> instruct
>>>>> me on how to do that
>>>>>
>>>>> Please advise ASAP.
>>>>>
>>>>> Thanks
>>>>>
>>>>>
>>>>>
>>>&

Re: Fwd: $$Excel-Macros$$ urgent macro or template r eq

[Sara Lee]

hello Haseeb

thanks but

1) how would i change this if user has to enter five different inputs
instead of just two... where should i change in formula? can you give a five
input formula.. just assume any 3 more columns as inputs..

2) also can i get a button where in user can click on the button to enter
input values

pls advise thanks

On Sun, Aug 7, 2011 at 7:54 PM, Haseeb Avarakkan  wrote:

> Hello Lee,
>
> See the attached with Array Formula.
>
> HTH
> Haseeb
>
> For free MS product help, visit;
> http://www.excelfox.com/forum/forum.php
>
> --
>
> --
> 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

Fwd: $$Excel-Macros$$ urgent macro or template r eq

[Sara Lee]

 i have a table in excel  like below


volumeships   parameter savings
1x   20   T1200
2x   25   L  1500
3X   67   T 1400


i need a macro or a form or template where user is asked to enter volume or
parameter and then excel should output the corresponding savings and ships
values fo

for example enter the volume

if user enters the volume 1x, then excel should return the output in
columnar form as follows

For 1x

ships   20
savings  1200

besides the above columns i would be adding other columns. So the macro or
form should ask the user to enter any of the input values/columns.  please
explain me how i would modify the
macro to input other columns.  If  user enters
one of the input values as blank or null , then it should still extract the
output based on other parameter. for example if user does not enter any
value for volume and enters T for parameter,

the output should be

1x

ships 20
savings 1200

3x

ships  67
saving 1400

please advise



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

$$Excel-Macros$$ urgent macro or template r eq

[Sara Lee]

 i have a table in excel  like below


volumeships   parameter savings
1x   20   T1200
2x   25   L  1500
3X   67   T 1400


i need a macro or a form or template where user is asked to enter volume or
parameter and then excel should output the corresponding savings and ships
values fo

for example enter the volume

if user enters the volume 1x, then excel should return the output in
columnar form as follows

For 1x

ships   20
savings  1200

besides the above columns i would be adding other columns. So the macro or
form should ask the user to enter any of the input values/columns.  please
explain me how i would modify the
macro to input other columns.  If  user enters
one of the input values as blank or null , then it should still extract the
output based on other parameter. for example if user does not enter any
value for volume and enters T for parameter,

the output should be

1x

ships 20
savings 1200

3x

ships  67
saving 1400

please advise

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

$$Excel-Macros$$ urgent help on the excel macro or dashboard

[Sara Lee]

hello

i have the table in the below format and  4 columns as below  in excel

volumelocation   builds   saving



Now i want the user to be prompted for three values which will be
volume, location, builds and the excel should give the user corresponding
savings and the o/p should be in *vertical format* with all the inputs. o/p
should be

volume: [ value entered by user]
location:[ value entered by user]
builds:[ value entered by user]
saving: corresponding value in the table for that row of inputs

is there a template or a macro or a dashboard... can you pls hlep.

thanks

-- 
--
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$$ urgent help needed.

[Sara Lee]

This helps . Thank you much.

On Sun, Jul 31, 2011 at 1:18 AM, ashish koul  wrote:

> Try this see if it helps
>
>
> On Sun, Jul 31, 2011 at 12:18 AM, Sara Lee  wrote:
>
>> hello
>>
>> i need to combine multiple  excel files(15) into one excel file. Each file
>> has 2 sheets... R and S and data from both needs to consolidated into
>> respective sheets. .. so i need a macro which can give one file with two
>> sheets that consolidate data from all the files...  All the files have same
>> structure and columns.
>>
>> Also please let me know step by step on how to run the macro and do i have
>> to run it from the first file
>>
>> Thanks  much.. this is urgent
>>
>> --
>>
>> --
>> 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 <http://akoul.blogspot.com/>
> http://akoul.posterous.com/
>  *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> 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$$ urgent macro required pls

[Sara Lee]

Thank You Daniel. I really appreciate it.

On Sun, Jul 31, 2011 at 10:52 AM, Daniel  wrote:

> Open the workbook where the results are to be copied in. The macro adds
> maps and shipment sheets so there should be no such sheets in the workbook.
> Press the Alt+F11 keys, this opens the VB Editor window. Now, keep in mind
> that I use a French version of Excel, so the words I use may not be Exactly
> those of an English version. In the left part of the window, look for a
> project that has the same name as your workbook. Click on it; click on the
> “Insert” menu, then click on “Module”. Paste the below macro in the right
> part of the screen and you are done !
>
> Now, running the macro depends of your version of Excel; the simplest way
> to do it is to click into the macro and press the F5 key. Please, tell which
> version you use and I tell you how to run it from the Excel window.
>
> ** **
>
> Sub Consolidate()
>
> 'this macro should be placed in the result workbook
>
> Dim inCalculationMode As Integer
>
> Application.ScreenUpdating = False
>
> inCalculationMode = Application.Calculation
>
> Application.Calculation = xlCalculationManual
>
> Const strPath As String = _
>
> "C:\Users\Daniel\Documents\Donnees\Daniel\mpfe\" 'change the path*
> ***
>
> Dim strFile As String, shMaps As Worksheet, shShipment As Worksheet***
> *
>
> Dim arrSheets
>
> arrSheets = Array("maps", "shipment")
>
> Sheets.Add.Name = "maps"
>
> Sheets.Add.Name = "shipment"
>
> 'guess headers are in row 1
>
> 'guess all columns are equal length
>
> 'guess there is data in column A
>
> strFile = Dir(strPath & "*.xls*")
>
> Do While strFile <> ""
>
> Workbooks.Open strPath & strFile
>
> For Each sh In arrSheets
>
> With Sheets(sh)
>
> If ThisWorkbook.Sheets(sh).Range("A1") = "" Then
>
> .Range(.[A1], .Cells(Rows.Count,
> 1).End(xlUp)).EntireRow.Copy
>
> 
>
> ThisWorkbook.Sheets(sh).Range("A1").PasteSpecial
> xlPasteValues
>
> Else
>
> .Range(.[A2], .Cells(Rows.Count,
> 1).End(xlUp)).EntireRow.Copy
>
> ThisWorkbook.Sheets(sh).Cells(Rows.Count,
> 1).End(xlUp).Offset(1).PasteSpecial xlPasteValues
>
> End If
>
> End With
>
> Next sh
>
> ActiveWorkbook.Close False
>
> strFile = Dir
>
> Loop
>
> Application.Calculation = inCalculationMode
>
> Application.ScreenUpdating = True
>
> End Sub
>
> ** **
>
> Regards.
>
> ** **
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Sara Lee
> *Envoyé :* dimanche 31 juillet 2011 14:03
> *À :* excel-macros@googlegroups.com
> *Objet :* Re: $$Excel-Macros$$ urgent macro required pls
>
> ** **
>
> i would like to add rows of respective sheets to be added below one
> another. i have never run a macro. Can you please give step by step
> instruction.
>
> On Sun, Jul 31, 2011 at 5:27 AM, Daniel  wrote:
>
> Hi,
>
> Do you want to add the rows of each sheet below the preceding ones, or do
> you intend to consolidate the sheets like you'll do it with Data,
> Consolidate menus ?
>
> Regards.
>
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> De
> la part de lee
> Envoyé : samedi 30 juillet 2011 19:56
> À : MS EXCEL AND VBA MACROS
> Objet : $$Excel-Macros$$ urgent macro required pls
>
>
> hello
>
> i have 15 files in one folder. i need to combine two  sheets called as maps
> and shipment of  all the 15 files into one consolidated file with
> 2 sheets( with respective data). Structure and columns are same in sheets
> for  all the files.
>
> Can you pls give a macro.. also can you please let m e know on how to run
> the macro i never ran it.. like do i have to open the first spreadsheet
> while running macro
>
> thanks
>
> --
>
> 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http:

Re: $$Excel-Macros$$ urgent macro required pls

[Sara Lee]

i would like to add rows of respective sheets to be added below one another.
i have never run a macro. Can you please give step by step instruction.

On Sun, Jul 31, 2011 at 5:27 AM, Daniel  wrote:

> Hi,
>
> Do you want to add the rows of each sheet below the preceding ones, or do
> you intend to consolidate the sheets like you'll do it with Data,
> Consolidate menus ?
>
> Regards.
>
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> De
> la part de lee
> Envoyé : samedi 30 juillet 2011 19:56
> À : MS EXCEL AND VBA MACROS
> Objet : $$Excel-Macros$$ urgent macro required pls
>
> hello
>
> i have 15 files in one folder. i need to combine two  sheets called as maps
> and shipment of  all the 15 files into one consolidated file with
> 2 sheets( with respective data). Structure and columns are same in sheets
> for  all the files.
>
> Can you pls give a macro.. also can you please let m e know on how to run
> the macro i never ran it.. like do i have to open the first spreadsheet
> while running macro
>
> thanks
>
> --
>
> 
> --
> 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

$$Excel-Macros$$ urgent help needed.

[Sara Lee]

hello

i need to combine multiple  excel files(15) into one excel file. Each file
has 2 sheets... R and S and data from both needs to consolidated into
respective sheets. .. so i need a macro which can give one file with two
sheets that consolidate data from all the files...  All the files have same
structure and columns.

Also please let me know step by step on how to run the macro and do i have
to run it from the first file

Thanks  much.. this is urgent

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