$$Excel-Macros$$ Re: Forum rules : Please adhere else you will be BANNED

[Pravin Gunjal]

Hello Mr.Ayush,

It seems now a days many people are posting job vacancies on our group.
Some action need to be taken..

Regards,



On Saturday, July 23, 2011 at 5:50:06 PM UTC+5:30, Ayush Jain wrote:
>
> Hello everyone,
>  
> Please adhere to below rules of the forum. You will be banned without 
> warning on non compliance.
> Till date 806 members are banned in group, This is the reason the group is 
> spam free.
>  
> *Please read and adhere to these simple rules!*
>
> * 1. Use concise, accurate thread titles. *Your post title should 
> describe your problem, not your anticipated solution. Use terms appropriate 
> to a Google search. 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* -- start your 
> own. If you feel it's particularly relevant, provide a link to the other 
> thread.
>
> *3. Don't Private Message* or email questions to moderators or other 
> members. The point of having a public forum is to share solutions to common 
> (and sometimes uncommon) problems with all members.
>
> *4. Common courtesy is the order of the day*. Avoid coarse language 
> (meaning any words you didn't hear in Sunday school), provide feedback to 
> suggested solutions, and take the time to thank those who took their time 
> to help you. If you solve a problem yourself before anyone else has 
> responded, please take a moment to describe your solution -- chances are 
> some other member will benefit.
>
> *5. Don't post questions regarding breaking or bypassing any security 
> measure.* Such posts will be deleted, and repeat offenders will be 
> banned. This includes posting of links to sites that offer software, code 
> or services to do this or posting of code to remove passwords.
>
> *6. Acknowledge the responses you receive, good or bad.*
>
> *7. Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited. *
>
> *8. Any post which is not related to excel, macros, vba, access or any 
> other office technology, It will be considered as spam on the discretion of 
> moderators.*
>
> *General suggestions:*
>
>1. 
> *Don't put your email address in a post unless you're dying for more spam 
>in your inbox. * 
>2. *Don't ever post personal or confidential data in a workbook. The 
>moderators will not consider any request to delete such posts.*
>
>  
> Feel free to let me know if you have any doubts or if you want to add more 
> rules to keep this forum clean.
>  
> The rules are also available @ this link 
>  
>
> Best regards,
> Ayush Jain
> Group Manager, MVP
>

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

FORUM RULES

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

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

$$Excel-Macros$$ Update Formula to Value by VBA

[Pravin Gunjal]

Hi Experts,

I need a small help with attached file.

In column *U,* I have used one formula that, if column *T* has anything in 
it, then today's date will be displayed in column *U.*
I need all these dates of column *U* to be transferred in values before 
closing the file. (Apart from the cells where there is no date, but have 
formula)

Can anyone help me on this please..

Regards,
Pravin Gunjal

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

FORUM RULES

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

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


Invoice Reg Test.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

$$Excel-Macros$$ Macro to create a table for changeable data

[Pravin Gunjal]

Hi Guys,

I have a macro in the attached file to create a table for the data (my data 
doesn't have fix rows and changes on daily basis), but after the table is 
created few or more rows have to be deleted based on the requirement.

But as you could see that the table is still existing with blank rows. So I 
want these blank rows are to be deleted at the end.
 
So can you help me to do it so? Or else let me know any other solution for 
it.

Thank you!

Regards,
Pravin Gunjal. 

-- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/excel-macros/ca764912-7111-4ce0-980f-37aaef28bd55n%40googlegroups.com.


ZSRLNO Working.xlsm
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: Remove blank table or create table based on final data only

[Pravin Gunjal]

Hi Friends,
Any update please.

On Monday, September 21, 2020 at 3:30:16 PM UTC+5:30 Pravin Gunjal wrote:

> Hi Friends,
>
> I have attached two excel files as follows:-
>
> 1) ZSRLNO File No.1 (This is system downloaded file)
> 2) ZSRLNO File No.2 (This is after use of macro in above file) 
>
> *I do not want the blank table in it, which is appearing below the data in 
> file no.2.*
>
> *Solution can be *eighther remove blank data after workout of macro, OR 
> create table only for available data and not extra as it is created. (PS: 
> rows can be less or more everyday, they are not fixed) 
>
> *The macro is available in file no.2 for your ready reference.*
>
> Thank you!
>
> Regards
> Pravin Gunjal
>
>

-- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/excel-macros/6073098a-f850-4871-a8c9-87079bb76240n%40googlegroups.com.

$$Excel-Macros$$ Specific word in a cell to be highlighted with Bold & Blue color

[Pravin Gunjal]

Greetings!

I am having a data containing a word called "ACTIV". And would like to 
highlight only this word out of the cell with a *specific color (BLUE) *and 
*BOLD* 

(only this word and not other words in the same cell)

Could you please help me on this issue.

Regards
Pravin Gunjal.
 

-- 
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$$ A word in a cell to be highlighted with Blue color & Bold

[Pravin Gunjal]

Greetings!

I am having a data containing a word called "ACTIV". And would like to 
highlight only this word out of the cell with a *specific color (BLUE) *and 
*BOLD* 

(only this word and not other words in the same cell)

Could you please help me on this issue.
​  File is attached.​

Regards
Pravin Gunjal.

-- 
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.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ A word in a cell to be highlighted with Blue color & Bold

[Pravin Gunjal]

Thanks Ravinder

Also would like to do it *BOLD*. Pl help.


On Thu, May 8, 2014 at 4:32 PM, Ravinder wrote:

> Pfa for your solution
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Pravin Gunjal
> *Sent:* Thursday, May 08, 2014 4:15 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ A word in a cell to be highlighted with Blue
> color & Bold
>
>
>
> Greetings!
>
>
>
> I am having a data containing a word called "ACTIV". And would like to
> highlight only this word out of the cell with a *specific color (BLUE) *
> and *BOLD*
>
>
>
> (only this word and not other words in the same cell)
>
>
>
> Could you please help me on this issue.
>
>  File is attached.
>
>
>
> Regards
>
> Pravin Gunjal.
>
> --
> 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 a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/pI6eWifu_0E/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at 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$$ Column wise data to be moved to separate sheets

[Pravin Gunjal]

Dear Vabz

It can be moved by a button.


On Tuesday, May 13, 2014 12:35:15 PM UTC+5:30, Vabz wrote:
>
> what is trigger for moving?
>
>
> On Tue, May 13, 2014 at 12:22 PM, Pravin Gunjal 
> > wrote:
>
>> Dear Friends,
>>
>> I would like to update the data from sheet viz. "Sales Register" to the 
>> next three sheets as per column "Invoice No."
>>
>> For Example: Invoice No. starts from: "CPU2014-15-XXX" should move to 
>> "CPU2014-15" sheet with entire row data. Likewise for other sheets also.
>>
>> I have given output sample in all the sheets viz. 
>> CPU2014-15, DPU2014-15, FPU2014-15.
>>
>> Thank you,
>>
>> Regards
>> Pravin Gunjal
>>  
>> -- 
>> 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.

$$Excel-Macros$$ Multiple Order Should Pickup

[Pravin Gunjal]

Dear Friends,

Greetings!

I have attached an excel file.  The data is already entered in this file
and nothing can be changed.

The "Qty" column must be multiple of "Pack" column.  If it is correct then
it should display: "Correct" otherwise "Incorrect" in "Result" column.

Hope you would help me. Thank you.

Regards
Pravin Gunjal.

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


16.05.2014.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Multiple value to be picked up

[Pravin Gunjal]

Hello,

I have attached an excel file.  The data is already entered in this file.


The "Qty" column must be multiple of "Pack" column.  If it is correct then
it should display: "Correct" otherwise "Incorrect" in "Result" column.

Hope you would help me. Thank you.

Regards
Pravin Gunjal.

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


16.05.2014.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Date wise amount & Invoice Nos. wanted to merge

[Pravin Gunjal]

Dear Friends

Good Evening,

I have attached a working file and need help as follows:

1. The amount to be added in the above cell, if the date & party is unique.

2. Invoice No. to be added by giving slash (/)

For Example: Before Workout

 *Due Date*

*Amount*

*Inv No*

*Party Name*

17.06.2014

32,174.00

1579001280

Annapurna Distributo - Latur

17.06.2014

2,123.00

1579001281

Annapurna Distributo - Latur

17.06.2014

19,377.00

1579001307

Annapurna Distributo - Latur

17.06.2014

5,571.00

1579001316

Annapurna Distributo - Latur

After Workout it must be as follows:

 *Due Date*

*Amount*

*Inv No*

*Party Name*

17.06.2014

59,245.00

1579001280/1579001281/1579001307/1579001316

Annapurna Distributo - Latur

Please help.

Regards
Pravin Gunjal.

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


Ageing Help.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

$$Excel-Macros$$ Date wise amount & Invoice Nos. to be add/merge

[Pravin Gunjal]

Hello, Do I get any updates on this?

-- Forwarded message --
From: Pravin Gunjal 
Date: Fri, Jun 6, 2014 at 6:01 PM
Subject: Date wise amount & Invoice Nos. wanted to merge
To: excel-macros@googlegroups.com


Dear Friends

Good Evening,

I have attached a working file and need help as follows:

1. The amount to be added in the above cell, if the date & party is unique.

2. Invoice No. to be added by giving slash (/)

For Example: Before Workout

 *Due Date*

*Amount*

*Inv No*

*Party Name*

17.06.2014

32,174.00

1579001280

Annapurna Distributo - Latur

17.06.2014

2,123.00

1579001281

Annapurna Distributo - Latur

17.06.2014

19,377.00

1579001307

Annapurna Distributo - Latur

17.06.2014

5,571.00

1579001316

Annapurna Distributo - Latur

After Workout it must be as follows:

 *Due Date*

*Amount*

*Inv No*

*Party Name*

17.06.2014

59,245.00

1579001280/1579001281/1579001307/1579001316

Annapurna Distributo - Latur

Please help.

Regards
Pravin Gunjal.

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


Ageing Help.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

$$Excel-Macros$$ Date Format Query

[Pravin Gunjal]

Hi,

I wanted to convert the dates in this format *DD.MM.*

Now it is not in system's date format ( MM/DD/ ) and it is displayed as 
DD/MM/ or as D/M/. 

Kindly help.

Regards
Pravin Gunjal.

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


Date Query.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

Re: $$Excel-Macros$$ Date Format Query

[Pravin Gunjal]

Dear Pramod,

Thank you for your reply.  But I found it is not giving result for all
cells.
Please do the needful.


On Thu, Jun 12, 2014 at 4:22 PM, Pramod Singh  wrote:

> Hi
> Pravin Gunjal,
>
> PFA
>
> Hope This will fine for you..
>
>
>
>
> Warm Regards
>
> Pramod
>
> VBA Developer
>
>
> On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal  wrote:
>
>> Hi,
>>
>> I wanted to convert the dates in this format *DD.MM.*
>>
>> Now it is not in system's date format ( MM/DD/ ) and it is displayed
>> as DD/MM/ or as D/M/.
>>
>> Kindly help.
>>
>> Regards
>> Pravin Gunjal.
>>
>> --
>> 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.
>>
>
>
>
> --
> *PramodSingh*
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/KuYWzt64SjI/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at 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$$ Date Format Query

[Pravin Gunjal]

Yes rightly said. The file which has been downloaded from software isn't
having proper systems date format.  So I would like to make it in
DD.MM. (2.2.4 digits)

Kindly do the needful.


On Mon, Jun 16, 2014 at 5:19 PM, Paul Schreiner 
wrote:

> Guys:
>
> I started with the same response, until I noticed that
> I believe what he's saying is that the value in the cell is NOT an Excel
> date:
>
> He said:  "Now it is not in system's date format"
>
> so, he cannot change the display format to display it in another date
> format.
>
> the solution using the parsing the string and re-assembling it as a valid
> date is what is necessary.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *"Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can." - John Wesley*
> -
>
>*From:* 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS <
> excel-macros@googlegroups.com>
> *To:* "excel-macros@googlegroups.com" 
> *Sent:* Sunday, June 15, 2014 1:24 PM
> *Subject:* Re: $$Excel-Macros$$ Date Format Query
>
> Hi Pravin ...
>
> You can go to Format cell and custom the format of the date which ever
> result you need. furthermore you can see in the attachement.
>
>
> [image: cid:image001.gif@01C80A4D.0DE9E110]
>
>
> *Delin.F*
>
>
>
>
>   On Sunday, 15 June 2014 4:54 PM, Vaibhav Joshi  wrote:
>
>
> Hi
>
> You can change display format by going to cell property & select custom
> and type dd.mm.
>
> If by doing so if date format does not change then select single column
> then press Data tab in Menu then press Next 2 times then select Date (DMY)
> and press finish button.
>
> Cheers!!
>
>
> On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal  wrote:
>
> Hi,
>
> I wanted to convert the dates in this format *DD.MM.*
>
> Now it is not in system's date format ( MM/DD/ ) and it is displayed
> as DD/MM/ or as D/M/.
>
> Kindly help.
>
> Regards
> Pravin Gunjal.
>  --
> 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@googlegr

Re: $$Excel-Macros$$ Date Format Query

[Pravin Gunjal]

This is working perfectly as per my requirement.
Thanks.

Regards
Pravin Gunjal.


On Sun, Jun 15, 2014 at 10:54 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA
MACROS  wrote:

> Hi Pravin ...
>
> You can go to Format cell and custom the format of the date which ever
> result you need. furthermore you can see in the attachement.
>
>
> [image: cid:image001.gif@01C80A4D.0DE9E110]
>
>
> *Delin.F*
>
>
>
>
>   On Sunday, 15 June 2014 4:54 PM, Vaibhav Joshi  wrote:
>
>
> Hi
>
> You can change display format by going to cell property & select custom
> and type dd.mm.
>
> If by doing so if date format does not change then select single column
> then press Data tab in Menu then press Next 2 times then select Date (DMY)
> and press finish button.
>
> Cheers!!
>
>
> On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal  wrote:
>
> Hi,
>
> I wanted to convert the dates in this format *DD.MM.*
>
> Now it is not in system's date format ( MM/DD/ ) and it is displayed
> as DD/MM/ or as D/M/.
>
> Kindly help.
>
> Regards
> Pravin Gunjal.
>  --
> 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 a topic in the
> Google G

$$Excel-Macros$$ Excel Data E Mail to Respective Customers

[Pravin Gunjal]

Hello,

I would like to email the attached data once for all in a single click from
column A to H to the respective customers as per email id mentioned in
column I.

Kindly help me on this matter.  Pl find attached test file for the same.

Thank you in anticipation.

Regards
Pravin Gunjal.

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


E Mail Test for All Customer.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

$$Excel-Macros$$ Excel Data to be sent through email to customers at a time

[Pravin Gunjal]

Good Morning,

I would like to email the attached data
in body text of email
in a single click
to all customers.

A
separate mail must be sent for different customers with only their data
i.e.
from column A to H
to the
email id mentioned in column I.

Kindly help me on this matter.  Pl find attached test file for the same.

Thank you in anticipation.

Regards
Pravin Gunjal.

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


E Mail Test for All Customer.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

$$Excel-Macros$$ Drop Down Option - reg.

[Pravin Gunjal]

Hello,



I have three sheets in the attached file.

I have created a name manager in master sheet for "Party Names" and it has
accessed in first two sheets viz. Veritaz & Hospin.



*My requirement is: *



If I select drop down option in "Veritaz" sheet under party name the system
must display only those divisions parties which comes under "Veritaz" &
"Both"


Likewise if I select the drop down in "Hospin" sheet, then the party list
should come which comes under of "Hospin" & "Both" division.



Thank you,




*Regards, Pravin Gunjal.*

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


Invoice Register Test.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

$$Excel-Macros$$ Fwd: Drop Down Option - reg.

[Pravin Gunjal]

Any idea on this !!

-- Forwarded message --
From: Pravin Gunjal 
Date: Thu, Jul 3, 2014 at 11:03 AM
Subject: Drop Down Option - reg.
To: excel-macros@googlegroups.com


Hello,



I have three sheets in the attached file.

I have created a name manager in master sheet for "Party Names" and it has
accessed in first two sheets viz. Veritaz & Hospin.



*My requirement is: *



If I select drop down option in "Veritaz" sheet under party name the system
must display only those divisions parties which comes under "Veritaz" &
"Both"


Likewise if I select the drop down in "Hospin" sheet, then the party list
should come which comes under of "Hospin" & "Both" division.



Thank you,




*Regards, Pravin Gunjal.*

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


Invoice Register Test.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

$$Excel-Macros$$ Conditional formatting help - file attached

[Pravin Gunjal]

Hello Friends,

I have attached an excel file, in which Column D, M and Y are very
important in this file.

*I need the following :*
If a Division (Col D) has crossed 30 days (Col Y) and still not received an
acknowledgement copy (Col M) then the entire row (from Column A to Y) must
be highlighted with any of the background colors.

Kindly do the needful.  Thank you,

Regards
Pravin Gunjal.

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


POD Working.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

$$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

[Pravin Gunjal]

*Hi,I have recorded a macro to create a new sheet called "Party Wise" based 
on the info available in sheet called "Pending CN"When I go for second 
attempt it's giving an error because of the sheet name.Could you please 
look in to this and arrange a solution to overwrite the data second time in 
the same sheet: "Party Wise" Hope the matter is clear.  Thank you in 
anticipation.Sub Paryt_Wise()'' Paryt_Wise Macro' Pravin Gunjal''
Sheets("Pending CN").SelectSheets("Pending CN").Copy 
Before:=Sheets(1)Sheets("Pending CN (2)").SelectSheets("Pending CN 
(2)").Name = "Party Wise"Cells.Select
ActiveWorkbook.Worksheets("Party Wise").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Party Wise").Sort.SortFields.Add Key:=Range( 
_"C2:C83"), SortOn:=xlSortOnValues, Order:=xlAscending, 
DataOption:= _xlSortNormalActiveWorkbook.Worksheets("Party 
Wise").Sort.SortFields.Add Key:=Range( _"B2:B83"), 
SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormalWith ActiveWorkbook.Worksheets("Party Wise").Sort
.SetRange Range("A1:IV83").Header = xlYes.MatchCase = 
False.Orientation = xlTopToBottom.SortMethod = 
xlPinYin.ApplyEnd WithRange("C4").Select
ActiveWorkbook.SaveEnd SubRegardsPravin Gunjal.*

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


Pending CN.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

[Pravin Gunjal]

*Hi Paul :* If I add this code in my code it creates new sheet and deletes
immediately.  Pl look in to this.

*Hi Ashish :* Your file is creating new sheet every time but I want the
same sheet to be overwritten with changes.

Thank you,

On Thu, Nov 13, 2014 at 7:46 PM, Ashish Kumar 
wrote:

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

[Pravin Gunjal]

Thank you everyone.

On Fri, Nov 14, 2014 at 5:42 PM, Ashish Kumar 
wrote:

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

$$Excel-Macros$$ How to unhide columns in Office 2010 - Windows 10

[Pravin Gunjal]

Hi Friend

Greetings!

Could you please assist me on how to unhide shortcut of "Ctrl+Shift+0" as
it's not working in Windows 10 with Office 2010.

Thanks,


*With regards,**Pravin Gunjal*
*​​*

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

FORUM RULES

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

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

$$Excel-Macros$$ Rename all sheets of one excel file in single shot with different names

[Pravin Gunjal]

Dear Friends,

Greetings!

Could you please teach me how to rename multiple sheets in a single shot 
with different name of each sheet.

Any tool/formula/VB is welcome. Thanks,

Example:
1. Gather all sheet names in a new sheet in the same file
2. In the next column type new names (which are to be replaced)
3. Make one button in that sheet - once the button is hit the all the 
sheets are renamed.

Regards
Pravin Gunjal

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Rename all sheets of one excel file in single shot with different names

[Pravin Gunjal]

Dear Gaurav

Thanks for solution. You have created a sheet viz. *Tab-Names *and then
used two macros based on requirement.

But my worry is that in every month number of sheets are getting changed
and I believe the codes can run only up to 49 sheets. Please check and
advise.


*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*




On Wed, Aug 17, 2016 at 4:05 PM, Gaurav Devrani 
wrote:

> Hi Pravin,
>
> I think this query was already posted few weeks back. Please check the
> attachment. Let me know if that does not work.
>
> Regards
> Gaurav Devrani
>
> On Wed, Aug 17, 2016 at 3:25 AM, Pravin Gunjal  wrote:
>
>> Dear Friends,
>>
>> Greetings!
>>
>> Could you please teach me how to rename multiple sheets in a single shot
>> with different name of each sheet.
>>
>> Any tool/formula/VB is welcome. Thanks,
>>
>> Example:
>> 1. Gather all sheet names in a new sheet in the same file
>> 2. In the next column type new names (which are to be replaced)
>> 3. Make one button in that sheet - once the button is hit the all the
>> sheets are renamed.
>>
>> Regards
>> Pravin Gunjal
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
>
> *Thanks & Regards*
> *Gaurav Devrani*
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/excel-macros/tW_oubrzWAs/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

Re: $$Excel-Macros$$ Rename all sheets of one excel file in single shot with different names

[Pravin Gunjal]

Hi Gaurav

Checked once again and it's working fine. Thanks :)
Need one more help with the same subject.
In "Tab-Names" sheet, can we insert B1 cell of all the sheets along with
sheet names in a column.


*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*




On Tue, Aug 23, 2016 at 4:27 PM, Gaurav Devrani 
wrote:

> What do you mean by 49 sheets. I don't think this code have such
> functionality not to work more than 49 sheets. I am sure you are confused
> with the code written inside. but still let me know your opinion about 49
> sheets.
>
> On Tue, Aug 23, 2016 at 3:04 AM, Pravin Gunjal  wrote:
>
>> Dear Gaurav
>>
>> Thanks for solution. You have created a sheet viz. *Tab-Names *and then
>> used two macros based on requirement.
>>
>> But my worry is that in every month number of sheets are getting changed
>> and I believe the codes can run only up to 49 sheets. Please check and
>> advise.
>>
>>
>> *With regards,**Pravin Gunjal*
>> *Mobile: 77100 *
>> *97250*
>>
>>
>>
>>
>> On Wed, Aug 17, 2016 at 4:05 PM, Gaurav Devrani 
>> wrote:
>>
>>> Hi Pravin,
>>>
>>> I think this query was already posted few weeks back. Please check the
>>> attachment. Let me know if that does not work.
>>>
>>> Regards
>>> Gaurav Devrani
>>>
>>> On Wed, Aug 17, 2016 at 3:25 AM, Pravin Gunjal 
>>> wrote:
>>>
>>>> Dear Friends,
>>>>
>>>> Greetings!
>>>>
>>>> Could you please teach me how to rename multiple sheets in a single
>>>> shot with different name of each sheet.
>>>>
>>>> Any tool/formula/VB is welcome. Thanks,
>>>>
>>>> Example:
>>>> 1. Gather all sheet names in a new sheet in the same file
>>>> 2. In the next column type new names (which are to be replaced)
>>>> 3. Make one button in that sheet - once the button is hit the all the
>>>> sheets are renamed.
>>>>
>>>> Regards
>>>> Pravin Gunjal
>>>>
>>>> --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> Visit this group at https://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>>
>>>
>>> --
>>>
>>> *Thanks & Regards*
>>> *Gaurav Devrani*
>>>
>>> --
>>> 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) Sh

$$Excel-Macros$$ Data moving from one file to other as required

[Pravin Gunjal]

Hi Friends

Greetings!

I have attached two files viz. Sample Source & Sample Target.
I want 3 columns data from source file to target file in columns H, I & J.

This has to be done based on "Invoice No." column.

(If the invoice no. comes more than one in next row then "Material" should
be added with comma, whereas "Doctor Name" & "Patient Name" should come
only once for an invoice)

e.g. I have taken up the data for Invoice No.8137000290 from source file to
target.

Could you please help me to get it done with any VB / Formula.


*With regards,**Pravin Gunjal*

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

FORUM RULES

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

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


Sample Source.xlsx
Description: MS-Excel 2007 spreadsheet


Sample Target.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Fetching Matches Data

[Pravin Gunjal]

Hi Everyone,

I need to have some data which I could take by doing VLOOKUP but there are 
multiple rows with same requirement, hence excel takes only first row with 
VLOOKUP.
Can I have any other formula OR VB code which can work it out for me to 
take required data with multiple rows.

I want to have 3 columns data viz. 1) Material, 2) Doctor Name & 3) Patient 
Name in "Sample Target" from file "Sample Source"
When there are multiple rows for Material, it should be added with commas 
in the same cell.
I have filed one example for one invoice in the same file.

Column serial may differs but name is the same in both the file, for ready 
reference I have given Pink Background color for identification.

Can someone help me out on this please. Find attached both the files. 

Regards
Pravin Gunjal

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

FORUM RULES

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

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


Sample Source.xlsx
Description: MS-Excel 2007 spreadsheet


Sample Target.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: Data moving from one file to other as required

[Pravin Gunjal]

Hi,
Can anyone help me out on this subject, please.


*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*




On Tue, Feb 7, 2017 at 11:40 AM, Pravin Gunjal  wrote:

> Hi Friends
>
> Greetings!
>
> I have attached two files viz. Sample Source & Sample Target.
> I want 3 columns data from source file to target file in columns H, I & J.
>
> This has to be done based on "Invoice No." column.
>
> (If the invoice no. comes more than one in next row then "Material" should
> be added with comma, whereas "Doctor Name" & "Patient Name" should come
> only once for an invoice)
>
> e.g. I have taken up the data for Invoice No.8137000290 from source file
> to target.
>
> Could you please help me to get it done with any VB / Formula.
>
>
> *With regards,**Pravin Gunjal*
>
>

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

FORUM RULES

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

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

$$Excel-Macros$$ Re: Fetching Matches Data

[Pravin Gunjal]

Hi Buddy's 

Any solution on this please.

Regards
Pravin.


On Tuesday, February 7, 2017 at 12:50:51 PM UTC+5:30, Pravin Gunjal wrote:
>
> Hi Everyone,
>
> I need to have some data which I could take by doing VLOOKUP but there are 
> multiple rows with same requirement, hence excel takes only first row with 
> VLOOKUP.
> Can I have any other formula OR VB code which can work it out for me to 
> take required data with multiple rows.
>
> I want to have 3 columns data viz. 1) Material, 2) Doctor Name & 3) 
> Patient Name in "Sample Target" from file "Sample Source"
> When there are multiple rows for Material, it should be added with commas 
> in the same cell.
> I have filed one example for one invoice in the same file.
>
> Column serial may differs but name is the same in both the file, for ready 
> reference I have given Pink Background color for identification.
>
> Can someone help me out on this please. Find attached both the files. 
>
> Regards
> Pravin Gunjal
>

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

FORUM RULES

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

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

$$Excel-Macros$$ Values are not calculating in number format

[Pravin Gunjal]

Dear Friends,

Greetings!

I need to calculate SUM OR COUNT formula's for column D & E but it seems
these values are not in number format.
Could you please guide me how to convert them in number. As there is *space
& comma *given before all the values.


*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*

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

FORUM RULES

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

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


Book1.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Microsoft Office 2013 OR 2016

[Pravin Gunjal]

Hi Everyone

I would like to know whether any of these Microsoft Office 2013 OR 2016 are 
available for free download with nay product key to activate.
If so, kindly share the links to download.

Thanks,
Pravin Gunjal

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

FORUM RULES

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

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

$$Excel-Macros$$ Microsoft Office Opens Very Slow in Windows 10

[Pravin Gunjal]

Dear Friends,

Greetings,

I have Windows 10 Pro with 3 GB Ram & 64 Bit OS x64 Processor Desktop.
In which I have installed Microsoft Office 2016 (Activated)
*But the MS Office Applications viz. EXCEL, Word & Outlook are opens very 
slow in my computer.*
*Any file takes 15-20 seconds to open, even for blank file also.*
Could anyone let me have solution for this please.
Thank you.

Regards,
Pravin Gunjal.

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

FORUM RULES

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

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

$$Excel-Macros$$ Microsoft Office 2016 Opens Very Slow in Windows 10

[Pravin Gunjal]

Hi, Can any look in to this request please.


*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*


-- Forwarded message --
From: Pravin Gunjal 
Date: Fri, Nov 24, 2017 at 10:09 AM
Subject: $$Excel-Macros$$ Microsoft Office Opens Very Slow in Windows 10
To: MS EXCEL AND VBA MACROS 


Dear Friends,

Greetings,

I have Windows 10 Pro with 3 GB Ram & 64 Bit OS x64 Processor Desktop.
In which I have installed Microsoft Office 2016 (Activated)
*But the MS Office Applications viz. EXCEL, Word & Outlook are opens very
slow in my computer.*
*Any file takes 15-20 seconds to open, even for blank file also.*
Could anyone let me have solution for this please.
Thank you.

Regards,
Pravin Gunjal.

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

FORUM RULES

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

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

$$Excel-Macros$$ Re: Microsoft Office 2016 Opens Very Slow in Windows 10

[Pravin Gunjal]

Hi Experts,
Need your advises.

Regards,
Pravin.

On Friday, November 24, 2017 at 5:45:08 PM UTC+5:30, Pravin Gunjal wrote:
>
> Hi, Can any look in to this request please.
>
>
> *With regards,**Pravin Gunjal*  
>
 

>
> -- Forwarded message --
>
> Dear Friends,
>
> Greetings,
>
> I have Windows 10 Pro with 3 GB Ram & 64 Bit OS x64 Processor Desktop.
> In which I have installed Microsoft Office 2016 (Activated)
> *But the MS Office Applications viz. EXCEL, Word & Outlook are opens very 
> slow in my computer.*
> *Any file takes 15-20 seconds to open, even for blank file also.*
> Could anyone let me have solution for this please.
> Thank you.
>
> Regards,
> Pravin Gunjal.
>

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

FORUM RULES

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

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

$$Excel-Macros$$ Re: Microsoft Office Opens Very Slow in Windows 10

[Pravin Gunjal]

Dear *Experts*

Awaiting for your help on the above subject.

Regards,
Pravin Gunjal

On Friday, November 24, 2017 at 10:09:56 AM UTC+5:30, Pravin Gunjal wrote:
>
> Dear Friends,
>
> Greetings,
>
> I have Windows 10 Pro with 3 GB Ram & 64 Bit OS x64 Processor Desktop.
> In which I have installed Microsoft Office 2016 (Activated)
> *But the MS Office Applications viz. EXCEL, Word & Outlook are opens very 
> slow in my computer.*
> *Any file takes 15-20 seconds to open, even for blank file also.*
> Could anyone let me have solution for this please.
> Thank you.
>
> Regards,
> Pravin Gunjal.
>
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Delete some rows from Excel as per condition

[Pravin Gunjal]

Dear Mr.Paul,

Thanks for your reply.
I tried using this code in the existing macro of the file and observed
that, it deletes only the year 2012 and not 2011.
Also it has deleted the header row apart from old years, which shouldn't do.

The existing macro is attached for your immediate reference. Please help.

*With regards,*

*Pravin Gunjal*



On Tue, Dec 5, 2017 at 5:51 PM, Paul Schreiner 
wrote:

> Sure,
> the "trick" is that you have to start at the last row and work your way
> "up".
>
> because otherwise, when you delete a row, the "next" row moves up into
> the deleted position, then the loop would skip over that record.
>
> By starting at the bottom, the row that moves up has already been
> processed..
>
> the macro would look something like:
> ​​
> Sub Delete_By_Year()
> Dim nRows, nRow
> Application.ScreenUpdating = False
> On Error Resume Next
> nRows = Application.WorksheetFunction.CountA(Range("A:A"))
> For nRow = nRows To 1 Step -1
> If (nRow Mod 1000 = 0) Then Application.StatusBar = "Processing "
> & nRow
> If ((Year(Cells(nRow, "H").Value) = 2011) _
>  Or (Year(Cells(nRow, "H").Value) = 2012)) Then
> Cells(nRow, "A").EntireRow.Delete
> End If
> Next nRow
> Application.ScreenUpdating = True
> Application.StatusBar = False
> MsgBox "finished"
> End Sub
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Tuesday, December 5, 2017 2:46 AM, Pravin Gunjal 
> wrote:
>
>
> Hi Experts
>
> I want to delete those rows which belongs to Year 2011 & 2012 available as
> per column H of "Expiry Date"
>
>
> <https://lh3.googleusercontent.com/-gexr3n-M860/WiZOjt2f0AI/WnE/acZCY1U77tYO-ao1C7FgkZkEKKxptlRUwCLcBGAs/s1600/Untitled.png>
>
>
> Can we do it by any macro. Thank you in anticipation.
>
> Regards,
> Pravin Gunjal.
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/excel-macros/SM3b1he4JSA/unsubscribe.
> To unsubscribe from this

$$Excel-Macros$$ Numbers to Words by Formula or Macro

[Pravin Gunjal]

Dear Experts

Kindly help me by sharing a formula or Macro to convert numbers to words in
attached file.
It is required up to the last number mentioned in excel file. (Some higher
numbers are not displayed by excel in number format)


*With regards,*

*Pravin Gunjal*

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

FORUM RULES

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

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


Number to Words.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

$$Excel-Macros$$ Windows 10 Updates - reg.

[Pravin Gunjal]

Hi Friends,

I have installed *Windows 10 Pro (activated) *on my Desktop Computer.

RAM : 3 GB
Type: 64-Bit
Processor : Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz 2.94GHz
*MS Office 2016 *32-Bit

I am facing problems like:
1) Daily updation of Windows 10 (it takes much time and need restart in
between)
2) Slow opening of MS Office (Word, *Excel*, Outlook etc.)

I would be very happy if you could help me to sort out these issues. Thank
you,


*With regards,**Pravin Gunjal*

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

FORUM RULES

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

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

$$Excel-Macros$$ Same conditional formatting is required in other sheets of the same file

[Pravin Gunjal]

Hello Friends,

I have an excel file with many sheets which is attached for your reference.

In this file there is a sheet called: "Mahavir" ( you may go to this sheet 
by clicking on cell: *D18 *) in which I have set one conditional formatting 
which I wanted for all other sheets except "Main Sheet - Sheet No.1"

Could anybody help me to do this.  Thank you,

*Also one more help is required in the same file. **There is columns 
heading with "CHQ" in main sheet.*

*For Example please go to sheet "Ambika" here whatever "Cheque Dates" are 
blank against "Cheque No." those no. of entries I erquired in Main Sheet 
under "CHQ" filed before Ambika Agencies. So the No. will come as 1 in main 
sheet in cell : "C5".*

*I hope it is possible.  Kindly help me out on this subject.  It can be 
very very helpful for me in day to day activities.  Thanks a lot in 
advance.*

Regards
Pravin Gunjal

-- 
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$$ Same conditional formatting is required in other sheets of the same file

[Pravin Gunjal]

Hi Vabs

Set rng = Application.InputBox("Select cell/range for which you want to
update chq no.", Type:=8)
For the above function can we make following cells by default:

*C4 to C21*
*F4 to F21*
*I4 to I21*
*O4 to O15*

Because I want the result to be come in these cells only.

Regards
Pravin Gunjal


On Wed, Jan 14, 2015 at 1:39 PM, Vaibhav Joshi  wrote:

> Pravin,
>
> Chek this...Logic for fetching data remains same..
>
> Also i have added one more functionality, just doubl click on chq. count
> to see it..
>
> Cheers!!
> ᐧ
>
> On Wed, Jan 14, 2015 at 12:20 PM, Pravin Gunjal  wrote:
>
>> Dear Vabs
>>
>> Thank you for looking in to my query.
>>
>> I have checked the file given by you and it's giving the cheque details
>> in main sheet, instead I want only *no. of cheques (how many cheques are
>> not utilized) *available in main sheet.
>>
>> Also I want conditional format to be copied in other sheets too from
>> sheet "Mahavir".
>>
>> Could you please check it once again.  Thank you,
>>
>> Regards
>> Pravin Gunjal
>>
>> On Sat, Jan 10, 2015 at 10:12 PM, Vaibhav Joshi  wrote:
>>
>>> Hi Pravin,
>>>
>>> Check this...hope you must have handled conditional formatting, i worked
>>> on part for updating chq no..
>>>
>>> Click on CHQ button select range from A4 to anything, or just single
>>> cell with customer name ..rest macro will take care..
>>>
>>> Cheers!!
>>>
>>>
>>>
>>> On Sat, Jan 10, 2015 at 3:06 PM, Vaibhav Joshi  wrote:
>>>
>>>> is this resolved at your end or still pending?
>>>> ᐧ
>>>>
>>>> On Fri, Jan 9, 2015 at 1:14 PM, Pravin Gunjal 
>>>> wrote:
>>>>
>>>>> Hello Friends,
>>>>>
>>>>> I have an excel file with many sheets which is attached for your
>>>>> reference.
>>>>>
>>>>> In this file there is a sheet called: "Mahavir" ( you may go to this
>>>>> sheet by clicking on cell: *D18 *) in which I have set one
>>>>> conditional formatting which I wanted for all other sheets except "Main
>>>>> Sheet - Sheet No.1"
>>>>>
>>>>> Could anybody help me to do this.  Thank you,
>>>>>
>>>>> *Also one more help is required in the same file. **There is columns
>>>>> heading with "CHQ" in main sheet.*
>>>>>
>>>>> *For Example please go to sheet "Ambika" here whatever "Cheque Dates"
>>>>> are blank against "Cheque No." those no. of entries I erquired in Main
>>>>> Sheet under "CHQ" filed before Ambika Agencies. So the No. will come as 1
>>>>> in main sheet in cell : "C5".*
>>>>>
>>>>> *I hope it is possible.  Kindly help me out on this subject.  It can
>>>>> be very very helpful for me in day to day activities.  Thanks a lot in
>>>>> advance.*
>>>>>
>>>>> Regards
>>>>> Pravin Gunjal
>>>>>
>>>>> --
>>>>> 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 ex

Re: $$Excel-Macros$$ Same conditional formatting is required in other sheets of the same file

[Pravin Gunjal]

*Very nice, thank you for the same.  And the functionality you have added
is awesome.*

Also let me know the conditional formatting asked in my original mail.

On Wed, Jan 14, 2015 at 5:56 PM, Vaibhav Joshi  wrote:

> Replace with this line..
>
> Set rng = Application.Union(Range("A4:A21"), Range("D4:D21"),
> Range("G4:G21"), Range("J4:J21"), Range("M4:M15"))
>
> ᐧ
>
> On Wed, Jan 14, 2015 at 5:44 PM, Pravin Gunjal  wrote:
>
>> Hi Vabs
>>
>> Set rng = Application.InputBox("Select cell/range for which you want to
>> update chq no.", Type:=8)
>> For the above function can we make following cells by default:
>>
>> *C4 to C21*
>> *F4 to F21*
>> *I4 to I21*
>> *O4 to O15*
>>
>> Because I want the result to be come in these cells only.
>>
>> Regards
>> Pravin Gunjal
>>
>>
>> On Wed, Jan 14, 2015 at 1:39 PM, Vaibhav Joshi  wrote:
>>
>>> Pravin,
>>>
>>> Chek this...Logic for fetching data remains same..
>>>
>>> Also i have added one more functionality, just doubl click on chq. count
>>> to see it..
>>>
>>> Cheers!!
>>> ᐧ
>>>
>>> On Wed, Jan 14, 2015 at 12:20 PM, Pravin Gunjal 
>>> wrote:
>>>
>>>> Dear Vabs
>>>>
>>>> Thank you for looking in to my query.
>>>>
>>>> I have checked the file given by you and it's giving the cheque details
>>>> in main sheet, instead I want only *no. of cheques (how many cheques
>>>> are not utilized) *available in main sheet.
>>>>
>>>> Also I want conditional format to be copied in other sheets too from
>>>> sheet "Mahavir".
>>>>
>>>> Could you please check it once again.  Thank you,
>>>>
>>>> Regards
>>>> Pravin Gunjal
>>>>
>>>> On Sat, Jan 10, 2015 at 10:12 PM, Vaibhav Joshi  wrote:
>>>>
>>>>> Hi Pravin,
>>>>>
>>>>> Check this...hope you must have handled conditional formatting, i
>>>>> worked on part for updating chq no..
>>>>>
>>>>> Click on CHQ button select range from A4 to anything, or just single
>>>>> cell with customer name ..rest macro will take care..
>>>>>
>>>>> Cheers!!
>>>>>
>>>>>
>>>>>
>>>>> On Sat, Jan 10, 2015 at 3:06 PM, Vaibhav Joshi  wrote:
>>>>>
>>>>>> is this resolved at your end or still pending?
>>>>>> ᐧ
>>>>>>
>>>>>> On Fri, Jan 9, 2015 at 1:14 PM, Pravin Gunjal 
>>>>>> wrote:
>>>>>>
>>>>>>> Hello Friends,
>>>>>>>
>>>>>>> I have an excel file with many sheets which is attached for your
>>>>>>> reference.
>>>>>>>
>>>>>>> In this file there is a sheet called: "Mahavir" ( you may go to this
>>>>>>> sheet by clicking on cell: *D18 *) in which I have set one
>>>>>>> conditional formatting which I wanted for all other sheets except "Main
>>>>>>> Sheet - Sheet No.1"
>>>>>>>
>>>>>>> Could anybody help me to do this.  Thank you,
>>>>>>>
>>>>>>> *Also one more help is required in the same file. **There is
>>>>>>> columns heading with "CHQ" in main sheet.*
>>>>>>>
>>>>>>> *For Example please go to sheet "Ambika" here whatever "Cheque
>>>>>>> Dates" are blank against "Cheque No." those no. of entries I erquired in
>>>>>>> Main Sheet under "CHQ" filed before Ambika Agencies. So the No. will 
>>>>>>> come
>>>>>>> as 1 in main sheet in cell : "C5".*
>>>>>>>
>>>>>>> *I hope it is possible.  Kindly help me out on this subject.  It can
>>>>>>> be very very helpful for me in day to day activities.  Thanks a lot in
>>>>>>> advance.*
>>>>>>>
>>>>>>> Regards
>>>>>>> Pravin Gunjal
>>>>>>>
>>>>>>> --
>>>>>>> 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 

$$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

[Pravin Gunjal]

*Hi, Can I expect a reply from anyone..*


On Friday, January 16, 2015 at 4:13:20 PM UTC+5:30, Pravin Gunjal wrote:
>
> Hi,
>
> I have attached an excel file contains 4 sheets..
>
> I am entering mu data in fourth sheet viz. GRRN Entry -which has connected 
> with first three sheets.
>
> *What I want is:*
>
> 1. When I click on cells of *Batch *column (column C) in GRRN Entry 
> sheet, only the particular batches must be displayed here which are related 
> to the *Code *from Batch sheet, to enable me to choose one of them to 
> complete my entry.
>
> 2. Once the *Batch *is selected from the list, the *MRP *also to be 
> picked up automatically from the same sheet. (I could use here vlookup, but 
> MRP may be unique for multiple products, so I need a formula which can 
> refer *Code *and then *Batch*)
>
> Hope to get a good solution.
>
> Thank you,
>
> Regards
> Pravin Gunjal.
>

-- 
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: Need a Formula or Macro to pick-up values from other sheets

[Pravin Gunjal]

It's  *Lot Number (column D)*


On Sat, Jan 17, 2015 at 5:28 PM, Ashish Kumar 
wrote:

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

[Pravin Gunjal]

don

On Sat, Jan 17, 2015 at 5:55 PM, Ashish Kumar 
wrote:

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

[Pravin Gunjal]

Dear Ashish jee

Its fine and working good as per requirement.  Thank you.

But it would be much better, if any pop-up will appear here in Batch column
to select the batches out of many.  In pop-up if we type any starting
letter then only those batches should appear which contains that typed
letter/number.

Please look in to this.



On Sat, Jan 17, 2015 at 9:32 PM, Ashish Kumar 
wrote:

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

[Pravin Gunjal]

Good Morning,

It's fantastic...

On Mon, Jan 19, 2015 at 9:13 PM, Ashish Kumar 
wrote:

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

[Pravin Gunjal]

Hi
I am working with it and observed that while opening the window for batches
it's taking much time.  Can we do something for it.

On Tue, Jan 20, 2015 at 7:28 PM, Ashish Kumar 
wrote:

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

$$Excel-Macros$$ How to Save DBF files in Excel 2007

[Pravin Gunjal]

Hi Good Evening

I am working with foxpro and unable to save DBF files in excel 2007 while
saving it's asking to save in current formats of excels.

Can you tell me is there anyway to overcome from this issue / any solution
because I do not have 2003 version and having only 2007.

Thanks,

Pravin Gunjal.

-- 
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: Need a Formula or Macro to pick-up values from other sheets

[Pravin Gunjal]

Thanks.


On Thu, Jan 22, 2015 at 5:00 PM, Ashish Kumar 
wrote:

> Hi,
>
> Hardly it's take 3 second for showing Batch Details.
>
> Did you checked the count of Batch Data which was in the user form. The
> Count is more than 5000. It's heavy..!!
>
>
>
> Yes We have two more Alternate Options for it.
>
> First is,
> Use the First Sheet, which I'hve send to you on dated 17th Jan.
>
>
> Second is,
> Do Manual Data Entry. If you Do it Manually, then sheet is not take much
> time.
>
>
> Regards
> Ashish
>
>
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/LKJLBMVLV7c/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at 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.

$$Excel-Macros$$ How to modify & save the existing DBF files in Excel 2007

[Pravin Gunjal]

Hi,

Please help me out on the above subject.

Thank you
Pravin.

-- 
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$$ Error In Excel - Pl look in to this & advise

[Pravin Gunjal]

[image: Inline image 1]

Hi,
Suddenly I am getting the above error while opening the excel file and
macro is not running.

Regards
Pravin Gunjal

-- 
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$$ Error on saving the DBF file in Excel 2007

[Pravin Gunjal]

Hi

I tried this one and un-ticked MISSING from libraries and tried to Save As 
the file with existing.
Then it says: The file is already exists. Do you want to replace with 
existing file?
When I click on Yes it again says: Unable to remove existing file..

Kindly look in to this please.

Thanks,
Pravin Gunjal.

On Tuesday, February 3, 2015 at 9:45:31 PM UTC+5:30, Paul Schreiner wrote:
>
> That usually is a problem with "References".
>  
> try these steps:
>  
> Stop execution of macro
> in VB Editor, select Tools-> References...
>  
> you'll find several libraries selected.
> But you might see one that says "Missing" (or something like that).
>  
> The problem is that once the compiler hits this missing library, it stops 
> looking at the others.
>  
> The string manipulation functions like Left() and Right() are in one of 
> the object libraries and are not being found.
>  
> You won't need all of the ones I have but the references I have selected 
> in Excel 2010 are:
>  
> Visual Basic for Applications
> Microsoft Excel 14.0 Object Library
> OLE Automation
> Microsoft Office 14.0 Object Library
> Microsoft Word 14.0 Object Library
> Microsoft Forms 2.0 Object LIbrary
>  
>  
>  
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you 
> can,In all the places you can,At all the times you can,To all the people 
> you can,As long as ever you can.” - John Wesley*
> -
>
>*From:* Pravin Gunjal >
> *To:* Excel Macros > 
> *Sent:* Tuesday, February 3, 2015 8:33 AM
> *Subject:* $$Excel-Macros$$ Error on saving the DBF file in Excel 2007
>  
> Hi
>
> I have downloaded the DBF save add-in but while saving got the attached 
> error in VB.
> Could anyone please check and update me on this issue.
>
> Thank you
> Pravin Gunjal
> -- 
> 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.

$$Excel-Macros$$ User name to be picked up in excel

[Pravin Gunjal]

Hi,



The user name to be picked up by formula in the column *L* once the value
is entered in column *K*



I have entered few names manually.  Please help.




*Regards, Pravin Gunjal*

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


Data Entry.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

[Pravin Gunjal]

col.Type = adLongVarWChar
ElseIf lenlong > 128 And lenlong < 255 Then
col.Type = adWChar
col.Precision = 254
ElseIf lenshort = lenlong And lenlong < 17 Then
col.Type = adWChar
col.Precision = lenlong
Else
col.Type = adWChar
col.Precision = ceilPow2(lenlong)
End If

fillColStringType = True
End Function

Function fillColNumberType(col As ADOX.Column, r As Range) As Boolean
Dim hasDecimal As Boolean
Dim t As Boolean

hasDecimal = False

On Error Resume Next
For Each c In r.Cells
If c.row > 1 Then
t = val(c.Text) <> Int(val(c.Text))
If Err.Number = 0 And t Then
hasDecimal = True
Exit For
End If
End If
Next
On Error GoTo 0

If hasDecimal Then
col.Type = adNumeric
col.Precision = 11
col.NumericScale = 4
Else
col.Type = adInteger
End If

fillColNumberType = True
End Function

Function ceilPow2(x As Integer)
Dim i As Integer
    i = 2
Do While i < x
i = i * 2
Loop

ceilPow2 = i
End Function


On Sat, Feb 7, 2015 at 9:29 PM, Vaibhav Joshi  wrote:

> Hi
>
> pl send code to test on, also what is your MS office version?
>
> On Thu, Feb 5, 2015 at 2:07 PM, Pravin Gunjal  wrote:
>
>> Hi
>>
>> I tried this one and un-ticked MISSING from libraries and tried to Save
>> As the file with existing.
>> Then it says: The file is already exists. Do you want to replace with
>> existing file?
>> When I click on Yes it again says: Unable to remove existing file..
>>
>> Kindly look in to this please.
>>
>> Thanks,
>> Pravin Gunjal.
>>
>>
>> On Tuesday, February 3, 2015 at 9:45:31 PM UTC+5:30, Paul Schreiner wrote:
>>
>>> That usually is a problem with "References".
>>>
>>> try these steps:
>>>
>>> Stop execution of macro
>>> in VB Editor, select Tools-> References...
>>>
>>> you'll find several libraries selected.
>>> But you might see one that says "Missing" (or something like that).
>>>
>>> The problem is that once the compiler hits this missing library, it
>>> stops looking at the others.
>>>
>>> The string manipulation functions like Left() and Right() are in one of
>>> the object libraries and are not being found.
>>>
>>> You won't need all of the ones I have but the references I have selected
>>> in Excel 2010 are:
>>>
>>> Visual Basic for Applications
>>> Microsoft Excel 14.0 Object Library
>>> OLE Automation
>>> Microsoft Office 14.0 Object Library
>>> Microsoft Word 14.0 Object Library
>>> Microsoft Forms 2.0 Object LIbrary
>>>
>>>
>>>
>>> *Paul*
>>> -
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> *"Do all the good you can,By all the means you can,In all the ways you
>>> can,In all the places you can,At all the times you can,To all the people
>>> you can,As long as ever you can." - John Wesley*
>>> -
>>>
>>>*From:* Pravin Gunjal 
>>> *To:* Excel Macros 
>>> *Sent:* Tuesday, February 3, 2015 8:33 AM
>>> *Subject:* $$Excel-Macros$$ Error on saving the DBF file in Excel 2007
>>>
>>> Hi
>>>
>>> I have downloaded the DBF save add-in but while saving got the attached
>>> error in VB.
>>> Could anyone please check and update me on this issue.
>>>
>>> Thank you
>>> Pravin Gunjal
>>> --
>>> 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.

Re: $$Excel-Macros$$ User name to be picked up in excel

[Pravin Gunjal]

Hi Mr Paul

The "user name" of excel to be come automatically in column L, once column 
K is entered by the user.

I have given few names in column L as an example, which can be removed..

Pl do the needful.

Regards
Pravin.

On Wednesday, February 11, 2015 at 6:00:14 PM UTC+5:30, Paul Schreiner 
wrote:
>
> Where do the names come from?
> what does the value in column "K" have to do with these names?
>  
> I see JKD lsted for case 48 and 12, so it evidently isn't some form of 
> unique index...
>  
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you 
> can,In all the places you can,At all the times you can,To all the people 
> you can,As long as ever you can.” - John Wesley*
> -
>
>*From:* Pravin Gunjal >
> *To:* Excel Macros >; Paul 
> Schreiner - Excel >; Vaibhav Joshi 
> (Vabz) - Mumbai Excel >; Ms-Exl-Learner - 
> Chennai > 
> *Sent:* Wednesday, February 11, 2015 6:24 AM
> *Subject:* $$Excel-Macros$$ User name to be picked up in excel
>  
> Hi,
>  
> The user name to be picked up by formula in the column *L* once the value 
> is entered in column *K*
>  
> I have entered few names manually.  Please help.
>  
>
> *Regards, Pravin Gunjal*
> -- 
> 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.

Re: $$Excel-Macros$$ User name to be picked up in excel

[Pravin Gunjal]

Thank you so much.
This is what I was looking for...

On Tue, Feb 17, 2015 at 10:31 AM, Mandeep Baluja 
wrote:

> check this worksheet event.
>
> regards,
> Mandeep
> On Monday, February 16, 2015 at 7:49:23 PM UTC+5:30, Pravin Gunjal wrote:
>>
>> Hi Mr Paul
>>
>> The "user name" of excel to be come automatically in column L, once
>> column K is entered by the user.
>>
>> I have given few names in column L as an example, which can be removed..
>>
>> Pl do the needful.
>>
>> Regards
>> Pravin.
>>
>> On Wednesday, February 11, 2015 at 6:00:14 PM UTC+5:30, Paul Schreiner
>> wrote:
>>>
>>> Where do the names come from?
>>> what does the value in column "K" have to do with these names?
>>>
>>> I see JKD lsted for case 48 and 12, so it evidently isn't some form of
>>> unique index...
>>>
>>> *Paul*
>>> -
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> *"Do all the good you can,By all the means you can,In all the ways you
>>> can,In all the places you can,At all the times you can,To all the people
>>> you can,As long as ever you can." - John Wesley*
>>> -
>>>
>>>*From:* Pravin Gunjal 
>>> *To:* Excel Macros ; Paul Schreiner - Excel
>>> ; Vaibhav Joshi (Vabz) - Mumbai Excel ;
>>> Ms-Exl-Learner - Chennai 
>>> *Sent:* Wednesday, February 11, 2015 6:24 AM
>>> *Subject:* $$Excel-Macros$$ User name to be picked up in excel
>>>
>>> Hi,
>>>
>>> The user name to be picked up by formula in the column *L* once the
>>> value is entered in column *K*
>>>
>>> I have entered few names manually.  Please help.
>>>
>>>
>>> *Regards, Pravin Gunjal*
>>> --
>>> 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 a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/-iFy4bw9BEQ/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@goo

$$Excel-Macros$$ Computer Login & Logout Time Record

[Pravin Gunjal]

*Hello Friends,*

*I need to have a file which may record the Login & Logout time of 
computer.  I am using Windows XP.*

*Thanks in anticipation.*

*Regards*
*Pravin Gunjal*

-- 
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$$ Computer Login & Logout Time Record

[Pravin Gunjal]

Thank you for your reply.

I have full access of my computer, there is no restriction of IT.

I will try for it.

On Wed, Feb 18, 2015 at 6:22 PM, Paul Schreiner 
wrote:

> Do you have admin privileges for the machine?
>
> Windows has "policies" that you can assign to a machine.
> These Policies can be used to create startup/exit scripts that write to
> log files.
>
> That's the "cleanest" way to handle it.
>
> There's also a way to query the Win32_NTLogEvent
>
> Then search through that log to find what you're looking for.
>
> I don't have any way to try this on an XP machine.
>
> try googling:
> SELECT * FROM Win32_NTLogEvent WHERE logfile =
>
> and see what you get.
>
>
> *Paul*
> -
>
>
>
>
>
>
>
> *"Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can." - John Wesley*
> -
>
>*From:* Pravin Gunjal 
> *To:* excel-macros@googlegroups.com
> *Sent:* Wednesday, February 18, 2015 7:21 AM
> *Subject:* $$Excel-Macros$$ Computer Login & Logout Time Record
>
> *Hello Friends,*
>
> *I need to have a file which may record the Login & Logout time of
> computer.  I am using Windows XP.*
>
> *Thanks in anticipation.*
>
> *Regards*
> *Pravin Gunjal*
>
> --
> 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 a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/1auoU5csZpk/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at 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 b

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

[Pravin Gunjal]

Hi Vabs
Any updates on this please.

Regards
Pravin Gunjal

On Wednesday, February 11, 2015 at 5:00:32 PM UTC+5:30, Pravin Gunjal wrote:
>
> Hi Vabs
>
> Following is the code:
>
> Function savedbf() As Boolean
> Dim filename As Variant
> Dim temp As Variant
> Dim currentFile As String
> Dim defaultFile As String
> 
> currentFile = ActiveWorkbook.Name
> temp = Split(currentFile, ".")
> temp(UBound(temp)) = "dbf"
> defaultFile = Join(temp, ".")
> If defaultFile = "dbf" Then
> defaultFile = ActiveWorkbook.Name & ".dbf"
> End If
> filename = Application.GetSaveAsFilename(InitialFileName:=defaultFile, 
> FileFilter:="DBF 4 (dBASE IV) (*.dbf),*.dbf", Title:="Save As DBF")
> 
> If filename = False Then Exit Function
> 
> savedbf = DoSaveDefault(filename)
> End Function
>
> Function DoSaveDefault(ByVal filename As String)
> ' Declare DB vars
> Dim path As Variant
> Dim file As Variant
> Dim tfile As Variant
> Dim table As Variant
> Dim dbConn As ADODB.Connection
> 
> ' Initialize DB vars
> path = Split(filename, "\")
> file = path(UBound(path))
> file = Replace(Left(file, Len(file) - 4), ".", "_") & Right(file, 4)
> tfile = "__T_DB__.dbf"
> path(UBound(path)) = ""
> path = Join(path, "\")
> table = Left(tfile, 8)
> filename = path & file
> 
> ' Check if file exists
> On Error Resume Next
> GetAttr filename
> If Err.Number = 0 Then
> Dim mbResult As VbMsgBoxResult
> mbResult = MsgBox("The file " & file & " already exists. Do you 
> want to replace the existing file?", _
> VbMsgBoxStyle.vbYesNo + VbMsgBoxStyle.vbExclamation, "File 
> Exists")
> If mbResult = vbNo Then
> DoSaveDefault = False
> Exit Function
> Else
> SetAttr filename, vbNormal
> Kill filename
> End If
> End If
> 
> Err.Number = 0
> 
> GetAttr filename
> If Err.Number = 0 Then
> MsgBox "Unable to remove existing file " & file & ".", 
> vbExclamation, "Error Removing File"
> DoSaveDefault = False
> Exit Function
> End If
> On Error GoTo 0
>
> ' Open DB connection
> Set dbConn = New ADODB.Connection
> dbConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path & 
> ";Extended Properties=""DBASE IV;"";"
> 
> ' Declare excel vars
> Dim dataRange As Range
> 
> Set dataRange = Selection
> 
> If dataRange.Areas.Count > 1 Then
> MsgBox "The command you chose cannot be performed with multiple 
> selections. Select a single range and click the command again.", _
> VbMsgBoxStyle.vbCritical, "Error Saving File"
> DoSaveDefault = False
> Exit Function
> End If
> 
> ' Expand selection if single cell (Expands selection using the Excel 
> 2003 save DBF behavior)
> 'If dataRange.Cells.Count = 1 Then
> 'If IsEmpty(dataRange.Cells(1).Value) Then
> 'MsgBox "The command could not be completed by using the range 
> specified. Select a single cell within the range and try the command 
> again.", _
> 'VbMsgBoxStyle.vbExclamation, "Error Saving File"
> 'DoSaveDefault = False
> 'Exit Function
> 'Else
> 'Set dataRange = dataRange.CurrentRegion
> 'End If
> 'End If
> 
> ' Expand selection if single cell (Differs from normal Excel 2003 
> behavior by not stopping at blank rows and columns)
> If dataRange.Cells.Count = 1 Then
> Dim row1 As Integer
> Dim rowN As Integer
> Dim col1 As Integer
> Dim colN As Integer
> Dim cellFirst As Range
> Dim cellLast As Range
> 
> row1 = ActiveSheet.Cells.Find(What:="*", SearchOrder:=xlByRows, 
> SearchDirection:=xlNext).row
> col1 = ActiveSheet.Cells.Find(What:="*", SearchOrder:=xlByColumns, 
> SearchDirection:=xlNext).Column
> rowN = ActiveSheet.Cells.Find(What:="*", After:=[A1], 
> SearchOrder:=xlByRows, SearchDirection:=xlPrevious).row
> colN = ActiveSheet.Cells.Find(What

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

[Pravin Gunjal]

Hi,

I tried working on it but could not do the same.  

Could you please explain me how to do it or is there any other solution for 
this.  Please do share.

Thank you

Regards
Pravin Gunjal


On Tuesday, February 3, 2015 at 9:45:31 PM UTC+5:30, Paul Schreiner wrote:
>
> That usually is a problem with "References".
>  
> try these steps:
>  
> Stop execution of macro
> in VB Editor, select Tools-> References...
>  
> you'll find several libraries selected.
> But you might see one that says "Missing" (or something like that).
>  
> The problem is that once the compiler hits this missing library, it stops 
> looking at the others.
>  
> The string manipulation functions like Left() and Right() are in one of 
> the object libraries and are not being found.
>  
> You won't need all of the ones I have but the references I have selected 
> in Excel 2010 are:
>  
> Visual Basic for Applications
> Microsoft Excel 14.0 Object Library
> OLE Automation
> Microsoft Office 14.0 Object Library
> Microsoft Word 14.0 Object Library
> Microsoft Forms 2.0 Object LIbrary
>  
>  
>  
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you 
> can,In all the places you can,At all the times you can,To all the people 
> you can,As long as ever you can.” - John Wesley*
> -
>
>*From:* Pravin Gunjal >
> *To:* Excel Macros > 
> *Sent:* Tuesday, February 3, 2015 8:33 AM
> *Subject:* $$Excel-Macros$$ Error on saving the DBF file in Excel 2007
>  
> Hi
>
> I have downloaded the DBF save add-in but while saving got the attached 
> error in VB.
> Could anyone please check and update me on this issue.
>
> Thank you
> Pravin Gunjal
> -- 
> 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.

$$Excel-Macros$$ Serial Number Must Come As Per Selected Alphabet in Previous Column

[Pravin Gunjal]

Hi, 

I have an excel format 2007 for daily data entry, as attached.

I used to select Party Names through drop down list in column F and need to 
type the invoice numbers in cloumn E based on the letter in column D.

Our invoice numbers start with C, D & F letters and it comes serially for 
different parties.

So for next party next serial number would come...as per the letter 
mentioned in column D

If I type any one these letters the next invoice number should come 
automatically in column E.

For example: In cell F8 there is a party viz. The Ichalkaranji Sales Corp - 
Ichalkaranji for which I i would like to give next C serial then I would 
type C in cell D8 and then then next number 1327 must come in E8 
automatically.

Hope you understand the requirement. Please do the need.

Thank you,

Pravin Gunjal.

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


Curatio Invoice Register 2014-15.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

[Pravin Gunjal]

Hello,
Can anyone help me to modify & save DBF files in Excel 2007.

Pravin.

On Saturday, March 14, 2015 at 1:01:39 PM UTC+5:30, Pravin Gunjal wrote:
>
> Hi,
>
> I tried working on it but could not do the same.  
>
> Could you please explain me how to do it or is there any other solution 
> for this.  Please do share.
>
> Thank you
>
> Regards
> Pravin Gunjal
>
>
> On Tuesday, February 3, 2015 at 9:45:31 PM UTC+5:30, Paul Schreiner wrote:
>>
>> That usually is a problem with "References".
>>  
>> try these steps:
>>  
>> Stop execution of macro
>> in VB Editor, select Tools-> References...
>>  
>> you'll find several libraries selected.
>> But you might see one that says "Missing" (or something like that).
>>  
>> The problem is that once the compiler hits this missing library, it stops 
>> looking at the others.
>>  
>> The string manipulation functions like Left() and Right() are in one of 
>> the object libraries and are not being found.
>>  
>> You won't need all of the ones I have but the references I have selected 
>> in Excel 2010 are:
>>  
>> Visual Basic for Applications
>> Microsoft Excel 14.0 Object Library
>> OLE Automation
>> Microsoft Office 14.0 Object Library
>> Microsoft Word 14.0 Object Library
>> Microsoft Forms 2.0 Object LIbrary
>>  
>>  
>>  
>> *Paul*
>> -
>>
>>
>>
>>
>>
>>
>>
>> *“Do all the good you can,By all the means you can,In all the ways you 
>> can,In all the places you can,At all the times you can,To all the people 
>> you can,As long as ever you can.” - John Wesley*
>> -
>>
>>*From:* Pravin Gunjal 
>> *To:* Excel Macros  
>> *Sent:* Tuesday, February 3, 2015 8:33 AM
>> *Subject:* $$Excel-Macros$$ Error on saving the DBF file in Excel 2007
>>  
>> Hi
>>
>> I have downloaded the DBF save add-in but while saving got the attached 
>> error in VB.
>> Could anyone please check and update me on this issue.
>>
>> Thank you
>> Pravin Gunjal
>> -- 
>> 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.

Re: $$Excel-Macros$$ Serial Number Must Come As Per Selected Alphabet in Previous Column

[Pravin Gunjal]

Hi Vabs

Thank you much.  It works good as required.

Pravin.

On Tue, Mar 17, 2015 at 1:51 PM, Vaibhav Joshi  wrote:

> Check this...
>
>
> Cheers!!
>
> On Tue, Mar 17, 2015 at 11:35 AM, Pravin Gunjal  wrote:
>
>> Hi,
>>
>> I have an excel format 2007 for daily data entry, as attached.
>>
>> I used to select Party Names through drop down list in column F and need
>> to type the invoice numbers in cloumn E based on the letter in column D.
>>
>> Our invoice numbers start with C, D & F letters and it comes serially for
>> different parties.
>>
>> So for next party next serial number would come...as per the letter
>> mentioned in column D
>>
>> If I type any one these letters the next invoice number should come
>> automatically in column E.
>>
>> For example: In cell F8 there is a party viz. The Ichalkaranji Sales Corp
>> - Ichalkaranji for which I i would like to give next C serial then I would
>> type C in cell D8 and then then next number 1327 must come in E8
>> automatically.
>>
>> Hope you understand the requirement. Please do the need.
>>
>> Thank you,
>>
>> Pravin Gunjal.
>>
>>  --
>> 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 a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/5kQW1VKHk_I/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at 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 allow

$$Excel-Macros$$ MSG: Code execution has been interrupted

[Pravin Gunjal]

Hi,

I am getting an above mentioned error message while running any macro on my 
computer, while the same macro could run in other computer.

Could you please help me out on this.  Thanks,

Regards
Pravin Gunjal.

-- 
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$$ Error While Running Any Macro - Code execution has been interrupted

[Pravin Gunjal]

Hi, Can anyone help me on this subject?

On Saturday, September 19, 2015 at 1:45:12 PM UTC+5:30, Pravin Gunjal wrote:
>
> Hi,
>
> I am getting an above mentioned error message while running any macro on 
> my computer, while the same macro could run in other computer.
>
> Could you please help me out on this.  Thanks,
>
> Regards
> Pravin Gunjal.
>

-- 
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$$ Error While Running Any Macro - Code execution has been interrupted

[Pravin Gunjal]

Thanks but it doesn't work
Application.EnableCancelKey = xlDisabled

On Sat, Sep 19, 2015 at 3:08 PM, Abhishek Jain 
wrote:

> See if this helps -
>
>
> http://www.maheshsubramaniya.com/article/fix-for-code-execution-has-been-interrupted-in-excel-vba-macros.html
>
> On Sat, Sep 19, 2015 at 3:04 PM, Pravin Gunjal  wrote:
>
>> Hi, Can anyone help me on this subject?
>>
>> On Saturday, September 19, 2015 at 1:45:12 PM UTC+5:30, Pravin Gunjal
>> wrote:
>>>
>>> Hi,
>>>
>>> I am getting an above mentioned error message while running any macro on
>>> my computer, while the same macro could run in other computer.
>>>
>>> Could you please help me out on this.  Thanks,
>>>
>>> Regards
>>> Pravin Gunjal.
>>>
>> --
>> 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 a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/UpMP7qsXOEQ/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at 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.

$$Excel-Macros$$ Getting Run time error for macro

[Pravin Gunjal]

Hi, 

Greetings,

I have used a simple macro in an attached file

But while pasting or deleting the data in multiple cells, getting following 
error:

Run-time error '13':
Type mismatch

Kindly help me out on this. Thank you,

Regards
Pravin Gunjal

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


Test Outward 2015-16.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

$$Excel-Macros$$ Getting Run time error for macro

[Pravin Gunjal]

Hi,

Greetings,

I have used a simple macro in an attached file

But while pasting or deleting the data in multiple cells, getting following
error:

Run-time error '13':
Type mismatch

Kindly help me out on this. Thank you,

Regards
Pravin Gunjal

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


Test Outward 2015-16.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

Re: $$Excel-Macros$$ Re: Getting Run time error for macro

[Pravin Gunjal]

Dear Mandeep
Thank you so much.. it works fantastic.

Can you tell me one more thing, how to modify the vba code in all sheets...

Regards,
Pravin Gunjal.
On Oct 20, 2015 2:47 PM, "Mandeep Baluja"  wrote:

> check this out !!
>
>
>
>
> Private Sub Worksheet_Change(ByVal Target As Excel.Range)
>
> If Not Application.Intersect(Target, Range("n4:n100")) Is Nothing Then
> For Each cell In Target
> If cell.Value <> "" Then
> cell.Offset(0, 1).Value = Application.UserName
> End If
> Next
> End If
>
> End Sub
>
> Regards,
> Mandeep baluja
> https://www.facebook.com/groups/825221420889809/
>
>
>
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/IAYAJFr4fQ8/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at 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: Getting Run time error for macro

[Pravin Gunjal]

Can anyone help me on this issue plz.
On Oct 21, 2015 3:26 PM, "Pravin Gunjal"  wrote:

> Hi Mandeep
>
> The code you have replaced in this mail​ has to be replaced in other
> sheets also of the same file.. file is attached for your immediate
> reference.
>
> Pl help me out on this.
>
> Thanks,
> Pravin Gunjal.
>
> On Oct 20, 2015 4:35 PM, "Mandeep Baluja" <
> ​​
> ​​
> rockerna...@gmail.com> wrote:
>
>> Hi Praveen,
>>
>> Welcome,I am sorry but Please elaborate your query Modify in what sense
>> and for all sheets means you have the same code in all sheets what kind of
>> modification you're looking for whether it is automated or it is manual.
>>
>> Regards,
>> Mandeep Baluja
>>
>>
>>
>> On Tuesday, October 20, 2015 at 4:20:14 PM UTC+5:30, Pravin Gunjal wrote:
>>>
>>> Dear Mandeep
>>> Thank you so much.. it works fantastic.
>>>
>>> Can you tell me one more thing, how to modify the vba code in all
>>> sheets...
>>>
>>> Regards,
>>> Pravin Gunjal.
>>> On Oct 20, 2015 2:47 PM, "Mandeep Baluja"  wrote:
>>>
>>>> check this out !!
>>>>
>>>>
>>>>
>>>>
>>>> Private Sub Worksheet_Change(ByVal Target As Excel.Range)
>>>>
>>>> If Not Application.Intersect(Target, Range("n4:n100")) Is Nothing
>>>> Then
>>>> For Each cell In Target
>>>> If cell.Value <> "" Then
>>>> cell.Offset(0, 1).Value = Application.UserName
>>>> End If
>>>> Next
>>>> End If
>>>>
>>>> End Sub
>>>>
>>>> Regards,
>>>> Mandeep baluja
>>>> https://www.facebook.com/groups/825221420889809/
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to a topic in the
>>>> Google Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this topic, visit
>>>> https://groups.google.com/d/topic/excel-macros/IAYAJFr4fQ8/unsubscribe.
>>>> To unsubscribe from this group and all its topics, 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 recei

$$Excel-Macros$$ How to replace a macro in all sheets

[Pravin Gunjal]

Hi Friend
pl help me out to replace a macro in all sheets of the same file. Or any
other solution may welcome.
Thanks
Pravin Gunjal
On Oct 22, 2015 1:09 PM, "Pravin Gunjal"  wrote:

> Can anyone help me on this issue plz.
> On Oct 21, 2015 3:26 PM, "Pravin Gunjal"  wrote:
>
>> Hi Mandeep
>>
>> The code you have replaced in this mail​ has to be replaced in other
>> sheets also of the same file.. file is attached for your immediate
>> reference.
>>
>> Pl help me out on this.
>>
>> Thanks,
>> Pravin Gunjal.
>>
>> On Oct 20, 2015 4:35 PM, "Mandeep Baluja" <
>> ​​
>> ​​
>> rockerna...@gmail.com> wrote:
>>
>>> Hi Praveen,
>>>
>>> Welcome,I am sorry but Please elaborate your query Modify in what sense
>>> and for all sheets means you have the same code in all sheets what kind of
>>> modification you're looking for whether it is automated or it is manual.
>>>
>>> Regards,
>>> Mandeep Baluja
>>>
>>>
>>>
>>> On Tuesday, October 20, 2015 at 4:20:14 PM UTC+5:30, Pravin Gunjal wrote:
>>>>
>>>> Dear Mandeep
>>>> Thank you so much.. it works fantastic.
>>>>
>>>> Can you tell me one more thing, how to modify the vba code in all
>>>> sheets...
>>>>
>>>> Regards,
>>>> Pravin Gunjal.
>>>> On Oct 20, 2015 2:47 PM, "Mandeep Baluja"  wrote:
>>>>
>>>>> check this out !!
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Private Sub Worksheet_Change(ByVal Target As Excel.Range)
>>>>>
>>>>> If Not Application.Intersect(Target, Range("n4:n100")) Is Nothing
>>>>> Then
>>>>> For Each cell In Target
>>>>> If cell.Value <> "" Then
>>>>> cell.Offset(0, 1).Value = Application.UserName
>>>>> End If
>>>>> Next
>>>>> End If
>>>>>
>>>>> End Sub
>>>>>
>>>>> Regards,
>>>>> Mandeep baluja
>>>>> https://www.facebook.com/groups/825221420889809/
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>>> https://www.facebook.com/discussexcel
>>>>>
>>>>> FORUM RULES
>>>>>
>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>> Advice will not get quick attention or may not be answered.
>>>>> 2) Don't post a question in the thread of another member.
>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>> measure.
>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>> 5) Jobs posting is not allowed.
>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>
>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>>> and members are not responsible for any loss.
>>>>> ---
>>>>> You received this message because you are subscribed to a topic in the
>>>>> Google Groups "MS EXCEL AND VBA MACROS" group.
>>>>> To unsubscribe from this topic, visit
>>>>> https://groups.google.com/d/topic/excel-macros/IAYAJFr4fQ8/unsubscribe
>>>>> .
>>>>> To unsubscribe from this group and all its topics, 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

$$Excel-Macros$$ VBA Code Error in all files

[Pravin Gunjal]

Hi

Greetings!

Getting an attached error while opening files of VBA.
Kindly help me to resolve the same.

Regards
Pravin Gunjal

-- 
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$$ VBA to pick up current date in last column

[Pravin Gunjal]

Dear Friends

I have attached an excel file in which I have used macro to get "Created
by" field automatically once the values are entered in column N (Qty).
Likewise I want the last column (Entry Date) to be updated as current date,
as and when the column N gets entered.
I have made one manual entry in row no. 7.
Could you please help me out to fulfil the requirement.

Thank you,

Regards
Pravin Gunjal

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


Test Outward 2015-16.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

$$Excel-Macros$$ Fwd: VBA to pick up current date in last column

[Pravin Gunjal]

Hi Friend
could you plz helm me out on the issue.
Thanks in advance.

Regards
Pravin Gunjal
-- Forwarded message --
From: "Pravin Gunjal" 
Date: Oct 26, 2015 4:02 PM
Subject: VBA to pick up current date in last column
To: "Excel Macros" , "Mandeep Baluja" <
rockerna...@gmail.com>, "Vaibhav Joshi (Vabz) - Mumbai Excel" 
Cc:

Dear Friends

I have attached an excel file in which I have used macro to get "Created
by" field automatically once the values are entered in column N (Qty).
Likewise I want the last column (Entry Date) to be updated as current date,
as and when the column N gets entered.
I have made one manual entry in row no. 7.
Could you please help me out to fulfil the requirement.

Thank you,

Regards
Pravin Gunjal

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


Test Outward 2015-16.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

$$Excel-Macros$$ Remove all existing macros on certain date

[Pravin Gunjal]

Hi Expert,

Can i get a macro which can remove all existing macros from a file on certain 
date..

Kindly share the same. Thanks. 

Regards 
Pravin Gunjal 

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Remove all existing macros on certain date

[Pravin Gunjal]

Hi any update on this plz.
On Dec 23, 2015 7:45 PM, "Pravin Gunjal"  wrote:

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Remove all existing macros on certain date

[Pravin Gunjal]

Yes exactly. On specific date.
On Dec 24, 2015 3:53 PM, "jayaraj metta"  wrote:

> Hello Pravin Gunjal,
> Do you want to delete modules in a project using a macro?
> Can you please elaborate it ?
> On Dec 23, 2015 7:45 PM, "Pravin Gunjal"  wrote:
>
>> Hi Expert,
>>
>> Can i get a macro which can remove all existing macros from a file on
>> certain date..
>>
>> Kindly share the same. Thanks.
>>
>> Regards
>> Pravin Gunjal
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/P7sdDZpHNY8/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Remove all existing macros on certain date

[Pravin Gunjal]

Thanks but where is the date
On Dec 24, 2015 3:59 PM, "jayaraj metta"  wrote:

> If you want to delete the module then use below code
> 'Author #Jayaraju Metta
> Sub vbcomponents()
> Dim vbcom as Object
> Set vbcom=application.VBE.activeVBProject.Vbcomponents
> vbcom.remove Vbcomponent:=_
> vbcom.item("Module1")
> End sub
>
> If you find any difficulties please let me know
> On Dec 23, 2015 7:45 PM, "Pravin Gunjal"  wrote:
>
>> Hi Expert,
>>
>> Can i get a macro which can remove all existing macros from a file on
>> certain date..
>>
>> Kindly share the same. Thanks.
>>
>> Regards
>> Pravin Gunjal
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/P7sdDZpHNY8/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Remove all existing macros on certain date

[Pravin Gunjal]

Hi
I have some macro in file and suppose i want to remove them after 4 days.
So is there any such macro available which can work on my requirements.

Thanks
Pravin Gunjal.
On Dec 24, 2015 5:53 PM, "jayaraj metta"  wrote:

> "Existing macro on certain Date"
>
> Can you please elaborate above line with some live example. Share some
> files with the same
> On Dec 23, 2015 7:45 PM, "Pravin Gunjal"  wrote:
>
>> Hi Expert,
>>
>> Can i get a macro which can remove all existing macros from a file on
>> certain date..
>>
>> Kindly share the same. Thanks.
>>
>> Regards
>> Pravin Gunjal
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/P7sdDZpHNY8/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

$$Excel-Macros$$ Sharing Problem on Network Computers

[Pravin Gunjal]

Dear Friends,

I am sharing one different issue with you colleagues, which is other than
excel. I hope you will help me in this.

I have 3-4 computers in my office and all are connected to the same network
and workgroup. All the computers have access of others except one.

My system can see other computers & access, but other can't access mine
though it is shared.  Kindly help. Thanks,

Following is the screenshot:


​
*With regards,*

*Pravin Gunjal*
*Mobile: 77100 *
*97250*

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

FORUM RULES

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

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

$$Excel-Macros$$ Get Value If Criteria Matched

[Pravin Gunjal]

Hi,



Greetings!



I want the data in *column E (Sr.No.)* of sheet1 from sheet2, if column B,
C & D are matches in both sheets. PFA file.



Look forward for good formula. Thanks,



Regards,

*Pravin Gunjal*

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

FORUM RULES

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

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


Creteria Matches.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

Re: $$Excel-Macros$$ Get Value If Criteria Matched

[Pravin Gunjal]

Thank you sir..

On Tuesday, April 5, 2016 at 5:47:14 PM UTC+5:30, Paul Schreiner wrote:
>
> If you're wanting an Excel Function solution:
>
> In Sheet2, I'd create a "helper" column (A)
> and concatenate the Customer Name, Code and Material columns.
> Then, in Sheet1, Cell E2, use:
> =IF(COUNTIF(Sheet2!A:A,A2&"_"&B2&"_"&C2)=0,"NO Matches",
> IF(COUNTIF(Sheet2!A:A,A2&"_"&B2&"_"&C2)>1,"Duplicate Records",
> VLOOKUP(A2&"_"&B2&"_"&C2,Sheet2!A:F,6,FALSE)))
>
> and copy down
>
> If you want a VBA solution, I'd use:
> Option Explicit
> Sub Lookup_ABC()
> Dim Dict_Data
> Dim NumRows, NumRow
> Dim RecID
> 
> 
> Set Dict_Data = CreateObject("Scripting.Dictionary")
> Dict_Data.RemoveAll
> 
> 
> '
> 'Load Data Dictionary
> 
> '
> NumRows = 
> Application.WorksheetFunction.CountA(Sheets("Sheet2").Range("A:A"))
> 
> For NumRow = 2 To NumRows
> RecID = Sheets("Sheet2").Cells(NumRow, "A").Value
> RecID = RecID & "_" & Sheets("Sheet2").Cells(NumRow, "B").Value
> RecID = RecID & "_" & Sheets("Sheet2").Cells(NumRow, "C").Value
> 
> If (Not Dict_Data.exists(RecID)) Then
> Dict_Data.Add RecID, Sheets("Sheet2").Cells(NumRow, 
> "E").Value
> Else
> Dict_Data.Item(RecID) = Dict_Data.Item(RecID) & ", " & 
> Sheets("Sheet2").Cells(NumRow, "E").Value
> End If
> 
> Next NumRow
> 
> '
> ' Read from Data Dictionary
> 
> '
> NumRows = 
> Application.WorksheetFunction.CountA(Sheets("Sheet1").Range("A:A"))
> 
> On Error Resume Next
> For NumRow = 2 To NumRows
> RecID = Sheets("Sheet1").Cells(NumRow, "A").Value
> RecID = RecID & "_" & Sheets("Sheet1").Cells(NumRow, "B").Value
> RecID = RecID & "_" & Sheets("Sheet1").Cells(NumRow, "C").Value
> 
> If (Dict_Data.exists(RecID)) Then
> Sheets("Sheet1").Cells(NumRow, "E").Value = 
> Dict_Data.Item(RecID)
> Else
> Sheets("Sheet1").Cells(NumRow, "E").Value = "No Match Found"
> End If
> 
> Next NumRow
> End Sub
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you 
> can,In all the places you can,At all the times you can,To all the people 
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Tuesday, April 5, 2016 6:08 AM, Pravin Gunjal  > wrote:
>
>
>
> Hi, 
>  
> Greetings!
>  
> I want the data in *column E (Sr.No.)* of sheet1 from sheet2, if column 
> B, C & D are matches in both sheets. PFA file.
>  
> Look forward for good formula. Thanks,
>  
> Regards,
> *Pravin Gunjal*
>  
> -- 
> 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

Re: $$Excel-Macros$$ Problem in Pivot Table

[Pravin Gunjal]

Not relevant..


*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*




On Mon, Apr 25, 2016 at 12:41 PM, Satendra kumar 
wrote:

> Hi,
>
> you can check name spelling or space.
>
> thanks
> satendra
>
> On Mon, Apr 25, 2016 at 12:32 PM, Pravin Gunjal  wrote:
>
>> Hi Friends,
>>
>> I got an error while arranging the data in pivot table.
>>
>> The list has only 34 names common in Data Sheet while when I click on Row
>> Lable Filter in Pivot Sheet it shows many names and while selection on them
>> nothing is getting displayed. For Example: "DR . ABHIJEET PATAK"
>>
>> Can you please let me know how is it happening? File attached.
>>
>> Thanks in anticipation.
>>
>> Regards
>> Pravin Gunjal
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Thanks & Regards
> Satendra Kumar
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/ZmIyRfDocaM/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Problem in Pivot Table

[Pravin Gunjal]

Perfect... Thanks!


*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*




On Mon, Apr 25, 2016 at 1:17 PM, Abhishek Jain 
wrote:

> Try this:
>
>1. Right-click a cell in the pivot table
>2. Click on PivotTable options
>3. Click on the Data tab
>4. In the Retain Items section, select None from the drop down list.
>5. Click OK, then refresh the pivot table.
>
>
> On Mon, Apr 25, 2016 at 12:54 PM, Pravin Gunjal  wrote:
>
>> Not relevant..
>>
>>
>> *With regards,**Pravin Gunjal*
>> *Mobile: 77100 *
>> *97250*
>>
>>
>>
>>
>> On Mon, Apr 25, 2016 at 12:41 PM, Satendra kumar <
>> satendrakuma...@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> you can check name spelling or space.
>>>
>>> thanks
>>> satendra
>>>
>>> On Mon, Apr 25, 2016 at 12:32 PM, Pravin Gunjal 
>>> wrote:
>>>
>>>> Hi Friends,
>>>>
>>>> I got an error while arranging the data in pivot table.
>>>>
>>>> The list has only 34 names common in Data Sheet while when I click on
>>>> Row Lable Filter in Pivot Sheet it shows many names and while selection on
>>>> them nothing is getting displayed. For Example: "DR . ABHIJEET PATAK"
>>>>
>>>> Can you please let me know how is it happening? File attached.
>>>>
>>>> Thanks in anticipation.
>>>>
>>>> Regards
>>>> Pravin Gunjal
>>>>
>>>> --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> Visit this group at https://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>>
>>>
>>> --
>>> Thanks & Regards
>>> Satendra Kumar
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to a topic in the
>>> Google Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/excel-macros/ZmIyRfDocaM/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> excel-macros+unsubs

$$Excel-Macros$$ Screenshot in different designs

[Pravin Gunjal]

Dear Friends,

This is apart from excel knowledge, I would like to know to how to take 
such different designs screenshots:

Attached one example.

Please confirm. Thanks,

Regards
Pravin Gunjal

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Screenshot in different designs

[Pravin Gunjal]

Thanks..

On Wednesday, April 27, 2016 at 12:50:04 PM UTC+5:30, Abhi wrote:
>
> Try searching for something like "screen capture with effects"
>
> BTW, the TNT Screen Capture tool has paper-tear effects like the one in 
> your example.
>
>
>
> On Wed, Apr 27, 2016 at 12:31 PM, Pravin Gunjal  > wrote:
>
>> Dear Friends,
>>
>> This is apart from excel knowledge, I would like to know to how to take 
>> such different designs screenshots:
>>
>> Attached one example.
>>
>> Please confirm. Thanks,
>>
>> Regards
>> Pravin Gunjal
>>
>> -- 
>> 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 https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

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

FORUM RULES

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

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

$$Excel-Macros$$ Remove all macros from all the excel files on a computer

[Pravin Gunjal]

Hi, Good Evening

I would like to know whether is there any provision to remove all macros 
from all the excel files on a computer?
Kindly share your inputs. Thank you,

Regards
Pravin Gunjal

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Remove all macros from all the excel files on a computer

[Pravin Gunjal]

Thanks Mr.Abhishek but it's not helpful. Is there any file or something
else by opening that all the macros from all excel files will be removed
once in all.

Pravin.


*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*




On Mon, May 2, 2016 at 6:07 PM, Abhishek Jain 
wrote:

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

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Remove all macros from all the excel files on a computer

[Pravin Gunjal]

Thanks but I want to remove macros not only from a workbook but also from
all the excel files available in that computer.


*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*




On Tue, May 3, 2016 at 10:57 AM, Abhishek Jain 
wrote:

> http://excelribbon.tips.net/T010656_Removing_All_Macros.html
>
> On Tue, May 3, 2016 at 10:18 AM, Pravin Gunjal  wrote:
>
>> Thanks Mr.Abhishek but it's not helpful. Is there any file or something
>> else by opening that all the macros from all excel files will be removed
>> once in all.
>>
>> Pravin.
>>
>>
>> *With regards,**Pravin Gunjal*
>> *Mobile: 77100 *
>> *97250*
>>
>>
>>
>>
>> On Mon, May 2, 2016 at 6:07 PM, Abhishek Jain 
>> wrote:
>>
>>>
>>> http://www.mrexcel.com/forum/excel-questions/518757-delete-all-macros-workbook.html
>>>
>>> On Mon, May 2, 2016 at 5:41 PM, Pravin Gunjal  wrote:
>>>
>>>> Hi, Good Evening
>>>>
>>>> I would like to know whether is there any provision to remove all
>>>> macros from all the excel files on a computer?
>>>> Kindly share your inputs. Thank you,
>>>>
>>>> Regards
>>>> Pravin Gunjal
>>>>
>>>> --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> Visit this group at https://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to a topic in the
>>> Google Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/excel-macros/MR-2pXEbak0/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>> 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 offic

Re: $$Excel-Macros$$ Remove all macros from all the excel files on a computer

[Pravin Gunjal]

Thanks.


*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*




On Mon, May 9, 2016 at 8:05 PM, Paul Schreiner 
wrote:

> The only way I can think of immediately is to use Excel 2010 or 2013 and
> have a macro that opens all excel files on a computer and  saves the file
> in .xlsx format.
> You can turn off prompts by using Application.DisplayAlerts = false
>
> Your macro should also disable automatic macros when opening the files.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> ---------
>
>
> On Tuesday, May 3, 2016 1:48 AM, Pravin Gunjal  wrote:
>
>
>
> Thanks but I want to remove macros not only from a workbook but also from
> all the excel files available in that computer.
>
>
> *With regards,**Pravin Gunjal*
> *Mobile: 77100 *
> *97250*
>
>
> On Tue, May 3, 2016 at 10:57 AM, Abhishek Jain 
> wrote:
>
> http://excelribbon.tips.net/T010656_Removing_All_Macros.html
>
> On Tue, May 3, 2016 at 10:18 AM, Pravin Gunjal  wrote:
>
> Thanks Mr.Abhishek but it's not helpful. Is there any file or something
> else by opening that all the macros from all excel files will be removed
> once in all.
>
> Pravin.
>
>
> *With regards,**Pravin Gunjal*
> *Mobile: 77100 *
> *97250*
>
>
> On Mon, May 2, 2016 at 6:07 PM, Abhishek Jain 
> wrote:
>
>
> http://www.mrexcel.com/forum/excel-questions/518757-delete-all-macros-workbook.html
>
> On Mon, May 2, 2016 at 5:41 PM, Pravin Gunjal  wrote:
>
> Hi, Good Evening
>
> I would like to know whether is there any provision to remove all macros
> from all the excel files on a computer?
> Kindly share your inputs. Thank you,
>
> Regards
> Pravin Gunjal
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/MR-2pXEbak0/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> 

Re: $$Excel-Macros$$ Hyperlink for multiple sheets

[Pravin Gunjal]

Thanks Abhishek..


*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*




On Fri, May 13, 2016 at 3:15 PM, Abhishek Jain 
wrote:

>
> http://www.get-digital-help.com/2012/07/18/create-links-to-all-sheets-in-a-workbook/
>
> On Fri, May 13, 2016 at 3:06 PM, Pravin Gunjal  wrote:
>
>> Hi Friends,
>>
>> I have 48 sheets in a file and have one summary sheet in the beginning of
>> the same file.
>>
>>
>>
>> I would like to use hyperlink in summary sheet to open other sheets
>> respectively. I have made it for first sheet.
>>
>> Can you suggest/guide me how to do this activity in single shot.
>>
>>
>> Please find attached file for the same.
>>
>> Regards
>> Pravin Gunjal.
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/GJZyb_1ebWo/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Excel is showing different data on other sharing computer

[Pravin Gunjal]

Hi Experts,

May I have any solution on this subject please.
On 30 May 2016 16:55, "Pravin Gunjal"  wrote:

> Dear Friend,
>
> Greetings!
>
> I have 3-4 computers in shared network. In one of them there is an excel
> file which contains data with 184 rows and 19 columns. If I open this file
> in the origin computer it shows data up to 184 rows but when I open the
> same file with other shared computer it shows only up to 173 rows.
>
> I have attached both the screen shorts for your immediate reference.
> Kindly help. Thanks,
>
> Regards,
> Pravin Gunjal.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/cLtZLYtA2Yk/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: Excel is showing different data on other sharing computer

[Pravin Gunjal]

Thanks for reply. The path and file is unique. One sheet was hidden at the
time of screenshot taken on other computer.


*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*




On Wed, Jun 8, 2016 at 5:14 PM, B Sharma  wrote:

> Hiii Pravin,,
> From your screen shot I think that both the files are at different
> location...
> Please check that in the first first there is only one sheet, and in the
> another file there are 2 sheets (one new with name "Master")
>
> Please carefully check the path of the file which you open in the shared
> computer, because I doubt that it could be the previously saved file /
> older version of that file which you have saved..
>
> Please let us know about this ...
>
> Thanks & Regards,
> Bajrang sharma
>
>
> On Monday, May 30, 2016 at 4:55:18 PM UTC+5:30, Pravin Gunjal wrote:
>>
>> Dear Friend,
>>
>> Greetings!
>>
>> I have 3-4 computers in shared network. In one of them there is an excel
>> file which contains data with 184 rows and 19 columns. If I open this file
>> in the origin computer it shows data up to 184 rows but when I open the
>> same file with other shared computer it shows only up to 173 rows.
>>
>> I have attached both the screen shorts for your immediate reference.
>> Kindly help. Thanks,
>>
>> Regards,
>> Pravin Gunjal.
>>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/cLtZLYtA2Yk/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

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

FORUM RULES

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

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

$$Excel-Macros$$ Fwd: Unable to increase the rows anywhere in excel file - please help

[Pravin Gunjal]

*With regards,

**Pravin Gunjal**
**Mobile: **83418 89718**
E-Mail: **isk1...@gmail.com*

*  *




-- Forwarded message --
From: Pravin Gunjal 
Date: Thu, Aug 9, 2012 at 12:04 PM
Subject: Unable to increase the rows anywhere in excel file - please help
To: excel-macros@googlegroups.com


Dear Sir,



I am unable to increase the rows in the attached file, and the system is
giving the following error.



Error : Cannot shift objects off sheet.



Kindly help me out on this issue please.  The file is attached for your
reference.


*With regards,

Pravin Gunjal*

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

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

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

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




Test working.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Cell show blank but in it show formula

[Pravin Gunjal]

Dear Amar

You may use the same formula

=IFERROR(INDEX(INDIRECT($D$2),C10),"")

*With regards,

**Pravin Gunjal**
*


On Thu, Aug 16, 2012 at 5:18 PM, amar takale  wrote:

> Thanks to all very much.One question ask to all there are custom
> formatting then error will disappear in cell?Is it right? I used index
> formula in my sheet but it show reference.
> I attached sheet here Pl see all.
>
> On Thu, Aug 16, 2012 at 4:17 PM, Kuldeep Singh wrote:
>
>>
>> You're Great Noorain Sir.
>>
>> Regards,
>> Kuldeep Singh
>> Phone.: +91-120-4763789, Extn.: 789
>> naukrikuld...@gmail.com || www.naukri.com
>> *Please* *Consider the environment. Please don't print this e-mail
>> unless you really need to.*
>>
>> On Thu, Aug 16, 2012 at 4:12 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Amar,
>>>
>>> In case of 2003 Version
>>> You can also use..
>>>
>>> =IF(ISERROR(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))
>>> Or
>>>
>>> =IF(ISNA(VLOOKUP(F5,$B$4:$D$9,3,0)),"",VLOOKUP(F5,$B$4:$D$9,3,0))
>>>
>>>
>>>
>>> On Thu, Aug 16, 2012 at 3:39 PM, amar takale wrote:
>>>
>>>>
>>>>  --
>>>> Join official facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES (1120+ members already BANNED for violation)
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>>
>>>> 2) Don't post a question in the thread of another member.
>>>>
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>>
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>
>>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>>> signatures are prohibited.
>>>>
>>>> 6) Jobs posting is not allowed.
>>>>
>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> To unsubscribe from this group, send email to
>>>> excel-macros+unsubscr...@googlegroups.com.
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>> --
>>> With Regards,
>>> Noorain Ansari
>>> http:// 
>>> <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com>
>>> http:// 
>>> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com><http://accesssqclinic.blogspot.in/>
>>>
>>>
>>>  --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@goog

$$Excel-Macros$$ How the excel searching the data in it

[Pravin Gunjal]

*Can anyone inform me how it works..  Thanks!*
* *

 *With regards,
**Pravin Gunjal**
*

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

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

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

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




Customer Search CF.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ conditional formatting

[Pravin Gunjal]

*Hi Smitha*
*
*
*Pl try this...*
* *

 *With regards,
**Pravin Gunjal**
*

*
*
-- Forwarded message --
From: Smitha S R 
Date: Mon, Aug 20, 2012 at 4:59 PM
Subject: Re: $$Excel-Macros$$ conditional formatting
To: excel-macros@googlegroups.com


The colour should be filled in the whole row, not only in the cell.
The way suggested fill the colour in the cell only.

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

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

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

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




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