Re: $$Excel-Macros$$ Formula to Calculate Age in Excel
Hi Rakesh, follow below link: http://www.cpearson.com/excel/datedif.aspx Regards Anoop On Fri, Dec 7, 2012 at 12:12 PM, Rakesh Kumar Sharma wrote: > Dear Team, > > Can you help me how to calculate age ( in Year, month & day) in Excel > > -- > Regards, > > Rakesh Kumar Sharma > Contact: +91-9971024741 > > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Regards, Anoop Sr. Developer -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Conditional Formatting
Use the following one =IF(B2>$A$2,"↓",IF(B2<$A$2,"↑","↕")) On Fri, Dec 7, 2012 at 12:37 PM, amar takale wrote: > Hi Annop, > > Good Solution.But If there are Constant number both cell then I want > Neutral arrow,can it possible? > Regards Amar > > > On Wed, Dec 5, 2012 at 11:35 AM, Anoop K Sharma wrote: > >> Please find attached. I hope this can help you. >> >> Regards, >> Anoop >> Sr. Developer >> >> >> On Wed, Dec 5, 2012 at 12:54 AM, JP wrote: >> >>> Hi - >>> >>> I have a spreadsheet in which I have the following formula for >>> statistical testing, =IF(L7>=$S$2,CHAR(233),IF(L7<=-$S$2,CHAR(234),"")). It >>> displays an up arrow if the first IF statement is true and an down arrow if >>> the second IF statement is true. I would like the arrow displayed to be >>> bolded and if it is an up arrow then it should be in green font and if the >>> arrow is downward then it should be in red font. How would I add the color >>> code to the existing formula so the arrows are displayed in color? >>> >>> Thanks, >>> JP >>> >>> -- >>> Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> To unsubscribe from this group, send email to >>> excel-macros+unsubscr...@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >>> >>> >>> >> >> >> >> -- >> Regards, >> Anoop >> Sr. Developer >> >> -- >> Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >> > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Regards, Anoop Sr. Developer -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is n
Re: $$Excel-Macros$$ Formula to Calculate Age in Excel
Hi, if the date is (D111) - 12/20/1991, then for no. year : =DATEDIF(D111,TODAY(),"y") = 20 for no. of month : =DATEDIF(D111,TODAY(),"m") = 251 for no. of days : =DATEDIF(D111,TODAY(),"d") = 7658 --- and if you want link 20 years, some month and some days then - just chnage the text as - for count of year- =DATEDIF(D111,TODAY(),"y") = 20 days for count of month- =DATEDIF(D111,TODAY(),"ym") = 11 months for count of days = =DATEDIF(D111,TODAY(),"md") = 17 days -- deba Thanks & Regards, *Deba ranjan* On Fri, Dec 7, 2012 at 12:12 PM, Rakesh Kumar Sharma wrote: > Dear Team, > > Can you help me how to calculate age ( in Year, month & day) in Excel > > -- > Regards, > > Rakesh Kumar Sharma > Contact: +91-9971024741 > > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Conditional Formatting
Hi Annop, Good Solution.But If there are Constant number both cell then I want Neutral arrow,can it possible? Regards Amar On Wed, Dec 5, 2012 at 11:35 AM, Anoop K Sharma wrote: > Please find attached. I hope this can help you. > > Regards, > Anoop > Sr. Developer > > > On Wed, Dec 5, 2012 at 12:54 AM, JP wrote: > >> Hi - >> >> I have a spreadsheet in which I have the following formula for >> statistical testing, =IF(L7>=$S$2,CHAR(233),IF(L7<=-$S$2,CHAR(234),"")). It >> displays an up arrow if the first IF statement is true and an down arrow if >> the second IF statement is true. I would like the arrow displayed to be >> bolded and if it is an up arrow then it should be in green font and if the >> arrow is downward then it should be in red font. How would I add the color >> code to the existing formula so the arrows are displayed in color? >> >> Thanks, >> JP >> >> -- >> Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >> > > > > -- > Regards, > Anoop > Sr. Developer > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Formula to Calculate Age in Excel
Dear Team, Can you help me how to calculate age ( in Year, month & day) in Excel -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Formula to Calculate Weeks
Hi, =WEEKNUM(Future date,2)-WEEKNUM(today(),2)Weeknum gives number of week you can change option (2) in formula as per your requirement, formula will prompt you when you enter formula. If this works otherwise tell us more detail --- On Thu, 12/6/12, t vinay wrote: From: t vinay Subject: $$Excel-Macros$$ Formula to Calculate Weeks To: excel-macros@googlegroups.com Date: Thursday, December 6, 2012, 8:48 PM Hi Team, can you please help me with a formula to calculate the number of weeks from today to a future date. -- Regards, Vinay. T -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Extracting Text from Cell
Thanks Anoop for helping & supporting me.
Regards,
C.G.Kumar
On Fri, Dec 7, 2012 at 9:40 AM, Anoop K Sharma wrote:
> Use the Ashish's formula for second case.
>
> Regards,
> Anoop
>
>
>
> On Thu, Dec 6, 2012 at 8:01 PM, ashish koul wrote:
>
>> try this
>>
>> =RIGHT(G4,LEN(G4)-FIND("~",SUBSTITUTE(G4,"
>> ","~",LEN(G4)-LEN(SUBSTITUTE(G4," ","")
>>
>>
>>
>>
>> On Thu, Dec 6, 2012 at 4:07 PM, C.G.Kumar wrote:
>>
>>> Dear Anoop,
>>>
>>> Thanks.
>>>
>>> But the formula in sector gives errorenous result when the last text are
>>> like "HYD/DXB/AMS/DXB/HYD"
>>>
>>>
>>> Sample attached.
>>>
>>> Can you advise.
>>>
>>>
>>>
>>>
>>>
>>> On Thu, Dec 6, 2012 at 2:16 PM, Anoop K Sharma
>>> wrote:
>>>
Hi CG,
PFA.
Regards,
Anoop
On Thu, Dec 6, 2012 at 12:59 PM, C.G.Kumar
wrote:
>
> Hi ,
>
>
> I need to extract a relevant portion from Excel cell.
>
> Attached example file.
>
>
> Many Regards,
>
> C.G.Kumar
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
--
Regards,
Anoop
Sr. Developer
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners
and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>> --
>>> Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>>
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>>
>>
>> *Visit*
>> *http://www.excelvbamacros.com/*
>> *http://www.accessvbamacros.com/*
>>
>> P Before printing, think about the environment.
>>
>>
>>
>> --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles.
Re: $$Excel-Macros$$ Extracting Text from Cell
It worked.
Thanks a lot.
On Thu, Dec 6, 2012 at 8:01 PM, ashish koul wrote:
> try this
>
> =RIGHT(G4,LEN(G4)-FIND("~",SUBSTITUTE(G4,"
> ","~",LEN(G4)-LEN(SUBSTITUTE(G4," ","")
>
>
>
>
> On Thu, Dec 6, 2012 at 4:07 PM, C.G.Kumar wrote:
>
>> Dear Anoop,
>>
>> Thanks.
>>
>> But the formula in sector gives errorenous result when the last text are
>> like "HYD/DXB/AMS/DXB/HYD"
>>
>>
>> Sample attached.
>>
>> Can you advise.
>>
>>
>>
>>
>>
>> On Thu, Dec 6, 2012 at 2:16 PM, Anoop K Sharma wrote:
>>
>>> Hi CG,
>>>
>>> PFA.
>>>
>>> Regards,
>>> Anoop
>>>
>>>
>>> On Thu, Dec 6, 2012 at 12:59 PM, C.G.Kumar
>>> wrote:
>>>
Hi ,
I need to extract a relevant portion from Excel cell.
Attached example file.
Many Regards,
C.G.Kumar
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners
and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>>
>>>
>>> --
>>> Regards,
>>> Anoop
>>> Sr. Developer
>>>
>>> --
>>> Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>>
>>>
>>
>> --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/*
>
> P Before printing, think about the environment.
>
>
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you re
Re: $$Excel-Macros$$ High low Query
Hi ppl , Could u suggest some good vb and macros material On Dec 5, 2012 6:56 AM, "Dhaval Shah" wrote: > Friends, > > pls go through the attached excel sheet > > in main sheet there is raw data of differenet date for different product > now suppose product x trade for 5 days and 5 days close value is also > different need to know the which date product x close on highest and lowest > with date > > > thanks > > dhaval shah > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Lease date alarm
Hi Ahmed If you want more help you will have to give us more information. It is not helpful to just say "It did not work" You need to tell us just what you want to happen when the date arrives, and you need to tell us what happened when you made inserted the conditional formatting. It would be helpful to have a copy of the file with conditional formatting applied so we can see if (a) you have not applied the conditional formatting to the correct cells (b) you have not provided a suitable format to distinguish those cells where renewal is approaching (c) you do not have any leases where the renewal is approaching. Otherwise we are just guessing what is in your file, what you have done with it, and what effect you are expecting. If I had been using the method proposed by Ravinder, I would have specified a light red fill for the cell if the conditions were met. I do not know what format you specified so I don't know what you were expecting. Regards David Grugeon On 7 December 2012 05:56, Ahmed Ab wrote: > Ravinder Negi > Thanks for your support , But it does not work > > Regards > > Ahmed > > On Thursday, December 6, 2012 1:50:24 PM UTC+3, Ahmed Ab wrote: >> >> Hi group , >> Actually I am new here , And I am asking for you support >> Attached file has table for lease , I am searching for the possibility to >> get alarm from excel before the due date by certain period (i.e one week >> before , two weeks ,) >> >> Thanks for all >> > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Rearrange data: Move and split cells, delete irrelevant info
Paul,
Wow! OK, let's see what we can do. Going with your most recent post first:
I tried running the ReadData first pass on the real output. I got an error:
"Run-time error '9': Subscript out of range". When I chose "debug," the
code that was highlighed was Ln 41, Col 1:
Sheets(Sht_Out).Range("A2:Z65000").Clear Contents
Regarding the format of the original data: I have three options to create a
text file. I can create the report directly to a .txt file (Ascii--I don't
know what that means). I can also "print to screen" to get the report in
the internal document viewer--what I called the PDF-looking file earlier,
then export to either a "text" or "tab-separated text" file. I had been
choosing Excel97-2000 from this list.
I think I understand what you're saying about the underlying data--that
basically the data might be cleaner/more easily malleable if it's not in
the Excel format. Do you have a preference of the three types of outputs
above? The tab-separated, I'm assuming? I experimented with all three, but
I can't send them out because they're not de-identified. I am going to go
ahead and put 3 sample accounts into the system, then generate the report
from them. I had manually changed all the info in the previous attachment
after I exported to Excel.
That being said, I don't have an easy answer to your question about which
format I want to use as the "input data." There are 2 considerations:
1. Difficulty and/or time to increase my skills: I would like to learn how
to replicate the principles/coding for 2 other reports with different
information. However, I don't have a good sense of how long that would
take me. I took a VBA class almost 10 years ago and consider myself
relatively computer savvy and a quick learner, but there are too many
unknowns to guess how long it would take me to hash through things.
2. Difficulty for other users: The final users for this report and the
others mentioned above have ZERO experience with macros and have differing
levels of computer-savviness. Is the process for creating the output
significantly simpler or less prone to error when starting by text file or
starting by Excel file? They will need to do multiple times per month.
Do you have any thoughts on this?
I'll await your thoughts on choosing an input. Meanwhile I'll actually
enter the three sample accounts into the software so you can see the data
in the different forms.
Thank you!
On Thu, Dec 6, 2012 at 11:56 AM, Paul Schreiner wrote:
> Becky,
> There are many "clues" here that lead me to suspect some things about the
> original data.
>
> First:
> you said the file is in Excel97-2000 and you're working in 2010...
> many (older) software packages are designed to allow reports to be
> "exported"
> to text files, or "spreadsheets".
>
> Since they're doing a "simple" export and are not adding any advanced
> features to the file,
> they haven't bothered to change their file format.
> Since everything they're exporting is compatible to the newer versions of
> excel,
> there's really no benefit for them to change.
>
> Usually, if there's an option to export to excel97, then there's an option
> to export to a text file.
> (my "personal" preference for this type of work)
>
> I find it odd that you said the sample data was "extracted from a
> PDF-looking report".
> It's actually possible that your Acrobat Reader (PDF) is being used for
> viewing .txt files!
> In which case the file itself may have been a text file, and it "looked"
> like a PDF file because that's what you were using to view it.
>
> the secondary "odd" part is that in viewing the "PDF-looking report", you
> (or someone) CHOSE to enter data in columns E-F-G..
> Is that where the "real" data would end up?
> in other words: is this sample data "consistent" in formatting as the
> actual data will be?
>
>
> Here's my first pass.
>
> I created a macro called "ReadData"
>
> Now, I made some "assumptions" based on your sample data.
> It may be that when actual data is used, these assumptions don't hold up.
>
> let me know which direction you'd like to go from here!
>
>
>
>
> *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:* Becky Kaliq
> *To:* excel-macros@googlegroups.com
> *Sent:* Thu, December 6, 2012 12:09:36 PM
> *Subject:* Re: $$Excel-Macros$$ Rearrange data: Move and split cells,
> delete irrelevant info
>
> Paul,
> I'm very excited to find someone who thinks this will be fun! Once I
> know more, I'm sure I'll think it's fun, too. :) I'm currently training
> other staff members, but I will answer your questions as soon as possible
> later today. I believe we do have the option of exporting as a text file.
> What I attached as sample data
$$Excel-Macros$$ Need to create a summary sheet
Need to create a summary sheet for the attached Excel doc. Tab “Detailed” is the input tab and works fine. Tab “Summary” should show the name from the A column in “Detailed” in any cell that corresponds. An example is showing Booth 1 is: 9am 10am 11am 12pm Booth 1 Person6 Person1 Person3 Person1 Person5 Joe Person1 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Test Excel Sheet.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Password problem in Excel Macro
On Thursday, December 6, 2012 9:17:50 AM UTC-6, Paul Schreiner wrote:
>
> Do you have the password?
>
> Is it asking for the password when you open the file? or when you try to
> select the range?
>
> (need to figure out if you are dealing with a protected file or sheet)
>
> if your password is "easypwd" then:
>
> If the workbook is password protected, you can use:
>
> activeworkbook.unprotect "easypwd"
>
> the sheet syntax is:
> sheets("Result").unprotect "easypwd"
>
>
> *Paul*
>
> Thanks for the reply
>
Where exactly I should place "activeworkbook.unprotect "easypwd""
> This is what I did and still asking me password
>
Workbooks.Open Filename:=path1, UpdateLinks:=0
Sheets("DATA").Select
Workbooks.Open Filename:=path2, UpdateLinks:=0
ActiveWorkbook.SaveAs Filename:=path3 _
, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
ActiveWorkbook.Unprotect "my password"
Sheets("Control_Panel").Select
Workbooks.Open Filename:=path2, UpdateLinks:=0
Sheets("Result").Select
Range("DU1:KF60").Select
Selection.Copy
> --
> *From:* Mccue >
> *To:* excel-...@googlegroups.com
> *Sent:* Wed, December 5, 2012 4:21:48 PM
> *Subject:* $$Excel-Macros$$ Password problem in Excel Macro
>
> I have this macro that I run everyday.
>
> But it is a password protected excel sheet so Macro is asking me to put in
> the password during macro is running. Here is where it asks password
>
> Workbooks.Open Filename:=path1, UpdateLinks:=0
> Sheets("DATA").Select
> Workbooks.Open Filename:=path2, UpdateLinks:=0
> ActiveWorkbook.SaveAs Filename:=path3 _
> , FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
>
> Sheets("Control_Panel").Select
> Workbooks.Open Filename:=path2, UpdateLinks:=0
> Sheets("Result").Select
> Range("DU1:KF60").Select
> Selection.Copy
>
> Can someone tell me what to so so that macro stops asking password?
>
> Thanks
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-...@googlegroups.com
> .
> To unsubscribe from this group, send email to
> excel-macros...@googlegroups.com .
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: Lease date alarm
Ravinder Negi Thanks for your support , But it does not work Regards Ahmed On Thursday, December 6, 2012 1:50:24 PM UTC+3, Ahmed Ab wrote: > > Hi group , > Actually I am new here , And I am asking for you support > Attached file has table for lease , I am searching for the possibility to > get alarm from excel before the due date by certain period (i.e one week > before , two weeks ,) > > Thanks for all > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Formula to Count Specific Words
Hi, PFA On Fri, Dec 7, 2012 at 12:30 AM, JMac wrote: > When I opened the file, the formulas don't work on my PC. WIll they not > work in Excel 2003 ? > > Thanks > > On Thursday, December 6, 2012 1:10:14 PM UTC-5, JMac wrote: > >> I've got a tracking sheet with 6 columns, each row being an entry for >> equipment maintenance. Column C contains the serial number of the >> equipment. On a separate >> sheet I have a summary, by serial number, that I want to calculate the >> total number of times a particular entry is made on the tracking sheet. >> >> Tracking Sheet >> >> Col ACol BCol CCol D Col >> E Col F >> 1/2/2012 Jim3245Amco >> 270 cleaned >> 2/2/2012 Bill ** 3245 Star ** >> 245 cleaned >> 2/23/2012 Jim3654Nowell >> 324 cleaned >> 2/27/2012 Jim3245 Amco >> 213 cleaned >> 3/5/2012 Bob 3654 Nowell >> 345 cleaned >> >> >> Summary Sheet >> >> Col A Col B Col C >> 3245 cleaned 3 >> 3654 cleaned 2 >> >> Thanks >> >> > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- *Regards,* * * *Excel Beginner* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Remove duplicate.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Formula to Count Specific Words
When I opened the file, the formulas don't work on my PC. WIll they not work in Excel 2003 ? Thanks On Thursday, December 6, 2012 1:10:14 PM UTC-5, JMac wrote: > I've got a tracking sheet with 6 columns, each row being an entry for > equipment maintenance. Column C contains the serial number of the > equipment. On a separate > sheet I have a summary, by serial number, that I want to calculate the > total number of times a particular entry is made on the tracking sheet. > > Tracking Sheet > > Col ACol BCol CCol D Col > E Col F > 1/2/2012 Jim3245Amco > 270 cleaned > 2/2/2012 Bill3245 Star > 245 cleaned > 2/23/2012 Jim3654Nowell > 324 cleaned > 2/27/2012 Jim3245 Amco > 213 cleaned > 3/5/2012 Bob 3654 Nowell > 345 cleaned > > > Summary Sheet > > Col A Col B Col C > 3245 cleaned 3 > 3654 cleaned 2 > > Thanks > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Formula to Count Specific Words
If you're wanting to do it with simple functions.. What I'd do is add a column to the tracking sheet in which you "concatenate" the serial number and activity. Like: Cell G1: =C1&F1 and copy down. Then, in the summary sheet, you can use: =COUNTIF(Tracking!G:G,A1&B1) 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: JMac To: excel-macros@googlegroups.com Sent: Thu, December 6, 2012 1:11:58 PM Subject: $$Excel-Macros$$ Formula to Count Specific Words I've got a tracking sheet with 6 columns, each row being an entry for equipment maintenance. Column C contains the serial number of the equipment. On a separate sheet I have a summary, by serial number, that I want to calculate the total number of times a particular entry is made on the tracking sheet. Tracking Sheet Col A Col B Col C Col D Col E Col F 1/2/2012 Jim3245 Amco 270 cleaned 2/2/2012 Bill 3245 Star 245 cleaned 2/23/2012 Jim 3654 Nowell 324 cleaned 2/27/2012 Jim 3245 Amco 213 cleaned 3/5/2012 Bob 3654 Nowell 345 cleaned Summary Sheet Col A Col B Col C 3245 cleaned 3 3654 cleaned 2 Thanks -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Formula to Count Specific Words
Hi, Please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Thu, Dec 6, 2012 at 11:40 PM, JMac wrote: > I've got a tracking sheet with 6 columns, each row being an entry for > equipment maintenance. Column C contains the serial number of the > equipment. On a separate > sheet I have a summary, by serial number, that I want to calculate the > total number of times a particular entry is made on the tracking sheet. > > Tracking Sheet > > Col ACol BCol CCol D Col > E Col F > 1/2/2012 Jim3245Amco > 270 cleaned > 2/2/2012 Bill3245 Star > 245 cleaned > 2/23/2012 Jim3654Nowell > 324 cleaned > 2/27/2012 Jim3245 Amco > 213 cleaned > 3/5/2012 Bob 3654 Nowell > 345 cleaned > > > Summary Sheet > > Col A Col B Col C > 3245 cleaned 3 > 3654 cleaned 2 > > Thanks > > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Remove duplicate.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ File conversion from BMP to XLS !!!!!
Hi All, Is it possible to convert a Bitmap image (BMP) into a Excel file through some Macro? If it is possible then please send me the code. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Formula to Count Specific Words
I've got a tracking sheet with 6 columns, each row being an entry for equipment maintenance. Column C contains the serial number of the equipment. On a separate sheet I have a summary, by serial number, that I want to calculate the total number of times a particular entry is made on the tracking sheet. Tracking Sheet Col ACol BCol CCol D Col E Col F 1/2/2012 Jim3245Amco 270 cleaned 2/2/2012 Bill3245 Star 245 cleaned 2/23/2012 Jim3654Nowell 324 cleaned 2/27/2012 Jim3245 Amco 213 cleaned 3/5/2012 Bob 3654 Nowell 345 cleaned Summary Sheet Col A Col B Col C 3245 cleaned 3 3654 cleaned 2 Thanks -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ convert excel file to text file
There IS a way to get to the data in an excel file without opening it, but I've not worked with that much. Mainly because it's very convenient to simply have Excel disable display updating. In which case a macro can open hundreds of excel files and file/save them as text files in a relatively short period of time. To write a macro for this, we'd need to know some things. Where are the files you want to process? How do you want to identify them? (that is: do you have a specific list of file names, or do you want to process all files in a specific folder or subfolders) 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: Manoj Kumar To: excel-macros@googlegroups.com Sent: Thu, December 6, 2012 12:54:18 PM Subject: $$Excel-Macros$$ convert excel file to text file Hi Expert I want to convert many excel file in text format. So is this possible to convert file without open a file or save as options. becouse i have to consolidated many excel file in one excel so is this any suggestion so please help Thanks Manoj -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ convert excel file to text file
Hi Expert I want to convert many excel file in text format. So is this possible to convert file without open a file or save as options. becouse i have to consolidated many excel file in one excel so is this any suggestion so please help Thanks Manoj -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Rearrange data: Move and split cells, delete irrelevant info
Paul, I'm very excited to find someone who thinks this will be fun! Once I know more, I'm sure I'll think it's fun, too. :) I'm currently training other staff members, but I will answer your questions as soon as possible later today. I believe we do have the option of exporting as a text file. What I attached as sample data was actually extracted from a PDF-looking report. I'll get back to you ASAP, and thank you! Becky On Thursday, December 6, 2012 9:50:24 AM UTC-6, Paul Schreiner wrote: > Becky, > This looks like FUN (I know, sick AND twisted!) > > --- > There's a few things I need to help you out. > > First of all, do you recieve this data already in an Excel file? > or is it a "flat" text file? > > If it's a "text" file, it would almost be easier to use VBA to read the > file itself. > I could read each line, > for the first row of data looks like it was probably tab-delimeted. > Your first field of interest is in column "E" > > The second line looks like it has two delimeter pairs. > each field and value is separated by "--" > then, the field and value are separated by ":" > > although, the first line looks like it SOMETIMES can have a "--"/":" > pairing (with the Action Note:) > > I think I can do this fairly quickly. > > but first, I'd like to know if THIS format (as an Excel sheet) > is how you want to process the input data. > > Or would you prefer that I/we use a "dialogbox" to select an external file > to use as input. > > > > > *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:* Becky Kaliq > > *To:* excel-...@googlegroups.com > *Sent:* Wed, December 5, 2012 4:45:48 PM > *Subject:* $$Excel-Macros$$ Rearrange data: Move and split cells, delete > irrelevant info > > Hello all, > > I have an Excel output from a legal software in which I need to > (significantly) rearrange the data. I’ve attached a sample of the output > with identifiers removed. The second sheet in the workbook is my ideal > output. > > > > Here are the rearrangements I’d like to be able to do: > > 1. Data for one person comes out on two rows; I would like it all on one > row. > > 2. Some data are condensed into a single cell; I need particular items > extracted to separate cells. > > 3. Output gives irrelevant data; I would like it deleted. > > 4. I would like the remaining columns arranged in a particular order. > > > > Notes: > > -- I am new to macros in Excel and have a little experience writing Visual > Basic code for an Access database. I can get to the Developer tab, et > cetera. I have recorded a basic macro (cut and paste). I see where to > access the code in my PERSONAL.XLSB modules. > > --Output is created for Excel 97-2000. I am working in 2010. > > --I left the output formatted exactly as it comes out of the software, > including column widths. > > --Output is sorted by Court with a header row for each. I don’t need those > header rows. > > --Not all defendants will have data for all my desired columns (i.e., > there may or may not be a second defendant, a service date, or a > type/note). I replicated this with my sample: one case has a second > defendant and a service type. A different case has a type/note. > > --I would like to be able to use the macro(s) weekly when we generate this > report. The usual week will have 150-300 cases. > > > > Any assistance you all can provide will be much appreciated! > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-...@googlegroups.com > . > To unsubscribe from this group, send email to > excel-macros...@googlegroups.com . > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poo
$$Excel-Macros$$ Re: Need quick help to extract rows that meets a search criteria
Hi Sharath, Can you pls provide ur workbook so that we can give you exact solution. regards prince On Thursday, December 6, 2012 7:36:09 PM UTC+5:30, sharath chandra wrote: > > Hello, > > I have a set of 51 unique names. > > I want to extract rows that contain any one of the 51 names. > > Please help. > > Thank you, > Sharath > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: Formula to Calculate Weeks
Hi vinay, Use this formula it will give you no of weeks between two dates: let suppose : A1 contain Todays Date and C1 contain futures date then: in A4:* = trunc((C1-A1)/7)* * * * * *Regards* *Prince* * * On Thursday, December 6, 2012 8:48:34 PM UTC+5:30, t vinay wrote: > > Hi Team, > > can you please help me with a formula to calculate the number of weeks > from today to a future date. > > > > -- > Regards, > > Vinay. T > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Add a new sheet and named based on last item in a row *
Yes that Ȋ̝̊̅§ what I did.
The effect of that being 3 different macros
One to create a new sheet and name the sheet by the name item
Second to copy data from a particular sheet and paste it in the sheet created
above
The last one Ȋ̝̊̅§ to copy the format in that particular sheet and paste it in
the sheet created above
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Prince
Date: Thu, 6 Dec 2012 08:38:37
To:
Cc:
Subject: Re: $$Excel-Macros$$ Add a new sheet and named based on last item
in a row *
Hi Hilary,
Your first query solution is:
Ws1.range("a1:ak132").copy
Ws2.range("a1:ak132").pastespecial xlall
application.cutcopymode=false
for Query 2: do you want set ws2 name should be strName ?
regards
prince
On Thursday, December 6, 2012 8:52:37 PM UTC+5:30, hilary lomotey wrote:
>
> Used Macro recording to achieved ♍Ɣ purpose thanks
> Sent from my BlackBerry® smartphone from Airtel Ghana
>
> -Original Message-
> From: res...@gmail.com
> Sender: excel-...@googlegroups.com
> Date: Thu, 6 Dec 2012 13:16:02
> To: >
> Reply-To: excel-...@googlegroups.com
> Subject: $$Excel-Macros$$ Add a new sheet and named based on last item in
> a row
> *
>
> Thanks again Prince for your help earlier on this. Additional request
>
> The code below enables me to copy data from sheet one to sheet two. The
> problem I have Ȋ̝̊̅§
>
> One. It doesn't copy the format in sheetone to sheet two. Kindly help with
> the code
>
> Two. This other code "addsheets" that creates a name from the last item in
> a row
> strName = Sheets(3).Range("A"&rows.count).end(xlup)
> I need help such that in the copydata code ws2 will be equal to the value
> of strName = Sheets(3).Range("A"&rows.count).end(xlup)
>
>
> Thanks
>
>
> Sub copydata()
> Dim ws1 as worksheet
> Dim ws2 as worksheet
>
> Set ws1 = thisworkbook.sheets("sheet1")
> Set ws2 = thisworkbook.sheets("sheet2")
>
> Ws2.range("a1:ak132").value =
> Ws1.range("a1:ak132").value
>
> End sub
>
>
>
>
> Sub AddSheet()
> Dim strName As String strName =
> Sheets(3).Range("A"&rows.count).end(xlup)
> Sheets.Add After:=Sheets(Sheets.Count)ActiveSheet.Name =
> strNameEnd Su
> Sent from my BlackBerry® smartphone from Airtel Ghana
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-...@googlegroups.com.
>
> To unsubscribe from this group, send email to
> excel-macros...@googlegroups.com .
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Add a new sheet and named based on last item in a row *
Hi Hilary,
Your first query solution is:
Ws1.range("a1:ak132").copy
Ws2.range("a1:ak132").pastespecial xlall
application.cutcopymode=false
for Query 2: do you want set ws2 name should be strName ?
regards
prince
On Thursday, December 6, 2012 8:52:37 PM UTC+5:30, hilary lomotey wrote:
>
> Used Macro recording to achieved ♍Ɣ purpose thanks
> Sent from my BlackBerry® smartphone from Airtel Ghana
>
> -Original Message-
> From: res...@gmail.com
> Sender: excel-...@googlegroups.com
> Date: Thu, 6 Dec 2012 13:16:02
> To: >
> Reply-To: excel-...@googlegroups.com
> Subject: $$Excel-Macros$$ Add a new sheet and named based on last item in
> a row
> *
>
> Thanks again Prince for your help earlier on this. Additional request
>
> The code below enables me to copy data from sheet one to sheet two. The
> problem I have Ȋ̝̊̅§
>
> One. It doesn't copy the format in sheetone to sheet two. Kindly help with
> the code
>
> Two. This other code "addsheets" that creates a name from the last item in
> a row
> strName = Sheets(3).Range("A"&rows.count).end(xlup)
> I need help such that in the copydata code ws2 will be equal to the value
> of strName = Sheets(3).Range("A"&rows.count).end(xlup)
>
>
> Thanks
>
>
> Sub copydata()
> Dim ws1 as worksheet
> Dim ws2 as worksheet
>
> Set ws1 = thisworkbook.sheets("sheet1")
> Set ws2 = thisworkbook.sheets("sheet2")
>
> Ws2.range("a1:ak132").value =
> Ws1.range("a1:ak132").value
>
> End sub
>
>
>
>
> Sub AddSheet()
> Dim strName As String strName =
> Sheets(3).Range("A"&rows.count).end(xlup)
> Sheets.Add After:=Sheets(Sheets.Count)ActiveSheet.Name =
> strNameEnd Su
> Sent from my BlackBerry® smartphone from Airtel Ghana
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-...@googlegroups.com.
>
> To unsubscribe from this group, send email to
> excel-macros...@googlegroups.com .
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Formula to Calculate Weeks
http://www.exceltip.com/st/Calculating_Number_of_Days,_Weeks,_Months_and_Years_between_Dates/915.html On Thu, Dec 6, 2012 at 8:48 PM, t vinay wrote: > Hi Team, > > can you please help me with a formula to calculate the number of weeks > from today to a future date. > > > > -- > Regards, > > Vinay. T > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Formula to Calculate Weeks
WEEKS is easy. Keep in mind that Excel "dates" are simply numbers. The number of days since 1/1/1900. You can use =TODAY() to get today's date: So today (12/6/2013) is: 41249 a future date, for say, 11/8/2014 is 41951 The difference is: 41951 - 41249 = 702 divide that by 7 to get the number of weeks: 100.285714285714 Rouned off to even weeks is: 100 If you have the "future" date in Cell A1, you could use: =ROUND((A1-TODAY())/7,0) 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: t vinay To: excel-macros@googlegroups.com Sent: Thu, December 6, 2012 10:19:25 AM Subject: $$Excel-Macros$$ Formula to Calculate Weeks Hi Team, can you please help me with a formula to calculate the number of weeks from today to a future date. -- Regards, Vinay. T -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Rearrange data: Move and split cells, delete irrelevant info
Becky, This looks like FUN (I know, sick AND twisted!) --- There's a few things I need to help you out. First of all, do you recieve this data already in an Excel file? or is it a "flat" text file? If it's a "text" file, it would almost be easier to use VBA to read the file itself. I could read each line, for the first row of data looks like it was probably tab-delimeted. Your first field of interest is in column "E" The second line looks like it has two delimeter pairs. each field and value is separated by "--" then, the field and value are separated by ":" although, the first line looks like it SOMETIMES can have a "--"/":" pairing (with the Action Note:) I think I can do this fairly quickly. but first, I'd like to know if THIS format (as an Excel sheet) is how you want to process the input data. Or would you prefer that I/we use a "dialogbox" to select an external file to use as input. 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: Becky Kaliq To: excel-macros@googlegroups.com Sent: Wed, December 5, 2012 4:45:48 PM Subject: $$Excel-Macros$$ Rearrange data: Move and split cells, delete irrelevant info Hello all, I have an Excel output from a legal software in which I need to (significantly) rearrange the data. I’ve attached a sample of the output with identifiers removed. The second sheet in the workbook is my ideal output. Here are the rearrangements I’d like to be able to do: 1. Data for one person comes out on two rows; I would like it all on one row. 2. Some data are condensed into a single cell; I need particular items extracted to separate cells. 3. Output gives irrelevant data; I would like it deleted. 4. I would like the remaining columns arranged in a particular order. Notes: -- I am new to macros in Excel and have a little experience writing Visual Basic code for an Access database. I can get to the Developer tab, et cetera. I have recorded a basic macro (cut and paste). I see where to access the code in my PERSONAL.XLSB modules. --Output is created for Excel 97-2000. I am working in 2010. --I left the output formatted exactly as it comes out of the software, including column widths. --Output is sorted by Court with a header row for each. I don’t need those header rows. --Not all defendants will have data for all my desired columns (i.e., there may or may not be a second defendant, a service date, or a type/note). I replicated this with my sample: one case has a second defendant and a service type. A different case has a type/note. --I would like to be able to use the macro(s) weekly when we generate this report. The usual week will have 150-300 cases. Any assistance you all can provide will be much appreciated!-- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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,
Re: $$Excel-Macros$$ Add a new sheet and named based on last item in a row *
Used Macro recording to achieved ♍Ɣ purpose thanks
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: resp...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 6 Dec 2012 13:16:02
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Add a new sheet and named based on last item in a row
*
Thanks again Prince for your help earlier on this. Additional request
The code below enables me to copy data from sheet one to sheet two. The problem
I have Ȋ̝̊̅§
One. It doesn't copy the format in sheetone to sheet two. Kindly help with the
code
Two. This other code "addsheets" that creates a name from the last item in a row
strName = Sheets(3).Range("A"&rows.count).end(xlup)
I need help such that in the copydata code ws2 will be equal to the value of
strName = Sheets(3).Range("A"&rows.count).end(xlup)
Thanks
Sub copydata()
Dim ws1 as worksheet
Dim ws2 as worksheet
Set ws1 = thisworkbook.sheets("sheet1")
Set ws2 = thisworkbook.sheets("sheet2")
Ws2.range("a1:ak132").value =
Ws1.range("a1:ak132").value
End sub
Sub AddSheet()
Dim strName As String strName =
Sheets(3).Range("A"&rows.count).end(xlup)
Sheets.Add After:=Sheets(Sheets.Count) ActiveSheet.Name = strNameEnd Su
Sent from my BlackBerry® smartphone from Airtel Ghana
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Formula to Calculate Weeks
Hi Team, can you please help me with a formula to calculate the number of weeks from today to a future date. -- Regards, Vinay. T -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Password problem in Excel Macro
Do you have the password?
Is it asking for the password when you open the file? or when you try to
select the range?
(need to figure out if you are dealing with a protected file or sheet)
if your password is "easypwd" then:
If the workbook is password protected, you can use:
activeworkbook.unprotect "easypwd"
the sheet syntax is:
sheets("Result").unprotect "easypwd"
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: Mccue
To: excel-macros@googlegroups.com
Sent: Wed, December 5, 2012 4:21:48 PM
Subject: $$Excel-Macros$$ Password problem in Excel Macro
I have this macro that I run everyday.
But it is a password protected excel sheet so Macro is asking me to put in the
password during macro is running. Here is where it asks password
Workbooks.Open Filename:=path1, UpdateLinks:=0
Sheets("DATA").Select
Workbooks.Open Filename:=path2, UpdateLinks:=0
ActiveWorkbook.SaveAs Filename:=path3 _
, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
Sheets("Control_Panel").Select
Workbooks.Open Filename:=path2, UpdateLinks:=0
Sheets("Result").Select
Range("DU1:KF60").Select
Selection.Copy
Can someone tell me what to so so that macro stops asking password?
Thanks--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members
are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Convert a CSV data string into Rows & Columns
Here's a test file based on some of the assumptions below. It's in Excel 2010 format. If you need Excel97/2003 let me know. 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: Paul Schreiner To: excel-macros@googlegroups.com Sent: Thu, December 6, 2012 9:15:39 AM Subject: Re: $$Excel-Macros$$ Convert a CSV data string into Rows & Columns I have a couple of questions for you: 1) How do you obtain the string? If that's not important for this exercise (you'll supply the string), I can use StrValue as the variable and your can set this value however you may. 2) I believe you're saying that you want the user to enter the number of rows/columns desired. I would suggest determining the number of values, then use a userform to enter the row/column values. That way, if they enter the number of rows, the number of columns will be adjusted to match. If they change the number of columns, the number of rows will be adjusted. 3) How do you want to fill the matrix? Fill across the columns first (in row 1) before moving to the next row, or Fill the rows vertically before moving to the next column? 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: Jewel Sharma To: excel-macros@googlegroups.com Sent: Thu, December 6, 2012 1:22:28 AM Subject: $$Excel-Macros$$ Convert a CSV data string into Rows & Columns Hi All, I have a string with comma separated values (say N values) (E.g. 233, 127, 139, 38, 560, 72, 56, 67, 45, 232, 28, 242, 344, 234, 034, 072, 342, 34, 5, 34, 34, 6, 782, 342, 34, 234, 2, 423, 45, 23, 21, 56, 03, 08, 56, 22, 94, 22.4, 23.1, 40, 45, 242, 475, 21, 24, 23, 423, 444, 24, 75, 67) I would like to build a macro that does the following: 1. Breaks this string values into individual cells (say 1 row X N columns, or 1 column X N rows). 2. It ask the user to enter the no. of rows (say P) and no. of columns (say Q); and then moves the data into "P" Rows X "Q" Columns. 3. it should check that N = P X Q (just to confirm that the data will fit into P X Q table). For E.g. the above e.g. data string has 36 values, the macro should be able to covert these into a 1 X 36, 2 X 18, 3 X 12, 4 X 9, 6 X 6, 9 X 4, 12 X 3, 18 X 2 and 36 X 1 rows and columns, as per the rows & columns desired by the user. I believe this should be doable using a combination of "UBound" and "Offset", but I'm just not able to piece together the logic. Cheers ! Jewel-- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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+unsub
$$Excel-Macros$$ Assignment or examples
Dear Expert, I'm keen to learn many things on excel but I don't have proper guide line like assignment or example to work out. Can you please provide if you have anything's. So that I can improve my excel skill Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Services Authority in respect of insurance mediation activities only. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Add a new sheet and named based on last item in a row *
Hi experts
I have been able to amend the code to pick any new sheet name that Ȋ̝̊̅§
created.
What I kindly request Ȋ̝̊̅§ the format from the first sheet to the new sheet.
See ♍Ɣ new code below.
Sub copydata()
Dim ws1 as worksheet
Dim ws2 as worksheet
Dim strtname as string
strName = Sheets(3).Range("A"&rows.count).end(xlup)
Set ws1 = thisworkbook.sheets("sheet1")
Set ws2 = thisworkbook.sheets(strtname)
Ws2.range("a1:ak132").value = Ws1.range("a1:ak132").value End sub
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: resp...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 6 Dec 2012 13:16:02
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Add a new sheet and named based on last item in a row
*
Thanks again Prince for your help earlier on this. Additional request
The code below enables me to copy data from sheet one to sheet two. The problem
I have Ȋ̝̊̅§
One. It doesn't copy the format in sheetone to sheet two. Kindly help with the
code
Two. This other code "addsheets" that creates a name from the last item in a row
strName = Sheets(3).Range("A"&rows.count).end(xlup)
I need help such that in the copydata code ws2 will be equal to the value of
strName = Sheets(3).Range("A"&rows.count).end(xlup)
Thanks
Sub copydata()
Dim ws1 as worksheet
Dim ws2 as worksheet
Set ws1 = thisworkbook.sheets("sheet1")
Set ws2 = thisworkbook.sheets("sheet2")
Ws2.range("a1:ak132").value =
Ws1.range("a1:ak132").value
End sub
Sub AddSheet()
Dim strName As String strName =
Sheets(3).Range("A"&rows.count).end(xlup)
Sheets.Add After:=Sheets(Sheets.Count) ActiveSheet.Name = strNameEnd Su
Sent from my BlackBerry® smartphone from Airtel Ghana
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Extracting Text from Cell
try this
=RIGHT(G4,LEN(G4)-FIND("~",SUBSTITUTE(G4,"
","~",LEN(G4)-LEN(SUBSTITUTE(G4," ","")
On Thu, Dec 6, 2012 at 4:07 PM, C.G.Kumar wrote:
> Dear Anoop,
>
> Thanks.
>
> But the formula in sector gives errorenous result when the last text are
> like "HYD/DXB/AMS/DXB/HYD"
>
>
> Sample attached.
>
> Can you advise.
>
>
>
>
>
> On Thu, Dec 6, 2012 at 2:16 PM, Anoop K Sharma wrote:
>
>> Hi CG,
>>
>> PFA.
>>
>> Regards,
>> Anoop
>>
>>
>> On Thu, Dec 6, 2012 at 12:59 PM, C.G.Kumar wrote:
>>
>>>
>>> Hi ,
>>>
>>>
>>> I need to extract a relevant portion from Excel cell.
>>>
>>> Attached example file.
>>>
>>>
>>> Many Regards,
>>>
>>> C.G.Kumar
>>>
>>> --
>>> Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>>
>>>
>>
>>
>>
>> --
>> Regards,
>> Anoop
>> Sr. Developer
>>
>> --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*
P Before printing, think about the environment.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are
Re: $$Excel-Macros$$ VBA to update in Website.
try these links see if it helps http://www.dailydoseofexcel.com/archives/2006/11/29/html-tables/ http://www.tushar-mehta.com/publish_train/xl_vba_cases/vba_web_pages_services/index.htm On Thu, Dec 6, 2012 at 5:46 PM, Rakesh Joshi wrote: > how update value in text box in website which contain in table like > as I am having the text box in table in interexplorer.** > > As I can fill it if they are not it table using doc methon. > > ** ** > > Please help me as soon as poosible. > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Need quick help to extract rows that meets a search criteria
LOTS of ways to do this. Some are much better than others (faster, more efficient) We need more to work with. - Are the rows filled with sentences, or multiple columns of values? - Will the name match the entire cell value, or a portion of a larger string? - Do you wish a case sensitive match? - Do you wish a partial match, or full word? (Paul found in Paulette) Perhaps it would be best if you provided a sample file. Just a few rows of data, and how you want the result presented. 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: sharath chandra To: excel-macros@googlegroups.com Sent: Thu, December 6, 2012 9:09:01 AM Subject: $$Excel-Macros$$ Need quick help to extract rows that meets a search criteria Hello, I have a set of 51 unique names. I want to extract rows that contain any one of the 51 names. Please help. Thank you, Sharath-- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Need quick help to extract rows that meets a search criteria
use advance search option http://office.microsoft.com/en-001/excel-help/filter-by-using-advanced-criteria-HP005200178.aspx On Thu, Dec 6, 2012 at 7:36 PM, sharath chandra < sharath.c.sambr...@gmail.com> wrote: > Hello, > > I have a set of 51 unique names. > > I want to extract rows that contain any one of the 51 names. > > Please help. > > Thank you, > Sharath > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Convert a CSV data string into Rows & Columns
I have a couple of questions for you: 1) How do you obtain the string? If that's not important for this exercise (you'll supply the string), I can use StrValue as the variable and your can set this value however you may. 2) I believe you're saying that you want the user to enter the number of rows/columns desired. I would suggest determining the number of values, then use a userform to enter the row/column values. That way, if they enter the number of rows, the number of columns will be adjusted to match. If they change the number of columns, the number of rows will be adjusted. 3) How do you want to fill the matrix? Fill across the columns first (in row 1) before moving to the next row, or Fill the rows vertically before moving to the next column? 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: Jewel Sharma To: excel-macros@googlegroups.com Sent: Thu, December 6, 2012 1:22:28 AM Subject: $$Excel-Macros$$ Convert a CSV data string into Rows & Columns Hi All, I have a string with comma separated values (say N values) (E.g. 233, 127, 139, 38, 560, 72, 56, 67, 45, 232, 28, 242, 344, 234, 034, 072, 342, 34, 5, 34, 34, 6, 782, 342, 34, 234, 2, 423, 45, 23, 21, 56, 03, 08, 56, 22, 94, 22.4, 23.1, 40, 45, 242, 475, 21, 24, 23, 423, 444, 24, 75, 67) I would like to build a macro that does the following: 1. Breaks this string values into individual cells (say 1 row X N columns, or 1 column X N rows). 2. It ask the user to enter the no. of rows (say P) and no. of columns (say Q); and then moves the data into "P" Rows X "Q" Columns. 3. it should check that N = P X Q (just to confirm that the data will fit into P X Q table). For E.g. the above e.g. data string has 36 values, the macro should be able to covert these into a 1 X 36, 2 X 18, 3 X 12, 4 X 9, 6 X 6, 9 X 4, 12 X 3, 18 X 2 and 36 X 1 rows and columns, as per the rows & columns desired by the user. I believe this should be doable using a combination of "UBound" and "Offset", but I'm just not able to piece together the logic. Cheers ! Jewel-- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Need quick help to extract rows that meets a search criteria
Hello, I have a set of 51 unique names. I want to extract rows that contain any one of the 51 names. Please help. Thank you, Sharath -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: Fwd: $$Excel-Macros$$ Reference cells value required with condition
That's not really my question(s). I can write a function that checks sheet3, then sheet2, then sheet1. But that's not very efficient if tomorrow you have to check 4 sheets, then 5 on the next day. also, a function could work for 20-30 rows, but if you get into a larger spreadsheet, the recalculation time could be excessive. so: 1) Will there ALWAYS be a total of (4) sheets 2) would you rather have a function used on each row, or a VBA macro (and button) that refreshes the entire list? 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: Thu, December 6, 2012 8:32:10 AM Subject: Fwd: $$Excel-Macros$$ Reference cells value required with condition Hello Sir Thanks for your reply. I required the last updated value which may come from any of the sheets. If it is not available in sheet3, then it should get from sheet2; if it's not available in sheet2 also then it should get from sheet1 otherwise ZERO. Regards Pravin. -- Forwarded message -- From: Paul Schreiner Date: Thu, Dec 6, 2012 at 6:53 PM Subject: Re: $$Excel-Macros$$ Reference cells value required with condition To: excel-macros@googlegroups.com r would you rather copy a function down and have it refr -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Reference cells value required with condition
Pravin, It looks like you're wanting to find the "last" occurence of a name. looking in sheet3, then sheet2, then sheet1. Will there ALWAYS be a TOTAL of 4 sheets? Or will the be sheets added periodically? Is this something you'd rather hit a button and have it refresh sheet 4? or would you rather copy a function down and have it refresh each row? 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: Thu, December 6, 2012 7:13:54 AM Subject: $$Excel-Macros$$ Reference cells value required with condition Hi, I have attached a sample worksheet here for immediate reference. There is a cumulative sheet no.4 in which I required the values based on the condition given in file. Kindly inform me any formula or vb code for the same. Thanks Pravin Gunjal -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Add a new sheet and named based on last item in a row
Thanks again Prince for your help earlier on this. Additional request
The code below enables me to copy data from sheet one to sheet two. The problem
I have Ȋ̝̊̅§
One. It doesn't copy the format in sheetone to sheet two. Kindly help with the
code
Two. This other code "addsheets" that creates a name from the last item in a row
strName = Sheets(3).Range("A"&rows.count).end(xlup)
I need help such that in the copydata code ws2 will be equal to the value of
strName = Sheets(3).Range("A"&rows.count).end(xlup)
Thanks
Sub copydata()
Dim ws1 as worksheet
Dim ws2 as worksheet
Set ws1 = thisworkbook.sheets("sheet1")
Set ws2 = thisworkbook.sheets("sheet2")
Ws2.range("a1:ak132").value =
Ws1.range("a1:ak132").value
End sub
Sub AddSheet()
Dim strName As String strName =
Sheets(3).Range("A"&rows.count).end(xlup)
Sheets.Add After:=Sheets(Sheets.Count) ActiveSheet.Name = strNameEnd Su
Sent from my BlackBerry® smartphone from Airtel Ghana
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ VBA to update in Website.
how update value in text box in website which contain in table like as I am having the text box in table in interexplorer. As I can fill it if they are not it table using doc methon. Please help me as soon as poosible. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Reference cells value required with condition
*Hi,* * * *I have attached a sample worksheet here for immediate reference.* *There is a cumulative sheet no.4 in which I required the values based on the condition given in file.* * * *Kindly inform me any formula or vb code for the same.* * * *Thanks * *Pravin Gunjal* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Reference formula.xlsb Description: Binary data
Re: $$Excel-Macros$$ Re: Add a new sheet and named based on last item ina row *
Thanks prince but I get a debug error on the
Strtname =sheets(1).range("a1"& rows.count).end(xlup)
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Prince
Sender: excel-macros@googlegroups.com
Date: Thu, 6 Dec 2012 03:51:53
To:
Reply-To: excel-macros@googlegroups.com
Cc:
Subject: $$Excel-Macros$$ Re: Add a new sheet and named based on last item ina
row *
This message is eligible for Automatic Cleanup! (prince141...@gmail.com)
Add cleanup rule:
https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DwjllUQNBKLY764%252FddsPpfq9EfGBswt0msCubY4omtUFxqydJmBuEbNXBSMYtK0K1y3nMPzMI07x19h7b%252Fi6tGCGVq%252BgcmGFJPq6AGWEesQrx5xxXS%252BxIXT0e%252BZ4iAL%252BZouojSfucQT8GyhMjqb3fCA%253D%253D%26key%3DkZDj0s%252FZATy419PaeSBouFyX1C0gqJtPD1Szf4rP%252Fec%253D&tc=13058181434_576394978
More info:
http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13058181434_576394978
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: Add a new sheet and named based on last item in a row
Hi Hilary,
Just Replace Sheets(1).Range("A1")line Bysheets(1).Range("A" &
Rows.Count).End(xlup)
Regards
Prince
On Thursday, December 6, 2012 5:05:10 PM UTC+5:30, hilary lomotey wrote:
>
> Hello experts
>
> The below code aids me to add a new sheet and named according to the text
> in cell A1. What I request Ȋ̝̊̅§ to modify this code to always pick the
> last item in the row. For instance row 1 has ABX and row A2 has BCD it shd
> pick BCD as the sheet name if there Ȋ̝̊̅§ a text in say row A3 GCB when I
> run the code it should pick that name.
>
>
> Sub AddSheet()
> Dim strName As String
>
> strName = Sheets(1).Range("A1")
> Sheets.Add After:=Sheets(Sheets.Count)
> ActiveSheet.Name = strName
> End Sub
> Sent from my BlackBerry® smartphone from Airtel Ghana
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Add a new sheet and named based on last item in a row
Hello experts
The below code aids me to add a new sheet and named according to the text in
cell A1. What I request Ȋ̝̊̅§ to modify this code to always pick the last item
in the row. For instance row 1 has ABX and row A2 has BCD it shd pick BCD as
the sheet name if there Ȋ̝̊̅§ a text in say row A3 GCB when I run the code it
should pick that name.
Sub AddSheet()
Dim strName As String
strName = Sheets(1).Range("A1")
Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Name = strName
End Sub
Sent from my BlackBerry® smartphone from Airtel Ghana
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Lease date alarm
hi Ahmed,If you want this through conditional formatting then you can paste
this =INDIRECT("g"&ROW())=TODAY()+14" in conditional formatting formula thanks
--- On Thu, 12/6/12, Ahmed Ab wrote:
From: Ahmed Ab
Subject: $$Excel-Macros$$ Lease date alarm
To: excel-macros@googlegroups.com
Date: Thursday, December 6, 2012, 4:20 PM
Hi group ,
Actually I am new here , And I am asking for you support Attached file has
table for lease , I am searching for the possibility to get alarm from excel
before the due date by certain period (i.e one week before , two weeks ,)
Thanks for all
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Lease date alarm
Hi group , Actually I am new here , And I am asking for you support Attached file has table for lease , I am searching for the possibility to get alarm from excel before the due date by certain period (i.e one week before , two weeks ,) Thanks for all -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Lease.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Extracting Text from Cell
Dear Anoop, Thanks. But the formula in sector gives errorenous result when the last text are like "HYD/DXB/AMS/DXB/HYD" Sample attached. Can you advise. On Thu, Dec 6, 2012 at 2:16 PM, Anoop K Sharma wrote: > Hi CG, > > PFA. > > Regards, > Anoop > > > On Thu, Dec 6, 2012 at 12:59 PM, C.G.Kumar wrote: > >> >> Hi , >> >> >> I need to extract a relevant portion from Excel cell. >> >> Attached example file. >> >> >> Many Regards, >> >> C.G.Kumar >> >> -- >> Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >> > > > > -- > Regards, > Anoop > Sr. Developer > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Extracting Text_Anoop.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Extracting Text from Cell
Hi, Another way to do this with lesser formulas Regards, Nishant On Thu, Dec 6, 2012 at 3:36 PM, ravinder negi wrote: > HERE IS THE SOLUTION > > --- On *Thu, 12/6/12, C.G.Kumar * wrote: > > > From: C.G.Kumar > Subject: $$Excel-Macros$$ Extracting Text from Cell > To: excel-macros@googlegroups.com > Date: Thursday, December 6, 2012, 12:59 PM > > > > Hi , > > > I need to extract a relevant portion from Excel cell. > > Attached example file. > > > Many Regards, > > C.G.Kumar > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Nishant Mendiratta nishant.mendira...@gmail.com -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Extracting Text.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Extracting Text from Cell
HERE IS THE SOLUTION --- On Thu, 12/6/12, C.G.Kumar wrote: From: C.G.Kumar Subject: $$Excel-Macros$$ Extracting Text from Cell To: excel-macros@googlegroups.com Date: Thursday, December 6, 2012, 12:59 PM Hi , I need to extract a relevant portion from Excel cell. Attached example file. Many Regards, C.G.Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Extracting Text.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Extracting Text from Cell
Hi CG, PFA. Regards, Anoop On Thu, Dec 6, 2012 at 12:59 PM, C.G.Kumar wrote: > > Hi , > > > I need to extract a relevant portion from Excel cell. > > Attached example file. > > > Many Regards, > > C.G.Kumar > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Regards, Anoop Sr. Developer -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Extracting Text.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
