Re: $$Excel-Macros$$ Excel Macro Help

2017-12-19 Thread 'Kenyatta Freed' via MS EXCEL AND VBA MACROS 


On Tue, 12/19/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Excel Macro Help
 To: excel-macros@googlegroups.com
 Date: Tuesday, December 19, 2017, 3:29 AM
 
 
 
 On Mon, 12/18/17, V <vianeyespin...@nvo2.grandluxxe.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Excel
 Macro Help
  To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com>
  Date: Monday, December 18, 2017, 7:56
 PM
  
  Hi, do you know how
  can I get using validations in Google
 Drive that change the
  color by codes.
  
  El miércoles, 11 de octubre de 2017,
 11:40:37 (UTC-5),
  GENIUS escribió:look at the
  attachment, I can do only this.
  
  
  
  
  -- 
  
  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
 https://groups.google.com/group/excel-macros.
  
  For more options, visit
 https://groups.google.com/d/optout.
  ublicul va lua cunostinta de ele abia
 in anii '80 ai secolului nostru  ele
 
 -- 
 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
 https://groups.google.com/group/excel-macros.
 For more options, visit
 https://groups.google.com/d/optout.ascoala dteSc sale 
In v>-h > socia!-poiitrca a maniei.Rascoala din 1907 a constituit apogeul 
miscarilor sociale de la finele >cii modeme  ce s-a remarcat printr-o amploare  
intensitate  grad de violenta  irindere si caracter exploziv fara precedent. 
Unii contemporani au intrevazut  a un veritabil razboi taranesc  ce a impus cu 
stringenta necesitatea rezolvarii blemei agrare.

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

Re: $$Excel-Macros$$ Excel Macro Help

2017-12-18 Thread 'Julienne Schindler' via MS EXCEL AND VBA MACROS 


On Mon, 12/18/17, V <vianeyespin...@nvo2.grandluxxe.com> wrote:

 Subject: Re: $$Excel-Macros$$ Excel Macro Help
 To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com>
 Date: Monday, December 18, 2017, 7:56 PM
 
 Hi, do you know how
 can I get using validations in Google Drive that change the
 color by codes.
 
 El miércoles, 11 de octubre de 2017, 11:40:37 (UTC-5),
 GENIUS escribió:look at the
 attachment, I can do only this.
 
 
 
 
 -- 
 
 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 https://groups.google.com/group/excel-macros.
 
 For more options, visit https://groups.google.com/d/optout.
 ublicul va lua cunostinta de ele abia in anii '80 ai secolului nostru  ele

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Excel Macro Help

2017-12-18 Thread V 
Hi, do you know how can I get using validations in Google Drive that change 
the color by codes.

El miércoles, 11 de octubre de 2017, 11:40:37 (UTC-5), GENIUS escribió:
>
> look at the attachment, I can do only this.
>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Excel Macro Help

2017-10-11 Thread GENIUS 
look at the attachment, I can do only this.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


New folder.rar
Description: application/rar

Re: $$Excel-Macros$$ Excel Macro Help

2017-10-09 Thread Ram Prakash Palaniswamy 
Dear Paul,

Thank you for your help.
I have attached both files in the mail.

In the master file I’ve highlighted some columns, if I update any value in
the master file automatically it’s need to update in the another attached
excel..

Thank you in advance.

On Mon, 09 Oct 2017 at 14:41, Paul Schreiner  wrote:

> sure.
> fairly easily done.
> Please provide sample files.
>
> *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*
> -
>
>
> On Saturday, October 7, 2017 7:48 AM, Ram Prakash Palaniswamy <
> ramcb...@gmail.com> wrote:
>
>
> I have a master excel file (ABC.xls) which has n number of rows and
> columns.
>
> And also i have another excel file (DEF.xls) which has limited number of
> same data from the master excel file (ABC.xls).
>
> I need a macro code for if i update some values in the master excel file
> (ABC.xls), automatically
> the values needs to update in the second excel file (DEF.xls).
>
> Can you please any one help on this?
>
> Thank you in advance :-)
>
> --
> 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> 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/hroNyLwdv6s/unsubscribe.
> 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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
-- 
*With Thanks and Regards, *

*Ram Prakash Palaniswamy*

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

Re: $$Excel-Macros$$ Excel Macro Help

2017-10-09 Thread Paul Schreiner 
sure.fairly easily done.Please provide sample files. 
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
- 

On Saturday, October 7, 2017 7:48 AM, Ram Prakash Palaniswamy 
 wrote:
 

 I have a master excel file (ABC.xls) which has n number of rows and columns. 
And also i have another excel file (DEF.xls) which has limited number of same 
data from the master excel file (ABC.xls). 
I need a macro code for if i update some values in the master excel file 
(ABC.xls), automatically the values needs to update in the second excel file 
(DEF.xls). 
Can you please any one help on this? 
Thank you in advance :-) 
-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


   

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Excel Macro Help

2017-10-07 Thread Ram Prakash Palaniswamy 
I have a master excel file (ABC.xls) which has n number of rows and 
columns. 

And also i have another excel file (DEF.xls) which has limited number of 
same data from the master excel file (ABC.xls). 

I need a macro code for if i update some values in the master excel file 
(ABC.xls), automatically 
the values needs to update in the second excel file (DEF.xls). 

Can you please any one help on this? 

Thank you in advance :-) 

-- 
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 https://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

2013-08-04 Thread 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$$ excel macro help on regular basis required- on weekly payment/hourly basis

2013-08-04 Thread Sam Mathai Chacko 
As you can imagine, it's not easy to set up such a relationship that pays
on a weekly basis. Instead of paying weekly, why don't you hire a developer
on project basis only as and when you need it? You could use
http://www.excelfox.com/forum/f21/ to post queries that you are willing to
pay for.


On Sun, Aug 4, 2013 at 2:45 PM, Sara Lee lee.sar...@gmail.com wrote:

 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.






-- 
Sam Mathai Chacko

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

$$Excel-Macros$$ Excel macro help please

2012-12-17 Thread sw1085 
Hi all,

I've been searching for hours looking for a generic macro to help with the 
following problem.

If cell value in column J of worksheet Sheet1 = Apple or Pear then 
copy that cell plus the previous 4 cells to a new worksheet called Sheet2.

Hope someone can help.

Best regards

sw1085

-- 
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$$ Excel macro help please

2012-12-17 Thread ashish koul 
can you share the sample file


On Mon, Dec 17, 2012 at 9:57 PM, sw1085 swilson2...@gmail.com wrote:

 Hi all,

 I've been searching for hours looking for a generic macro to help with the
 following problem.

 If cell value in column J of worksheet Sheet1 = Apple or Pear then
 copy that cell plus the previous 4 cells to a new worksheet called Sheet2.

 Hope someone can help.

 Best regards

 sw1085

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






-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

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

FORUM RULES

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.

$$Excel-Macros$$ Excel Macro Help : Ambiguous name detected :

2010-06-02 Thread Sundarvelan N 
Hi Friends,

Please help me to solve the below issue.

While i try to use the below code it says Ambiguous name detected :W028M

Private Sub CommandButton1_Click()
Dim fn As String
fn = Trim(TextBox1.Text)
If fn = W001M Then
Call W001M
TextBox1.Text = 
ElseIf fn = W002BW Then
Call W002BW
TextBox1.Text = 
ElseIf fn = W003BW Then
Call W003BW
TextBox1.Text = 
ElseIf fn = W004W Then
Call W004W
TextBox1.Text = 
ElseIf fn = W005M Then
Call W005M
TextBox1.Text = 
ElseIf fn = W006BW Then
Call W006BW
TextBox1.Text = 
ElseIf fn = W007BW Then
Call W007BW
TextBox1.Text = 
ElseIf fn = W008BW Then
Call W008BW
TextBox1.Text = 
ElseIf fn = W009W Then
Call W009W
TextBox1.Text = 
ElseIf fn = W010W Then
Call W010W
TextBox1.Text = 
ElseIf fn = W011W Then
Call W011W
TextBox1.Text = 
ElseIf fn = W012W Then
Call W012W
TextBox1.Text = 
ElseIf fn = W013M Then
Call W013M
TextBox1.Text = 
ElseIf fn = W014BW Then
Call W014BW
TextBox1.Text = 
ElseIf fn = W015M Then
Call W015M
TextBox1.Text = 
ElseIf fn = W016W Then
Call W016W
TextBox1.Text = 
ElseIf fn = W017W Then
Call W017W
TextBox1.Text = 
ElseIf fn = W018W Then
Call W018W
TextBox1.Text = 
ElseIf fn = W019W Then
Call W019W
TextBox1.Text = 
ElseIf fn = W020W Then
Call W020W
TextBox1.Text = 
ElseIf fn = W021W Then
Call W021W
TextBox1.Text = 
ElseIf fn = W023M Then
Call W023M
TextBox1.Text = 
ElseIf fn = W024M Then
Call W024M
TextBox1.Text = 
ElseIf fn = W025M Then
Call W025M
TextBox1.Text = 
ElseIf fn = W026M Then
Call W026M
TextBox1.Text = 
ElseIf fn = W027M Then
Call W027M
TextBox1.Text = 
ElseIf fn = W028M Then
Call W028M
TextBox1.Text = 
ElseIf fn = W029M Then
Call W029M
TextBox1.Text = 
ElseIf fn = W030M Then
Call W030M
TextBox1.Text = 
ElseIf fn = W032W Then
Call W032W
TextBox1.Text = 
ElseIf fn = W033W Then
Call W033W
TextBox1.Text = 
ElseIf fn = W034W Then
Call W034W
TextBox1.Text = 
ElseIf fn = W035W Then
Call W035W
TextBox1.Text = 
ElseIf fn = W036W Then
Call W036W
TextBox1.Text = 
ElseIf fn = W037D Then
Call W037D
TextBox1.Text = 
ElseIf fn = W038W Then
Call W038W
TextBox1.Text = 
ElseIf fn = W039D Then
Call W039D
TextBox1.Text = 
ElseIf fn = W040W Then
Call W040W
TextBox1.Text = 
ElseIf fn = W041W Then
Call W041W
TextBox1.Text = 
ElseIf fn = W042W Then
Call W042W
TextBox1.Text = 
ElseIf fn = W043W Then
Call W043W
TextBox1.Text = 
ElseIf fn =  Then
MsgBox Please Enter The Report Number, vbOKOnly
Else
MsgBox Please Enter The Correct Report Number, vbOKOnly
TextBox1.Text = 
End If
End Sub


 Please help me

Thanks,
N.Sundarvelan

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


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Excel macro Help : Date of Previous day

2010-05-25 Thread Sundarvelan N 
Hi Friends,

Please give the VBA code to find the date of previous day (yesterday).

Thanks,
N.Sundarvelan

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


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Excel macro Help : Date of Previous day

2010-05-25 Thread Swapnil Palande 
Hi Sundarvelan,

There is no need to write vba code for this.

Use following function:
=NOW()-1 //This will return date and time ex.: 5/24/2010 13:11

=DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW())-1) // this will return only date
ex: 5/24/2010

Regards,

Swapnil.

On Tue, May 25, 2010 at 12:08 PM, Sundarvelan N nsund...@gmail.com wrote:

 Hi Friends,

 Please give the VBA code to find the date of previous day (yesterday).

 Thanks,
 N.Sundarvelan

 --

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

 
 HELP US GROW !!

 We reach over 7000 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


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


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Excel macro Help : Date of Previous day

2010-05-25 Thread Putta Madaiah 
use the following formula to get only the date.
=TODAY()-1
Regards,
Putta Madaiah
On Tue, May 25, 2010 at 1:15 PM, Swapnil Palande swapnilp1...@gmail.comwrote:

 Hi Sundarvelan,

 There is no need to write vba code for this.

 Use following function:
 =NOW()-1 //This will return date and time ex.: 5/24/2010 13:11

 =DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW())-1) // this will return only
 date ex: 5/24/2010

 Regards,

 Swapnil.

 On Tue, May 25, 2010 at 12:08 PM, Sundarvelan N nsund...@gmail.comwrote:

 Hi Friends,

 Please give the VBA code to find the date of previous day (yesterday).

 Thanks,
 N.Sundarvelan

 --

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

 
 HELP US GROW !!

 We reach over 7000 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


 --

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

 
 HELP US GROW !!

 We reach over 7000 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


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


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Excel macro Help : Date of Previous day

2010-05-25 Thread Rakhee Koshy 
Hi,

I want to learn macros step by step.  Please guide me.

Regards
Rakhee

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


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

RE: $$Excel-Macros$$ Excel macro Help : Date of Previous day

2010-05-25 Thread Dave Bonallack 

Hi,
VBA code for yesterday's date is:
A = Date - 1
The variable 'A' will contain yesterday's date.
Regards - Dave

Date: Tue, 25 May 2010 12:08:06 +0530
Subject: $$Excel-Macros$$ Excel macro Help : Date of Previous day
From: nsund...@gmail.com
To: excel-macros@googlegroups.com

Hi Friends,
 
Please give the VBA code to find the date of previous day (yesterday).
 
Thanks,
N.Sundarvelan





-- 

--

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

 



HELP US GROW !!

 

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
  
_
New, Used, Demo, Dealer or Private? Find it at CarPoint.com.au
http://clk.atdmt.com/NMN/go/206222968/direct/01/

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


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Excel Macro help : How to remove Page Break

2010-05-05 Thread Sundarvelan N 
Hi friends,

Please help.

How to automatically set the range to clear the pagebreaks in different
data.

Thanks,
Sundarvelan

On Wed, May 5, 2010 at 5:42 AM, siti Vi villager.g...@gmail.com wrote:

 try:

 Sheets(MySheet).UsedRange.PageBreak = xlPageBreakNone


 --
  On May 4, 6:09 pm, Sundarvelan N nsund...@gmail.com wrote:
  Hi Friends,
  Please help me to solve the final step of my project.
  I need to remove the page break lines to the end of the column upto which
  the data is available.
  Thanks,
  N.Sundarvelan

 --

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

 
 HELP US GROW !!

 We reach over 6,800 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe




-- 
N.Sundarvelan

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


HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Excel Macro help : How to remove Page Break

2010-05-04 Thread Sundarvelan N 
Hi Friends,

Please help me to solve the final step of my project.

I need to remove the page break lines to the end of the column upto which
the data is available.

Thanks,
N.Sundarvelan

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


HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Excel Macro help : How to remove Page Break

2010-05-04 Thread siti Vi 
try:

Sheets(MySheet).UsedRange.PageBreak = xlPageBreakNone


--
On May 4, 6:09 pm, Sundarvelan N nsund...@gmail.com wrote:
 Hi Friends,
 Please help me to solve the final step of my project.
 I need to remove the page break lines to the end of the column upto which
 the data is available.
 Thanks,
 N.Sundarvelan

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


HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Excel-Macro : Help

2010-04-26 Thread OSA 
Hello Sundarvelan,

I suggest you try  first the subtotal function of excel.  On the menu click
on data then sub total, follow as prompted. It should give you what you
need.

On Sun, Apr 25, 2010 at 7:49 PM, Sundarvelan N nsund...@gmail.com wrote:

 Hi Friends,

 I need a macro to sort the below excel by client and patient in Ascending
 order, and insert blank row between each client and Groos Assign column to
 $.

 Please help me to do this work by macro

 Thanks,
 N.Sundarvelan

 --

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

 
 HELP US GROW !!

 We reach over 6,800 subscribers worldwide and receive many nice notes about
 the learning and support from the group.Let friends and co-workers know they
 can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


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


HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Excel Macro : Help me please

2010-04-26 Thread Sundarvelan 
Hello Friends,

Any one please correct the error

Dim fcount As Range
With ActiveSheet
Set fcount = Worksheets(N136D).Cells.Find(what:=COUNT,
MatchCase:=False).Select
Range(Chr((ActiveCell.Column) + 64)  : 
Chr((ActiveCell.Column) + 64)).Select
Selection.Delete
On Error Resume Next
End With


My need is if COUNT available delete the entire column else next

Thanks,
Sundarvelan

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


HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Excel-Macro : Help

2010-04-25 Thread Sundarvelan N 
Hi Friends,

I need a macro to sort the below excel by client and patient in Ascending
order, and insert blank row between each client and Groos Assign column to
$.

Please help me to do this work by macro

Thanks,
N.Sundarvelan

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


HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


N178D.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Excel-Macro : Help

2010-04-25 Thread siti Vi 
Subtotal ??

Sub SortAndSubTotalOnColumn4()
   Cells(1).CurrentRegion.Select
   Selection.Sort _
  Key1:=Range(A2), Order1:=xlAscending, _
  Key2:=Range(B2), Order2:=xlAscending, _
  Header:=xlYes, OrderCustom:=1, MatchCase:=False, _
  Orientation:=xlTopToBottom, _
  DataOption1:=xlSortNormal, DataOption2:=xlSortNormal

   Selection.Subtotal _
  GroupBy:=1, Function:=xlSum, TotalList:=Array(4), _
  Replace:=True, PageBreaks:=False, SummaryBelowData:=True

   Cells(1).Select
End Sub


On Apr 25, 6:49 pm, Sundarvelan N nsund...@gmail.com wrote:
 Hi Friends,
 I need a macro to sort the below excel by client and patient in
 Ascendingorder, and insert blank row between each client and
 Groos Assign column to $.
 Please help me to do this work by macro
 Thanks,
 N.Sundarvelan

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


HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Excel macro-Help

2009-10-06 Thread Umesh Matkar 
Dear Friends,
I have one query regarding macro.
i want to record a macro for goal seek.
Attached reference sheet says following

Column A - my goal starts from 2009 for 16 years till 2024.
B - Accumulated amount equal to one row up for column E
C - goal seek result i.e investment amount, please refer below macro
 Sub Macro1()
'
' Macro1 Macro
'

'
Range(E18).GoalSeek Goal:=2032281, ChangingCell:=Range(C3)
End Sub

Column D - interest rates
Column E - Future value of present investments with given interest rate in
column D

What i have done in this is that i got a target amount of 2032281 which i
want after 16 years. So the amount what i have to invest monthly with given
interest rate acquired from goal seek in cell C3.

Challenge is goal years may vary, say it may be for 20 years or 25 years or
50 years also not sure. One thing is sure that the interest rate for last
five years will remain same as given but for remaining previous years it
will be as what is in starting.
E.g: if you see in this sheet first 11 years interest rate is same and last
five years we have to keep interest rate same what is given
but if we go for 20 years then last five years interest will be same what is
given. but for prior 15 years interest rate has to be change what is given
for 11 years above. accordingly table should be prepared and goal seek
features should also be used in macro.

I am attaching the file. Please revert in case of any questions.
Please help.


Thanks
Umesh








-- 
Warm Regards,

You mesh

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



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