RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

[Ravinder]

Try this file

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: Wednesday, April 02, 2014 12:22 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

Dear Ravinder

Actually it show like Missing: "Microsoft Word 14.0 Object Library"

Attached screen shot here

Regards
Amar

On Wed, Apr 2, 2014 at 12:09 PM, Ravinder 
wrote:
> Press alt + F11 then go in tools then reference select  "Microsoft 
> Word 14.0 Object Library" library number can b 12.0 or else. Please 
> see attached excel file.
>
>
> -Original Message-
> From: excel-macros@googlegroups.com 
> [mailto:excel-macros@googlegroups.com]
> On Behalf Of amar takale
> Sent: Wednesday, April 02, 2014 10:50 AM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word 
> file
>
> Dear Ravinder
>
> Thanks for reply but how to do it.Pls give me guidance or give 
> modified code.
>
> Regards
> Amar
>
> On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi 
> 
> wrote:
>> have u added the library word object library in vba
>>
>>
>> On Mon, Mar 31, 2014 at 10:02 PM, amar takale 
> wrote:
>>>
>>> Dear Ravinder
>>>
>>> VBA Code not working.Attached Error Screen shot here.Pls see & guide 
>>> me.I have no knowledge of VBA. In excel there are no show "Microsoft 
>>> Word library " in Tools-reference option but show it as "Microsoft 
>>> Word 11.0 Object library "
>>> Pls look in this issue.
>>>
>>> Regards
>>> Amar
>>>
>>>
>>> On Mon, Mar 31, 2014 at 5:39 PM, Ravinder 
>>> 
>>> wrote:
>>> > Note:- add word library "Microsoft Word library "
>>> >
>>> > This is simply copy and paste value from excel to word and you 
>>> > need to select range (will be asked by program) which you want to 
>>> > transfer in word
>>> >
>>> > Sub Button1_Click()
>>> > Dim wrd As New Word.Application
>>> > Dim doc As Word.Document
>>> > Dim RNG As Range
>>> > Set RNG = Application.InputBox("Please Select Range to Transfer in 
>>> > Word:",
>>> > Type:=8)
>>> >
>>> > Set doc = wrd.documents.Add
>>> > wrd.Visible = True 'if you dont want to show wrd application then 
>>> > just use false instead of true RNG.Copy wrd.Selection.Paste Set 
>>> > tbl = doc.Tables(1)
>>> > doc.SaveAs2 ThisWorkbook.Path & "\" & ActiveSheet.Name & ".doc"
>>> > 'change save as path as per ur requirement
>>> >
>>> > End Sub
>>> >
>>> > -Original Message-
>>> > From: excel-macros@googlegroups.com 
>>> > [mailto:excel-macros@googlegroups.com]
>>> > On Behalf Of amar takale
>>> > Sent: Monday, March 31, 2014 3:35 PM
>>> > To: excel-macros@googlegroups.com
>>> > Subject: $$Excel-Macros$$ VBA Code to Import Excel table in Word 
>>> > file
>>> >
>>> > Dear Ashish Sir,
>>> >
>>> > I learned many VBA work from your Code which is a lot of time 
>>> > saving & easy to do. Before one week on our excel forum one topic 
>>> > discussed as (Macro to Import Word Tables to Excel from a folder).
>>> > I got code from word to excel but  I required excel to word.I use 
>>> > excel 2003.
>>> >
>>> > Can you share code excel to word table as proper in one sheet with 
>>> > respective sheet name.
>>> >
>>> > I would appreciate very much if you can help me on this.
>>> >
>>> > Regards
>>> >
>>> > --
>>> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> > It's
>>> > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>>> > https://www.facebook.com/discussexcel
>>> >
>>> > FORUM RULES
>>> >
>>> > 1) Use concise, accurate thread titles. Poor thread titles, like 
>>> > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
>>> > Need Advice will not get quick attention or may not be answered.
>>> > 2) Don't post a question in the thread of another member.
>>> > 3) Don't post questions regarding breaking or bypassing any 
>>> > security measure.
>>> > 4) Acknowledge the responses you receive, good or bad.
>>> > 5) Jobs posting is not allowed.
>>> > 6) Sharing copyrighted material and their links is not allowed.
>>> >
>>> > NOTE  : Don't ever post confidential data in a workbook. Forum 
>>> > owners and members are not responsible for any loss.
>>> > ---
>>> > You received this message because you are subscribed to the Google 
>>> > Groups "MS EXCEL AND VBA MACROS" group.
>>> > To unsubscribe from this group and stop receiving emails from it, 
>>> > send an email to excel-macros+unsubscr...@googlegroups.com.
>>> > To post to this group, send email to excel-macros@googlegroups.com.
>>> > Visit this group at http://groups.google.com/group/excel-macros.
>>> > For more options, visit https://groups.google.com/d/optout.
>>> >
>>> > --
>>> > 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 title

Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

[amar takale]

Dear Ravinder

Perfect,You are done it.

I am really thankful for its wonderful coding.

I have some other query regarding this issue topic (If you have
sufficient time regarding my query)

Single Excel sheet & more than 2 tables
1) I will create button & click then automatic table copy paste in
word.(First data range fixed of table).there are more than two table
with different range.I want all table copy paste in one word file one
by one below after one click button.

Single Excel sheet & one table
1)  I will create button & click then automatic table copy paste in
word.(First data range fixed of table).code not asking for select
range.

As always Thank you all for your help. I greatly appreciated it.

Regards
Amar


On Wed, Apr 2, 2014 at 12:31 PM, Ravinder  wrote:
> Try this file
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of amar takale
> Sent: Wednesday, April 02, 2014 12:22 PM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
>
> Dear Ravinder
>
> Actually it show like Missing: "Microsoft Word 14.0 Object Library"
>
> Attached screen shot here
>
> Regards
> Amar
>
> On Wed, Apr 2, 2014 at 12:09 PM, Ravinder 
> wrote:
>> Press alt + F11 then go in tools then reference select  "Microsoft
>> Word 14.0 Object Library" library number can b 12.0 or else. Please
>> see attached excel file.
>>
>>
>> -Original Message-
>> From: excel-macros@googlegroups.com
>> [mailto:excel-macros@googlegroups.com]
>> On Behalf Of amar takale
>> Sent: Wednesday, April 02, 2014 10:50 AM
>> To: excel-macros@googlegroups.com
>> Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word
>> file
>>
>> Dear Ravinder
>>
>> Thanks for reply but how to do it.Pls give me guidance or give
>> modified code.
>>
>> Regards
>> Amar
>>
>> On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi
>> 
>> wrote:
>>> have u added the library word object library in vba
>>>
>>>
>>> On Mon, Mar 31, 2014 at 10:02 PM, amar takale 
>> wrote:

 Dear Ravinder

 VBA Code not working.Attached Error Screen shot here.Pls see & guide
 me.I have no knowledge of VBA. In excel there are no show "Microsoft
 Word library " in Tools-reference option but show it as "Microsoft
 Word 11.0 Object library "
 Pls look in this issue.

 Regards
 Amar


 On Mon, Mar 31, 2014 at 5:39 PM, Ravinder
 
 wrote:
 > Note:- add word library "Microsoft Word library "
 >
 > This is simply copy and paste value from excel to word and you
 > need to select range (will be asked by program) which you want to
 > transfer in word
 >
 > Sub Button1_Click()
 > Dim wrd As New Word.Application
 > Dim doc As Word.Document
 > Dim RNG As Range
 > Set RNG = Application.InputBox("Please Select Range to Transfer in
 > Word:",
 > Type:=8)
 >
 > Set doc = wrd.documents.Add
 > wrd.Visible = True 'if you dont want to show wrd application then
 > just use false instead of true RNG.Copy wrd.Selection.Paste Set
 > tbl = doc.Tables(1)
 > doc.SaveAs2 ThisWorkbook.Path & "\" & ActiveSheet.Name & ".doc"
 > 'change save as path as per ur requirement
 >
 > End Sub
 >
 > -Original Message-
 > From: excel-macros@googlegroups.com
 > [mailto:excel-macros@googlegroups.com]
 > On Behalf Of amar takale
 > Sent: Monday, March 31, 2014 3:35 PM
 > To: excel-macros@googlegroups.com
 > Subject: $$Excel-Macros$$ VBA Code to Import Excel table in Word
 > file
 >
 > Dear Ashish Sir,
 >
 > I learned many VBA work from your Code which is a lot of time
 > saving & easy to do. Before one week on our excel forum one topic
 > discussed as (Macro to Import Word Tables to Excel from a folder).
 > I got code from word to excel but  I required excel to word.I use
 > excel 2003.
 >
 > Can you share code excel to word table as proper in one sheet with
 > respective sheet name.
 >
 > I would appreciate very much if you can help me on this.
 >
 > Regards
 >
 > --
 > 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 allo

RE: $$Excel-Macros$$ Macro for data indexing

[Ravinder]

pfa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deepak Rawat
Sent: Wednesday, April 02, 2014 11:51 AM
To: excel-macros
Subject: $$Excel-Macros$$ Macro for data indexing

 

Dear friends,

 

I attached a sheet it has a data set A

 

I need to convert data into data set B for cleaning (value is comma
separated)

 

& after cleaning and unique i have to put that data into same format as data
set A i.e. comma separated on appropriate serial number 

 

i have a huge data set to clean & i know it is best possible with the macro

Kindly help me out to complete this and to learn

 

Regards,

Deepak 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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

RE: $$Excel-Macros$$ Need macro for repetative formatting

[Ravinder]

Provid any data and your 10 steps which u want to do after download data from 
software

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Suyog Kulkarni
Sent: Tuesday, April 01, 2014 7:18 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need macro for repetative formatting

 

Hello All,

Pl advice on mail below. Am I asking something very difficult ? If anybody can 
help that can save my lots of time.
Pl do the needful.

Regards,
Suyog
 

On Tuesday, 25 March 2014 11:59:37 UTC+5:30, Suyog Kulkarni wrote:

Hello Vicky,

I'm not at all coping data from any where otherwise I would have used the 
"paste special". I'm pulling data from software & which some times finish 
within 10 rows & 10 columns & sometimes it's cross 30 columns & 100 plus rows.

If somehow I want to tell excel that follow my 10 steps upto last row & last 
column which is having text. It may be "row 10 column 10" or "row 85 or column 
60" or anything. Sometimes it's come so hectic to just waste time on formatting 
only. 

Pl help & solve this problem.

With Regards,
Suyog 

On Tuesday, 25 March 2014 01:49:38 UTC+5:30, Vicky wrote:

Hi Suyog,

 

 

My understanding is you would like to have same format for all data so my logic 
is rather formating each line of data I have saved your format in "Format" tab 
in attached sheet and then that format will be applied to your copied data in 
Original Sheet.

 

Same as we do in Excel using Paste special + Paste+Formats. 

 

Hope this makes sense.

 

Regards,

 

On Mon, Mar 24, 2014 at 7:29 PM, Suyog Kulkarni  wrote:

Hello All,

Greetings for the day. 
Pl refer attached excel, I'm using one database software & when I pull out 
different reports from that I need to do 10 steps for each report every time. 
I've tried to record macro also but I don't know how to find out "last cell 
which contains text" sometimes report may finish in F column & 30th row or 
sometimes it cross P column & 150th row. 

Refer attached excel, I've added my steps, sample of original report & sample 
of expected report. If I got answer of this, this will increase my productivity 
& can save lots of time. 

With Regards,
Suyog

-- 
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...@googlegroups.com.
To post to this group, send email to excel-...@googlegroups.com.
Visit this group at http://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 http://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 Prob

$$Excel-Macros$$ Re: All text box need to be enter

[Rameshwari]

Dear Team,

Forget to attached excel sheet. Please help on this


Regards,
Rameshwari :) 

On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote:
>
>
>
> Dear Team,
>
> I am creating one tool in user form, it contains 3 textboxes, need help on 
> fallowing 
>
> If textbox3 fill with information then check for textbox4, if filled with 
> information then check for textbox5. If all textbox 3, 4 & 5 are filled 
> with information then go to remaining process.
>
> If any of 1 from these textbox is empty then prompt with the 
> msgbox(“textbox (name)”). 
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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

Re: $$Excel-Macros$$ Re: All text box need to be enter

[Ganesh N]

Hi Rameshwari,

Please find the attached file.

Regards,
Ganesh N


On Wed, Apr 2, 2014 at 3:41 PM, Rameshwari wrote:

> Dear Team,
>
> Forget to attached excel sheet. Please help on this
>
>
> Regards,
> Rameshwari :)
>
> On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote:
>>
>>
>>
>> Dear Team,
>>
>> I am creating one tool in user form, it contains 3 textboxes, need help
>> on fallowing
>>
>> If textbox3 fill with information then check for textbox4, if filled with
>> information then check for textbox5. If all textbox 3, 4 & 5 are filled
>> with information then go to remaining process.
>>
>> If any of 1 from these textbox is empty then prompt with the
>> msgbox("textbox (name)").
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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

Re: $$Excel-Macros$$ Macro for data indexing

[Deepak Rawat]

hi thanx for your reply but its not working correctly


On Wed, Apr 2, 2014 at 2:42 PM, Ravinder wrote:

> pfa
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Deepak Rawat
> *Sent:* Wednesday, April 02, 2014 11:51 AM
> *To:* excel-macros
> *Subject:* $$Excel-Macros$$ Macro for data indexing
>
>
>
> Dear friends,
>
>
>
> I attached a sheet it has a data set A
>
>
>
> I need to convert data into data set B for cleaning (value is comma
> separated)
>
>
>
> & after cleaning and unique i have to put that data into same format as
> data set A i.e. comma separated on appropriate serial number
>
>
>
> i have a huge data set to clean & i know it is best possible with the macro
>
> Kindly help me out to complete this and to learn
>
>
>
> Regards,
>
> Deepak
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Fwd: $$Excel-Macros$$ Show links which to other Data source

[Ashish Bhalara]

-- Forwarded message --
From: Ashish Bhalara 
Date: Tue, Apr 1, 2014 at 1:23 PM
Subject: $$Excel-Macros$$ Show links which to other Data source
To: "excel-macros@googlegroups com" 


Dear experts,

My workbook containing large no. of sheets & formulas, but I want to show
those formulas which containing links to other data source of file. Kindly
know me how to check it.

-- 
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.



-- 
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Macro for data indexing

[Deepak Rawat]

Dear Ravinder,
i was making mistake in selection but its working correct,
kindly give me a code to reverse it
my point is after doing all words in one line i could make them unique but
after that i need to put in that form again

Regards,
Deepak Rawat


On Wed, Apr 2, 2014 at 2:42 PM, Ravinder wrote:

> pfa
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Deepak Rawat
> *Sent:* Wednesday, April 02, 2014 11:51 AM
> *To:* excel-macros
> *Subject:* $$Excel-Macros$$ Macro for data indexing
>
>
>
> Dear friends,
>
>
>
> I attached a sheet it has a data set A
>
>
>
> I need to convert data into data set B for cleaning (value is comma
> separated)
>
>
>
> & after cleaning and unique i have to put that data into same format as
> data set A i.e. comma separated on appropriate serial number
>
>
>
> i have a huge data set to clean & i know it is best possible with the macro
>
> Kindly help me out to complete this and to learn
>
>
>
> Regards,
>
> Deepak
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: All text box need to be enter

[rameshwari shyam]

Dear Ganesh,
Thank you very much for quick reply.

Once enter the data in all textbox after that hit the submit button. and
after transfer the data to excel sheet all textbox need to be blank. as
this very confidential data of user not suppose to be duplicate.

Please help.

Regards,
Rameshwari :)

On Wed, Apr 2, 2014 at 2:32 PM, Ganesh N  wrote:

> Hi Rameshwari,
>
> Please find the attached file.
>
> Regards,
> Ganesh N
>
>
> On Wed, Apr 2, 2014 at 3:41 PM, Rameshwari wrote:
>
>> Dear Team,
>>
>> Forget to attached excel sheet. Please help on this
>>
>>
>> Regards,
>> Rameshwari :)
>>
>> On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote:
>>>
>>>
>>>
>>> Dear Team,
>>>
>>> I am creating one tool in user form, it contains 3 textboxes, need help
>>> on fallowing
>>>
>>> If textbox3 fill with information then check for textbox4, if filled
>>> with information then check for textbox5. If all textbox 3, 4 & 5 are
>>> filled with information then go to remaining process.
>>>
>>> If any of 1 from these textbox is empty then prompt with the
>>> msgbox("textbox (name)").
>>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: All text box need to be enter

[rameshwari shyam]

Dear Ganesh,
Thank you very much for quick reply.

Once enter the data in all textbox after that hit the submit button. and
after transfer the data to excel sheet all textbox need to be blank. as
this very confidential data of user not suppose to be duplicate.

Please help.

Regards,
Rameshwari :)


On Wed, Apr 2, 2014 at 2:47 PM, rameshwari shyam
wrote:

> Dear Ganesh,
> Thank you very much for quick reply.
>
> Once enter the data in all textbox after that hit the submit button. and
> after transfer the data to excel sheet all textbox need to be blank. as
> this very confidential data of user not suppose to be duplicate.
>
> Please help.
>
> Regards,
> Rameshwari :)
>
> On Wed, Apr 2, 2014 at 2:32 PM, Ganesh N  wrote:
>
>> Hi Rameshwari,
>>
>> Please find the attached file.
>>
>> Regards,
>> Ganesh N
>>
>>
>> On Wed, Apr 2, 2014 at 3:41 PM, Rameshwari wrote:
>>
>>> Dear Team,
>>>
>>> Forget to attached excel sheet. Please help on this
>>>
>>>
>>> Regards,
>>> Rameshwari :)
>>>
>>> On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote:



 Dear Team,

 I am creating one tool in user form, it contains 3 textboxes, need help
 on fallowing

 If textbox3 fill with information then check for textbox4, if filled
 with information then check for textbox5. If all textbox 3, 4 & 5 are
 filled with information then go to remaining process.

 If any of 1 from these textbox is empty then prompt with the
 msgbox("textbox (name)").

>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

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

Re: $$Excel-Macros$$ Re: All text box need to be enter

[Ganesh N]

Hi rameshwari,

Please find the updated one.

Regards,
Ganesh N


On Wed, Apr 2, 2014 at 4:18 PM, rameshwari shyam
wrote:

> Dear Ganesh,
> Thank you very much for quick reply.
>
> Once enter the data in all textbox after that hit the submit button. and
> after transfer the data to excel sheet all textbox need to be blank. as
> this very confidential data of user not suppose to be duplicate.
>
> Please help.
>
> Regards,
> Rameshwari :)
>
>
> On Wed, Apr 2, 2014 at 2:47 PM, rameshwari shyam <
> rameshwarish...@gmail.com> wrote:
>
>> Dear Ganesh,
>> Thank you very much for quick reply.
>>
>> Once enter the data in all textbox after that hit the submit button. and
>> after transfer the data to excel sheet all textbox need to be blank. as
>> this very confidential data of user not suppose to be duplicate.
>>
>> Please help.
>>
>> Regards,
>> Rameshwari :)
>>
>> On Wed, Apr 2, 2014 at 2:32 PM, Ganesh N  wrote:
>>
>>> Hi Rameshwari,
>>>
>>> Please find the attached file.
>>>
>>> Regards,
>>> Ganesh N
>>>
>>>
>>> On Wed, Apr 2, 2014 at 3:41 PM, Rameshwari wrote:
>>>
 Dear Team,

 Forget to attached excel sheet. Please help on this


 Regards,
 Rameshwari :)

 On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote:
>
>
>
> Dear Team,
>
> I am creating one tool in user form, it contains 3 textboxes, need
> help on fallowing
>
> If textbox3 fill with information then check for textbox4, if filled
> with information then check for textbox5. If all textbox 3, 4 & 5 are
> filled with information then go to remaining process.
>
> If any of 1 from these textbox is empty then prompt with the
> msgbox("textbox (name)").
>
  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.

>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>  --
> 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.

$$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

[Rashid Khan]

Dear All,
I am using Excel 2010.
I have attached a sample file with my problem.
Please see before and after

Any macro help would be appreciate.
Regards
Rashid

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Copy Data from Column on the right.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Help Required Urgent

[Neeraj Chauhan]

Dear experts,

 

Kindly find the attached sheet.



---
This email is free from viruses and malware because avast! Antivirus protection 
is active.
http://www.avast.com

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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

Re: $$Excel-Macros$$ Re: All text box need to be enter

[rameshwari shyam]

Dear Ganesh,

Here active cell will be different, data need to fill as per
textbox3 value in colostrum A first empty row
textbox4 value in column B first empty row
textbox5 value in column C first empty row

Please help

Regards,
Rameshwari :)


On Wed, Apr 2, 2014 at 3:04 PM, Ganesh N  wrote:

> Hi rameshwari,
>
> Please find the updated one.
>
> Regards,
> Ganesh N
>
>
> On Wed, Apr 2, 2014 at 4:18 PM, rameshwari shyam <
> rameshwarish...@gmail.com> wrote:
>
>> Dear Ganesh,
>> Thank you very much for quick reply.
>>
>> Once enter the data in all textbox after that hit the submit button. and
>> after transfer the data to excel sheet all textbox need to be blank. as
>> this very confidential data of user not suppose to be duplicate.
>>
>> Please help.
>>
>> Regards,
>> Rameshwari :)
>>
>>
>> On Wed, Apr 2, 2014 at 2:47 PM, rameshwari shyam <
>> rameshwarish...@gmail.com> wrote:
>>
>>> Dear Ganesh,
>>> Thank you very much for quick reply.
>>>
>>> Once enter the data in all textbox after that hit the submit button. and
>>> after transfer the data to excel sheet all textbox need to be blank. as
>>> this very confidential data of user not suppose to be duplicate.
>>>
>>> Please help.
>>>
>>> Regards,
>>> Rameshwari :)
>>>
>>> On Wed, Apr 2, 2014 at 2:32 PM, Ganesh N  wrote:
>>>
 Hi Rameshwari,

 Please find the attached file.

 Regards,
 Ganesh N


 On Wed, Apr 2, 2014 at 3:41 PM, Rameshwari 
 wrote:

> Dear Team,
>
> Forget to attached excel sheet. Please help on this
>
>
> Regards,
> Rameshwari :)
>
> On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote:
>>
>>
>>
>> Dear Team,
>>
>> I am creating one tool in user form, it contains 3 textboxes, need
>> help on fallowing
>>
>> If textbox3 fill with information then check for textbox4, if filled
>> with information then check for textbox5. If all textbox 3, 4 & 5 are
>> filled with information then go to remaining process.
>>
>> If any of 1 from these textbox is empty then prompt with the
>> msgbox("textbox (name)").
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.

>>>
>>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It

RE: $$Excel-Macros$$ Help Required Urgent

[Ravinder]

PFA

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Neeraj Chauhan
Sent: Wednesday, April 02, 2014 4:43 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help Required Urgent

 

Dear experts,

 

Kindly find the attached sheet.

 

  _  


  

This email is free from viruses and malware because avast! Antivirus
  protection is active. 

 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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

RE: $$Excel-Macros$$ Help Required Urgent

[Neeraj Chauhan]

Thanks Ravinder

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Wednesday, April 02, 2014 5:11 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: RE: $$Excel-Macros$$ Help Required Urgent

 

PFA

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Neeraj Chauhan
Sent: Wednesday, April 02, 2014 4:43 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help Required Urgent

 

Dear experts,

 

Kindly find the attached sheet.

 

  _  


  

This email is free from viruses and malware because avast!
  Antivirus protection is active. 

 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.



---
This email is free from viruses and malware because avast! Antivirus protection 
is active.
http://www.avast.com

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Macro for IF & AND condition

[Renata Torquato]

Olá Basole, obrigada pela resposta. 

Ainda não é isso Rs* Acontece que a célula somente deve mudar para o status 
DELAYED caso ela possua o status ON TRACK *E SE *a data do deadline for 
menor que a data atual (Se for igual o status deve continuar ON TRACK). 
Caso eu manualmente mude o status para COMPLETED ou CANCELLED, ainda que a 
data de deadline seja menor que a data atual, a célula deve permanecer com 
esses status sem mudar para DELAYED... O racional é que mesmo em atraso uma 
determinada pessoa pode completar uma determinada tarefa e desta forma ela 
estará completa ainda que tenha ficado atrasada em determinado período. 
Esse é um Dashboard de tarefas, estas que podem ser completas ou canceladas 
por alguma razão e por isso eu preciso ter a flexibilidade nas células de 
colocar o status COMPLETED ou CANCELLED quando aplicável, alterando-se 
somente de ON TRACK para DELAYED caso o deadline já tenha sido 
ultrapassado. 

Não sei se ficou muito claro!

Obrigada. 

Em terça-feira, 1 de abril de 2014 14h39min06s UTC-3, Basole escreveu:
>
> Olá Renata Torquato boa tarde, 
>
> Veja no anexo que é isso que voce está querendo. 
> Eu só fiz para duas condiçoes se for menor ou se for maior a data. No caso 
> de a data for igual, qual seria o status? 
>
> Saudaçoes. 
>
>
> Basole.
>
>   
>
>
> 2014-04-01 10:19 GMT-03:00 Renata Torquato 
> >:
>
>> Thanks. 
>>  
>> Please find attached the file (Sorry but it's not in english). 
>>  
>> SHEET ACTION PLANS: You will find the column P where I have all the 
>> deadlines and column R with the status (Completed, On Track, Cancelled and 
>> Delayed). I would like the ON TRACK status to automatically turn to DELAYED 
>> if the deadline (Column P)  is < than the current date (CELL K2 - SHEET 
>> DATA). 
>>  
>> Column R is under data validation and all the status are manually 
>> established because we need to change to COMPLETED if the action has been 
>> implemented. 
>>  
>> Thanks. 
>>  
>>
>> Em domingo, 30 de março de 2014 14h21min17s UTC-3, ashish escreveu:
>>
>>> can u share a sample file?
>>>
>>>
>>> On Sun, Mar 30, 2014 at 9:44 PM, Renata Torquato 
>>> wrote:
>>>
 Thanks. 

 That's exactly what I tried before but it doesn't work ... =/

 Em domingo, 30 de março de 2014 12h29min52s UTC-3, ashish escreveu: 
>
> Sub test()
>
> With Sheets("Sheet1")
> If .Range("a2").Value > VBA.Date And UCase(.Range("a1").Value) 
> = UCase("ON TRACK ") Then
> .Range("a1").Value = "DELAYED"
> End If
> End With
>
>
> End Sub
>
>
> On Sun, Mar 30, 2014 at 8:32 PM, Renata Torquato  > wrote:
>
>> I have the following situation: 
>>
>> I would like the range (A1) to change to the status DELAYED if this 
>> range shows the status ON TRACK and if the deadline date on range A2 has 
>> passed the current date (Formula TODAY in another sheet). If the 
>> condition 
>> is false I would like range A1 to keep its status (DELAYED, ON TRACK, 
>> COMPLETED or ON TRACK), which means that nothing will change with the 
>> Macro. 
>>
>> I have tried the code however it is not working. I was wondering if 
>> maybe it's due to the fact that all the conditions on range A1 are under 
>> data validation list?
>>
>> Which code should I try? 
>>
>> 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...@googlegroups.com.
>> To post to this group, send email to excel-...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> -- 
>  *Regards*
>  
> *Ashish Koul*
>
>
>  *Visit*
> http://www.excelvbamacros.in
> Like Us on 
> Fac

Re: $$Excel-Macros$$ Show links which to other Data source

[ashish koul]

Sub find_links()
Dim extlinks
Dim j As Long, k As Long
Dim wkb As Workbook
Dim rng As Range, cl As Range
Dim links1 As String
Dim wk As Worksheet
Set wkb = Workbooks.Add
wkb.Sheets(1).Range("a1").Value = "Sheet Name"
wkb.Sheets(1).Range("b1").Value = "Cell Address"
wkb.Sheets(1).Range("c1").Value = "Formula"
wkb.Sheets(1).Range("d1").Value = "External Link"
k = 2
extlinks = ThisWorkbook.LinkSources(xlExcelLinks)

For Each wk In ThisWorkbook.Sheets
On Error Resume Next
Set rng = wk.UsedRange.SpecialCells(xlCellTypeFormulas)

If Not rng Is Nothing Then
For j = LBound(extlinks) To UBound(extlinks)
links1 = Left(extlinks(j), InStrRev(extlinks(j), "\")) & "[" &
Right(extlinks(j), Len(extlinks(j)) - InStrRev(extlinks(j), "\"))
MsgBox links1
For Each cl In rng
If InStr(" " & cl.Formula, links1) > 0 Then
wkb.Sheets(1).Range("a" & k).Value = wk.Name
wkb.Sheets(1).Range("b" & k).Value = cl.Address
wkb.Sheets(1).Range("c" & k).Value = "'" & cl.Formula
wkb.Sheets(1).Range("d" & k).Value = extlinks(j)
k = k + 1
End If
Next
Next
End If
Err.Clear
Set rng = Nothing
Next
End Sub



On Wed, Apr 2, 2014 at 4:10 PM, Ashish Bhalara wrote:

>
>
> -- Forwarded message --
> From: Ashish Bhalara 
> Date: Tue, Apr 1, 2014 at 1:23 PM
> Subject: $$Excel-Macros$$ Show links which to other Data source
> To: "excel-macros@googlegroups com" 
>
>
> Dear experts,
>
> My workbook containing large no. of sheets & formulas, but I want to show
> those formulas which containing links to other data source of file. Kindly
> know me how to check it.
>
> --
> Regards.
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
> --
> Regards.
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on 
Facebook
Join Us on Facebook 


P Bef

Re: $$Excel-Macros$$ Convert PDF to Excel - single file with 12000 pages

[Ricardo®]

Pls. share your PDF file, so I can adjust the code in this format.

Regards,
Basole.



2014-04-02 1:37 GMT-03:00 Abhishek Jain :

> I tried saving the PDF as Text and importing it in Excel, it didn't work.
> Do you have a sample macro or something that I can try?
>
> Thanks.
>
>
> On Tue, Apr 1, 2014 at 11:24 PM, Ricardo(R)  wrote:
>
>> Hi Abhishek Jain,
>>
>> If the formatting of the PDF files is standardized, you can create a
>> macro to convert to TXT and then import into excel and then save in xlsx
>> format automatically for all pages.
>>
>>
>> Regards,
>>
>> Basole.
>>
>>
>>
>>
>> 2014-04-01 11:30 GMT-03:00 Abhishek Jain :
>>
>> Hi Friends,
>>>
>>> I have a PDF file with some 11800+ pages in it (around 28 MB). Is there
>>> a way I can convert it in Excel format using a macro or a tool?
>>>
>>> Many thanks for help.
>>>
>>> Regards,
>>>
>>> Abhishek
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

Re: $$Excel-Macros$$ Macro for IF & AND condition

[Renata Torquato]

Olá, boa tarde. 

Muito obrigada. Vou testar no arquivo original para ver como roda.

Muito obrigada. 

Att.

Em quarta-feira, 2 de abril de 2014 15h19min18s UTC-3, Basole escreveu:
>
> Olá Renata boa tarde,
>
>
> Veja agora no anexo, se entendi o que voce quer. 
>
>
> Saudações, 
>
>
> Basole.
>   
>
>
>
>
> 2014-04-02 9:42 GMT-03:00 Renata Torquato 
> >:
>
>> Olá Basole, obrigada pela resposta. 
>>
>> Ainda não é isso Rs* Acontece que a célula somente deve mudar para o 
>> status DELAYED caso ela possua o status ON TRACK *E SE *a data do 
>> deadline for menor que a data atual (Se for igual o status deve continuar 
>> ON TRACK). Caso eu manualmente mude o status para COMPLETED ou CANCELLED, 
>> ainda que a data de deadline seja menor que a data atual, a célula deve 
>> permanecer com esses status sem mudar para DELAYED... O racional é que 
>> mesmo em atraso uma determinada pessoa pode completar uma determinada 
>> tarefa e desta forma ela estará completa ainda que tenha ficado atrasada em 
>> determinado período. Esse é um Dashboard de tarefas, estas que podem ser 
>> completas ou canceladas por alguma razão e por isso eu preciso ter a 
>> flexibilidade nas células de colocar o status COMPLETED ou CANCELLED quando 
>> aplicável, alterando-se somente de ON TRACK para DELAYED caso o deadline já 
>> tenha sido ultrapassado. 
>>
>> Não sei se ficou muito claro!
>>
>> Obrigada. 
>>
>> Em terça-feira, 1 de abril de 2014 14h39min06s UTC-3, Basole escreveu:
>>>
>>> Olá Renata Torquato boa tarde, 
>>>
>>> Veja no anexo que é isso que voce está querendo. 
>>> Eu só fiz para duas condiçoes se for menor ou se for maior a data. No 
>>> caso de a data for igual, qual seria o status? 
>>>
>>> Saudaçoes. 
>>>
>>>
>>> Basole.
>>>
>>>   
>>>
>>>
>>> 2014-04-01 10:19 GMT-03:00 Renata Torquato :
>>>
>>> Thanks. 
  
 Please find attached the file (Sorry but it's not in english). 
  
 SHEET ACTION PLANS: You will find the column P where I have all the 
 deadlines and column R with the status (Completed, On Track, Cancelled and 
 Delayed). I would like the ON TRACK status to automatically turn to 
 DELAYED 
 if the deadline (Column P)  is < than the current date (CELL K2 - SHEET 
 DATA). 
  
 Column R is under data validation and all the status are manually 
 established because we need to change to COMPLETED if the action has been 
 implemented. 
  
 Thanks. 
  

 Em domingo, 30 de março de 2014 14h21min17s UTC-3, ashish escreveu:

> can u share a sample file?
>
>
> On Sun, Mar 30, 2014 at 9:44 PM, Renata Torquato  > wrote:
>
>> Thanks. 
>>
>> That's exactly what I tried before but it doesn't work ... =/
>>
>> Em domingo, 30 de março de 2014 12h29min52s UTC-3, ashish escreveu: 
>>>
>>> Sub test()
>>>
>>> With Sheets("Sheet1")
>>> If .Range("a2").Value > VBA.Date And 
>>> UCase(.Range("a1").Value) = UCase("ON TRACK ") Then
>>> .Range("a1").Value = "DELAYED"
>>> End If
>>> End With
>>>
>>>
>>> End Sub
>>>
>>>
>>> On Sun, Mar 30, 2014 at 8:32 PM, Renata Torquato <
>>> renataa...@gmail.com> wrote:
>>>
 I have the following situation: 

 I would like the range (A1) to change to the status DELAYED if this 
 range shows the status ON TRACK and if the deadline date on range A2 
 has 
 passed the current date (Formula TODAY in another sheet). If the 
 condition 
 is false I would like range A1 to keep its status (DELAYED, ON TRACK, 
 COMPLETED or ON TRACK), which means that nothing will change with the 
 Macro. 

 I have tried the code however it is not working. I was wondering if 
 maybe it's due to the fact that all the conditions on range A1 are 
 under 
 data validation list?

 Which code should I try? 

 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 me

Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

[Bipin Singh]

Rashid Sir, Hope attached will help?


On Wed, Apr 2, 2014 at 4:39 PM, Rashid Khan  wrote:

> Dear All,
> I am using Excel 2010.
> I have attached a sample file with my problem.
> Please see before and after
>
> Any macro help would be appreciate.
> Regards
> Rashid
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Copy Data from Column on the right.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Re: Macro for data indexing

[João]

Hello, what I propose will involve Word (or any other word processor) 
besides excel but will work pretty fast:

Copy the column with the data to Word, paste it as unformatted text.

Run a replacement searching for commas and replacing them with ^p for 
paragraph.

Copy the data to excel and it should be ok.

Quarta-feira, 2 de Abril de 2014 7:21:16 UTC+1, Deepak Rawat escreveu:
>
> Dear friends,
>
> I attached a sheet it has a data set A
>
> I need to convert data into data set B for cleaning (value is comma 
> separated)
>
> & after cleaning and unique i have to put that data into same format as 
> data set A i.e. comma separated on appropriate serial number 
>
> i have a huge data set to clean & i know it is best possible with the macro
> Kindly help me out to complete this and to learn
>
> Regards,
> Deepak 
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Strange .visble Issue

[ydoubleuz]

Hi All,

Chanced upon a strange error and unable to find any threads on it.

Private Sub SWS_CB_Click() 'SWS_CB is a checkbox while SWS_LB is a listbox
   If Sheet2.SWS_CB.value = True Then
   Sheet2.SWS_LB.Visible = True
   'Sheet2.SWS_LB.Enabled = True
   Else
   Sheet2.SWS_LB.Visible = False
   End If
End Sub

When I use this ".visible = true"; the listbox becomes unselectable; the 
"cross" cursor does not change to an "arrow".

Things tried:
1. All properties (enabled, locked) of the list box changed ... no avail
2. ".Enabled" does not work too

However this code works initially and on other projects as well. It just 
appears and I managed to find the "erroneous"  line of code. Any 
suggestions / hints?

Thanks in advance
ywz

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Validation on button click

[Rupesh Patil]

Hello Experts,

I need your kind, I have attache sheet with my requirement, Please find in
attachment.

-- 
Thanks and Regards, Rp.
 

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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

RE: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

[Ravinder]

pfa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bipin Singh
Sent: Thursday, April 03, 2014 1:33 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as
per the Values

 

Rashid Sir, Hope attached will help?

 

On Wed, Apr 2, 2014 at 4:39 PM, Rashid Khan  wrote:

Dear All,

I am using Excel 2010.

I have attached a sample file with my problem.

Please see before and after

 

Any macro help would be appreciate.

Regards

Rashid 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Copy Data from Column on the right.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Fwd: $$Excel-Macros$$ Show links which to other Data source

[Ashish Bhalara]

-- Forwarded message --
From: Ashish Bhalara 
Date: Wed, Apr 2, 2014 at 4:10 PM
Subject: Fwd: $$Excel-Macros$$ Show links which to other Data source
To: "excel-macros@googlegroups com" 




-- Forwarded message --
From: Ashish Bhalara 
Date: Tue, Apr 1, 2014 at 1:23 PM
Subject: $$Excel-Macros$$ Show links which to other Data source
To: "excel-macros@googlegroups com" 


Dear experts,

My workbook containing large no. of sheets & formulas, but I want to show
those formulas which containing links to other data source of file. Kindly
know me how to check it.

-- 
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.



-- 
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ All text box need to be enter

[ashish koul]

please share the sample file


On Wed, Apr 2, 2014 at 11:56 AM, Rameshwari wrote:

>
>
> Dear Team,
>
> I am creating one tool in user form, it contains 3 textboxes, need help on
> fallowing
>
> If textbox3 fill with information then check for textbox4, if filled with
> information then check for textbox5. If all textbox 3, 4 & 5 are filled
> with information then go to remaining process.
>
> If any of 1 from these textbox is empty then prompt with the
> msgbox("textbox (name)").
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Arrow solution

[amar takale]

Dear Expert team

I required arrow solution in excel for UP & Down & Constant.Pls see
attached sheet.

Regards
Amar

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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

Re: $$Excel-Macros$$ All text box need to be enter

[rameshwari shyam]

Dear Ashish,

Please find enclosed herewith file.

value for textbox3 need to be fill in column A first empty row
textbox4 value for column B
textbox5 value for column C

After value/text transfer to excel sheet all textbox need to be empty.

Regards,
Rameshwari

On Thu, Apr 3, 2014 at 9:42 AM, ashish koul  wrote:

> please share the sample file
>
>
> On Wed, Apr 2, 2014 at 11:56 AM, Rameshwari wrote:
>
>>
>>
>> Dear Team,
>>
>> I am creating one tool in user form, it contains 3 textboxes, need help
>> on fallowing
>>
>> If textbox3 fill with information then check for textbox4, if filled with
>> information then check for textbox5. If all textbox 3, 4 & 5 are filled
>> with information then go to remaining process.
>>
>> If any of 1 from these textbox is empty then prompt with the
>> msgbox("textbox (name)").
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> *Regards*
>
> *Ashish Koul*
>
>
> *Visit*
> http://www.excelvbamacros.in
> Like Us on 
> Facebook
> Join Us on Facebook 
>
>
> P Before printing, think about the environment.
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Book1.xlsm
Description: application/vnd

Re: $$Excel-Macros$$ Re: All text box need to be enter

[Ganesh N]

Hi,

Please find the attachment.

Regards,
Ganesh N


On Wed, Apr 2, 2014 at 4:55 PM, rameshwari shyam
wrote:

> Dear Ganesh,
>
> Here active cell will be different, data need to fill as per
> textbox3 value in colostrum A first empty row
> textbox4 value in column B first empty row
> textbox5 value in column C first empty row
>
> Please help
>
> Regards,
> Rameshwari :)
>
>
> On Wed, Apr 2, 2014 at 3:04 PM, Ganesh N  wrote:
>
>> Hi rameshwari,
>>
>> Please find the updated one.
>>
>> Regards,
>> Ganesh N
>>
>>
>> On Wed, Apr 2, 2014 at 4:18 PM, rameshwari shyam <
>> rameshwarish...@gmail.com> wrote:
>>
>>> Dear Ganesh,
>>> Thank you very much for quick reply.
>>>
>>> Once enter the data in all textbox after that hit the submit button. and
>>> after transfer the data to excel sheet all textbox need to be blank. as
>>> this very confidential data of user not suppose to be duplicate.
>>>
>>> Please help.
>>>
>>> Regards,
>>> Rameshwari :)
>>>
>>>
>>> On Wed, Apr 2, 2014 at 2:47 PM, rameshwari shyam <
>>> rameshwarish...@gmail.com> wrote:
>>>
 Dear Ganesh,
 Thank you very much for quick reply.

 Once enter the data in all textbox after that hit the submit button.
 and after transfer the data to excel sheet all textbox need to be blank. as
 this very confidential data of user not suppose to be duplicate.

 Please help.

 Regards,
 Rameshwari :)

 On Wed, Apr 2, 2014 at 2:32 PM, Ganesh N  wrote:

> Hi Rameshwari,
>
> Please find the attached file.
>
> Regards,
> Ganesh N
>
>
> On Wed, Apr 2, 2014 at 3:41 PM, Rameshwari 
> wrote:
>
>> Dear Team,
>>
>> Forget to attached excel sheet. Please help on this
>>
>>
>> Regards,
>> Rameshwari :)
>>
>> On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote:
>>>
>>>
>>>
>>> Dear Team,
>>>
>>> I am creating one tool in user form, it contains 3 textboxes, need
>>> help on fallowing
>>>
>>> If textbox3 fill with information then check for textbox4, if filled
>>> with information then check for textbox5. If all textbox 3, 4 & 5 are
>>> filled with information then go to remaining process.
>>>
>>> If any of 1 from these textbox is empty then prompt with the
>>> msgbox("textbox (name)").
>>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> Advice will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>> and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google
>> Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it,
>> send an email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> 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 emai

Re: $$Excel-Macros$$ Re: All text box need to be enter

[rameshwari shyam]

Dear Ganesh,

Thanks for your help. yes it work out as per requirements.

Regards,
Rameshwari


On Thu, Apr 3, 2014 at 10:29 AM, Ganesh N  wrote:

> Hi,
>
> Please find the attachment.
>
> Regards,
> Ganesh N
>
>
> On Wed, Apr 2, 2014 at 4:55 PM, rameshwari shyam <
> rameshwarish...@gmail.com> wrote:
>
>> Dear Ganesh,
>>
>> Here active cell will be different, data need to fill as per
>> textbox3 value in colostrum A first empty row
>> textbox4 value in column B first empty row
>> textbox5 value in column C first empty row
>>
>> Please help
>>
>> Regards,
>> Rameshwari :)
>>
>>
>> On Wed, Apr 2, 2014 at 3:04 PM, Ganesh N  wrote:
>>
>>> Hi rameshwari,
>>>
>>> Please find the updated one.
>>>
>>> Regards,
>>> Ganesh N
>>>
>>>
>>> On Wed, Apr 2, 2014 at 4:18 PM, rameshwari shyam <
>>> rameshwarish...@gmail.com> wrote:
>>>
 Dear Ganesh,
 Thank you very much for quick reply.

 Once enter the data in all textbox after that hit the submit button.
 and after transfer the data to excel sheet all textbox need to be blank. as
 this very confidential data of user not suppose to be duplicate.

 Please help.

 Regards,
 Rameshwari :)


 On Wed, Apr 2, 2014 at 2:47 PM, rameshwari shyam <
 rameshwarish...@gmail.com> wrote:

> Dear Ganesh,
> Thank you very much for quick reply.
>
> Once enter the data in all textbox after that hit the submit button.
> and after transfer the data to excel sheet all textbox need to be blank. 
> as
> this very confidential data of user not suppose to be duplicate.
>
> Please help.
>
> Regards,
> Rameshwari :)
>
> On Wed, Apr 2, 2014 at 2:32 PM, Ganesh N  wrote:
>
>> Hi Rameshwari,
>>
>> Please find the attached file.
>>
>> Regards,
>> Ganesh N
>>
>>
>> On Wed, Apr 2, 2014 at 3:41 PM, Rameshwari > > wrote:
>>
>>> Dear Team,
>>>
>>> Forget to attached excel sheet. Please help on this
>>>
>>>
>>> Regards,
>>> Rameshwari :)
>>>
>>> On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote:



 Dear Team,

 I am creating one tool in user form, it contains 3 textboxes, need
 help on fallowing

 If textbox3 fill with information then check for textbox4, if
 filled with information then check for textbox5. If all textbox 3, 4 & 
 5
 are filled with information then go to remaining process.

 If any of 1 from these textbox is empty then prompt with the
 msgbox("textbox (name)").

>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>> Advice will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>> and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it,
>>> send an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
>> 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
>> an

RE: $$Excel-Macros$$ Validation on button click

[Ravinder]

pfa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rupesh Patil
Sent: Thursday, April 03, 2014 10:45 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Validation on button click

 

Hello Experts,

 

I need your kind, I have attache sheet with my requirement, Please find in
attachment.

 

-- 

Thanks and Regards, Rp.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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

RE: $$Excel-Macros$$ Arrow solution

[Ravinder]

=IF(D2>C2,"q",IF(D2mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: Thursday, April 03, 2014 11:23 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Arrow solution

Dear Expert team

I required arrow solution in excel for UP & Down & Constant.Pls see attached
sheet.

Regards
Amar

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Arrow solution

[amar takale]

Dear Ravinder
Thanks for reply but this is not as per my solution,I want arrow like
H column in excel.
Regards
Amar

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Validation on button click

[Rupesh Patil]

Dear Ravinder,

Thanks but provided micro is not working as requirement.


On Thu, Apr 3, 2014 at 12:15 PM, Ravinder wrote:

> pfa
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Rupesh Patil
> *Sent:* Thursday, April 03, 2014 10:45 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Validation on button click
>
>
>
> Hello Experts,
>
>
>
> I need your kind, I have attache sheet with my requirement, Please find in
> attachment.
>
>
>
> --
>
> Thanks and Regards, Rp.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Thanks and Regards, Rp.

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.