$$Excel-Macros$$ i need written pdf to excel macro please helpme

2013-06-05 Thread Sharmila k
-- 
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$$ i need written pdf to excel macro please helpme

2013-06-05 Thread Sharmila k
-- 
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$$ Abridged summary of excel-macros@googlegroups.com - 32 Messages in 12 Topics

2013-06-05 Thread krishan jha
Hi Team excel,
 
I want to create horizontal filter in excel file which having huge data.
could you please help me.
 
Thanks,
Kris

--- On Tue, 6/4/13, excel-macros@googlegroups.com 
excel-macros@googlegroups.com wrote:


From: excel-macros@googlegroups.com excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 
32 Messages in 12 Topics
To: Abridged Recipients excel-macros@googlegroups.com
Date: Tuesday, June 4, 2013, 8:36 PM



  Today's Topic Summary
Group: http://groups.google.com/group/excel-macros/topics

Urgent need Cold Fusion - Technical Specialist @ NJ [1 Update]
Macro - To Combine data from multiple worksheets into one single worksheet [2 
Updates]
Urgent Need Windows Admin @ OH [1 Update]
Please help Excel Gurus [6 Updates]
Formula require [4 Updates]
Hey I want to know how to create variable macros for creating the attendence 
sheet plese help me out [2 Updates]
[No Subject] [3 Updates]
Want to add every third row or coloumn! [5 Updates]
Marge Data from Different workssheet. [3 Updates]
Know cell.address for a clicked hyperlink [1 Update]
Need to builtd carreer in MIS/Database Reporting [1 Update]
use full link to learn Excel [3 Updates]
 Urgent need Cold Fusion - Technical Specialist @ NJ

adam smith adam.app...@gmail.com Jun 04 09:48PM +0530  

* *
 
* *
 
*Apps**-**Star** LLC*
 
* ……GO for IT ,IT Works*
 
*
**Dear Associates,*
 
*My name is **ADAM SMITH* *Account Manager at APPS-STAR LLC *
 
*About Apps-Star LLC*
...more

 Macro - To Combine data from multiple worksheets into one single worksheet

KAUSHIK SAVLA savla.kaus...@gmail.com Jun 04 09:23PM +0530  

Hi Team,
 
Need your help in creating the macro doing the below:-
 
I am having huge data in different worksheets
I am having 10 worksheets in total
I want to get the data copied from each ...more


Paul Schreiner schreiner_p...@att.net Jun 04 09:44AM -0700  

What experience do you have with VBA and macros?
 
If you record a macro in which you use Ctrl-End to locate the last used cell, 
you can then use the row number from that selection to determine ...more

 Urgent Need Windows Admin @ OH

adam smith adam.app...@gmail.com Jun 04 09:15PM +0530  

*Apps**-**Star** LLC*
 
* ……GO for IT ,IT Works*
 
*
*Dear Associates,
 
My name is *ADAM SMITH* Account Manager at APPS-STAR LLC
 
* *
 
*About Apps-Star LLC*
...more

 Please help Excel Gurus

Harish P Y py.har...@gmail.com Jun 03 08:52PM -0700  

Hi Every One,
Please find the attached file,
Kindly help me with the required formula
 
In the file there is a table,
with start date end date amount and corresponding months in rows ...more


Vabz v...@vabs.in Jun 03 10:13PM -0700  

Hi
 
Chek this file.
 
I have changed dates in header to respective month ends since deductions 
are made at the end of the month.
 
HTH//Vabs
 
On Tuesday, June 4, 2013 9:22:38 AM UTC+5:30, ...more


Harish P Y py.har...@gmail.com Jun 04 11:14AM +0530  

Hi,
Thank you very much for replying to my quire y,
 
firstly the amount needs to be calculated for a day and then equally
distributed for no of days in that particular month. kindly help me ...more


Vabz v...@vabs.in Jun 04 12:10AM -0700  

PFA
 
On Tuesday, June 4, 2013 11:14:15 AM UTC+5:30, Harish P Y wrote:
...more


P.VIJAYKUMAR vijay.4...@gmail.com Jun 04 04:47PM +0530  

Respected Harish,
 
On what ratio do you want to distribute the amount based on the date.what
are the specific criteria for distributing.
 
Regards,
VIJAYKUMAR
 
 
 
-- 
 
 
 
 
 
 
 
 
...more


Bé Trần Văn betnmtdongna...@gmail.com Jun 04 11:14PM +0800  

Formula Cell G5
 
=$F5/($E$5-$D$5)
 
Fill down and fill right
 
2013/6/4 P.VIJAYKUMAR vijay.4...@gmail.com
 
...more

 Formula require

Prabhakar S H prabakar.k...@gmail.com Jun 04 04:19AM -0700  

Hi Team,

i want to get formula to find Total value of cars with black color only. 
pls help.

Rgds,
Prabhakar
...more


priti verma pritiverma1...@gmail.com Jun 04 04:54PM +0530  

try this
=SUMIFS($J$9:$J$17,$H$9:$H$17,Cars,$I$9:$I$17,black)
 
 
...more


Prince prince141...@gmail.com Jun 04 04:46AM -0700  

may be it can help you.
 
=SUMPRODUCT(--(I9:I17=Black),--(H9:H17=Cars),(J9:J17))
 
Regards
Prince
 
On Tuesday, June 4, 2013 4:49:56 PM UTC+5:30, Prabhakar S H wrote:
...more


Eugene Bernard eugene.bern...@gmail.com Jun 04 07:43PM +0530  

Hi Prince,
 
What is the use of -- in the formula mentioned by you.
 
The result is OK, but I do not find this of syntax in Excel Help.
 
Please elaborate.
 
Regards
Eugene
 
 
...more

 Hey I want to know how to create variable macros for creating the attendence 
sheet plese help me out

rajkmr4...@gmail.com Jun 04 06:55AM -0700  

...more


Paul Schreiner schreiner_p...@att.net Jun 04 07:13AM -0700  

The Body of your email ended up in the subject line.
 
From the subject line, I gather you have an attendance sheet.
 
But the term variable macros is confusing.
 
You want macros that vary? ...more

 [No Subject]

Raj Kumar rajlu...@gmail.com Jun 04 

Re: $$Excel-Macros$$ i need a macro to convert written pdf to excel. please help me

2013-06-05 Thread Francis Mukobi


Sharmila k sharmi.sha...@gmail.com wrote:

Hi friends, 
I need a macro to convert written pdf to excel using by excel vba. Please 
anyone can help me asap.

Thanks,
Vimal

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

2013-06-05 Thread jason nix

http://grashal.com/fisogpq/geljnglz.php

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




Re: $$Excel-Macros$$ Please help Excel Gurus

2013-06-05 Thread Harish P Y
Hi ravinder ,

The formula i wanted is as below if amount is Rs 6000 per month , per day
it is around Rs 200 . when we enter the start date and finish date the
amount
should be distributed by no of days in the month.
ie in january if it is 13 days it should show 2600 in january month column
please help me out in solving this issue

Regards
Harish

With Regards

*HARISH P Y*

*P** **THINK BEFORE YOU PRINT:**Before printing this e-mail think whether
it is really necessary. Thanks for your support to protect our environment
for the future generation*

*1 ream of paper = 6% of a tree and 5.4 kg CO2 in the atmosphere
3 sheets of A4 paper pollutes 1 litre of water*




On Wed, Jun 5, 2013 at 2:54 PM, ravinder negi ravi_colw...@yahoo.comwrote:

 HI,

 I have attached the solution, amount has been distributed equally
 (6000/difference between startdate and enddate). if you distribute in other
 ratio just change the calculation in formula.

 Thanks
 Ravinder

 --- On *Tue, 6/4/13, Bé Trần Văn betnmtdongna...@gmail.com* wrote:


 From: Bé Trần Văn betnmtdongna...@gmail.com
 Subject: Re: $$Excel-Macros$$ Please help Excel Gurus
 To: excel-macros@googlegroups.com
 Date: Tuesday, June 4, 2013, 8:44 PM

 Formula Cell G5

 =$F5/($E$5-$D$5)

 Fill down and fill right

 2013/6/4 P.VIJAYKUMAR 
 vijay.4...@gmail.comhttp://mc/compose?to=vijay.4...@gmail.com
 

  Respected Harish,

 On what ratio do you want to distribute the amount based on the date.what
 are the specific criteria for distributing.

 Regards,
 VIJAYKUMAR


 On Tue, Jun 4, 2013 at 9:22 AM, Harish P Y 
 py.har...@gmail.comhttp://mc/compose?to=py.har...@gmail.com
  wrote:

 Hi Every One,
 Please find the attached file,
 Kindly help me with the required formula

 In the file there is a table,
 with start date end date amount and corresponding months in rows
 i want a formula to distribute the amount month wise by referring to start
 date and end date
 Kindly help me regarding this issue.

 Regards
 Harish

 --
 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.comhttp://mc/compose?to=excel-macros%2bunsubscr...@googlegroups.com
 .
 To post to this group, send email to 
 excel-macros@googlegroups.comhttp://mc/compose?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.






 --









 P.VIJAY KUMAR

 --
 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.comhttp://mc/compose?to=excel-macros%2bunsubscr...@googlegroups.com
 .
 To post to this group, send email to 
 excel-macros@googlegroups.comhttp://mc/compose?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 

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 32 Messages in 12 Topics

2013-06-05 Thread Paul Schreiner
It looks like you've posted a NEW topic as part of a SUMMARY of topics in the 
group.

If you need assistance, I suggest you select the New Topic button at the top 
of the site.

Also, use a descriptive subject to help attract the participants that have an 
interest or area of expertise in the subject area.

next... explain exactly what you're trying to do and how you wish to accomplish 
your task (Excel functions, VBA macros, or other)

It would be helpful to supply examples or even a sample file.
Since sometimes a problem takes 5 minutes to solve, but 15 minutes  or more to 
figure out and assemble sample data.
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: krishan jha kris4u1...@yahoo.com
To: excel-macros@googlegroups.com
Sent: Wed, June 5, 2013 2:49:46 AM
Subject: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 
32 
Messages in 12 Topics


Hi Team excel,

I want to create horizontal filter in excel file which having huge data. 
could you please help me. 

Thanks,
Kris

--- On Tue, 6/4/13, excel-macros@googlegroups.com 
excel-macros@googlegroups.com wrote:


From: excel-macros@googlegroups.com excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 
32 
Messages in 12 Topics
To: Abridged Recipients excel-macros@googlegroups.com
Date: Tuesday, June 4, 2013, 8:36 PM


  Today's Topic Summary
Group: http://groups.google.com/group/excel-macros/topics
   * Urgent need Cold Fusion - Technical Specialist @ NJ [1 Update]
   * Macro - To Combine data from multiple worksheets into one single 
 worksheet [2 
Updates]
   * Urgent Need Windows Admin @ OH [1 Update]
   * Please help Excel Gurus [6 Updates]
   * Formula require [4 Updates]
   * Hey I want to know how to create variable macros for creating the 
 attendence 
sheet plese help me out [2 Updates]
   * [No Subject] [3 Updates]
   * Want to add every third row or coloumn! [5 Updates]
   * Marge Data from Different workssheet. [3 Updates]
   * Know cell.address for a clicked hyperlink [1 Update]
   * Need to builtd carreer in MIS/Database Reporting [1 Update]
   * use full link to learn Excel [3 Updates]
 Urgent need Cold Fusion - Technical Specialist @ NJ
adam smith adam.app...@gmail.com Jun 04 09:48PM +0530  

* *
 
* *
 
*Apps**-**Star** LLC*
 
* ……GO for IT ,IT Works*
 
*
**Dear Associates,*
 
*My name is **ADAM SMITH* *Account Manager at APPS-STAR LLC *
 
*About Apps-Star LLC*
...more

 Macro - To Combine data from multiple worksheets into one single worksheet
KAUSHIK SAVLA savla.kaus...@gmail.com Jun 04 09:23PM +0530  

Hi Team,
 
Need your help in creating the macro doing the below:-
 
I am having huge data in different worksheets
I am having 10 worksheets in total
I want to get the data copied from each ...more

Paul Schreiner schreiner_p...@att.net Jun 04 09:44AM -0700  

What experience do you have with VBA and macros?
 
If you record a macro in which you use Ctrl-End to locate the last used cell, 
you can then use the row number from that selection to determine ...more

 Urgent Need Windows Admin @ OH
adam smith adam.app...@gmail.com Jun 04 09:15PM +0530  

*Apps**-**Star** LLC*
 
* ……GO for IT ,IT Works*
 
*
*Dear Associates,
 
My name is *ADAM SMITH* Account Manager at APPS-STAR LLC
 
* *
 
*About Apps-Star LLC*
...more

 Please help Excel Gurus
Harish P Y py.har...@gmail.com Jun 03 08:52PM -0700  

Hi Every One,
Please find the attached file,
Kindly help me with the required formula
 
In the file there is a table,
with start date end date amount and corresponding months in rows ...more

Vabz v...@vabs.in Jun 03 10:13PM -0700  

Hi
 
Chek this file.
 
I have changed dates in header to respective month ends since deductions 
are made at the end of the month.
 
HTH//Vabs
 
On Tuesday, June 4, 2013 9:22:38 AM UTC+5:30, ...more

Harish P Y py.har...@gmail.com Jun 04 11:14AM +0530  

Hi,
Thank you very much for replying to my quire y,
 
firstly the amount needs to be calculated for a day and then equally
distributed for no of days in that particular month. kindly help me ...more

Vabz v...@vabs.in Jun 04 12:10AM -0700  

PFA
 
On Tuesday, June 4, 2013 11:14:15 AM UTC+5:30, Harish P Y wrote:
...more

P.VIJAYKUMAR vijay.4...@gmail.com Jun 04 04:47PM +0530  

Respected Harish,
 
On what ratio do you want to distribute the amount based on the date.what
are the specific criteria for distributing.
 
Regards,
VIJAYKUMAR
 
 
 
-- 
 
 
 
 
 
 
 
 
...more

Bé Trần Văn betnmtdongna...@gmail.com Jun 04 11:14PM +0800  

Formula Cell G5
 
=$F5/($E$5-$D$5)
 
Fill down and fill right
 
2013/6/4 P.VIJAYKUMAR vijay.4...@gmail.com
 
...more

 Formula require
Prabhakar S 

$$Excel-Macros$$ Rerquire Formula.xlsx

2013-06-05 Thread Gulam Hameed
Dear Experts,

 

Please find the attached xl file formula required please help.

 

Regards 

Gulam Hameed

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




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


Re: $$Excel-Macros$$ Rerquire Formula.xlsx

2013-06-05 Thread priti verma
Activity for yes status
=COUNTIFS($D$3:$D$56,I5,$C$3:$C$56,yes)
Activity for no status
=COUNTIFS($D$3:$D$56,I5,$C$3:$C$56,no)


On Wed, Jun 5, 2013 at 7:26 PM, Gulam Hameed gulamham...@gmail.com wrote:

  Dear Experts,

 ** **

 Please find the attached xl file formula required please help.

 ** **

 Regards 

 Gulam Hameed

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




RE: $$Excel-Macros$$ Rerquire Formula.xlsx

2013-06-05 Thread Gulam Hameed
Thank you so much  priti 

 

Gulam Hameed

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of priti verma
Sent: Wednesday, June 05, 2013 5:30 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Rerquire Formula.xlsx

 

Activity for yes status

=COUNTIFS($D$3:$D$56,I5,$C$3:$C$56,yes)

Activity for no status

=COUNTIFS($D$3:$D$56,I5,$C$3:$C$56,no)

 

On Wed, Jun 5, 2013 at 7:26 PM, Gulam Hameed gulamham...@gmail.com wrote:

Dear Experts,

 

Please find the attached xl file formula required please help.

 

Regards 

Gulam Hameed

-- 
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
mailto:excel-macros%2bunsubscr...@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.
 
 

-- 
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$$ Need Urgent Oracle DBA, with Data warehousing @ CA

2013-06-05 Thread adam.apps02
*Apps-Star LLC*

*……GO for IT ,IT Works*

*
*Dear Manager

My name is *ADAM SMITH* Account Manager at APPS-STAR LLC

* *

*About Apps-Star LLC *

Apps Star is a global IT consulting company with 1,000 consultants
in America, Europe and Asia/Pacific, and approximately $1 billion in annual
revenue. Client focused and results driven, Apps Star partners with
organizations to develop technology strategies and solutions that deliver
tangible business value



* *

*Requirement Of the Day From Direct Client *

* *

*Title** :* *Oracle** DBA,*

*Location  : **Sunnyvale**, CA*

*Duration** : 8+ Months*

* *

* *

*Primary Skills**:* *Oracle DBA, with Strong experience in Oracle Data
warehousing*

*Responsibilities:*

•  *DBA in Data warehousing  Tuning experience*
•  Very good knowledge of oracle internals
•  Parameter set-up for *Data warehousing environment*
•  Knowledge about *Oracle Parallel execution, Oracle multi-level
partitioning (partition wise joins, split, merge, partition exchange, etc.)
and Oracle Wait Events*
•  *UNIX Shell scripting*

*Desired Skills   *

• Experience working with O*racle Grid Control (good to have)*
• Good knowledge of* Data warehouse concepts. (preferred)*
• Expert in *database instance and query tuning. (good to have)*
• Knowledge of *NetApp storage knowledge and AIX background is preferred.
(Good to have) *



Send me your Resume to *a...@apps-star.com* with below details:

Full Legal Name :

Location :

Visa status :

Availability :

Relocation :











 *ADAM SMITH*


-
*Client Support Account Manager **
Call: 773-309-1667 |Email: a...@apps-star.com
Y:adam_ap...@ymail.com|G:adam.ap...@gmail.com
F: adam.ap...@facebook.com
L: *www.linkedin.com/pub/adam-smith/71/8a0/566/*
**



Note: If you have received this mail in error or prefer not to receive such
emails in the future, please reply with REMOVE in the subject line and
the email id(s) to be removed. All removal requests will be honored ASAP.
We sincerely apologize for any inconvenience caused.*

-- 
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$$ Invitation to use Google Talk

2013-06-05 Thread Google Talk
I've been using Google Talk and thought you might like to try it out.
We can use it to call each other for free over the internet. Here's an
invitation to download Google Talk. Give it a try!

---

You've been invited by Mr Excellent to use Google Talk.

If you already have a Google account, login to Gmail and accept this chat
invitation:
http://mail.google.com/mail/b-c528d6c904-a6dfd3dbb6-vJ5PLNYUE0qDRwsYIyTh04uXkPw

To sign up for a Google account and get started with Google Talk, you can
visit:
http://mail.google.com/mail/a-c528d6c904-a6dfd3dbb6-vJ5PLNYUE0qDRwsYIyTh04uXkPw?pc=en-rf---a

Learn more at:
http://www.google.com/intl/en/landing/accounts/


Thanks,
The Google Team

-- 
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$$ Need Urgent Oracle DBA, with Data warehousing @ CA

2013-06-05 Thread adam smith
*Apps-Star LLC*

*……GO for IT ,IT Works*

*
*Dear Manager

My name is *ADAM SMITH* Account Manager at APPS-STAR LLC

* *

*About Apps-Star LLC *

Apps Star is a global IT consulting company with 1,000 consultants
in America, Europe and Asia/Pacific, and approximately $1 billion in annual
revenue. Client focused and results driven, Apps Star partners with
organizations to develop technology strategies and solutions that deliver
tangible business value



* *

*Requirement Of the Day From Direct Client *

* *

*Title** :* *Oracle** DBA,*

*Location  : **Sunnyvale**, CA*

*Duration** : 8+ Months*

* *

* *

*Primary Skills**:* *Oracle DBA, with Strong experience in Oracle Data
warehousing*

*Responsibilities:*

•  *DBA in Data warehousing  Tuning experience*
•  Very good knowledge of oracle internals
•  Parameter set-up for *Data warehousing environment*
•  Knowledge about *Oracle Parallel execution, Oracle multi-level
partitioning (partition wise joins, split, merge, partition exchange, etc.)
and Oracle Wait Events*
•  *UNIX Shell scripting*

*Desired Skills   *

• Experience working with O*racle Grid Control (good to have)*
• Good knowledge of* Data warehouse concepts. (preferred)*
• Expert in *database instance and query tuning. (good to have)*
• Knowledge of *NetApp storage knowledge and AIX background is preferred.
(Good to have) *



Send me your Resume to *a...@apps-star.com* with below details:

Full Legal Name :

Location :

Visa status :

Availability :

Relocation :











 *ADAM SMITH*


-
*Client Support Account Manager **
Call: 773-309-1667 |Email: a...@apps-star.com
Y:adam_ap...@ymail.com|G:adam.ap...@gmail.com
F: adam.ap...@facebook.com
L: *www.linkedin.com/pub/adam-smith/71/8a0/566/*
**



Note: If you have received this mail in error or prefer not to receive such
emails in the future, please reply with REMOVE in the subject line and
the email id(s) to be removed. All removal requests will be honored ASAP.
We sincerely apologize for any inconvenience caused.*

-- 
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$$ Urgent need Cold Fusion - Technical Specialist @ NJ

2013-06-05 Thread adam smith
* *

* *

*Apps**-**Star** LLC*

*……GO for IT ,IT Works*

*
**Dear Associates,*

*My name is **ADAM SMITH* *Account Manager at APPS-STAR LLC *

*About Apps-Star LLC*

*Apps** Star is a global IT consulting company with 1,000 consultants
in America, Europe and Asia/Pacific, and approximately $1 billion in annual
revenue. Client focused and results driven, AppsStar partners with
organizations to develop technology strategies and solutions that deliver
tangible business value*

 * **Requirement Of the Day From Direct Client** *

*Cold Fusion - Technical Specialist*

*Location: Wayne, NJ*

*Duration : 2 Years*

*Rate: $Low *

* *



*Details of Position:*

Develops  debugs application programs; executes system  integration
tests; supports production applications; knowledge of Agile Development a
plus: Scrum methodology

*Management Skills:*

Excellent oral  written communication skills, excellent
problem-solving skills, flexibility, adaptive to change, good interpersonal
skills, demonstrate self-initiatives, good planning and organizing, must
possess the following traits for Agile Development: forward thinker,
excellent collaborator, adaptive to change, ability to work well in a
self-organizing team, demonstrate commitment to process  self-improvement

*Primary Skill: *Cold Fusion

*Additional Skills:*

· SQL Programming – A MUST!

· Cold Fusion - Advanced

· JavaScript - Intermediate

· SQL  PL/SQL - Advanced

· .NET Environment - Intermediate

· ADO .NET - Intermediate

· ASP .NET Web Programming – Beginner

Send me your Resume to *a...@apps-star.com* with below details:

Full Legal Name :

Location :

Visa status :

Availability :

Relocation :

SSN:

 *ADAM SMITH*


-
*Client Support Account Manager **
Call: 773-309-1667 |Email: a...@apps-star.com
Y:adam_ap...@ymail.com|G:adam.ap...@gmail.com
F: adam.ap...@facebook.com
L: 
**www.linkedin.com/pub/adam-smith/71/8a0/566**/*http://www.linkedin.com/pub/adam-smith/71/8a0/566/

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




Re: $$Excel-Macros$$

2013-06-05 Thread Vikas Bhosale
Hi guys ,

I am using 2007 Microsoft excel. I am using pivot table but when I create it 
every time I need to go in pivot option then select display tab and then select 
pivot classic option every time. Is it any option for classics display. When I 
create pivot table then it directly create in classic option.  
Sent from my BlackBerry® Smartphone on Loop Mobile.

-Original Message-
From: Prafull Jadhav prafulltjad...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 3 Jun 2013 11:47:06 
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$

Dear  Vikas,

if the cell value length is less then 11 then find the solution with
Vlookup and Mid function.

if length if more then 10 then you have to edit the formula and add the
condition.



On Mon, Jun 3, 2013 at 11:35 AM, Vikas Bhosale vikin...@gmail.com wrote:

 Hi Frnd here I attached excel file
 Sent from my BlackBerry® Smartphone on Loop Mobile.

 -Original Message-
 From: chhajersand...@gmail.com
 Sender: excel-macros@googlegroups.com
 Date: Mon, 3 Jun 2013 05:41:42
 To: excel-macros@googlegroups.com
 Reply-To: excel-macros@googlegroups.com
 Subject: Re: $$Excel-Macros$$

 How many alphabets are there? are there always 4 alphabets grouped
 together? And are always the alphabets in capital letter?

 Sandeep
 Sent on my BlackBerry® from Vodafone

 -Original Message-
 From: Vikas Bhosale vikin...@gmail.com
 Sender: excel-macros@googlegroups.com
 Date: Mon, 3 Jun 2013 05:32:34
 To: excel-macros@googlegroups.com
 Reply-To: excel-macros@googlegroups.com
 Subject: $$Excel-Macros$$

 Hi experts ,

 I am beginner of excel. And I want to convert alphabet in number . Like.

 ABCD = 1234

 A=1
 B=2
 C=3
 D=4
 E=5
 F=6
 G=7
 H=8
 I=9
 J=0
 In excel one cell there is ABCD I want to convert this alphabet in number
 like 1234
 Other example:
 GJIA then need to convert in 7091

 Please help me to solve this problem I use if conditions then concatenate
 but not get Wright. Answer and this process is very lengthy.

 Plz plz help me to solve this problem.

 Sent from my BlackBerry® Smartphone on Loop Mobile.

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


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

$$Excel-Macros$$ Please help me adding variables to my macro

2013-06-05 Thread Mccue
I am attaching a macro that I recorded. But I need the variables to be 
updated
 
Basically this macro is going thru several tabs and update the pivot tables 
by simply changing the dates.
 
So everytime I run the macro, I want dates in these pivot tables to be 
updated to today.
 
Please look at the attached.
Thanks

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




Book3.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12


$$Excel-Macros$$ Need Urgent Electronic Data Interchange (EDI) @ NJ

2013-06-05 Thread adam smith
*Apps-Star LLC*

*……GO for IT ,IT Works*

*
*Dear Manager

My name is  *ADAM SMITH  *Account Manager at APPS-STAR LLC

* *

*About Apps-Star LLC *

Apps Star is a global IT consulting company with 1,000 consultants
in America, Europe and Asia/Pacific, and approximately $1 billion in annual
revenue. Client focused and results driven, Apps Star partners with
organizations to develop technology strategies and solutions that deliver
tangible business value



* *

*Requirement Of the Day From Direct Client *

* *

*Title** **:** Electronic Data Interchange (EDI) *

*Location  : **Wayne**, NJ*

*Duration** : 8+ Months*

*Interview: **F2F interview/local candidates preferred*



* *

*Explanation for Position:*

This requisition is for a supplemental staff position in the Electronic
Data Interchange (EDI) mainframe group. The EDI group utilizes IBM’s,
formerly Sterling, product Gentran to transform data from application flat
file format to EDI format and vice versa. Currently both ANSI and EDIFACT
are supported. Although EDI supports over 35 different EDI messages, the
majority of the volume are 210s, 214s, 215s, and 240s.

*Details of Position:*

· The individual must have extensive knowledge of Gentran on the
mainframe, COBOL, JCL, MQ, Syncsort, IBM utilities on the mainframe, VSAM,
File Aid, Expediter, S/FTP/S, Connect Direct (formerly Sterling RDX),
Easytrieve and REXX.

· If the candidate has working knowledge of ESP, DB2, SQL and
Changeman, it is a plus.

· The individual will be involved in every phase of the development
lifecycle.

· He/ She must be able to attend requirements meetings, translate
the requirements into design documents, code from a design document, create
test scenarios/cases/scripts, perform and support various testing cycles,
create implementation plans and implement the change.

· In addition, this person will recommend process improvements and
support the application including off site coverage.



Send me your Resume to a...@apps-star.com  with below details:





Full Legal Name:

Location:

Visa status:

Availability:

Relocation:













 *ADAM SMITH*


-
*Client Support Account Manager **
Call: 773-309-1667 |Email: a...@apps-star.com
Y:adam_ap...@ymail.com|G:adam.ap...@gmail.com
F: adam.ap...@facebook.com
L: *www.linkedin.com/pub/adam-smith/71/8a0/566/

*
**Note:** If you have received this mail in error or prefer not to receive
such emails in the future, please reply with **REMOVE** in the subject
line and the email id(s) to be removed. All removal requests will be
honored ASAP. We sincerely apologize for any inconvenience caused.

*

-- 
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$$ Re: Help Needed

2013-06-05 Thread Prince
But what u want to do with this data ?

prince

On Wednesday, June 5, 2013 6:50:19 PM UTC+5:30, Patil M G wrote:

 HI Team Excel Experts

 I am learning Excel and new to Macro coding. I want to create attached 
 INPUT FILE Format into Output Format...always INPUT FILE have huge 
 data, difficult to do it manually

 could you please help me to generate macro or is their any other solution 
 ( formula) to over come this problem

 -- 
 Thank You
 Patil MG
 91 99016 16995 


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




Re: $$Excel-Macros$$ Help Needed

2013-06-05 Thread Patil MG
its serving my requirement..thank you so much for help paul

thanks
Patil MG


On Wed, Jun 5, 2013 at 8:05 PM, Paul Schreiner schreiner_p...@att.netwrote:

 Try this macro.

 if it does what you're looking for, then I can walk you through how it
 operates.


 *Paul*

 -
 *“Do all the good you can,
 By all the means you can,
 In all the ways you can,
 In all the places you can,
 At all the times you can,
 To all the people you can,
 As long as ever you can.” - John Wesley
 *-


  --
 *From:* Patil MG mailpati...@gmail.com
 *To:* excel-macros@googlegroups.com; Patil M G Gmail 
 mailpati...@gmail.com
 *Sent:* Wed, June 5, 2013 9:25:36 AM
 *Subject:* $$Excel-Macros$$ Help Needed

 HI Team Excel Experts

 I am learning Excel and new to Macro coding. I want to create attached
 INPUT FILE Format into Output Format...always INPUT FILE have huge
 data, difficult to do it manually

 could you please help me to generate macro or is their any other solution
 ( formula) to over come this problem

 --
 Thank You
 Patil MG
 91 99016 16995

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






-- 
Thank You
Patil MG
91 99016 16995

-- 
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$$ Conditional Search Replace

2013-06-05 Thread Amit Desai (MERU)
Dear Friends,

Do we have any functionality to do conditional search  replace...

For example what if I wants to search for values less than 80%  replace them 
by 80% in selected range! Do we have any features...

Best Regards,
Amit Desai



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

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