Re: $$Excel-Macros$$ please provide me some basic training materials of Excel
Hi, http://www.youtube.com/user/excelisfun http://people.highline.edu/mgirvin/ExcelIsFun.htm On Mon, Mar 4, 2013 at 7:32 PM, xlstime xlst...@gmail.com wrote: try this http://www.free-training-tutorial.com/ On Mon, Mar 4, 2013 at 8:35 PM, Indrajit $nai talk2indra...@gmail.comwrote: Hi all, please provide me some basic training materials of Excel . thanks in advance. -- Indrajit talk2indra...@gmail.com 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. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- . Enjoy Team XLS -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: Compare two text columns by last name
Hi, Try it, =TRIM(RIGHT(SUBSTITUTE(A1, ,REPT( ,100)),100))=TRIM(RIGHT(SUBSTITUTE(B1, ,REPT( ,100)),100)) On Sat, Mar 2, 2013 at 11:46 AM, satyas manav...@gmail.com wrote: Hi Nitin, I found an error when I applied it on my database where there is no space between last name and first name. I am attaching the sheet to make u understand. Please let me know if there is any solution. Satya On Sunday, 24 February 2013 19:47:18 UTC+5:30, satyas wrote: Thanks Nitin. On Saturday, February 23, 2013 4:40:33 PM UTC+5:30, Nitin Gupta wrote: Pls see the solution in attached sheet Nitin On Saturday, February 23, 2013 1:14:46 PM UTC+5:30, satyas wrote: Hi Experts, Just need to compare two columns by last name . Will appreciate if you can help me for this. Satya. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. Satya.xlsm Description: Binary data
Re: $$Excel-Macros$$ Re: Assignment
HI,
Try it,
Function ValidateString(strInput As String) As String
Dim strInvalidChars As String
Dim i As Long
strInvalidChars = *,?~@#$%^()_+{}[]:; '
For i = 1 To Len(strInvalidChars)
strInput = Replace$(strInput, Mid$(strInvalidChars, i, 1), )
Next
ValidateString = strInput
End Function
On Fri, Mar 1, 2013 at 10:25 AM, Prince prince141...@gmail.com wrote:
Hi,
Check this May be if it can help you.
Function GetNumberS(strData As String) As String
Dim objRge As Object, REMatches As Object
Set objRge = CreateObject(vbscript.regexp)
With objRge
'.Pattern = [0-9][0-9][0-9][0-9]
.Pattern = (\d+)
End With
Set REMatches = objRge.Execute(strData)
GetNumberS = REMatches(0)
End Function
Regards
Prince
On Saturday, February 23, 2013 11:44:01 AM UTC+5:30, Harkesh Kumar wrote:
Please solve this Problem
Please Seperate Special character and number
num
Ans
@1234
#1239
$1244
%1249
^1254
1259
*1264
@1234
#1239
$1244
%1249
^1254
1259
*1264
@1234
#1239
$1244
%1249
^1254
1259
*1264
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups
MS EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
*
*
* MARIES*
Excel Inspiration http://xcel-inspiration.blogspot.com/
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups MS
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Need formula for sum
Hi, Try it, =SUMIF($D$2:$AB$2,AC2,D$3:AB$3) On Wed, Feb 27, 2013 at 6:26 PM, Deepak Rawat deepakexce...@gmail.comwrote: Sorry attached wrong one now attached the correct one. Regards, Deepak On Wed, Feb 27, 2013 at 5:41 PM, David Grugeon da...@grugeon.com.auwrote: We need more information. What do you want the sum of? There does not seem to be anything in the worksheet provided that you could possibly want to add up. On Wednesday, 27 February 2013, Deepak Rawat wrote: Hi, need formula for sum in attach Regards, Deepak -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards David Grugeon -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4
Re: $$Excel-Macros$$ Grade Wise Max Total Required
Hi, Please this formula in C22 Drag it down. (Apply with Ctrl+Shift+Enter =MAX(IF($A$2:$A$18=A22,$C$2:$C$18,)) On Wed, Jul 4, 2012 at 11:11 AM, Jayaprakash S bhat.jayaprak...@gmail.comwrote: Dear Experts, Please help to get the Grade wise Maxium total through formula for the enclosed data. Many Thanks JP. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June'12)
Congrats Rajan... On Wed, Jul 4, 2012 at 9:53 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Congrats Rajan... On Wed, Jul 4, 2012 at 10:43 PM, dguillett1 dguille...@gmail.com wrote: Congratulations from Austin Texas Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Ayush Jain jainayus...@gmail.com *Sent:* Wednesday, July 04, 2012 11:16 AM *To:* excel-macros excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Rajan Verma - Most helpful Member(June'12) Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of June'2012. This is third time in row. :) He has posted 149 posts in June 2012 and helped many people through his expertise. I truly appreciate his consistency and commitment to group. He is really doing great job. Thanks to Noorain, Deba Ranjan, Don, David, Lalit, Lokesh, Hilary, Asa and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Keep posting. Regards Ayush Jain Group Manager , Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email
Re: $$Excel-Macros$$ Excel Q A
Nice Collection Thanks On Wed, Jun 20, 2012 at 9:11 PM, Anil Gawli gawlianil8...@gmail.com wrote: Hi Krishna, Thanks 4 sharing ... Regards, Gawli Anil On Wed, Jun 20, 2012 at 8:35 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Nice collection, Kirshna Thanks to sharing with group. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Wed, Jun 20, 2012 at 6:50 PM, Krishnaraddi excelkris...@in.comwrote: Hi Experts, I have collected few questions regarding excel and updated in single document. I have also attached answers in separate excel sheet. I hope this will help few who are learning Excel. Dear *excel-macros !* Get Yourself a cool, short *@in.com* Email ID now!http://www3.in.com/sso/commonregister.php?ref=INutm_source=inviteutm_medium=outgoing -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Saving Photos from webpage
are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com ** ** -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Kiran 9920456606 -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ All Ideas matter : Need your support here.
*My Suggestion* http://www.google.com/moderator/#15/e=455dbt=455db.40f=455db.66a716q=455db.66a716 On Tue, Jun 19, 2012 at 9:33 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, Last year,I started an initiative to collect ideas for improvements in excel. The initiative received the great response of 165 ideas and 1018 votes. If you have ideas and new features that you would like to see in upcoming version of MS Excel, you can submit the same herehttp://www.google.com/moderator/#16/e=455db The only intent here is to make excel awesome for the users and give feedback to Microsoft on their product. Submit your idea here http://www.google.com/moderator/#16/e=455db If you dont have idea, you can votehttp://www.google.com/moderator/#16/e=455dbthe ideas of others and support them. The ideas will be reviewed by Microsoft product team and they may incorporate if they like it. Thanks all for supporting this initiative. Best regards, Ayush Jain Group Manager Microsoft MVP Have a feedback about group ? Submit herehttp://www.surveymonkey.com/s/3WM3FYH -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Formula for Username in a cell
Thank you Krishna. Its very useful. On Thu, Jun 21, 2012 at 7:54 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi, Thank you so much Regards, Kuldeep Singh Phone.: +91-9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Thu, Jun 21, 2012 at 9:21 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: So Nice and also I never seen such a nice tutorial on Excel, Good user friendly, easy and simply superb Thanks dear. On Thu, Jun 21, 2012 at 8:27 PM, Krishnaraddi excelkris...@in.comwrote: Hi All, Please find the attached PPT consists of few useful excel functions explained. I have prepared this document for training purpose thought to share with this group. FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Dear *excel-macros !* Get Yourself a cool, short *@in.com* Email ID now!http://www3.in.com/sso/commonregister.php?ref=INutm_source=inviteutm_medium=outgoing -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- -- FORUM RULES (986+ members already BANNED
Re: $$Excel-Macros$$ Excel 2010 short cut
http://office.microsoft.com/en-us/excel-help/keyboard-shortcuts-in-excel-2010-HP010342494.aspx On Wed, Jun 20, 2012 at 5:34 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Rakesh, Please find attached SHort cut of MS Excel 2010 On Wed, Jun 20, 2012 at 6:00 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Hi Experts, Plz share if you have any spread sheet for short cut in MS Excel 2010. -- *Regards, Rakesh Kumar Sharma Contact: +91-9971024741 * -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Lookup fomular
Hi, * PFA.* On Fri, Jun 15, 2012 at 11:20 AM, attapan_chainarongb...@ck-mail.comwrote: Dear Gawli ** ** Thanks for your advice, but still problem I tried apply on my sheet, So the fomular catch on max date of forecast date My requirement are catch on max date Which it have number ** ** ** ** Rdgs * * *Attapan Chainarongboon* *Production control Dept (Compressor)* *Calsonic Kansei (Thailand)*** *E-mail* : attapan_chainarongb...@ck-mail.com *Phone* : (+66) 038-210-129 #101 *Mobile phone*: (+66) 086-824-5045 ** ** ** ** ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Anil Gawli *Sent:* Friday, June 15, 2012 1:36 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Lookup fomular ** ** Find Attached Sheet On Fri, Jun 15, 2012 at 10:55 AM, attapan_chainarongb...@ck-mail.com wrote: Dear all experts I’ve some questions to ask in my sheet The sheet put for the forecast date and quantity each per forecast date** ** I need to get the lastest forecast date and the quantity of that, So, the result which fomular which I use are “Ok”, but I think may be have better way to do that Please advice Rdgs * * *Attapan Chainarongboon* *E-mail* : attapan_chainarongb...@ck-mail.com *Phone* : (+66) 038-210-129 #101 *Mobile phone*: (+66) 086-824-5045 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge
Re: $$Excel-Macros$$ No. of years and months
HI, Assume data entries in A1, Try below formula, * =INT(A1/12) Years A1-INT(A1/12)*12 Months* On Wed, Jun 13, 2012 at 5:56 AM, Ahmed Honest ahmedhon...@gmail.com wrote: Hi Experts, Based on a given number I need the result to be something like below: Given Number : 200 Answer should be 16 Years 8 Months. Is there any way of doing it in Ms Excel by Formula? Thanks, Ahmed Bawazir -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Extract Comma separated Data
HI David, *Wrap Text *only avoiding continues spaces from the cell text. That's why output not containing any empty rows in between. If you check total length of cell - say =LEN(B8), its counting spaces too. I hope this clarify clear. On Mon, Jun 11, 2012 at 1:14 AM, David Grugeon da...@grugeon.com.au wrote: Hi Maries Interesting. Do you know what is going through Excels mind when it does that? Why it does not just end up with lots of empty rows? On 11 June 2012 17:19, Maries talk2mar...@gmail.com wrote: HI, Use the below formula PFA. * =SUBSTITUTE(B2,,,REPT( ,1000))* On Sun, Jun 10, 2012 at 11:50 PM, David Grugeon da...@grugeon.com.auwrote: Hi Nalini Select the data Ctrl H to bring up the replace dialog Click in the Find what box. Type a comma. Click in the Replace with box. Hold down ALT and on the number pad type 013. Release ALT Hold down ALT and on the number pad type 010. Release ALT Click Replace All Select the rows and with the mouse between two row numbers on the left double click. Regards David Grugeon -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Introduce Yourself !!
, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ delete my id from mailing list
*To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com* On Tue, Jun 5, 2012 at 4:04 AM, Ajay Tripathi tripathiaja...@gmail.comwrote: Hi Please delete my name from mailing list for the time being. Thanx Ajay Tripathi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Graph with radio button
Hi, PFA... On Mon, Jun 4, 2012 at 1:39 AM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hi Group, I want to create a graph which will show the work performance of different teams as and when they are selected. Attached is the sample sheet for your easy reference. -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Chart.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Graph with radio button
Hi Santosh, Find the attached file. I hope this fulfill. On Mon, Jun 4, 2012 at 2:27 AM, Anil Gawli gawlianil8...@gmail.com wrote: See the attached data Regards, Gawli Anil On Mon, Jun 4, 2012 at 2:38 PM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hi Maries, Thankyou for your early response. I want to show only the list of people who are available. I mean when I will select team 1 then the graph should show only the data for the three people and no zero's . Hope I am clear with query. Regards Santosh santoshkumar.subu...@gmail.com From: talk2mar...@gmail.com Date: Mon, 4 Jun 2012 02:01:14 -0700 Subject: Re: $$Excel-Macros$$ Graph with radio button To: excel-macros@googlegroups.com Hi, PFA... On Mon, Jun 4, 2012 at 1:39 AM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hi Group, I want to create a graph which will show the work performance of different teams as and when they are selected. Attached is the sample sheet for your easy reference. -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send
Re: $$Excel-Macros$$ Unique value formula required
in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --**--** --** To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscribe@** googlegroups.com excel-macros%2bunsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.**comhttp://www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Unique Extract.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Lookup Item No. from Stock.xls in Order.xls
Hi Use one more *IF* condition with your formula to show blank as blank. =IF(A1=,,Formula) On Sun, Jun 3, 2012 at 9:41 AM, prkhan56 prkha...@gmail.com wrote: Thanks. But it is showing Yes for Blanks also. I wish to show Blank for Blanks. On Saturday, June 2, 2012 12:12:39 PM UTC+4, vijayajith VA wrote: Hi Rashid As you requested.. Please find ...attached file...Thanks On Sat, Jun 2, 2012 at 1:14 PM, Rashid Khan prkha...@gmail.com wrote: Hello All I am enclosing two files viz Stock.xls and Order.xls I wish to have a formula in Order.xls in the ‘IS PRESENT’ column on all the 3 Sheets (PF,MU,PR) to lookup for Item No. from Stock.xls (6 digits from left only) and say “Yes” if present or “No” if not present. TIA Rashid -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --**--** --** To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscribe@** googlegroups.com excel-macros%2bunsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)
*Congrats Brother.* On Sun, Jun 3, 2012 at 9:36 PM, Anil Gawli gawlianil8...@gmail.com wrote: congrats Mr Rajan. Gawli Anil On Mon, Jun 4, 2012 at 9:23 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Congratulation Rajan.. On Sun, Jun 3, 2012 at 11:12 PM, Ayush Jain jainayus...@gmail.comwrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of May'2012 He has posted 147 posts in May 2012 and helped many people through his expertise. I truly appreciate his consistency and commitment to group. He is really doing great job God bless you :) Thanks to Noorain, Don, Asa, Maries, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Trust me, It requires big heart to help others voluntarily and thanks to everyone who is supporting this forum. Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ help required for creating a formula
Hi, Also try... =SUMIF(A7:A291,D7,B7:B291) On Fri, May 18, 2012 at 8:10 AM, Seraj Alam seraj.ala...@gmail.com wrote: Hi Ashish, You can try below formula also... =INDEX(B:B,MATCH(D7,A:A,0)) On Wed, May 16, 2012 at 6:03 AM, ashish damor damor.ash...@gmail.comwrote: Dear Sir, Thanks for your very useful and prompt reply. I am really very grateful to you. Take care. With regards, Ashish On 5/16/12, Prajakt Pande prajakt.pa...@gmail.com wrote: Dear Ashish Damor, solved, sheet attached. =VLOOKUP(D7,$A$7:$B$291,2,0) Thanks Regards, Prajakt Pande +971551388482 ** On Wed, May 16, 2012 at 1:48 PM, ashish damor damor.ash...@gmail.com wrote: Dear All, I have a list of industry in one column and in corresponding column the rates as per industry are given. I want to create a formula whereby when i selected a specific industry from the dropdown list automatically the corresponding rate is displayed in next cell. I am enclosing my worksheet. Please help me. Thanks all in advance. -- Thanking you. With regards, Ashish Damor -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanking you. With regards, Ashish Damor -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks Regards Seraj Alam *+91 989 130 1776* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
Re: $$Excel-Macros$$ Re: Row to repeat at the bottom of each page
Hi, Excel having options for *Rows to Repeat at Top *- Press Alt + P + I, Select the Range and OK. There is no in-build function for *Rows to Repeat at Bottom*, You can try below codes to show it in footer. Sub MyFooter() Dim StrFtr As String, Rng As Range, Sh As Worksheet, c As Range Set Sh = Worksheets(Sheet1) Set Rng = Sh.Range(A20:H20) For Each c In Rng StrFtr = StrFtr c Next c ActiveSheet.PageSetup.LeftFooter = StrFtr End Sub -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Anybody have total Floor's Electrical Load Calculation Sheet.Xls
Hi, Check this link, http://www.jiguparmar.com/1_22_Electrical-Engineering.html * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ 2 Values in the same cell
Hi, PFA... * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com 2 values in one cell.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Want to use micros
Hi, * * *Alt + A + S, then Select the Field Order, Press OK.* On Wed, May 16, 2012 at 4:15 AM, Reshma Shelar onlyx...@gmail.com wrote: here is my raw data On Wed, May 16, 2012 at 4:24 PM, Anil Gawli gawlianil8...@gmail.comwrote: Hi Reshma for that i want your raw data . Provide me then i can give you with the solved attached sheet On Wed, May 16, 2012 at 11:08 AM, Reshma Shelar onlyx...@gmail.comwrote: Hi, I want to sort my data date name wise can i use micros for that, if yes please help me with the formula. Thanks Reshma -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Time Difference
Hi, Find the attachments.. -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Time_Difference_Formula.xlsm Description: Binary data Time_Difference_VBA.xlsm Description: Binary data
Re: $$Excel-Macros$$ Pls help for expression col no * 25 + row no
Hi, Try it, * =COLUMN()*25+ROW()* On Wed, May 16, 2012 at 8:05 PM, Mangesh Dayne mangesh.da...@gmail.comwrote: I am happy for your kind support Pls help me again for below issue . Find attached sheet Thanks. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Pls help for expression col no * 25 + row no
*PFA...* On Wed, May 16, 2012 at 8:11 PM, Maries talk2mar...@gmail.com wrote: Hi, Try it, * =COLUMN()*25+ROW()* On Wed, May 16, 2012 at 8:05 PM, Mangesh Dayne mangesh.da...@gmail.comwrote: I am happy for your kind support Pls help me again for below issue . Find attached sheet Thanks. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Expression.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Time Difference
TO UNSUBSCRIBE Google Groups help on the subject: http://support.google.com/groups/bin/answer.py?hl=enanswer=46608 Key points thereof: Leave the group by any of these methods: · Reply to any group email and change the subject to REMOVE ME · Send a blank email to excel-macros+unsubscr...@googlegroups.com · If you have a Google account (you could create one first if you want), you can go to http://groups.google.com/group/excel-macros and click Edit my membership then Unsubscribe. You can actually also change your email option (even no email) there. [By Asa] Rajan. On Wed, May 16, 2012 at 9:21 PM, Swarup Choghale choghaleswa...@yahoo.co.in wrote: UNSUBSCRIBE Thanks and Regards, Swarup Choghale --- On *Wed, 16/5/12, Naresh V naresh.veerabo...@gmail.com* wrote: From: Naresh V naresh.veerabo...@gmail.com Subject: Re: $$Excel-Macros$$ Time Difference To: excel-macros@googlegroups.com Cc: Mangesh Dayne mangesh.da...@gmail.com Date: Wednesday, 16 May, 2012, 6:47 PM On Wed, May 16, 2012 at 8:04 AM, Mangesh Dayne mangesh.da...@gmail.comhttp://in.mc1926.mail.yahoo.com/mc/compose?to=mangesh.da...@gmail.com wrote: Hi Friends, Please help me on this issue. Please refer the attached file. In file, I need time at other countries depending on the time in Mumbai. Time difference is mentioned in the sheet. Please help me by providing answer/vba code. Thanks Mangesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.comhttp://in.mc1926.mail.yahoo.com/mc/compose?to=excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss
Re: $$Excel-Macros$$ How to get sheet name with formula
Try it, =MID(CELL(filename),FIND(],CELL(filename))+1,LEN(CELL(filename))) On Mon, May 14, 2012 at 4:16 AM, hilary lomotey resp...@gmail.com wrote: the name of the current sheet into one of the cells -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ How to get sheet name with formula
Hi, It can be VBA Try below code, Sub ShNmeChng() Dim nme As String nme = InputBox(Enter sheet name here...) ActiveSheet.Name = nme End Sub Regards, MARIES. On Mon, May 14, 2012 at 4:27 AM, hilary lomotey resp...@gmail.com wrote: EXCELLENT IT WORKED but i guess u cant change the sheet name with a formula On Mon, May 14, 2012 at 11:23 AM, Maries talk2mar...@gmail.com wrote: Try it, =MID(CELL(filename),FIND(],CELL(filename))+1,LEN(CELL(filename))) On Mon, May 14, 2012 at 4:16 AM, hilary lomotey resp...@gmail.comwrote: the name of the current sheet into one of the cells -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Require total timing
Hi, Try this formula,* =TEXT(B2-A2,[h]:mm:ss)* * * * * On Mon, May 14, 2012 at 9:40 PM, Seraj Alam seraj.ala...@gmail.com wrote: Hi Expert, I have attached sheet in which I need total time taken in column C, I have applied formula but its not working properly. So please help me on this one. -- Thanks Regards Seraj Alam *+91 989 130 1776* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ hii i need copy a row to another based on condition
*Can you share sample file with details* On Sun, May 13, 2012 at 9:35 PM, coolguy ashokrenga2...@gmail.com wrote: Hiii i need a help .. i have an excel sheet which changes dyamically and gives the word BUY in a cell C3 when C3 = buy i need to copy the values A3 B3 and D3 to another sheet .. ( like a call generate page) and also a pop up alert when there is a buy condition i need this for tracking nifty 50 stocks thankyou -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ urgent - Please Help _Urgent
Hi, Try this formula in F16. =IFERROR(INDEX(F$5:F$8,MATCH(1,($A$5:$A$8=$A16)*(F$5:F$8),0)),) Apply with Ctrl+Shift+Enter Regards, MARIES. On Thu, May 10, 2012 at 11:14 AM, Surendra Singh surendra.si...@in.aegisglobal.com wrote: ** Dear Group, Please help me, please provide the formula for the attach file, If any employee moved from one department to any other dept. I have to make a separate entry in the sheet, but for the payroll prospective I have to consolidate the complete attendance in a single row. please make some formula for this. Regards, Surendra +91 9584266415 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Solution.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Round off function query
Try it, *=INT(A1)+1 * On Thu, May 10, 2012 at 2:38 PM, Ashish Bhalara ashishbhalar...@gmail.comwrote: Dear expert, The function Round(value,0) display result i.e. 125.55 to 126 and 125.45 to 125. My result: If the value 125.55 or 125.45 or 125.01 or 125.99 then output is 126 In short if value contain any decimal point greater or equal to .01, the value should be add 1 value. Kindly know me how this possible. Thanks regards. Ashish Bhalara 9624111822 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Round off function query
*=ROUNDUP(A1,0.1) * On Thu, May 10, 2012 at 2:55 PM, Deepak Rawat deepakexce...@gmail.comwrote: =ROUND(E12,0) Regards, Deepak Rawat On Thu, May 10, 2012 at 5:08 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear expert, The function Round(value,0) display result i.e. 125.55 to 126 and 125.45 to 125. My result: If the value 125.55 or 125.45 or 125.01 or 125.99 then output is 126 In short if value contain any decimal point greater or equal to .01, the value should be add 1 value. Kindly know me how this possible. Thanks regards. Ashish Bhalara 9624111822 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ office stock-help
Hi, Try below codes, Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Or Target.Column 2 Then Exit Sub If Target.Value = Opening Stock Then Target.Offset(0, 3) = =VLOOKUP(RC[-1],'Closing St n Utlzn-Apr 2012'!R2C1:R65C3,3,FALSE) Else Target.Offset(0, 3) = End If End Sub Regards, MARIES. On Tue, May 8, 2012 at 10:40 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, PFA the statement with the formula as mentioned in the below mail. But if the particulars is selected Purchase /Issue other than Opening Stock , the qty is not changing. Please help. On Wed, May 9, 2012 at 10:53 AM, Maries talk2mar...@gmail.com wrote: HI, Try Vlookup for bring closing datas... =VLOOKUP(D2,'Closing St n Utlzn-Apr 2012'!$A$2:$C$65,3,FALSE) Regards, MARIES. On Tue, May 8, 2012 at 9:31 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, PFA the attachment. Office stock consumption statement is attached where I need the help on solving the explained below: .. I need the closing stock of the relevant items from the other work sheet 'closing st n Utlzn-Apr 2012' in the column 'Qty' of the work sheet 'May 2012' if the particulars is selected as Opening stock in the same work sheet and if its selected as Purchase or issue, I have to manually enter the quantity -- Please help at the earliest. Thanks Regards Smitha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Office Stock Test.xlsm Description: Binary data
Re: $$Excel-Macros$$ Table data fit the page size..(auto)
Hi, Try below codes, Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.ScreenUpdating = False With Worksheets(1).PageSetup .LeftMargin = Application.InchesToPoints(0.05) .RightMargin = Application.InchesToPoints(0.05) .TopMargin = Application.InchesToPoints(0.05) .BottomMargin = Application.InchesToPoints(0.05) .HeaderMargin = Application.InchesToPoints(0.05) .FooterMargin = Application.InchesToPoints(0.05) *.Zoom = 150* *.CenterHorizontally = True* End With Application.ScreenUpdating = True End Sub On Tue, May 8, 2012 at 9:32 PM, Mohammed Muneer mmun...@ccc.com.qa wrote: Ya, but it doesn’t zoom to the margin, and fit all the four sides. ** ** ** ** Regards, Muneer, CC…. ** ** ** ** ** ** ** ** I see you already have it fit to page when printed - ** ** Do you mean you want to have the table forced into the shape of the page to completely fill the page? ** ** If so, I think you will need a macro, and it could be a bit tricky. ** ** You currently have a macro adjusting the margins in the Worksheet.SelectionChange event -- that will slow your worksheet down -- there is no need to reset the margins every time the cursor moves. It should be enough to just set them once in the Page Setup dialog, but if you want to reset them with a macro, use Worksheet.Activate or Workbook.BeforePrint (in Workbook.BeforePrint you might check if the worksheet is in ActiveWindow.SelectedSheets to determine if it is one being printed -- if needed -- it should be reliable in most cases). ** ** To resize the table, I would use the Page Setup oftion to Fit to 1 Page TALL, and leave the Fit to pages wide blank. This will only scale the table automatically to fit based on length, and take up as many pages wide as required. Then in your macro adjust the column widths to makke it fit on the one page. I am not experienced with this, so I will leave the details for you or others, unless I find the time to experiment with it.** ** ** ** Asa ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mohammed Muneer *Sent:* Monday, May 07, 2012 11:02 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Table data fit the page size..(auto) ** ** Dear friends, ** ** I want the Table margin fit the page size – by equally grow to all the four sides irrespective of the data consistency. ** ** ** ** ** ** Regards, Muneer, CC… -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and
Re: $$Excel-Macros$$ office stock-help
I think MACRO IS NOT ENABLED. When you open file, Security warning show under Ribbon. Click options == Select Enable this content == Press ok. Try now... On Wed, May 9, 2012 at 11:57 AM, Smitha S R sperdwo...@gmail.com wrote: Hi, Below mentioned code is not working. Even if I select Opening Stock, Purchase or Issue option qty is same. On Wed, May 9, 2012 at 11:44 AM, Maries talk2mar...@gmail.com wrote: Hi, Try below codes, Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Or Target.Column 2 Then Exit Sub If Target.Value = Opening Stock Then Target.Offset(0, 3) = =VLOOKUP(RC[-1],'Closing St n Utlzn-Apr 2012'!R2C1:R65C3,3,FALSE) Else Target.Offset(0, 3) = End If End Sub Regards, MARIES. On Tue, May 8, 2012 at 10:40 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, PFA the statement with the formula as mentioned in the below mail. But if the particulars is selected Purchase /Issue other than Opening Stock , the qty is not changing. Please help. On Wed, May 9, 2012 at 10:53 AM, Maries talk2mar...@gmail.com wrote: HI, Try Vlookup for bring closing datas... =VLOOKUP(D2,'Closing St n Utlzn-Apr 2012'!$A$2:$C$65,3,FALSE) Regards, MARIES. On Tue, May 8, 2012 at 9:31 PM, Smitha S R sperdwo...@gmail.comwrote: Hi, PFA the attachment. Office stock consumption statement is attached where I need the help on solving the explained below: .. I need the closing stock of the relevant items from the other work sheet 'closing st n Utlzn-Apr 2012' in the column 'Qty' of the work sheet 'May 2012' if the particulars is selected as Opening stock in the same work sheet and if its selected as Purchase or issue, I have to manually enter the quantity -- Please help at the earliest. Thanks Regards Smitha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever
Re: $$Excel-Macros$$ office stock-help
HI, Try Vlookup for bring closing datas... =VLOOKUP(D2,'Closing St n Utlzn-Apr 2012'!$A$2:$C$65,3,FALSE) Regards, MARIES. On Tue, May 8, 2012 at 9:31 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, PFA the attachment. Office stock consumption statement is attached where I need the help on solving the explained below: .. I need the closing stock of the relevant items from the other work sheet 'closing st n Utlzn-Apr 2012' in the column 'Qty' of the work sheet 'May 2012' if the particulars is selected as Opening stock in the same work sheet and if its selected as Purchase or issue, I have to manually enter the quantity -- Please help at the earliest. Thanks Regards Smitha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Office Stock Test.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Macro required to add demand to substitution part and zero out the original one, see attachment.
Hi Tony, I have done by formula... Just check the sheets cells. There is no Macro codes inside. Regards, MARIES. On Mon, May 7, 2012 at 5:13 PM, Tony Wu wumu...@gmail.com wrote: Sorry ... I didn;t see the Macro in the attachment. thanks, Tony On Saturday, May 5, 2012 9:23:46 AM UTC-4, Maries wrote: Hi, Check the attachment. Regards, MARIES. On Fri, May 4, 2012 at 12:27 PM, Tony Wu wumu...@gmail.com wrote: Hello, I have a file for the forecast demand, some parts have substitution, what I need is if the part has substitution, the original demand will be added to the new part and original demand will be zero out, please see the attached file for reference. Thanks, Tony -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --**--** --** To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Formula required for finding Consumption value for giving cons. Qty.
*Can you explain more about FIFO calculation.* On Fri, May 4, 2012 at 8:19 PM, B Sharma sharma@gmail.com wrote: Dear Friends and excel experts,, I have a sheet in which there are columns like QtyRate of purchase of items, In Another sheet I need a formula for auto calculation of consumption value of goods for the given quantity in FIFO method (First In First Out) I have tried all my known tricks, but failed.. Please help. Thanks Regards, BS -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Formula required for finding Consumption value for giving cons. Qty.
Revised... On Sun, May 6, 2012 at 12:19 AM, Maries talk2mar...@gmail.com wrote: Hi, Find the attachment I hope this fulfill your requirements Regards, MAIRES. On Sat, May 5, 2012 at 11:37 PM, BS CTC sharma@gmail.com wrote: FIFO calculation means calculation on the basis of First In First Out.** ** ** ** In a year we purchase goods on different rates, For Example ** ** In April I purchased 10 Pcs @ Rs. 5.00 In May I purchased 5 Pcs @ Rs. 6.00 In June I purchased 8 Pcs @ Rs. 5.50 ** ** So when I will put the consumption for the months it will calculate the consumption value on the basis of FIFO For Example In April Consumed 7 Pcs @ Rs. 5/- Value Rs. 35/- (Apr Purchase) In May Consumed 8 Pcs @ 5.625/- Value Rs. 45/- (3Pcs x Rs. 5/- Apr Pur) + (5Pcs x Rs. 6/- May Pur) ** ** Hope you understand the calculation. The closing value of stock will be calculated on the Balance Quantity (@ of last purchase rate) ** ** Thanks Regards, BS ** ** ** ** ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Maries *Sent:* Sun, 06-May-2012 11:46 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Formula required for finding Consumption value for giving cons. Qty. ** ** *Can you explain more about FIFO calculation.* On Fri, May 4, 2012 at 8:19 PM, B Sharma sharma@gmail.com wrote:*** * Dear Friends and excel experts,, ** ** I have a sheet in which there are columns like QtyRate of purchase of items, In Another sheet I need a formula for auto calculation of consumption value of goods for the given quantity in FIFO method (First In First Out) ** ** I have tried all my known tricks, but failed.. ** ** Please help. ** ** Thanks Regards, BS -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good
Re: $$Excel-Macros$$ Need macro website
Hi, Check below link, http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm Regards, MARIES. On Sat, May 5, 2012 at 4:41 AM, karthik N n.karthi...@gmail.com wrote: Hi Friends, How learn the macro's in step by step,kindly provide the any macro tutorial website Pls Help Regards karthik.N -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012
*Congrats Brother.* On Wed, May 2, 2012 at 8:15 PM, xlstime xlst...@gmail.com wrote: Congratulation Rajan On Wed, May 2, 2012 at 9:30 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of April'2012 He has posted 185 posts in April 2012 and helped many people through his expertise. He has been consistent contributor to this excel forum and has acheived this recognition many times. Thanks to Don, Noorain, Asa, Maries, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ If condition problem
*Can you show sample OUTPUT in another column...* * * On Sat, Apr 21, 2012 at 1:16 AM, Ashish Bhalara ashishbhalar...@gmail.comwrote: Dear sir, I want to write the cell address to fulfill formula, is there any solution for it? Ashish On Sat, Apr 21, 2012 at 12:29 PM, Waseem Saifi waseemsa...@gmail.comwrote: I hope this will help You Ashish. On Fri, Apr 20, 2012 at 11:46 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear expert, I use date in if formula but not work in attached file, please know me the my mistake. Thanks regards Ashisih Bhalara -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Need help
Hi, Try this formula, =CEILING(ROW()/11,1) On Wed, Apr 18, 2012 at 1:36 AM, Krishnaraddi excelkris...@in.com wrote: Hi Experts, I have attached the sheet with question. I require formula which will give number to repeat 11 times and 12th numer should be next serial number which should reeat again 11 times. Dear *excel-macros!* Get Yourself a cool, short *@in.com* Email ID now!http://www3.in.com/sso/commonregister.php?ref=INutm_source=inviteutm_medium=outgoing -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com 11.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Disable Ctrl+D
Hi, Try it, Private Sub Workbook_Open() Application.OnKey ^d, End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.OnKey ^d End Sub On Tue, Apr 17, 2012 at 3:36 AM, muralidhar e emuralidha...@gmail.comwrote: hi, anil Iam not understand, if u not feel can u explain it. *Iam what i need is simply is.* iam need not want Ctrl+D option and it disable in my worksheet. if i suppose to use the Ctrl+D option i need a passward when i am using the Ctrl+D. Thanks Muralidhar E On Tue, Apr 17, 2012 at 3:11 PM, anil panchal anil.kan...@gmail.comwrote: Hi Please Use alt + ctrl + L then Ctrl D On Tue, Apr 17, 2012 at 3:07 PM, muralidhar e emuralidha...@gmail.comwrote: hi dear group members, Good afternoon Iam using excel-2007 2010, with a huge data, with this when iam suppose to use Ctrl+F for find the batches by overlook when iam pressing ctrl+F iam pressing Ctrl+D. In this case the data is changing. I want to disable the Ctl+D option, and if i want to suppose to use the Crl+D option i need a passward. Thanks in Advance. -- *Thanks Regards,* ** *Muralidhar E.* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks Regards Anil Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Thanks Regards,* ** *Muralidhar E.* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Shortcut Disable.xlsm Description: Binary data
Re: $$Excel-Macros$$ HOT LIST OF INFOTARGETS
** On Tue, Apr 17, 2012 at 11:00 PM, kevin pietersen resumeske...@gmail.comwrote: infotargets.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Time Calcuation
Hi, Try it, =TEXT((B5-INT(B5))+(C5-INT(C5)),[h]:mm:ss) On Mon, Apr 16, 2012 at 10:50 AM, anil panchal anil.kan...@gmail.comwrote: TEXT(B5+C5,[h]:mm:ss) -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Time Calcuation
*PFA...* On Mon, Apr 16, 2012 at 11:04 AM, Maries talk2mar...@gmail.com wrote: Hi, Try it, =TEXT((B5-INT(B5))+(C5-INT(C5)),[h]:mm:ss) On Mon, Apr 16, 2012 at 10:50 AM, anil panchal anil.kan...@gmail.comwrote: TEXT(B5+C5,[h]:mm:ss) -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Test.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Quarter Classification
Hi Anil,
Its very good formula made by Mr.Haseeb. 29 is used to pick the dates.
check below,
[image: Inline image 1]
like 28,30 also can use.
Regards,
MARIES.
On Mon, Apr 16, 2012 at 11:25 AM, anil panchal anil.kan...@gmail.comwrote:
Dear All,
Why Use *29???
=TEXT(LOOKUP(MONTH(A2),{1,4,7,10})*29,)
Thanks Regards
Anil Kumar
113784
On Mon, Apr 16, 2012 at 11:36 AM, Haseeb A
haseeb.avarak...@gmail.comwrote:
Nikhil, One way:
Assume date is in A2. So
In B2 for the Curr Quarter.
=TEXT(LOOKUP(MONTH(A2),{1,4,7,10})*29,)
Then in C2
=TEXT((1B2)+99,)
Copy across to E2.
See the attached.
___
HTH, Haseeb
nikhil wrote:
Now answer is right ,
i.e. Date 01/05/2010 ( DD/MM/ ) Format ,
Currently it's showing Curr.Qtr = April ; Next Qtr = July ..it is ok
After July , Now I want Next Qtr = October ; Next Qtr = January
Nikhil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Thanks Regards
Anil Kumar
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
123.JPG
Re: $$Excel-Macros$$ inventory in excel
Hi, Check these links... http://www.excelmagic.com/inventorymagic.html http://www.excel-skills.com/excel_templates.asp#InventoryUsage On Mon, Apr 16, 2012 at 6:22 PM, raghu gr balaji.bra...@gmail.com wrote: hi, how to maintain inventory in excel. if any one have samples pls let me know Thank you with regards Raghu -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Stock position - Reg
Hi, Find the attachment... On Sun, Apr 15, 2012 at 10:27 AM, jmothilal gjmothi...@gmail.com wrote: PURCHASE / SALES ITEM QTY STOCK P LG DVD WRITER 1 1 P LG DVD WRITER 5 6 S LG DVD WRITER 1 5 P LG DVD WRITER 1 6 P LG DVD WRITER 10 16 S LG DVD WRITER 4 12 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Test.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Pivot table
Hi, Try this formula, =B4/OFFSET($A$3,COUNTA(A:A)-1,2) Regards, MARIES. On Sun, Apr 15, 2012 at 10:20 PM, Sara Lee lee.sar...@gmail.com wrote: i have created a pivot table in excel in sheet 4 out of sheet 1 data. Now i have added a calculation column - right most column of the pivot... now when i delete the row of the data in sheet 1 say mumbai row, and then refresh the pivot... then the last column gets messed up showing div/0 error is therer any way to correct that last column formula in the pivot so that it updates itself when data is refresehed. thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Pivot Calculation.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Pivot table
Hi, In that case, Dynamic range is good solution. I have used Name Range rng refers as*=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1)) * Regards, MARIES.* * On Mon, Apr 16, 2012 at 12:14 AM, Sara Lee lee.sar...@gmail.com wrote: thanks it is good but one change required--- when i add more records into my base sheet , and then refresh the pivot, that column % does not get updated automatically;; also when i delete records, that column shows up 0 even though there are no records to left On Sun, Apr 15, 2012 at 3:41 PM, Maries talk2mar...@gmail.com wrote: Hi, Try this formula, =B4/OFFSET($A$3,COUNTA(A:A)-1,2) Regards, MARIES. On Sun, Apr 15, 2012 at 10:20 PM, Sara Lee lee.sar...@gmail.com wrote: i have created a pivot table in excel in sheet 4 out of sheet 1 data. Now i have added a calculation column - right most column of the pivot... now when i delete the row of the data in sheet 1 say mumbai row, and then refresh the pivot... then the last column gets messed up showing div/0 error is therer any way to correct that last column formula in the pivot so that it updates itself when data is refresehed. thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Pivot Calculation.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Pivot table
Hi, To get the percentage, *Copy paste* or *Drag Down* the formula from * Sheet1-D4*. On Mon, Apr 16, 2012 at 1:10 AM, Sara Lee lee.sar...@gmail.com wrote: Hi So do i have to copy and paste this formula? On Sun, Apr 15, 2012 at 4:32 PM, Maries talk2mar...@gmail.com wrote: Hi, In that case, Dynamic range is good solution. I have used Name Range rng refers as*=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1)) * Regards, MARIES. * * On Mon, Apr 16, 2012 at 12:14 AM, Sara Lee lee.sar...@gmail.com wrote: thanks it is good but one change required--- when i add more records into my base sheet , and then refresh the pivot, that column % does not get updated automatically;; also when i delete records, that column shows up 0 even though there are no records to left On Sun, Apr 15, 2012 at 3:41 PM, Maries talk2mar...@gmail.com wrote: Hi, Try this formula, =B4/OFFSET($A$3,COUNTA(A:A)-1,2) Regards, MARIES. On Sun, Apr 15, 2012 at 10:20 PM, Sara Lee lee.sar...@gmail.comwrote: i have created a pivot table in excel in sheet 4 out of sheet 1 data. Now i have added a calculation column - right most column of the pivot... now when i delete the row of the data in sheet 1 say mumbai row, and then refresh the pivot... then the last column gets messed up showing div/0 error is therer any way to correct that last column formula in the pivot so that it updates itself when data is refresehed. thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED
Re: $$Excel-Macros$$ Quarter Classification
Hi,
Try it,
=VLOOKUP(MONTH(TEXT(A1,)1),{11,January;12,January;1,January;2,April;3,April;4,April;5,July;6,July;7,July;8,October;9,October;10,October},2,FALSE)
Regards,
MARIES.
On Sat, Apr 14, 2012 at 11:38 AM, Nikhil Shah nikhil201...@gmail.comwrote:
Dear Friends,
I want to make the whole year classified in to 4 quarters as January,
April, July and October.
As and when I give a date it should be grouping in to that particular
quarter only,( the date may be random) and one more thing that the very
next Quarter will be taken for the name printing and followed by next
remaining quarters.
Ex : [ 1 ]. If I give a date - 16/08/2009 (dd/mm/) the whole process
will be like , Quarter grouping as 3rd Quarter as July Quarter and out put
name will be printed as October ( the very next Quarter) then followed by
Jan, April, and July.
Ex : [ 2 ]. Date.15/12/2010 (dd/mm/) Quarter will be - October
and the print will be January, April, July and October
Ex : [ 3 ] . Date.22/03/2011 (dd/mm/) Quarter will be -
January and the print will be April,July and October and January.
Ex : [ 4 ]. Date.15/10/2008 (dd/mm/) Quarter will be - October and
the print will be January, April,July and october
I am using Excel 2003. I do want any Macro , I want Only Formula
Awaiting Reply
Nikhil Shah
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
Nikhil.xls
Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Quarter Classification
Hi,
Previous one shows the next quarter.
Try below for previous quarter month,
=VLOOKUP(MONTH(TEXT(A1,)1),{1,January;2,January;3,January;4,April;5,April;6,April;7,July;8,July;9,July;10,October;11,October;12,October},2,FALSE)
Regards,
MARIES.
On Sat, Apr 14, 2012 at 11:53 AM, Maries talk2mar...@gmail.com wrote:
Hi,
Try it,
=VLOOKUP(MONTH(TEXT(A1,)1),{11,January;12,January;1,January;2,April;3,April;4,April;5,July;6,July;7,July;8,October;9,October;10,October},2,FALSE)
Regards,
MARIES.
On Sat, Apr 14, 2012 at 11:38 AM, Nikhil Shah nikhil201...@gmail.comwrote:
Dear Friends,
I want to make the whole year classified in to 4 quarters as January,
April, July and October.
As and when I give a date it should be grouping in to that particular
quarter only,( the date may be random) and one more thing that the very
next Quarter will be taken for the name printing and followed by next
remaining quarters.
Ex : [ 1 ]. If I give a date - 16/08/2009 (dd/mm/) the whole process
will be like , Quarter grouping as 3rd Quarter as July Quarter and out put
name will be printed as October ( the very next Quarter) then followed by
Jan, April, and July.
Ex : [ 2 ]. Date.15/12/2010 (dd/mm/) Quarter will be - October
and the print will be January, April, July and October
Ex : [ 3 ] . Date.22/03/2011 (dd/mm/) Quarter will be -
January and the print will be April,July and October and January.
Ex : [ 4 ]. Date.15/10/2008 (dd/mm/) Quarter will be -
October and the print will be January, April,July and october
I am using Excel 2003. I do want any Macro , I want Only Formula
Awaiting Reply
Nikhil Shah
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett
*Congrats DON... * On Sat, Apr 14, 2012 at 12:43 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Congrats DON ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain *Sent:* Apr/Sat/2012 02:06 *To:* excel-macros *Subject:* $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett** ** ** ** Dear members, Don Guillett has been selected as 'Most Helpful Member' for the month of March'12 He has been helping forum members from long time consistently and we are proud to have him in the forum. He is business degree holder from University of Texas and retired Regional Manager for ING. Don, Many Many Thanks for your great contribution to forum. Keep Posting !! Best regards, Ayush Jain Group Manager, Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Prefix a pic in the userform caption
http://www.pivot-table.com/excel-pivot-tables/excel-pivot-table-keyboard-shortcuts http://office.microsoft.com/en-us/excel-help/basic-keyboard-shortcuts-2-32-RZ102673162.aspx?section=3 http://office.microsoft.com/en-us/excel-help/keyboard-shortcuts-in-excel-2010-HP010342494.aspx On Thu, Apr 12, 2012 at 6:46 PM, venus vikramahuj...@gmail.com wrote: hi please provide shortcuts related to pivot tables and shortcut for converting sheet details in numbers via keyboard. On Apr 4, 2012 4:18 AM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hi Group, I want to prefix a picture in the userform caption in excel. Would request to help me with that. -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Unique count for a date between range
Hi, Consider, Dates Range is A1:A10, Try this array formula, (Apply with Ctrl+Shift+Enter) =SUM(--(COUNTIF(A1:A10,A1:A10)=1)) Regards, MARIES. On Tue, Apr 10, 2012 at 8:07 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Dear All, ** ** Please help to calculate unique count for a date for a date range. ** ** Best Regards, Amit ** ** -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Access..
Hi, Check below links Very Useful... MVP'S Web Links Al Campagna http://home.comcast.net/~cccsolutions/index.html Alex Dybenko http://Alex.Dybenko.com http://alex.dybenko.com/ Allen Browne http://allenbrowne.com Andrew Couch http://www.upsizing.co.uk Andy Baron http://www.mcwtech.com/ Arvin Meyer http://www.datastrat.com Bill Mosca http://www.thatlldoit.com Bob Larson http://www.btabdevelopment.com Crystal http://www.accessmvp.com/Strive4Peace D. C. Conlin http://www.Access.QBuilt.com http://www.access.qbuilt.com/ Daniel Pineault http://www.cardaconsultants.com/ Dev Ashish http://www.mvps.org/access Doug Steele http://www.accessmvp.com/DJSteele Emilio Sancha http://www.mvp-access.es/emilio Francisco Javier García Aguado http://accessbuho.mvps.org/ Graham Mandeno http://www.mandeno.com/ Graham R. Seach http://www.pacificdb.com.au Gunter Avenius http://www.accessribbon.com Gustavo Delucchi http://www.delucchimdb.com.ar Henry Habermacher http://www.psp-online.com Jeff Conrad http://www.accessmvp.com/JConrad/accessjunkie.html Jim Ferguson http://www.fmsinc.com/ Joan Wild http://www.jmwild.com John Viescas http://www.viescas.com/ José Bengoechea Ibaceta http://jbengoechea.com/ Juan M. Afan de Ribera http://accessvbafaq.mvps.org Karl Donaubauer http://www.donkarl.com Ken Getz http://www.mcwtech.com/ Ken Snell http://www.accessmvp.com/KDSnell/ Klaus Oberdalhoff http://www.sql-insider.de Lynn Trapp http://www.ltcomputerdesigns.com M.L. Sco Scofield http://www.ScoBiz.com http://www.scobiz.com/ Mary Chipman http://www.mcwtech.com/ Michael S. Kaplan http://www.trigeminal.com/ Mike Gunderloy http://www.mcwtech.com/ Olaf Rabbachin http://www.resources.intuidev.com Oliver Stohr http://www.access-freak.com Patrick Wood http://gainingaccess.net Paul Litwin http://www.mcwtech.com/ Philipp Stiefel http://www.codekabinett.de/ Rafael Andrada Cortina http://www.mcpegasus.net Roger Carlson http://www.rogersaccesslibrary.com Sandra Daigle http://www.daiglenet.com/msaccess.htm Simon Lewis http://www.btinternet.com/~srlewis Stephen Lebans http://www.lebans.com Steve Arbaugh http://www.groupacg.com/ Steve Clark http://www.fmsinc.com Steve Schapel http://www.datamanagementsolutions.biz Teresa Hennig http://www.DataDynamicsNW.com http://www.datadynamicsnw.com/ Terry Kreft http://www.mps.co.uk/mps/ Thomas Möller http://www.Team-Moeller.dehttp://www.team-moeller.de/ Tony Toews http://www.granite.ab.ca Regards, MARIES. On Sun, Apr 8, 2012 at 5:03 PM, Rajan_Verma rajanverma1...@gmail.comwrote: You can find sql queries on that link , please check this link ** ** http://www.functionx.com/vbaccess/ ** ** Rajan ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *vijayajith VA *Sent:* Apr/Sun/2012 06:30 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Access.. ** ** Hi . Raj ** ** I am not able to find ACCESS in that link.Thanks On Sun, Apr 8, 2012 at 6:25 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Try this : http://www.w3schools.com/ Rajan. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *vijayajith VA *Sent:* Apr/Sun/2012 06:23 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Access.. Hi All, Can you provide me MS ACCESS. LINKS(WEBSITES).Thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential
Re: $$Excel-Macros$$ Editing text in an unlocked cell of a protected sheet
*Can you share your file...* On Sun, Apr 8, 2012 at 4:18 AM, David davidjad...@gmail.com wrote: I'm looking for assistance in fixing a problem a user found. I have a form created in Excel 2010. All cells on the form were locked - then specific cells were unlocked. This allowed the users to only modify the 'blank' fields in the form. The worksheet was then protected using Protect Sheet button in the Review tab. The only option selected under the Allow all users of this worksheet to: is Select Unlocked Cells.(Although I have also tried checking the Format Cells option too with the same outcome.) The worksheet is protected and users are only allowed to enter text into the appropriate cells/fields as I intended. However, if a user wants to go back and edit something that was already typed in, they are unable to do so. Normally, you would see the text in the formula bar to edit, or double-click and edit. Neither option is available. There are a couple cells where users may type in several sentances. If they try to go back to correct/add/edit all text in that cell deletes as soon as one character is typed. Truly not friendly to the users. What option did I miss? Help!! David - Kansas City -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$
? On Sat, Apr 7, 2012 at 9:48 AM, Rajan_Verma rajanverma1...@gmail.comwrote: Do you need any assistance ?? ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Atef Gobran *Sent:* Apr/Sat/2012 06:35 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ ** ** font size=7img src= http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/39.gif;strong@@/strong strongfont style=BACKGROUND-COLOR:#ffbf80; face=comic sans ms color=#4040ffDr. Atef Gobran/font/strong strong@@/strongimg src= http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/39.gif;/font -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Leave tracker
Hi, PFA. Change A1. You will get answer for any months. Regards, MARIES. On Sun, Apr 8, 2012 at 12:34 AM, Rajan_Verma rajanverma1...@gmail.comwrote: Pivot will work for huge data also.. and if you are talking about formula ,with large data it can be cause to make your processing slow, macro can be a option. Rajan *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *santosh subudhi *Sent:* Apr/Sun/2012 02:02 *To:* excel-macros@googlegroups.com *Subject:* RE: $$Excel-Macros$$ Leave tracker ** ** Hi Rajan, ** ** The pivot option is possible when the team size is very less. I have a very big team and need a formula to fix this. ** ** Is there any way to fix a formula. ** ** Regards Santosh Kumar Subudhi ** ** From: rajanverma1...@gmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Leave tracker Date: Sun, 8 Apr 2012 01:50:54 +0530 Pivot table can be useful here… See the attached sheet Rajan. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *santosh subudhi *Sent:* Apr/Sun/2012 01:05 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Leave tracker Hi Group, Attached is a sample excel tracker in which the leaves taken by every employee is entered in a single sheet (Data). Now this is data has to split-ted in to respective months with the count type . Some Sample data is entered for the month of April12 for easy reference. -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal
Re: $$Excel-Macros$$ Leave tracker
Hi,
As Don explained, I have used Array Formulas.
Check below link for more details,
http://www.excelfunctions.net/Excel-Array-Formulas.html
Regards,
MARIES.
On Sun, Apr 8, 2012 at 1:50 AM, dguillett1 dguille...@gmail.com wrote:
If you mean { } this is because it is an array formula where you do
NOT put in the brackets. You save or change the formula using
ctrl+shift+enter instead of just enter.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* santosh subudhi santoshkumar.subu...@gmail.com
*Sent:* Saturday, April 07, 2012 4:15 PM
*To:* excel-macros@googlegroups.com
*Subject:* RE: $$Excel-Macros$$ Leave tracker
Hi Maries,
Thank you for quick resolution.
I have a small query I found { } brackets in your formula,can you just
help me in understanding when to use these brackets.
Regards
Santosh Kumar Subudhi
Hi,
PFA. Change A1. You will get answer for any months.
Regards,
MARIES.
On Sun, Apr 8, 2012 at 12:34 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
Pivot will work for huge data also.. and if you are talking about
formula ,with large data it can be cause to make your processing slow,
macro can be a option.
Rajan
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *santosh subudhi
*Sent:* Apr/Sun/2012 02:02
*To:* excel-macros@googlegroups.com
*Subject:* RE: $$Excel-Macros$$ Leave tracker
Hi Rajan,
The pivot option is possible when the team size is very less. I have a
very big team and need a formula to fix this.
Is there any way to fix a formula.
Regards
Santosh Kumar Subudhi
From: rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Leave tracker
Date: Sun, 8 Apr 2012 01:50:54 +0530
Pivot table can be useful here…
See the attached sheet
Rajan.
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *santosh subudhi
*Sent:* Apr/Sun/2012 01:05
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Leave tracker
Hi Group,
Attached is a sample excel tracker in which the leaves taken by every
employee is entered in a single sheet (Data).
Now this is data has to split-ted in to respective months with the count
type .
Some Sample data is entered for the month of April12 for easy reference.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal
Re: $$Excel-Macros$$ to remove time
*Try it, =TEXT(INT(A1),DD/MM/)* On Thu, Apr 5, 2012 at 7:54 PM, vijayajith VA vijayajith...@gmail.comwrote: Hi , 12/2/2001 12:00 PM --- How to remove time ? i need only date .. is thr any formula ..Thanks in advance -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ V LOOKUP PROBLEM
No need Value formula, It can do it, =SUMIF($C$2:$C$113,A2,$D$2:$D$113) On Fri, Apr 6, 2012 at 12:51 AM, Maries talk2mar...@gmail.com wrote: Hi, Try below formula, =SUMIF($C$2:$C$113,VALUE(A2),$D$2:$D$113) Regards, MARIES. On Thu, Apr 5, 2012 at 11:20 PM, Munir Ahmad munnu130134...@gmail.comwrote: Hi Group, please help Regards, munnu. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ how to clear all but the header row efficiently
Try it, Sheets(Results).Cells.ClearContents On Fri, Apr 6, 2012 at 3:29 AM, tangledweb domainqu...@gmail.com wrote: Results -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ how to clear all but the header row efficiently
*Sheets(Results).Range(A2:A ActiveSheet.UsedRange.Rows.Count).Clear* On Fri, Apr 6, 2012 at 3:36 AM, Maries talk2mar...@gmail.com wrote: Try it, Sheets(Results).Cells.ClearContents On Fri, Apr 6, 2012 at 3:29 AM, tangledweb domainqu...@gmail.com wrote: Results -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ how to clear all but the header row efficiently
Try it now,* Sheets(Results).Range(A2:A ActiveSheet.UsedRange.Rows.Count).Clear* On Fri, Apr 6, 2012 at 3:42 AM, Domain Admin domainqu...@gmail.com wrote: That clears the header row too. I need to keep that row intact. On Thu, Apr 5, 2012 at 4:36 PM, Maries talk2mar...@gmail.com wrote: Try it, Sheets(Results).Cells.ClearContents On Fri, Apr 6, 2012 at 3:29 AM, tangledweb domainqu...@gmail.com wrote: Results -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ how to clear all but the header row efficiently
For other columns, Sub Macro1() Sheets(Results).Range(A2:A ActiveSheet.UsedRange.Rows.Count).EntireRow.Clear End Sub On Fri, Apr 6, 2012 at 4:03 AM, Domain Admin domainqu...@gmail.com wrote: And would offset(0,1) mean skip the first column? On Thu, Apr 5, 2012 at 5:01 PM, Domain Admin domainqu...@gmail.com wrote: That works, thanks. How do you find out all the properties or functions or whatever of usedrange etc.? On Thu, Apr 5, 2012 at 4:47 PM, dguillett1 dguille...@gmail.com wrote: Should do it sub clearallbuttoprow() Sheets(Results).UsedRange.Offset(1).Clear End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: tangledweb Sent: Thursday, April 05, 2012 6:29 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ how to clear all but the header row efficiently Before running a program that puts the results onto a sheet I want to clear that sheet from the previous run. Easy to just clear a huge range, but really wanted to do it right and clear the used range. I tried to find a way to use the usedrange value but could not determine how to exclude the header row. I tried this where the activecell had been set to the first data element of the last column but the syntax is invalid. Sheets(Results).Range(a2:activecell.end(xldown).).Clear How can I accomplish this? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Extract desired data
Hi,
Try below array formula,
=MAX(IFERROR(RIGHT(C2,{1,2,3,4,5,6,7,8,9,10})*1,))
Apply with Ctrl + Shift + Enter.
Regards,
MARIES
On Wed, Apr 4, 2012 at 10:21 AM, Waseem Saifi waseemsa...@gmail.com wrote:
please check attached file.
On Wed, Apr 4, 2012 at 1:17 AM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Dear Group,
How to extract 6 digit numbers from right if its number convert this to
numbers by formula. See the attached file.
Regards,
Aamir Shahzad
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Excel functions (by category)
Dear Friends, Very Useful Link, http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HP010342656.aspx#BMcompatibility_functions Regards, MARIES. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ How to use subtotal in sumif formulae
*PFA...* On Wed, Apr 4, 2012 at 4:25 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Use only SUubtotal(109,rng_Sum) When you will apply filter it will sum only visible cells ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Muhammad Arslan *Sent:* Apr/Wed/2012 05:49 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ How to use subtotal in sumif formulae ** ** I am trying to use SUBTOTAL with a nested SUMIF like so =SUBTOTAL(109,(SUMIF(AB11:AB249,0,AB11:AB249)) I only want the sum_range to sum based on a filter, and thus the SUBTOTAL. I know this is not possible the way I have it , because it is not working, but is it possible some other way? If not, does anyone have a suggstion? Thank you Muhammad Arslan -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Negative Subtotal.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need assistance in finding formula to substitute the values to dates.
Thanks Rajan... On Wed, Apr 4, 2012 at 12:39 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Nice solution marries J ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Maries *Sent:* Apr/Wed/2012 10:20 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need assistance in finding formula to substitute the values to dates. ** ** Hi, PFA. Use below Array formula, =IFERROR(INDEX($B$4:$E$4,MATCH(B$9,OFFSET($A$4,MATCH($A10,$A$5:$A$7,0),1,1,4),0)),) Regards, MARIES. On Wed, Apr 4, 2012 at 7:16 AM, rekha siri rekha.siri2...@gmail.com wrote: Hi I need assistance in finding the right formula to substitute the value to dates in countif [image: Alexei De Guzman][image: Just Joined] *Alexei De Guzman https://thehub.thomsonreuters.com/people/0143599* Apr 3, 2012 9:03 PM Hi, I am trying to come up with the formula to pull up dates from a tracker for each individual. Example: *Name*** *April 1*** *April 2*** *April 3*** *April 4*** Alexei de Guzman VL Joseph Roxas SL Kelly Furio H *Name*** *VL*** *H*** *SL*** Alexei de Guzman April 1 Joseph Roxas April 3 So I am making a summary tracker that will break it down by dates for each name. I have tried using Countif for a particular value but I have been looking for a formula to come up to pull it up by dates. I hope someone already knows the answer. Thank you very much. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss
Re: $$Excel-Macros$$ How to use subtotal in sumif formulae
Hi Mohammed, Try Below Formula with Ctrl + Shift + Enter. =SUM((AB11:AB2490)*SUBTOTAL(109,INDIRECT(ABROW(11:249 Regards, MARIES. On Wed, Apr 4, 2012 at 5:20 PM, Maries talk2mar...@gmail.com wrote: *PFA...* On Wed, Apr 4, 2012 at 4:25 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Use only SUubtotal(109,rng_Sum) When you will apply filter it will sum only visible cells ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Muhammad Arslan *Sent:* Apr/Wed/2012 05:49 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ How to use subtotal in sumif formulae ** ** I am trying to use SUBTOTAL with a nested SUMIF like so =SUBTOTAL(109,(SUMIF(AB11:AB249,0,AB11:AB249)) I only want the sum_range to sum based on a filter, and thus the SUBTOTAL. I know this is not possible the way I have it , because it is not working, but is it possible some other way? If not, does anyone have a suggstion? Thank you Muhammad Arslan -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Revised.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need assistance in finding formula to substitute the values to dates.
Hi, PFA. Use below Array formula, =IFERROR(INDEX($B$4:$E$4,MATCH(B$9,OFFSET($A$4,MATCH($A10,$A$5:$A$7,0),1,1,4),0)),) Regards, MARIES. On Wed, Apr 4, 2012 at 7:16 AM, rekha siri rekha.siri2...@gmail.com wrote: Hi I need assistance in finding the right formula to substitute the value to dates in countif [image: Alexei De Guzman][image: Just Joined] *Alexei De Guzman https://thehub.thomsonreuters.com/people/0143599* Apr 3, 2012 9:03 PM Hi, I am trying to come up with the formula to pull up dates from a tracker for each individual. Example: *Name * *April 1 * *April 2 * *April 3* *April 4 * Alexei de Guzman VL Joseph Roxas SL Kelly Furio H *Name* *VL* *H* *SL* Alexei de Guzman April 1 Joseph Roxas April 3 So I am making a summary tracker that will break it down by dates for each name. I have tried using Countif for a particular value but I have been looking for a formula to come up to pull it up by dates. I hope someone already knows the answer. Thank you very much. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com SOLUTION.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ CONDITIONAL SUM
My Try,
Array formula, {=SUM(--(MONTH(Sheet1!A2:A7)=A1)*Sheet1!B2:B7)}
Regards,
MARIES.
On Mon, Apr 2, 2012 at 5:47 PM, dguillett1 dguille...@gmail.com wrote:
=sumproduct((month(sheet1!a2:a200)=a1)*sheet1!b2:b200
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Add-in creation in excel 2007
Hi Raj, Check below link, http://jackmcintyre.net/how-to-add-macros-to-the-excel-2007-ribbon/ Dear Friends, Anyone give more details about Custom UI Editor Toolhttp://openxmldeveloper.org/articles/CustomUIeditor.aspx. From above link, I came to know we required Custom UI Editor Toolhttp://openxmldeveloper.org/articles/CustomUIeditor.aspxfor customize the Ribbon. Regards, MARIES. On Mon, Apr 2, 2012 at 10:10 PM, Rajan_Verma rajanverma1...@gmail.comwrote: I think u should create custom menu to display that in Ribbon ** ** Rajan ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Raj Mahapatra *Sent:* Apr/Mon/2012 11:30 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Add-in creation in excel 2007 ** ** ** ** sam, how would i get that add in as a tab in ms excel Thanks Regards ** ** Rajesh Mahapatra ** ** ** ** On Mon, Apr 2, 2012 at 10:57 PM, Sam Mathai Chacko samde...@gmail.com wrote: Add-ins are designed to run in the background, and hence the file will not be visible when you open it. If you go to the VBE window, you could actually see that the vba project for your add-in is shown. Sam Mathai Chacko ** ** On Mon, Apr 2, 2012 at 10:50 PM, Raj Mahapatra rajafs...@gmail.com wrote: hi group, ** ** i wants to create addin in excel. i have created a addin using below steps, but it is not working. ** ** 1. in new workbook, i have insert a module and macro codes in it. 2. then saved the same workbook using .xlam extension. 3. when i opens the same add in in new excel. it does not open. ** ** appreciation for your assistance. ** ** thanks regards ** ** Rajesh Mahapatra -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive
Re: $$Excel-Macros$$ Re: format a cell
Hi Haseeb, Great Solution... On Mon, Apr 2, 2012 at 1:54 AM, pawel lupinski lupins...@yahoo.com wrote: Hi Again, Thanks again, it's all working, I have a lot to learn what is great, you've shown me the magic. thanks Pawel -- *From:* pawel lupinski lupins...@yahoo.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com *Sent:* Sunday, April 1, 2012 10:45 PM *Subject:* Re: $$Excel-Macros$$ Re: format a cell HI ALL in first words I'd like to thanks you all ever so much for so many replies. Its great to see how many different (great) solution is for one query. I've learn a lot and I'm so thankful for your help. I'll try all your helpful solution. Again thanks a lot. Pawel -- *From:* Haseeb A haseeb.avarak...@gmail.com *To:* excel-macros@googlegroups.com *Cc:* pawel lupinski lupins...@yahoo.com *Sent:* Sunday, April 1, 2012 7:42 PM *Subject:* $$Excel-Macros$$ Re: format a cell Hello Pawel, Another one. =TEXT(A1*IF(ISNUMBER(FIND(.,A1)),100,1),00\:00) If you want to enter 2 for 2'O clock enter as 200 or cell format as text then enter like 2.00 ___ HTH, Haseeb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Add-in creation in excel 2007
Thanks SAM. Let me check it... On Tue, Apr 3, 2012 at 12:16 AM, Sam Mathai Chacko samde...@gmail.comwrote: The Custom UI Editor Tool is used to modify the XML tag of the custom UI xml files on an office application file like Excel,Word, PPT, etc. Quite a few examples can be found at http://www.excelfox.com/forum/f10/ Regards, Sam Mathai Chacko On Tue, Apr 3, 2012 at 1:23 AM, Maries talk2mar...@gmail.com wrote: Hi Raj, Check below link, http://jackmcintyre.net/how-to-add-macros-to-the-excel-2007-ribbon/ Dear Friends, Anyone give more details about Custom UI Editor Toolhttp://openxmldeveloper.org/articles/CustomUIeditor.aspx. From above link, I came to know we required Custom UI Editor Toolhttp://openxmldeveloper.org/articles/CustomUIeditor.aspxfor customize the Ribbon. Regards, MARIES. On Mon, Apr 2, 2012 at 10:10 PM, Rajan_Verma rajanverma1...@gmail.comwrote: I think u should create custom menu to display that in Ribbon ** ** Rajan ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Raj Mahapatra *Sent:* Apr/Mon/2012 11:30 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Add-in creation in excel 2007 ** ** ** ** sam, how would i get that add in as a tab in ms excel Thanks Regards ** ** Rajesh Mahapatra ** ** ** ** On Mon, Apr 2, 2012 at 10:57 PM, Sam Mathai Chacko samde...@gmail.com wrote: Add-ins are designed to run in the background, and hence the file will not be visible when you open it. If you go to the VBE window, you could actually see that the vba project for your add-in is shown. Sam Mathai Chacko ** ** On Mon, Apr 2, 2012 at 10:50 PM, Raj Mahapatra rajafs...@gmail.com wrote: hi group, ** ** i wants to create addin in excel. i have created a addin using below steps, but it is not working. ** ** 1. in new workbook, i have insert a module and macro codes in it. 2. then saved the same workbook using .xlam extension. 3. when i opens the same add in in new excel. it does not open. ** ** appreciation for your assistance. ** ** thanks regards ** ** Rajesh Mahapatra -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise
Re: $$Excel-Macros$$ Format Conversation Question
Hi, Try below formula for TOI values. =TEXT(A1,h:mm AM/PM) Regards, MARIES. On Mon, Apr 2, 2012 at 1:40 AM, qcan comeonove...@gmail.com wrote: Hi, There is probably a very simple solution here, but I am stumped. In this link below, you will see a table that has a field called TOI (abbreviation for time on ice). The number is visually set up as minutes and seconds. When I bring this into excel, I am unable to convert this into minutes as it defaults to a date and time. http://www.cbssports.com/nhl/stats/playersort/NHL/GLS/regularseason?_3:col_1=6 Would appreciate knowing how I can reformat this into minutes, with the seconds being converted to a decimal. Ie : 1709.13 would be converted to 1709.217. Thanks. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Count formula
Hi, Try, below shown Array formula. (Apply with CSE) =SUM((--INT(D7:D955)=H13)*--(INT(D7:D955)=H14)) Conditions, H13-Start Date H14-End Date Regards, MARIES On Mon, Apr 2, 2012 at 11:47 AM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Dear Shrini** Plz find out solve attach file. Regards LAKSHMAN *From:* Shrinivas Shevde shrinivas...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Monday, April 2, 2012 12:44 PM *Subject:* $$Excel-Macros$$ Count formula Dear all , I have a software which takes the reading for temp. I can take that in excel I want to count the no of reading taken in particular day or in period Please find atached sheet Please let me know How I can count the no of reading Thanks in advance -- Shrini -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ format a cell
Hi Pawal, My try, =IF(ISERROR(FIND(.,A1,1)),TIME(LEFT(TEXT(SUBSTITUTE(A1,.,),),2),RIGHT(TEXT(SUBSTITUTE(A1,.,),),2),0),TIME(TEXT(INT(A1),00),(A1*100)-(INT(A1)*100),0)) I have tried with INT formula for decimal entries (For Decimal condition formula shown below) =TIME(TEXT(INT(A1),00),(A1*100)-(INT(A1)*100),0) Now it is working for all our conditions like, 532,,2.3,12.10etc. I hope this is fulfill your requirements. Regards, MARIES. On Thu, Mar 29, 2012 at 6:14 PM, pawel lupinski lupins...@yahoo.com wrote: hi Don, Yes, I've used data validation, and forcing people to do tis in right way. But I need to sort past data and I'd like to learn from you all things that I won't find in the books. Regards, Pawel PS macro I'm still not there. *From:* dguillett1 dguille...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, March 29, 2012 1:51 PM *Subject:* Re: $$Excel-Macros$$ format a cell BTW. You could use data validation to guide them to ONLY input as desired. Or, an input box macro. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* pawel lupinski lupins...@yahoo.com *Sent:* Thursday, March 29, 2012 7:18 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ format a cell Maries, this is great, realy simplistic working fine, but what I find out today is that people have tendency to input 2.3 what means 02:30 but formula exchanging it to 00:23 can you help me on this? I've done something like that: =IF(ISERROR(LEN(A1)-FIND(.,A1,1)),TIME(LEFT(TEXT(SUBSTITUTE(A1,.,),),2),RIGHT(TEXT(SUBSTITUTE(A1,.,),),2),0),IF((LEN(A1)-FIND(.,A1,1))=1,TIME(LEFT(TEXT(SUBSTITUTE(A10,.,),),2),RIGHT(TEXT(SUBSTITUTE(A10,.,),),2),0),TIME(LEFT(TEXT(SUBSTITUTE(A1,.,),),2),RIGHT(TEXT(SUBSTITUTE(A1,.,),),2),0))) But if you can have a look and simplified it will be graet Regards, Pawel *From:* Maries talk2mar...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, March 29, 2012 8:36 AM *Subject:* Re: $$Excel-Macros$$ format a cell Dear All, For these three conditions - 532, 1215 12.10, try below formula. =TIME(LEFT(TEXT(SUBSTITUTE(A1,.,),),2),RIGHT(TEXT(SUBSTITUTE(A1,.,),),2),0) Regards, MARIES. On Thu, Mar 29, 2012 at 10:16 AM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Dear All, If my input is 1215 or 12.15 converted to 12:15 of 12:15 *From:* Aamir Shahzad aamirshahza...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, March 29, 2012 12:22 AM *Subject:* Re: $$Excel-Macros$$ format a cell Now see the attached file. Aamir Shahzad On Wed, Mar 28, 2012 at 11:07 AM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Dear Noorain, I think he want 532, and I'd like to be converted to 05:32 *From:* NOORAIN ANSARI noorain.ans...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Wednesday, March 28, 2012 7:55 AM *Subject:* Re: $$Excel-Macros$$ format a cell Dear Pawel. Please try it.. =TIME(LEFT(C4,1),RIGHT(C4,2),0) -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Tue, Mar 27, 2012 at 7:35 PM, pawel lupinski lupins...@yahoo.comwrote: Hi All, I need your help on this simple task i don't know how to do this and for you it will be easy. I'd like to input eg 532, and I'd like to be converted to 05:32 or input 5.32 and be converted to 5:32. I've tried to change cell format like hh:mm, [hh]:mm but its not working what I've received as outcome is data and time format like 12768:00 Can you help me, please. Regards, Pawel -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure
Re: $$Excel-Macros$$ format a cell
*Convert the formula contain cell into Time format* On Sun, Apr 1, 2012 at 4:20 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: Dear Maris - your formula is giving 0.23 result if enter 532, required by powel was 5:32 Aamir Shahzad On Sun, Apr 1, 2012 at 4:07 PM, Maries talk2mar...@gmail.com wrote: Hi Pawal, My try, =IF(ISERROR(FIND(.,A1,1)),TIME(LEFT(TEXT(SUBSTITUTE(A1, .,),),2),RIGHT(TEXT(SUBSTITUTE(A1,.,),), 2),0),TIME(TEXT(INT(A1),00),(A1*100)-(INT(A1)*100),0)) I have tried with INT formula for decimal entries (For Decimal condition formula shown below) =TIME(TEXT(INT(A1),00),(A1*100)-(INT(A1)*100),0) Now it is working for all our conditions like, 532,,2.3,12.10etc. I hope this is fulfill your requirements. Regards, MARIES. On Thu, Mar 29, 2012 at 6:14 PM, pawel lupinski lupins...@yahoo.comwrote: hi Don, Yes, I've used data validation, and forcing people to do tis in right way. But I need to sort past data and I'd like to learn from you all things that I won't find in the books. Regards, Pawel PS macro I'm still not there. *From:* dguillett1 dguille...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, March 29, 2012 1:51 PM *Subject:* Re: $$Excel-Macros$$ format a cell BTW. You could use data validation to guide them to ONLY input as desired. Or, an input box macro. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* pawel lupinski lupins...@yahoo.com *Sent:* Thursday, March 29, 2012 7:18 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ format a cell Maries, this is great, realy simplistic working fine, but what I find out today is that people have tendency to input 2.3 what means 02:30 but formula exchanging it to 00:23 can you help me on this? I've done something like that: =IF(ISERROR(LEN(A1)-FIND(.,A1,1)),TIME(LEFT(TEXT(SUBSTITUTE(A1,.,),),2),RIGHT(TEXT(SUBSTITUTE(A1,.,),),2),0),IF((LEN(A1)-FIND(.,A1,1))=1,TIME(LEFT(TEXT(SUBSTITUTE(A10,.,),),2),RIGHT(TEXT(SUBSTITUTE(A10,.,),),2),0),TIME(LEFT(TEXT(SUBSTITUTE(A1,.,),),2),RIGHT(TEXT(SUBSTITUTE(A1,.,),),2),0))) But if you can have a look and simplified it will be graet Regards, Pawel *From:* Maries talk2mar...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, March 29, 2012 8:36 AM *Subject:* Re: $$Excel-Macros$$ format a cell Dear All, For these three conditions - 532, 1215 12.10, try below formula. =TIME(LEFT(TEXT(SUBSTITUTE(A1,.,),),2),RIGHT(TEXT(SUBSTITUTE(A1,.,),),2),0) Regards, MARIES. On Thu, Mar 29, 2012 at 10:16 AM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote: Dear All, If my input is 1215 or 12.15 converted to 12:15 of 12:15 *From:* Aamir Shahzad aamirshahza...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, March 29, 2012 12:22 AM *Subject:* Re: $$Excel-Macros$$ format a cell Now see the attached file. Aamir Shahzad On Wed, Mar 28, 2012 at 11:07 AM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote: Dear Noorain, I think he want 532, and I'd like to be converted to 05:32 *From:* NOORAIN ANSARI noorain.ans...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Wednesday, March 28, 2012 7:55 AM *Subject:* Re: $$Excel-Macros$$ format a cell Dear Pawel. Please try it.. =TIME(LEFT(C4,1),RIGHT(C4,2),0) -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Tue, Mar 27, 2012 at 7:35 PM, pawel lupinski lupins...@yahoo.comwrote: Hi All, I need your help on this simple task i don't know how to do this and for you it will be easy. I'd like to input eg 532, and I'd like to be converted to 05:32 or input 5.32 and be converted to 5:32. I've tried to change cell format like hh:mm, [hh]:mm but its not working what I've received as outcome is data and time format like 12768:00 Can you help me, please. Regards, Pawel -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use
Re: $$Excel-Macros$$ Macro for 100 sheets
Hi, Try Below Code, Sub Sheet1Multiplecopy() Dim i As Integer i = 1 For i = 1 To 100 Sheets(Sheet1).Select Sheets(Sheet1).Copy After:=Sheets(i) ActiveSheet.Name = i Next End Sub Regards, MARIES. On Sat, Mar 31, 2012 at 10:11 AM, chhajersand...@gmail.com wrote: Dear excel guru, I want a macro to insert 100 sheets (all are same/smilar copy of sheet 1) o sheet will be named 2...3..4...and so on! Please help. Thanks Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Macro for 100 sheets
Try this, Sub Sheet1Multiplecopy() Application.ScreenUpdating = False Application.DisplayAlerts = False For i = 1 To 100 Sheets(Sheet1).Copy After:=Sheets(i) ActiveSheet.Name = i Next Application.ScreenUpdating = True Application.DisplayAlerts = True End Sub On Sat, Mar 31, 2012 at 11:41 AM, Asa Rossoff a...@lovetour.info wrote: Sorry, Sandeep, I did not immediately see that you needed copies of another sheet. Maries has you. Asa -Original Message- From: Asa Rossoff [mailto:a...@lovetour.info] Sent: Saturday, March 31, 2012 12:40 AM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Macro for 100 sheets Hi Sandeep, sheets.Add count:=100 Check help for additional options. Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chhajersand...@gmail.com Sent: Friday, March 30, 2012 11:11 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Macro for 100 sheets Dear excel guru, I want a macro to insert 100 sheets (all are same/smilar copy of sheet 1) o sheet will be named 2...3..4...and so on! Please help. Thanks Sandeep Chhajer. Sent on my BlackBerryR from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Delivery Status Notification (Failure)
HI, PFA. Regards, MARIES. On Fri, Mar 30, 2012 at 4:46 PM, hilary lomotey resp...@gmail.com wrote: Hi Maries i keep sending to group but it bounces can you help? pls how do you trim an excel sheet such as done in the attached file(screen shot). ie if you look at Menuerror legal sheet, you realise that the whole sheet is trimmed except for the portion that contains text. thanks -- Forwarded message -- From: Mail Delivery Subsystem mailer-dae...@google.com Date: Fri, Mar 30, 2012 at 12:37 PM Subject: Delivery Status Notification (Failure) To: resp...@gmail.com Hello hilary lomotey resp...@gmail.com, The message you are sending is too large. All messages must be less than 0.10 MBytes. The max size was set by the owners of this list ( excel-macros+ow...@googlegroups.com). If you have questions related to this or any other Google Group, visit the Help Center at http://groups.google.com/support/?hl=en. Thanks, Google Groups - Original message - Received: by 10.224.108.68 with SMTP id e4mr1840344qap.4.1333111060840; Fri, 30 Mar 2012 05:37:40 -0700 (PDT) Received: by 10.224.108.68 with SMTP id e4mr1840343qap.4.1333111060777; Fri, 30 Mar 2012 05:37:40 -0700 (PDT) Return-Path: resp...@gmail.com Received: from mail-qa0-f44.google.com (mail-qa0-f44.google.com [209.85.216.44]) by gmr-mx.google.com with ESMTPS id b22si3860435qcs.3.2012.03.30.05.37.40 (version=TLSv1/SSLv3 cipher=OTHER); Fri, 30 Mar 2012 05:37:40 -0700 (PDT) Received-SPF: pass (google.com: domain of resp...@gmail.com designates 209.85.216.44 as permitted sender) client-ip=209.85.216.44; Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of resp...@gmail.com designates 209.85.216.44 as permitted sender) smtp.mail=resp...@gmail.com; dkim=pass header.i=@gmail.com Received: by qadc14 with SMTP id c14so487795qad.3 for EXCEL-MACROS@googlegroups.com; Fri, 30 Mar 2012 05:37:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=/gXdJjbgSc4JzBp1ckRe1P8w8ULq+yrlbqSfh59wzks=; b=gxew3dU442c17UYGX5chu6Gyxi1KbvTZs8LX/8AlyQ/Z+r2ChcOSRQWUq0B+ZQr3Gq 29tR/Vp8cAsk9U6kCj83JQ4Fu9Zf56Nx5OWR6ma+DQAunx0EBEvEqY74e+UR9I9QRa4E HsO3cGigifYb05kvg5xUXNYVlC7ZfQdtqvhhJI/HtFm1S3+ChGQhzPY+eW2STOe7iI04 HSuwJZmYpOQFjjBerxYZO7z47LcTc26Ve+v/Fl/9cO1ecAVkzq7lcTyTaKZ+PLYm0c46 c2WCO2z/b3aQEMiGqdUD2ZBw8UjOoSoIg3kdGqJ0h8n5FGHNYc3MZXwRK3R0i2nxTp9e EFQA== MIME-Version: 1.0 Received: by 10.229.137.8 with SMTP id u8mr765793qct.21.1333111060634; Fri, 30 Mar 2012 05:37:40 -0700 (PDT) Received: by 10.229.50.212 with HTTP; Fri, 30 Mar 2012 05:37:33 -0700 (PDT) Date: Fri, 30 Mar 2012 12:37:33 + Message-ID: CAOeJvQituTVXzpYC82ngxWC7Q9xdTng3= zyn1pbir-rbl7p...@mail.gmail.com Subject: trimming of excel sheet From: hilary lomotey resp...@gmail.com To: excel-macros EXCEL-MACROS@googlegroups.com Content-Type: multipart/mixed; boundary=00235452e6b0371e0504bc751be4 Hi Experts pls how do you trim an excel sheet such as done in the attached file(screen shot). ie if you look at Menuerror legal sheet, you realise that the whole sheet is trimmed except for the portion that contains text. thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Column Row Hide.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ format a cell
Dear All, For these three conditions - 532, 1215 12.10, try below formula. =TIME(LEFT(TEXT(SUBSTITUTE(A1,.,),),2),RIGHT(TEXT(SUBSTITUTE(A1,.,),),2),0) Regards, MARIES. On Thu, Mar 29, 2012 at 10:16 AM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Dear All, If my input is 1215 or 12.15 converted to 12:15 of 12:15 *From:* Aamir Shahzad aamirshahza...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, March 29, 2012 12:22 AM *Subject:* Re: $$Excel-Macros$$ format a cell Now see the attached file. Aamir Shahzad On Wed, Mar 28, 2012 at 11:07 AM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Dear Noorain, I think he want 532, and I'd like to be converted to 05:32 *From:* NOORAIN ANSARI noorain.ans...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Wednesday, March 28, 2012 7:55 AM *Subject:* Re: $$Excel-Macros$$ format a cell Dear Pawel. Please try it.. =TIME(LEFT(C4,1),RIGHT(C4,2),0) -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Tue, Mar 27, 2012 at 7:35 PM, pawel lupinski lupins...@yahoo.comwrote: Hi All, I need your help on this simple task i don't know how to do this and for you it will be easy. I'd like to input eg 532, and I'd like to be converted to 05:32 or input 5.32 and be converted to 5:32. I've tried to change cell format like hh:mm, [hh]:mm but its not working what I've received as outcome is data and time format like 12768:00 Can you help me, please. Regards, Pawel -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss
Re: $$Excel-Macros$$ Reading custom format as it appears in a cell
*PFA...* On Thu, Mar 29, 2012 at 4:08 PM, Ravi Kumar Vandavasi friendswrite...@gmail.com wrote: Dear Sir, I have a series of Numbers where there might be less than 15 digits i.e. custom format is used as 00 (14 instead of 15 or 16 instead of 15). So, I need to identify these numbers which are wrongly custom formatted. For better understanding, please check the attached file. Regards, Ravi Kumar On Wednesday, March 28, 2012 9:01:36 PM UTC-7, NOORAIN ANSARI wrote: Dear Ravi, Please use =REPT(0,15-LEN(A2))A2 instead of Custom format.. then you can easly count lenght.. See attached sheet. On Tue, Mar 27, 2012 at 9:09 PM, Ravi Kumar Vandavasi friendswrite...@gmail.com wrote: I have an excel file each cell may have different custom formats such as 000 or 0940101 or 0080100 etc. I would like to count number of characters in each cell. If I use len() function it retreives the length as it appears in the formula bar and not the maked characters by custom format. Please tell me how to read masked characters by custom format. Thanks Regards, Ravi Kumar Vandavasi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --**--** --** To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Wednesday, March 28, 2012 9:01:36 PM UTC-7, NOORAIN ANSARI wrote: Dear Ravi, Please use =REPT(0,15-LEN(A2))A2 instead of Custom format.. then you can easly count lenght.. See attached sheet. On Tue, Mar 27, 2012 at 9:09 PM, Ravi Kumar Vandavasi friendswrite...@gmail.com wrote: I have an excel file each cell may have different custom formats such as 000 or 0940101 or 0080100 etc. I would like to count number of characters in each cell. If I use len() function it retreives the length as it appears in the formula bar and not the maked characters by custom format. Please tell me how to read masked characters by custom format. Thanks Regards, Ravi Kumar Vandavasi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --**--** --** To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like
Re: $$Excel-Macros$$ Reading custom format as it appears in a cell
Hi, Try Below, 1. Select Cell C1 2. Press Shift+F3 3. Give Name as cellformat Refers to GET.CELL(7,A1) Use the formula in C1, =LEN(cellformat) Regards, MARIES. On Thu, Mar 29, 2012 at 4:34 PM, Maries talk2mar...@gmail.com wrote: *PFA...* On Thu, Mar 29, 2012 at 4:08 PM, Ravi Kumar Vandavasi friendswrite...@gmail.com wrote: Dear Sir, I have a series of Numbers where there might be less than 15 digits i.e. custom format is used as 00 (14 instead of 15 or 16 instead of 15). So, I need to identify these numbers which are wrongly custom formatted. For better understanding, please check the attached file. Regards, Ravi Kumar On Wednesday, March 28, 2012 9:01:36 PM UTC-7, NOORAIN ANSARI wrote: Dear Ravi, Please use =REPT(0,15-LEN(A2))A2 instead of Custom format.. then you can easly count lenght.. See attached sheet. On Tue, Mar 27, 2012 at 9:09 PM, Ravi Kumar Vandavasi friendswrite...@gmail.com wrote: I have an excel file each cell may have different custom formats such as 000 or 0940101 or 0080100 etc. I would like to count number of characters in each cell. If I use len() function it retreives the length as it appears in the formula bar and not the maked characters by custom format. Please tell me how to read masked characters by custom format. Thanks Regards, Ravi Kumar Vandavasi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --**--** --** To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Wednesday, March 28, 2012 9:01:36 PM UTC-7, NOORAIN ANSARI wrote: Dear Ravi, Please use =REPT(0,15-LEN(A2))A2 instead of Custom format.. then you can easly count lenght.. See attached sheet. On Tue, Mar 27, 2012 at 9:09 PM, Ravi Kumar Vandavasi friendswrite...@gmail.com wrote: I have an excel file each cell may have different custom formats such as 000 or 0940101 or 0080100 etc. I would like to count number of characters in each cell. If I use len() function it retreives the length as it appears in the formula bar and not the maked characters by custom format. Please tell me how to read masked characters by custom format. Thanks Regards, Ravi Kumar Vandavasi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --**--** --** To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss
Re: $$Excel-Macros$$ Reading custom format as it appears in a cell
*Ignore Previous One. Shortcut key is Ctrl + F3* ** On Thu, Mar 29, 2012 at 4:40 PM, Maries talk2mar...@gmail.com wrote: Hi, Try Below, 1. Select Cell C1 2. Press Shift+F3 3. Give Name as cellformat Refers to GET.CELL(7,A1) Use the formula in C1, =LEN(cellformat) Regards, MARIES. On Thu, Mar 29, 2012 at 4:34 PM, Maries talk2mar...@gmail.com wrote: *PFA...* On Thu, Mar 29, 2012 at 4:08 PM, Ravi Kumar Vandavasi friendswrite...@gmail.com wrote: Dear Sir, I have a series of Numbers where there might be less than 15 digits i.e. custom format is used as 00 (14 instead of 15 or 16 instead of 15). So, I need to identify these numbers which are wrongly custom formatted. For better understanding, please check the attached file. Regards, Ravi Kumar On Wednesday, March 28, 2012 9:01:36 PM UTC-7, NOORAIN ANSARI wrote: Dear Ravi, Please use =REPT(0,15-LEN(A2))A2 instead of Custom format.. then you can easly count lenght.. See attached sheet. On Tue, Mar 27, 2012 at 9:09 PM, Ravi Kumar Vandavasi friendswrite...@gmail.com wrote: I have an excel file each cell may have different custom formats such as 000 or 0940101 or 0080100 etc. I would like to count number of characters in each cell. If I use len() function it retreives the length as it appears in the formula bar and not the maked characters by custom format. Please tell me how to read masked characters by custom format. Thanks Regards, Ravi Kumar Vandavasi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --**--** --** To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Wednesday, March 28, 2012 9:01:36 PM UTC-7, NOORAIN ANSARI wrote: Dear Ravi, Please use =REPT(0,15-LEN(A2))A2 instead of Custom format.. then you can easly count lenght.. See attached sheet. On Tue, Mar 27, 2012 at 9:09 PM, Ravi Kumar Vandavasi friendswrite...@gmail.com wrote: I have an excel file each cell may have different custom formats such as 000 or 0940101 or 0080100 etc. I would like to count number of characters in each cell. If I use len() function it retreives the length as it appears in the formula bar and not the maked characters by custom format. Please tell me how to read masked characters by custom format. Thanks Regards, Ravi Kumar Vandavasi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --**--** --** To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data
Re: $$Excel-Macros$$ REG:$$Column to table formula not working
Hi, For D1 Try, =ROW($A1)*3-(3-COLUMN($A1)) For H1 Try, =ROW($B1)*3-(3-COLUMN($B1)+1) Regards, MARIES. On Wed, Mar 28, 2012 at 3:21 PM, karunanithi ramaswamy era_...@yahoo.comwrote: Sir, the file is attached. *From:* dguillett1 dguille...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tuesday, March 27, 2012 11:39 PM *Subject:* Re: $$Excel-Macros$$ REG:$$Column to table formula not working Show us your before/after data and/or send a file with explanation. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* karunanithi ramaswamy era_...@yahoo.com *Sent:* Tuesday, March 27, 2012 12:34 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ REG:$$Column to table formula not working Sir, About 4 to 6 months back, in theis Forum Someone(may be Siti or so) has given a formula to convert a column to table. i.e., =Row(A1)*3-(3-Column(A1)) this works fine when A1 to A100 is 1 to 100. But not with 10 digit cell phone number data. Can any one suggest any formula or vba.(i am using windows 2007) Karunanithi R -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com col-table.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ need a macro
*For, Compaign: =INDEX($A$4:$A$80,CEILING(COUNTA($E$3:E3)/COUNTA($A$4:$A$80),1)) For, Location: =INDEX($B$4:$B$80,COUNTIF($E$4:E4,E4))* Oops. Deleted too many rows on test sheet Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Amresh Maurya amreshkushw...@gmail.com *Sent:* Monday, March 26, 2012 7:02 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ need a macro Hi Friends, We have 77 campaign and 77 city lists , now what i need , each campaign has 77 cities. We have attached file for reference. kindly check Regards Amresh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Formula required
*Can You Please Explain More...* Dear Group, I am generating the attached series by some criteria but required further formula. Please review attached sheet. Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ print problem
Hi, Select *Cal Sheet Page1* === View Tab === Select Page Break Previow === Adjust One Page Break Lines By Cursor. Thats It..!! Regards, MARIES. On Sat, Mar 24, 2012 at 11:55 AM, Shankar Bheema shankar.n...@gmail.comwrote: Dear experts When I used to print the attached workbook. The two sheets have to be printed but I am getting the third page showing the buttons on the sheet1. how to restrict printing of that page. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Split text in cell
Hi,
PFA.
=MID(A2,FIND( ,A2,1)+1,LEN(A2)-MATCH(
,LEFT(RIGHT(A2,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}),1),0)-FIND(
,A2,1))
Regards,
MARIES.
On 3/22/12, L.K. Modi ca.mod...@gmail.com wrote:
Dear All,
Its good to see this resolution but can anyone explain this in simple
way
Regards
Modi
On Thu, Mar 22, 2012 at 4:51 AM, dguillett1 dguille...@gmail.com wrote:
Option Explicit
Sub getmiddleSAS()
Dim c As Range
Dim fs As Long
Dim ls As Long
For Each c In Range(a2:a10)
c = Application.Trim(c)
fs = InStr(c, )
ls = InStrRev(c, )
c.Offset(, 1) = Mid(c, fs, ls - fs)
Next c
Columns(b).AutoFit
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* NRao Mynampati ml.narasimha...@gmail.com
*Sent:* Wednesday, March 21, 2012 4:00 AM
*To:* excel-macros@googlegroups.com
*Cc:* Dilip Pandey dilipan...@gmail.com
*Subject:* $$Excel-Macros$$ Split text in cell
Hi Team,
How to remove a words left text and right text of reference
Please refer attachment.
Thanks in advance.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
Split a text.xls
Description: MS-Excel spreadsheet
