Fwd: $$Excel-Macros$$ Formula needed
Hi All, Awaiting for your help on formula. Thanks, Kaushik Savla -- Forwarded message - From: KAUSHIK SAVLA Date: Wed, Sep 5, 2018 at 8:06 PM Subject: $$Excel-Macros$$ Formula needed To: MS EXCEL AND VBA MACROS KAUSHIK SAVLA [image: Attachments]1:53 PM (6 hours ago) to excel-macros Hi team, Need an formula whick will look at each cell of Column A and Column B and fetch result Criteria as below:- if Account beginning with 1 and if have balance positive then OK, otherwise "To check" if Account beginning with 2 and if have balance negative then OK, otherwise "To check" if Account beginning with 3 and if have balance negative then OK, otherwise "To check" if Account beginning with 4 and if have balance negative then OK, otherwise "To check" if Account beginning with 5 and if have balance positive then OK, otherwise "To check" if Account beginning with 6 and if have balance positive then OK, otherwise "To check" if Account beginning with 7 and if have balance positive then OK, otherwise "To check" Account No. mentioned in Column A and balances mentioned in Column B Thanks, kaushik savla -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book1.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Formula needed
KAUSHIK SAVLA [image: Attachments]1:53 PM (6 hours ago) to excel-macros Hi team, Need an formula whick will look at each cell of Column A and Column B and fetch result Criteria as below:- if Account beginning with 1 and if have balance positive then OK, otherwise "To check" if Account beginning with 2 and if have balance negative then OK, otherwise "To check" if Account beginning with 3 and if have balance negative then OK, otherwise "To check" if Account beginning with 4 and if have balance negative then OK, otherwise "To check" if Account beginning with 5 and if have balance positive then OK, otherwise "To check" if Account beginning with 6 and if have balance positive then OK, otherwise "To check" if Account beginning with 7 and if have balance positive then OK, otherwise "To check" Account No. mentioned in Column A and balances mentioned in Column B Thanks, kaushik savla -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book1.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Excel Formula - Help needed
Hi All, Attached is the excel file which I am referring for help. Background: Daily basis there are some transactions getting created and are either approved or pending or rejected. For the one's which are pending we want to build a tracker which once data is dumped it will show whether follow up needed or not basis some criteria. Details:- 1. The criteria is as below:- If cell in Column D has "Mr A" then after 3 business days followup need to be done, if "Mr B" then after 2 days follow up need to be done, if "Mr C" there then after 1 day follow up need to be done, if "Mr D" then 2 days after which follow up need to be done 2. Column C contains formula which shows from current date how many days the transaction is sitting for approval. Problem here is it is taking into account all days but I want only business days which should exclude weekends ie. Saturday and Sunday 3. I want formula to give the same result as shown in Column E. Please do the needful. Regards, Kaushik Savla -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Excel Formula.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Re: Need Macro
Hi David, For current data word current will be mentioned and for prior data word prior would be mentioned. Regards, Kaushik Savla On Mon, Apr 30, 2018, 15:54 who <david.lanm...@gmail.com> wrote: > [image: Boxbe] <https://www.boxbe.com/overview> This message is eligible > for Automatic Cleanup! (david.lanm...@gmail.com) Add cleanup rule > <https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Fkey%3DUbbHXHTeazbtY1%252Bx4mYza7%252F%252BB98B1TzRszfhKSzq7eY%253D%26token%3DsF8%252F%252FJ3uHNYTWsbeBypyXfi80JlB2njS1o8eYxP9LjkkhhqT%252BXFQHm6N6ipJKAeCUV8aqH1e%252F1%252FywYJWh7Qjg3yCpiUmeifo22vEhpAjBLlXd%252Fxb4YZkqqVtN2BqTOSE4MKt7RmMV40j8rlP4%252F8bkA%253D%253D_serial=38822311583_rand=613838133_source=stf_medium=email_campaign=ANNO_CLEANUP_ADD_content=001> > | More info > <http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=38822311583_rand=613838133_source=stf_medium=email_campaign=ANNO_CLEANUP_ADD_content=001> > Hello Again, > > I am not sure what "current" means and how to identify "current", part of > #3? Can this be accomplished by sorting? Maybe this is a date? > > Thanks, David > > On Friday, April 27, 2018 at 12:46:20 AM UTC-7, KAUSHIK SAVLA wrote: >> >> Hi Team, >> >> Need your help in creating macro which would do following:- >> >> 1. To delete whole data in Sheet C >> 2. Copy whole data of Sheet B and paste it in Sheet C >> 3. Go to the Sheet A. Filter for "Current" in Column B >> 4. Copy the visible data of Step 3 and paste it in Sheet B >> 5. Now in Column C need formula to compare if the data as per Sheet A was >> appearing in Sheet C, then formula to give "Existing". Otherwise "Addition" >> in case of New. >> 6. There would be some data already in Sheet D. Now what I want is copy >> the visible data of Sheet A and Paste it at the bottom of the data of Sheet >> D >> (Kindly note there is no specific range eg say not always data will be >> till Row 100 sometime may be less and vice versa) >> 7. Go to Sheet E, delete whole data >> 8. Go to Sheet F, delete whole data >> 9. Now Filter for "Prior" in Column B of Sheet D. Copy the visible data >> from Column A to AO and paste the same in Sheet F >> 10.Now Filter for "Current" in Column B of Sheet D. Copy the visible data >> from Column A to AO and paste the same in Sheet F >> 11. Refresh the formulas of whole workbook >> >> Attached is the sample file for reference >> >> Thanks, >> Kaushik Savla >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/excel-macros/Np_IRhIvDvE/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and m
Re: $$Excel-Macros$$ Re: Need Macro
Hi David, Please let me know what additional information is needed. Regards, Kaushik Savla On Sat, Apr 28, 2018, 07:42 who <david.lanm...@gmail.com> wrote: > [image: Boxbe] <https://www.boxbe.com/overview> This message is eligible > for Automatic Cleanup! (david.lanm...@gmail.com) Add cleanup rule > <https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Fkey%3DFGvaf6qqeTKoGcmG9AvplnlJ6VsPMtVNuodF9lm27HA%253D%26token%3Dz269MqhrtCge4ILdcpQTk8wmtaSycFhf9x4qRZkDHIfJF5A7d13P%252F5I9gkNAUbsUYLMWustLpQHDGYiH%252BjvsmBYQfly2c9eWgK740ofgaaHlVx6TB8JaWKw0r0pMBJA1rsEpGlZIKFJ%252FGNDnHI7v0w%253D%253D_serial=38761694675_rand=201422455_source=stf_medium=email_campaign=ANNO_CLEANUP_ADD_content=001> > | More info > <http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc_serial=38761694675_rand=201422455_source=stf_medium=email_campaign=ANNO_CLEANUP_ADD_content=001> > > > On Friday, April 27, 2018 at 12:46:20 AM UTC-7, KAUSHIK SAVLA wrote: >> >> Hi Team, >> >> Need your help in creating macro which would do following:- >> >> 1. To delete whole data in Sheet C >> 2. Copy whole data of Sheet B and paste it in Sheet C >> 3. Go to the Sheet A. Filter for "Current" in Column B >> 4. Copy the visible data of Step 3 and paste it in Sheet B >> 5. Now in Column C need formula to compare if the data as per Sheet A was >> appearing in Sheet C, then formula to give "Existing". Otherwise "Addition" >> in case of New. >> 6. There would be some data already in Sheet D. Now what I want is copy >> the visible data of Sheet A and Paste it at the bottom of the data of Sheet >> D >> (Kindly note there is no specific range eg say not always data will be >> till Row 100 sometime may be less and vice versa) >> 7. Go to Sheet E, delete whole data >> 8. Go to Sheet F, delete whole data >> 9. Now Filter for "Prior" in Column B of Sheet D. Copy the visible data >> from Column A to AO and paste the same in Sheet F >> 10.Now Filter for "Current" in Column B of Sheet D. Copy the visible data >> from Column A to AO and paste the same in Sheet F >> 11. Refresh the formulas of whole workbook >> >> Attached is the sample file for reference >> >> Thanks, >> Kaushik Savla >> > > > Here is part of what you want, but would need more info to complete the > next the next step. Thanks, David > > Sub Savla() > Sheets("C").Cells.ClearContents > Sheets("B").Select > Range("A1").Select > Selection.CurrentRegion.Select > Selection.Copy > Sheets("C").Select > Range("A1").Select > ActiveSheet.Paste > End Sub > > Thanks, David > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/excel-macros/Np_IRhIvDvE/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you r
$$Excel-Macros$$ Need Macro
Please help on this one. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Need Macro
Hi Team, Need your help in creating macro which would do following:- 1. To delete whole data in Sheet C 2. Copy whole data of Sheet B and paste it in Sheet C 3. Go to the Sheet A. Filter for "Current" in Column B 4. Copy the visible data of Step 3 and paste it in Sheet B 5. Now in Column C need formula to compare if the data as per Sheet A was appearing in Sheet C, then formula to give "Existing". Otherwise "Addition" in case of New. 6. There would be some data already in Sheet D. Now what I want is copy the visible data of Sheet A and Paste it at the bottom of the data of Sheet D (Kindly note there is no specific range eg say not always data will be till Row 100 sometime may be less and vice versa) 7. Go to Sheet E, delete whole data 8. Go to Sheet F, delete whole data 9. Now Filter for "Prior" in Column B of Sheet D. Copy the visible data from Column A to AO and paste the same in Sheet F 10.Now Filter for "Current" in Column B of Sheet D. Copy the visible data from Column A to AO and paste the same in Sheet F 11. Refresh the formulas of whole workbook Attached is the sample file for reference Thanks, Kaushik Savla -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Sample.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Links
Hi Paul, I followed the instructions. However what's happening is the macro is just showing running and not giving any outcome. I kept it running for nearly 3 hours. Regards, Kaushik -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Links
Macro is just running and not fetching any outcome. Regards, Kaushik On May 26, 2017 16:11, "'Martin George' via MS EXCEL AND VBA MACROS" < excel-macros@googlegroups.com> wrote: > > > On Thu, 5/25/17, Paul Schreiner <schreiner_p...@att.net> wrote: > > Subject: Re: $$Excel-Macros$$ Links > To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> > Date: Thursday, May 25, 2017, 8:17 PM > > The workbook that you add the VBA macro to is > identified as "ThisWorkbook". > so, in the > macro: > > ThisWorkbook.Sheets(1).Range("A2:Z65000").ClearContents > clears > the contents of the first sheet in > "Thisworkbook"then: > > ThisWorkbook.Sheets(1).Cells(nRow, "A").Value = > Sht.Name > > ThisWorkbook.Sheets(1).Cells(nRow, "B").Value = > Rng.Address > > If (InStr(1, Rng.Formula, "[") > 0) Then > > ThisWorkbook.Sheets(1).Cells(nRow, "C").Value = > "'" & Rng.Formula > > Else > > ThisWorkbook.Sheets(1).Cells(nRow, "D").Value = > "'" & Rng.Formula > > End Ifputs > the listing on the first sheet of the workbook. > Paul- > “Do > all the good you can, > By all the means you > can, > In all the ways you can, > In all the places you can, > At > all the times you can, > To all the people you > can, > As long as ever you can.” - John > Wesley > - > > > >On Thursday, May 25, 2017 12:50 PM, > KAUSHIK SAVLA <savla.kaus...@gmail.com> wrote: > > > Hi Paul, > Macro got run and gave finished > message. > Where can I > find the desired output? > Regards, Kaushik > On May 25, 2017 19:06, > "Paul Schreiner" <schreiner_p...@att.net> > wrote: > OK.Spent > WAY longer on this than I should have. > I > should've had you create a "dummy" set of > workbooks that looked like yours instead of me spending an > hour+ guessing what yours looks like. > So, > I put together 20 separate workbooks with data.then > added 15 sheets to the "data" workbook and > created 150 random links to both the 20 external workbooks > and the internal worksheets. > It took about 15 minutes > to write some code to look at the formulas and determine > which are internal/external formulas. > It > DOESN'T distinguish between calculations and other > formulas. > Since I don't know what you want to do with > it, and how you want it to list the matches, I'll just > give you what I have and you can decide what you want to > change. > If it isn't what you > want, then send me a sample to write against. > Here it is: > Sub > Link_Summary() > > Dim DatFldr, DatFile > > Dim aLinks > > Dim nRow > > ' Location > and name of main Data file. > > DatFldr = "C:\temp\vba\Savla\" > > DatFile = "DataFile.xlsb" > > On Error Resume Next > > Workbooks(DatFile).Activate > > If (Err.Number <> 0) Then > > Workbooks.Open DatFldr & DatFile, UpdateLinks:=False > > Err.Clear > > End If > > nRow = 1 > > ThisWorkbook.Sheets(1).Range(" > A2:Z65000").ClearContents > > Dim Sht As Worksheet, Rng As Range > > For Each Sht In ActiveWorkbook.Sheets > > For Each Rng In Sht.UsedRange > > If (Rng.Value & "X" <> Rng.Formula & > "X") Then > > nRow = nRow + 1 > > ThisWorkbook.Sheets(1).Cells( nRow, "A").Value = > Sht.Name > > ThisWorkbook.Sheets(1).Cells( nRow, "B").Value = > Rng.Address > > If (InStr(1, Rng.Formula, "[") > 0) Then > > ThisWorkbook.Sheets(1).Cells( nRow, "C").Value = > "'" & Rng.Formula > > Else > > ThisWorkbook.Sheets(1).Cells( nRow, "D").Value = > "'" & Rng.Formula > > End If > > End If > > Next Rng > > Next Sht > > ThisWorkbook.Activate > > MsgBox "Finished"End > Sub > Paul-- > --- > “Do all the good you can, > By all the means you can, > In > all the ways you can, > In all the places you > can, > At all the times you can, > To all the people you can, > As > long as ever you can.” - John Wesley > -- > --- > > >On Thursday, May 25, 2017 2:51 AM, > KAUSHIK SAVLA <savla.kaus.
Re: $$Excel-Macros$$ Need help in Vba Macro
Hi Paul, The macro for this one is not working. Can you please share your file with macro. So i can compare with my file. I am getting error message the data cannot be pasted as shape and size are not same. Regards, Kaushik On Wednesday, May 24, 2017 at 4:29:56 PM UTC+5:30, Paul Schreiner wrote: > > What isn't working? > What does your code look like? > > I put random numbers in 100,000 cells in Book1.xlsb > Then, in Book2, I put 100,000 cells with links to the corresponding cell > in Book1. > > I then created a macro module with: > Option Explicit > Sub RemoveLinks() > Dim aLinks, inx > aLinks = ActiveWorkbook.LinkSources(xlExcelLinks) > > If Not IsEmpty(aLinks) Then > For inx = 1 To UBound(aLinks) > ActiveWorkbook.BreakLink _ > Name:=aLinks(inx), _ > Type:=xlLinkTypeExcelLinks > Next inx > End If > End Sub > > Ran RemoveLinks and it replaced all 100,000 cells with the contents > immediately. > > what does your code look like, and what do you mean that it "the code is > not working"? > > Is it not removing the links? > is it giving you an error? > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Wednesday, May 24, 2017 1:42 AM, KAUSHIK SAVLA <savla@gmail.com > > wrote: > > > Hi Paul, > > The code is not working. > > Can you please provide full code starting with Sub...till End sub > > Regards, > kaushik Savla > > On Wed, May 24, 2017 at 12:42 AM, Paul Schreiner <schrein...@att.net > > wrote: > > If you also want to get rid of the "internal" links and formulas, you can > make use of the fact that, for a given cell, the VALUE of the cell is what > is displayed, while the FORMULA of the cell is just that, the formula. > > For cells with a simple value, like "3", then the formula and value are > nearly the same. > (the issue is that the value would be an integer, but the formula would be > a string "3") > > So, basically you could compare the value and formula for each used cell > and overwrite if they are different. > > I "convert" both the Value and Formula to strings to ensure they are > compared properly, and use: > > Sub BreakLinks() > Dim Rng As Range > For Each Rng In Sheets(1).UsedRange > If (Rng.Formula & "X" <> Rng.Value & "X") Then Rng.Formula = > Rng.Value > Next Rng > End Sub > > > I created a sheet with 1000 rows and 100 columns. (so 100,000 cell > contents) > I then created a sheet that had 100,000 cells that added the contents of > the adjacent sheet. > > This macro converted the 100,000 cells to values in about 3 seconds. > > *Paul* > -- --- > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John > Wesley*-- > --- > > > On Tuesday, May 23, 2017 2:56 PM, KAUSHIK SAVLA <savla@gmail.com > > wrote: > > > This is think will definitely help. > > Thanks. > > On May 24, 2017 00:23, "Paul Schreiner" <schrein...@att.net > > wrote: > > That's very CPU intensive because it copies all cells to the clipboard > and pastes them from clipboard. > which can be a HUGE number of cells for each sheet. > > If you simply want to break the external links, you can use something like: > > alinks = ActiveWorkbook.LinkSources( xlExcelLinks) > > If Not IsEmpty(alinks) Then > For inx = 1 To UBound(alinks) > ActiveWorkbook.BreakLink _ > Name:=alinks(inx), _ > Type:=xlLinkTypeExcelLinks > Next inx > End If > > This will break links to EXTERNAL workbooks (and convert to values) > but it doesn't do anything to the links to worksheets within the current > workbook. > > does that help? > > *Paul* > -- --- > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John > Wesl
Re: $$Excel-Macros$$ Links
Could you please share your dummy workbook which you created? Regards, Kaushik Savla On Thursday, May 25, 2017 at 11:47:39 PM UTC+5:30, Paul Schreiner wrote: > > The workbook that you add the VBA macro to is identified as "ThisWorkbook". > > so, in the macro: > > ThisWorkbook.Sheets(1).Range("A2:Z65000").ClearContents > > clears the contents of the first sheet in "Thisworkbook" > then: > ThisWorkbook.Sheets(1).Cells(nRow, "A").Value = Sht.Name > ThisWorkbook.Sheets(1).Cells(nRow, "B").Value = > Rng.Address > If (InStr(1, Rng.Formula, "[") > 0) Then > ThisWorkbook.Sheets(1).Cells(nRow, "C").Value = "'" & > Rng.Formula > Else > ThisWorkbook.Sheets(1).Cells(nRow, "D").Value = "'" & > Rng.Formula > End If > puts the listing on the first sheet of the workbook. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Thursday, May 25, 2017 12:50 PM, KAUSHIK SAVLA <savla@gmail.com > > wrote: > > > Hi Paul, > > Macro got run and gave finished message. > > Where can I find the desired output? > > Regards, > Kaushik > > On May 25, 2017 19:06, "Paul Schreiner" <schrein...@att.net > > wrote: > > OK. > Spent WAY longer on this than I should have. > > I should've had you create a "dummy" set of workbooks that looked like > yours instead of me spending an hour+ guessing what yours looks like. > > So, I put together 20 separate workbooks with data. > then added 15 sheets to the "data" workbook and created 150 random > links to both the 20 external workbooks and the internal worksheets. > > It took about 15 minutes to write some code to look at the formulas and > determine which are internal/external formulas. > > It DOESN'T distinguish between calculations and other formulas. > > Since I don't know what you want to do with it, and how you want it to > list the matches, I'll just give you what I have and you can decide what > you want to change. > > If it isn't what you want, then send me a sample to write against. > > Here it is: > > Sub Link_Summary() > Dim DatFldr, DatFile > Dim aLinks > Dim nRow > > ' Location and name of main Data file. > DatFldr = "C:\temp\vba\Savla\" > DatFile = "DataFile.xlsb" > > On Error Resume Next > Workbooks(DatFile).Activate > If (Err.Number <> 0) Then > Workbooks.Open DatFldr & DatFile, UpdateLinks:=False > Err.Clear > End If > nRow = 1 > ThisWorkbook.Sheets(1).Range(" A2:Z65000").ClearContents > Dim Sht As Worksheet, Rng As Range > For Each Sht In ActiveWorkbook.Sheets > For Each Rng In Sht.UsedRange > If (Rng.Value & "X" <> Rng.Formula & "X") Then > nRow = nRow + 1 > ThisWorkbook.Sheets(1).Cells( nRow, "A").Value = Sht.Name > ThisWorkbook.Sheets(1).Cells( nRow, "B").Value = > Rng.Address > If (InStr(1, Rng.Formula, "[") > 0) Then > ThisWorkbook.Sheets(1).Cells( nRow, "C").Value = "'" & > Rng.Formula > Else > ThisWorkbook.Sheets(1).Cells( nRow, "D").Value = "'" & > Rng.Formula > End If > End If > Next Rng > Next Sht > ThisWorkbook.Activate > MsgBox "Finished" > End Sub > *Paul* > -- --- > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John > Wesley*------ > --- > > > On Thursday, May 25, 2017 2:51 AM, KAUSHIK SAVLA <savla@gmail.com > > wrote: > > > Hi Paul > > You are correct, I don't want to break links. Not possible to send > workbook as it contains sensitive confidential information. > > Just suppose there is a worksheet named A in workbook. It is linked to > exter
Re: $$Excel-Macros$$ Links
ok...Thanks On Thursday, May 25, 2017 at 11:47:39 PM UTC+5:30, Paul Schreiner wrote: > > The workbook that you add the VBA macro to is identified as "ThisWorkbook". > > so, in the macro: > > ThisWorkbook.Sheets(1).Range("A2:Z65000").ClearContents > > clears the contents of the first sheet in "Thisworkbook" > then: > ThisWorkbook.Sheets(1).Cells(nRow, "A").Value = Sht.Name > ThisWorkbook.Sheets(1).Cells(nRow, "B").Value = > Rng.Address > If (InStr(1, Rng.Formula, "[") > 0) Then > ThisWorkbook.Sheets(1).Cells(nRow, "C").Value = "'" & > Rng.Formula > Else > ThisWorkbook.Sheets(1).Cells(nRow, "D").Value = "'" & > Rng.Formula > End If > puts the listing on the first sheet of the workbook. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Thursday, May 25, 2017 12:50 PM, KAUSHIK SAVLA <savla@gmail.com > > wrote: > > > Hi Paul, > > Macro got run and gave finished message. > > Where can I find the desired output? > > Regards, > Kaushik > > On May 25, 2017 19:06, "Paul Schreiner" <schrein...@att.net > > wrote: > > OK. > Spent WAY longer on this than I should have. > > I should've had you create a "dummy" set of workbooks that looked like > yours instead of me spending an hour+ guessing what yours looks like. > > So, I put together 20 separate workbooks with data. > then added 15 sheets to the "data" workbook and created 150 random > links to both the 20 external workbooks and the internal worksheets. > > It took about 15 minutes to write some code to look at the formulas and > determine which are internal/external formulas. > > It DOESN'T distinguish between calculations and other formulas. > > Since I don't know what you want to do with it, and how you want it to > list the matches, I'll just give you what I have and you can decide what > you want to change. > > If it isn't what you want, then send me a sample to write against. > > Here it is: > > Sub Link_Summary() > Dim DatFldr, DatFile > Dim aLinks > Dim nRow > > ' Location and name of main Data file. > DatFldr = "C:\temp\vba\Savla\" > DatFile = "DataFile.xlsb" > > On Error Resume Next > Workbooks(DatFile).Activate > If (Err.Number <> 0) Then > Workbooks.Open DatFldr & DatFile, UpdateLinks:=False > Err.Clear > End If > nRow = 1 > ThisWorkbook.Sheets(1).Range(" A2:Z65000").ClearContents > Dim Sht As Worksheet, Rng As Range > For Each Sht In ActiveWorkbook.Sheets > For Each Rng In Sht.UsedRange > If (Rng.Value & "X" <> Rng.Formula & "X") Then > nRow = nRow + 1 > ThisWorkbook.Sheets(1).Cells( nRow, "A").Value = Sht.Name > ThisWorkbook.Sheets(1).Cells( nRow, "B").Value = > Rng.Address > If (InStr(1, Rng.Formula, "[") > 0) Then > ThisWorkbook.Sheets(1).Cells( nRow, "C").Value = "'" & > Rng.Formula > Else > ThisWorkbook.Sheets(1).Cells( nRow, "D").Value = "'" & > Rng.Formula > End If > End If > Next Rng > Next Sht > ThisWorkbook.Activate > MsgBox "Finished" > End Sub > *Paul* > -- --- > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John > Wesley*------ > --- > > > On Thursday, May 25, 2017 2:51 AM, KAUSHIK SAVLA <savla@gmail.com > > wrote: > > > Hi Paul > > You are correct, I don't want to break links. Not possible to send > workbook as it contains sensitive confidential information. > > Just suppose there is a worksheet named A in workbook. It is linked to > external workbook named say X, Y and it is also linked to worksheets in &
Re: $$Excel-Macros$$ Links
Hi Paul, Macro got run and gave finished message. Where can I find the desired output? Regards, Kaushik On May 25, 2017 19:06, "Paul Schreiner" <schreiner_p...@att.net> wrote: > OK. > Spent WAY longer on this than I should have. > > I should've had you create a "dummy" set of workbooks that looked like > yours instead of me spending an hour+ guessing what yours looks like. > > So, I put together 20 separate workbooks with data. > then added 15 sheets to the "data" workbook and created 150 random > links to both the 20 external workbooks and the internal worksheets. > > It took about 15 minutes to write some code to look at the formulas and > determine which are internal/external formulas. > > It DOESN'T distinguish between calculations and other formulas. > > Since I don't know what you want to do with it, and how you want it to > list the matches, I'll just give you what I have and you can decide what > you want to change. > > If it isn't what you want, then send me a sample to write against. > > Here it is: > > Sub Link_Summary() > Dim DatFldr, DatFile > Dim aLinks > Dim nRow > > ' Location and name of main Data file. > DatFldr = "C:\temp\vba\Savla\" > DatFile = "DataFile.xlsb" > > On Error Resume Next > Workbooks(DatFile).Activate > If (Err.Number <> 0) Then > Workbooks.Open DatFldr & DatFile, UpdateLinks:=False > Err.Clear > End If > nRow = 1 > ThisWorkbook.Sheets(1).Range("A2:Z65000").ClearContents > Dim Sht As Worksheet, Rng As Range > For Each Sht In ActiveWorkbook.Sheets > For Each Rng In Sht.UsedRange > If (Rng.Value & "X" <> Rng.Formula & "X") Then > nRow = nRow + 1 > ThisWorkbook.Sheets(1).Cells(nRow, "A").Value = Sht.Name > ThisWorkbook.Sheets(1).Cells(nRow, "B").Value = > Rng.Address > If (InStr(1, Rng.Formula, "[") > 0) Then > ThisWorkbook.Sheets(1).Cells(nRow, "C").Value = "'" & > Rng.Formula > Else > ThisWorkbook.Sheets(1).Cells(nRow, "D").Value = "'" & > Rng.Formula > End If > End If > Next Rng > Next Sht > ThisWorkbook.Activate > MsgBox "Finished" > End Sub > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Thursday, May 25, 2017 2:51 AM, KAUSHIK SAVLA <savla.kaus...@gmail.com> > wrote: > > > Hi Paul > > You are correct, I don't want to break links. Not possible to send > workbook as it contains sensitive confidential information. > > Just suppose there is a worksheet named A in workbook. It is linked to > external workbook named say X, Y and it is also linked to worksheets in > workbook say name B, C, D, E in different cells. > > What I want is in new workbook it should display > Worksheet A - Linked from external workbook X, Y and internal worksheets > B, C, D, E. > > This process repeat for all worksheets within a workbook. > > Regards, > Kaushik Savla > 8373916768 > > On May 25, 2017 00:53, "Paul Schreiner" <schreiner_p...@att.net> wrote: > > It sounds like you're not wanting to REMOVE the links, > but basically generate a list of worksheets and the name of the external > workbooks linked to those sheets. > > That doesn't sound difficult. > > But the error you're suggesting doesn't make sense because you're not > "pasting" anything (with the macro I suggested). > > It would take me at least an hour to TRY to create a file set that MIGHT > duplicate your structure. > Is it at all possible for you to send me the workbook directly ( > schreiner_p...@att.net)? > > If not, can you send me the macro you're using that is causing the > problems? > *Paul* > -- --- > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley*-- > --- > > > On Wednesday, May 24, 2017 3:07 PM, KAUSHIK SAVLA <savla.kaus...@gmail.com&
Re: $$Excel-Macros$$ Links
Hi Paul You are correct, I don't want to break links. Not possible to send workbook as it contains sensitive confidential information. Just suppose there is a worksheet named A in workbook. It is linked to external workbook named say X, Y and it is also linked to worksheets in workbook say name B, C, D, E in different cells. What I want is in new workbook it should display Worksheet A - Linked from external workbook X, Y and internal worksheets B, C, D, E. This process repeat for all worksheets within a workbook. Regards, Kaushik Savla 8373916768 On May 25, 2017 00:53, "Paul Schreiner" <schreiner_p...@att.net> wrote: > It sounds like you're not wanting to REMOVE the links, > but basically generate a list of worksheets and the name of the external > workbooks linked to those sheets. > > That doesn't sound difficult. > > But the error you're suggesting doesn't make sense because you're not > "pasting" anything (with the macro I suggested). > > It would take me at least an hour to TRY to create a file set that MIGHT > duplicate your structure. > Is it at all possible for you to send me the workbook directly ( > schreiner_p...@att.net)? > > If not, can you send me the macro you're using that is causing the > problems? > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Wednesday, May 24, 2017 3:07 PM, KAUSHIK SAVLA <savla.kaus...@gmail.com> > wrote: > > > Hi Paul, > > What I am looking for is below. > > 1. I have a workbook with 100 worksheets > 2. Each worksheet is linked to several external Workbooks and several > tabs/worksheets within workbook. > 3. What I want to do is first list all name of tabs sequentially in a new > workbook and against each worksheet name mention the unique source with > name say linked to external ABC, XYZ, files and linked to a, b, c, d, e, > f Worksheets. > This I want to do for all 100 worksheets. > > Hope this helps. > > Regards, > Kaushik > > On May 25, 2017 00:23, "KAUSHIK SAVLA" <savla.kaus...@gmail.com> wrote: > > Hi Paul, > > What I am looking for is below. > > 1. I have a workbook with 100 worksheets > 2. Each worksheet is linked to several external Workbooks and several > table within workbook. > 3. What I want to do is first list all name of tabs sequentially in a new > workbook and against each worksheet name mention the unique source with > name say linked to external ABC, XYZ, files and linked to a, b, c, d, e, > f Worksheets. > This I want to do for all 100 worksheets. > > Hope this helps. > > Regards, > Kaushik > > -- > 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 <https://www.facebook.com/discussexcel> > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/excel-macros/ lYmOGDBlWFU/unsubscribe > <https://groups.google.com/d/topic/excel-macros/lYmOGDBlWFU/unsubscribe>. > To unsubscribe from this group and all its topics, send an email to > excel-macros+unsubscribe@ > googlegroups.com <excel-macros%2bunsubscr...@googlegroups.com>. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/ group/excel-macros > <https://groups.google.com/group/excel-macros>. > For more options, visit https://groups.google.com/d/ optout > <https://groups.google.com/d/optout>. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook p
Re: $$Excel-Macros$$ Links
Hi Paul, What I am looking for is below. 1. I have a workbook with 100 worksheets 2. Each worksheet is linked to several external Workbooks and several tabs/worksheets within workbook. 3. What I want to do is first list all name of tabs sequentially in a new workbook and against each worksheet name mention the unique source with name say linked to external ABC, XYZ, files and linked to a, b, c, d, e, f Worksheets. This I want to do for all 100 worksheets. Hope this helps. Regards, Kaushik On May 25, 2017 00:23, "KAUSHIK SAVLA" <savla.kaus...@gmail.com> wrote: > Hi Paul, > > What I am looking for is below. > > 1. I have a workbook with 100 worksheets > 2. Each worksheet is linked to several external Workbooks and several > table within workbook. > 3. What I want to do is first list all name of tabs sequentially in a new > workbook and against each worksheet name mention the unique source with > name say linked to external ABC, XYZ, files and linked to a, b, c, d, e, > f Worksheets. > This I want to do for all 100 worksheets. > > Hope this helps. > > Regards, > Kaushik > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/excel-macros/lYmOGDBlWFU/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Links
Hi Paul, What I am looking for is below. 1. I have a workbook with 100 worksheets 2. Each worksheet is linked to several external Workbooks and several table within workbook. 3. What I want to do is first list all name of tabs sequentially in a new workbook and against each worksheet name mention the unique source with name say linked to external ABC, XYZ, files and linked to a, b, c, d, e, f Worksheets. This I want to do for all 100 worksheets. Hope this helps. Regards, Kaushik -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: Need help in Vba Macro
Hi Paul, I am getting error message mentioning the cells cannot be pasted as the size and shape is not same. Regards, Kaushik On Tuesday, May 23, 2017 at 11:32:58 PM UTC+5:30, KAUSHIK SAVLA wrote: > > Hi Team, > > I am trying to do below in an excel. You can assume there are 60 > worksheets minimum in a workbook. > > 1. In opened excel file. Which has links from several files > 2. All cells of the workbook I am doing paste special values > 3. Then to come at the first cell in all worksheets (i.e. Cell A1) > 4. Then to come at first tab, first cell, Save the workbook here (so > whenever excel opens the person will see first sheet, first cell) > 5. Close the workbook > > I am having below vba code. It is taking forever to run (minimum 15-20 > minutes). Can anyone please help in boosting speed so could be run in > fraction of seconds. > > > Sub Select_All_Sheets() > Dim sht As Worksheet > Dim SelectMe() As String > Dim s As Integer > For Each sht In Worksheets > s = s + 1 > ReDim Preserve SelectMe(1 To s) As String > SelectMe(s) = sht.Name > Sheets(SelectMe).Select > Cells.Select > Selection.Copy > Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, > SkipBlanks _ > :=False, Transpose:=False > Application.CutCopyMode = False > Application.Goto Range(Cells(ActiveWindow.SplitRow + 1, > ActiveWindow.SplitColumn + 1).Address) > ActiveWorkbook.Save > Next > End Sub > > Regards, > Kaushik Savla > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Need help in Vba Macro
Hi Paul, The code is not working. Can you please provide full code starting with Sub...till End sub Regards, kaushik Savla On Wed, May 24, 2017 at 12:42 AM, Paul Schreiner <schreiner_p...@att.net> wrote: > If you also want to get rid of the "internal" links and formulas, you can > make use of the fact that, for a given cell, the VALUE of the cell is what > is displayed, while the FORMULA of the cell is just that, the formula. > > For cells with a simple value, like "3", then the formula and value are > nearly the same. > (the issue is that the value would be an integer, but the formula would be > a string "3") > > So, basically you could compare the value and formula for each used cell > and overwrite if they are different. > > I "convert" both the Value and Formula to strings to ensure they are > compared properly, and use: > > Sub BreakLinks() > Dim Rng As Range > For Each Rng In Sheets(1).UsedRange > If (Rng.Formula & "X" <> Rng.Value & "X") Then Rng.Formula = > Rng.Value > Next Rng > End Sub > > > I created a sheet with 1000 rows and 100 columns. (so 100,000 cell > contents) > I then created a sheet that had 100,000 cells that added the contents of > the adjacent sheet. > > This macro converted the 100,000 cells to values in about 3 seconds. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Tuesday, May 23, 2017 2:56 PM, KAUSHIK SAVLA <savla.kaus...@gmail.com> > wrote: > > > This is think will definitely help. > > Thanks. > > On May 24, 2017 00:23, "Paul Schreiner" <schreiner_p...@att.net> wrote: > > That's very CPU intensive because it copies all cells to the clipboard > and pastes them from clipboard. > which can be a HUGE number of cells for each sheet. > > If you simply want to break the external links, you can use something like: > > alinks = ActiveWorkbook.LinkSources( xlExcelLinks) > > If Not IsEmpty(alinks) Then > For inx = 1 To UBound(alinks) > ActiveWorkbook.BreakLink _ > Name:=alinks(inx), _ > Type:=xlLinkTypeExcelLinks > Next inx > End If > > This will break links to EXTERNAL workbooks (and convert to values) > but it doesn't do anything to the links to worksheets within the current > workbook. > > does that help? > > *Paul* > ------ --- > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley*-- > --- > > > On Tuesday, May 23, 2017 2:03 PM, KAUSHIK SAVLA <savla.kaus...@gmail.com> > wrote: > > > Hi Team, > > I am trying to do below in an excel. You can assume there are 60 > worksheets minimum in a workbook. > > 1. In opened excel file. Which has links from several files > 2. All cells of the workbook I am doing paste special values > 3. Then to come at the first cell in all worksheets (i.e. Cell A1) > 4. Then to come at first tab, first cell, Save the workbook here (so > whenever excel opens the person will see first sheet, first cell) > 5. Close the workbook > > I am having below vba code. It is taking forever to run (minimum 15-20 > minutes). Can anyone please help in boosting speed so could be run in > fraction of seconds. > > > Sub Select_All_Sheets() > Dim sht As Worksheet > Dim SelectMe() As String > Dim s As Integer > For Each sht In Worksheets > s = s + 1 > ReDim Preserve SelectMe(1 To s) As String > SelectMe(s) = sht.Name > Sheets(SelectMe).Select > Cells.Select > Selection.Copy > Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, > SkipBlanks _ > :=False, Transpose:=False > Application.CutCopyMode = False > Application.Goto Range(Cells(ActiveWindow. SplitRow + 1, > ActiveWindow.SplitColumn + 1).Address) > ActiveWorkbook.Save > Next > End Sub > > Regards, > Kaushik Savla > -- > 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 <https://www.facebook.com/discussexcel> > > FORUM RULES &g
Re: $$Excel-Macros$$ Need help in Vba Macro
Wow. This is what actually I require. I will test in my file. Thanks a lot. On May 24, 2017 00:43, "Paul Schreiner" <schreiner_p...@att.net> wrote: > If you also want to get rid of the "internal" links and formulas, you can > make use of the fact that, for a given cell, the VALUE of the cell is what > is displayed, while the FORMULA of the cell is just that, the formula. > > For cells with a simple value, like "3", then the formula and value are > nearly the same. > (the issue is that the value would be an integer, but the formula would be > a string "3") > > So, basically you could compare the value and formula for each used cell > and overwrite if they are different. > > I "convert" both the Value and Formula to strings to ensure they are > compared properly, and use: > > Sub BreakLinks() > Dim Rng As Range > For Each Rng In Sheets(1).UsedRange > If (Rng.Formula & "X" <> Rng.Value & "X") Then Rng.Formula = > Rng.Value > Next Rng > End Sub > > > I created a sheet with 1000 rows and 100 columns. (so 100,000 cell > contents) > I then created a sheet that had 100,000 cells that added the contents of > the adjacent sheet. > > This macro converted the 100,000 cells to values in about 3 seconds. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Tuesday, May 23, 2017 2:56 PM, KAUSHIK SAVLA <savla.kaus...@gmail.com> > wrote: > > > This is think will definitely help. > > Thanks. > > On May 24, 2017 00:23, "Paul Schreiner" <schreiner_p...@att.net> wrote: > > That's very CPU intensive because it copies all cells to the clipboard > and pastes them from clipboard. > which can be a HUGE number of cells for each sheet. > > If you simply want to break the external links, you can use something like: > > alinks = ActiveWorkbook.LinkSources( xlExcelLinks) > > If Not IsEmpty(alinks) Then > For inx = 1 To UBound(alinks) > ActiveWorkbook.BreakLink _ > Name:=alinks(inx), _ > Type:=xlLinkTypeExcelLinks > Next inx > End If > > This will break links to EXTERNAL workbooks (and convert to values) > but it doesn't do anything to the links to worksheets within the current > workbook. > > does that help? > > *Paul* > -- --- > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley*-- > --- > > > On Tuesday, May 23, 2017 2:03 PM, KAUSHIK SAVLA <savla.kaus...@gmail.com> > wrote: > > > Hi Team, > > I am trying to do below in an excel. You can assume there are 60 > worksheets minimum in a workbook. > > 1. In opened excel file. Which has links from several files > 2. All cells of the workbook I am doing paste special values > 3. Then to come at the first cell in all worksheets (i.e. Cell A1) > 4. Then to come at first tab, first cell, Save the workbook here (so > whenever excel opens the person will see first sheet, first cell) > 5. Close the workbook > > I am having below vba code. It is taking forever to run (minimum 15-20 > minutes). Can anyone please help in boosting speed so could be run in > fraction of seconds. > > > Sub Select_All_Sheets() > Dim sht As Worksheet > Dim SelectMe() As String > Dim s As Integer > For Each sht In Worksheets > s = s + 1 > ReDim Preserve SelectMe(1 To s) As String > SelectMe(s) = sht.Name > Sheets(SelectMe).Select > Cells.Select > Selection.Copy > Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, > SkipBlanks _ > :=False, Transpose:=False > Application.CutCopyMode = False > Application.Goto Range(Cells(ActiveWindow. SplitRow + 1, > ActiveWindow.SplitColumn + 1).Address) > ActiveWorkbook.Save > Next > End Sub > > Regards, > Kaushik Savla > -- > 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 <https://www.facebook.com/discussexcel> > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor
Re: $$Excel-Macros$$ Need help in Vba Macro
This is think will definitely help. Thanks. On May 24, 2017 00:23, "Paul Schreiner" <schreiner_p...@att.net> wrote: > That's very CPU intensive because it copies all cells to the clipboard > and pastes them from clipboard. > which can be a HUGE number of cells for each sheet. > > If you simply want to break the external links, you can use something like: > > alinks = ActiveWorkbook.LinkSources(xlExcelLinks) > > If Not IsEmpty(alinks) Then > For inx = 1 To UBound(alinks) > ActiveWorkbook.BreakLink _ > Name:=alinks(inx), _ > Type:=xlLinkTypeExcelLinks > Next inx > End If > > This will break links to EXTERNAL workbooks (and convert to values) > but it doesn't do anything to the links to worksheets within the current > workbook. > > does that help? > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Tuesday, May 23, 2017 2:03 PM, KAUSHIK SAVLA <savla.kaus...@gmail.com> > wrote: > > > Hi Team, > > I am trying to do below in an excel. You can assume there are 60 > worksheets minimum in a workbook. > > 1. In opened excel file. Which has links from several files > 2. All cells of the workbook I am doing paste special values > 3. Then to come at the first cell in all worksheets (i.e. Cell A1) > 4. Then to come at first tab, first cell, Save the workbook here (so > whenever excel opens the person will see first sheet, first cell) > 5. Close the workbook > > I am having below vba code. It is taking forever to run (minimum 15-20 > minutes). Can anyone please help in boosting speed so could be run in > fraction of seconds. > > > Sub Select_All_Sheets() > Dim sht As Worksheet > Dim SelectMe() As String > Dim s As Integer > For Each sht In Worksheets > s = s + 1 > ReDim Preserve SelectMe(1 To s) As String > SelectMe(s) = sht.Name > Sheets(SelectMe).Select > Cells.Select > Selection.Copy > Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, > SkipBlanks _ > :=False, Transpose:=False > Application.CutCopyMode = False > Application.Goto Range(Cells(ActiveWindow.SplitRow + 1, > ActiveWindow.SplitColumn + 1).Address) > ActiveWorkbook.Save > Next > End Sub > > Regards, > Kaushik Savla > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsib
$$Excel-Macros$$ Links
Hi Team, I have several huge data files. Each file has links to several worksheets and several workbooks. Can anyone help me with a vba code which will go in each worksheet of workbook and will fetch me result mentioning each worksheet has source from which worksheets/workbooks. Doing it manually is impossible. Regards, Kaushik Savla -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Need help in Vba Macro
Hi Team, I am trying to do below in an excel. You can assume there are 60 worksheets minimum in a workbook. 1. In opened excel file. Which has links from several files 2. All cells of the workbook I am doing paste special values 3. Then to come at the first cell in all worksheets (i.e. Cell A1) 4. Then to come at first tab, first cell, Save the workbook here (so whenever excel opens the person will see first sheet, first cell) 5. Close the workbook I am having below vba code. It is taking forever to run (minimum 15-20 minutes). Can anyone please help in boosting speed so could be run in fraction of seconds. Sub Select_All_Sheets() Dim sht As Worksheet Dim SelectMe() As String Dim s As Integer For Each sht In Worksheets s = s + 1 ReDim Preserve SelectMe(1 To s) As String SelectMe(s) = sht.Name Sheets(SelectMe).Select Cells.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False Application.Goto Range(Cells(ActiveWindow.SplitRow + 1, ActiveWindow.SplitColumn + 1).Address) ActiveWorkbook.Save Next End Sub Regards, Kaushik Savla -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ VBA Required - For links in worksheet
Hi Team, Need your help in formulating a macro in the attached file which will do the following:- 1. there are many worksheets in the attached file 2. In the attached file, in each sheet data is coming from link in another worksheet. 3. What I want to do is - I want one sheet to be inserted. In that sheet it should have name of all the tabs. And against each name of tab in the inserted sheet it should have name of the tab from which data is flowing in the tab. For example:- Sheet1 - In this sheet data is coming from tab Sheet2. I want sheet 2 to be shown against Sheet 1. Sheet2 - In this sheet data is coming from tab Sheet3 and Sheet4. I want sheet3, Sheet4 against Sheet 2. Sheet3 - In this sheet data is coming from tab Sheet4, Sheet5 and Sheet7. I want Sheet4, Sheet5 and Sheet7 against Sheet3. And so on Please help. -- *Warm Regards,* *Kaushik Savla* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Sample File.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ VBA required - Finding duplicates and adding all in one new worksheet
Thanks.Macro works for what I was looking for. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Require a formula
Hi Team, Need a formula which will do the following in attached spreadsheet: I want to group the Ageing (Column E) as below:- less than or equal to 7 Upto 7 More than 7 but less than or equal to 14 Greater than 7 but less than or equal to 14 More than 14 but less than or equal to 30 Greater than 14 but less than or equal to 30 More than 30 Greater than 30 -- *Warm Regards,* *Kaushik Savla* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Formula for grouping.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Need help on silly problem quickly
Hi Team, Request you to kindly provide me solution to below silly problem I am facing in excel. I am trying to get sum of data range B2 to B6 in cell B8. Answer which I am getting is not correct, seems some problem with formatting. Pls help. -- *Warm Regards,* *Kaushik Savla* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need help on silly problem quickly
Thanks Prafull and Noorain sir. On Wed, Sep 4, 2013 at 2:33 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Remove* * from formula ...for number value On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Hi Team, Request you to kindly provide me solution to below silly problem I am facing in excel. I am trying to get sum of data range B2 to B6 in cell B8. Answer which I am getting is not correct, seems some problem with formatting. Pls help. -- *Warm Regards,* *Kaushik Savla* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Warm Regards,* *Kaushik Savla* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Need help on silly problem quickly
Thanks Ravi! On Wed, Sep 4, 2013 at 2:38 PM, Ravi Kumar excellearn2...@gmail.com wrote: Hi, ** ** ** ** Here is ur solution ** ** Don’t use “1” when u put number in if condition always give numbers as it is. There is no need to give like “-1”, “1”. Simply right -1, 1. ** ** ** ** * * *Warm Regards,* *Ravi Kumar.* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *KAUSHIK SAVLA *Sent:* Wednesday, September 04, 2013 2:26 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need help on silly problem quickly ** ** Hi Team, ** ** Request you to kindly provide me solution to below silly problem I am facing in excel. ** ** I am trying to get sum of data range B2 to B6 in cell B8. Answer which I am getting is not correct, seems some problem with formatting. ** ** Pls help. -- *Warm Regards,* *Kaushik Savla* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Warm Regards,* *Kaushik Savla* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Concatenate range of cells in excel
Hi Team, I am having some data in Cell A1 to A100 and I want to concatenate range of data from A1 to A100 with comma as seperator. Example: Cells A1 10 A2 20 A3 30 so on I want result as 10, 20, 30 so on. Please help. Warm Regards, Kaushik Savla -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Concatenate range of cells in excel
Thanks Vijay and Ahmed to resolve the query. Regards, Kaushik -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Fwd: Urgent job opening with Atos for VBA_Gurgaon
Fyi -- Forwarded message -- From: Abyss Horizon Consulting Pvt. Ltd. i...@monsterindia.com Date: Jun 17, 2013 2:19 PM Subject: Urgent job opening with Atos for VBA_Gurgaon To: savla.kaus...@gmail.com To respond back directly to the Employer, please click on Reply button, or send an email to anus...@ahcindia.com (Please don't delete or modify while replying to this email) *For Internal Use of Employer* - Monster Resume ID: 3540940 Personal Folder ID: 13512253 Dear Kaushik, Hi, This is with reference to a suitable career prospect and job opportunity. Abyss Horizon Consulting has been proactive in fulfilling career objectives. Company Name: Atos Job Location: Gurgaon Skills: VBA Experience Required: 3 years to 5.5 years Job Type: Contract To Apply for the above opportunity kindly mail your updated resumes on anus...@ahcindia.com including the below details:- 1) Current CTC- 2) Expected CTC- 3) Notice Period- 4) Total IT Experience- 5) Relevant Experience- 6) Educational Qualifications- 7) Present Company- 8) Contact no.- 9) Current Location.- 10) Current Job Type (contract / permanent)- Thanks Regards Anushka N | Executive| Abyss Horizon Consulting Pvt Ltd | Mumbai Main: 25658446 |Email: anus...@ahcindia.com|Visit www.ahcindia.com This mail has been sent by one of the employers (Employer name: Abyss Horizon Consulting Pvt. Ltd.) accessing the services of monsterindia.comhttp://www.monsterindia.comand not by Monster. Monster is committed to protecting the privacy of our users and our “Terms of Use” prohibits any misuse including spamming. If you consider the contents of the mails inappropriate or as spam, please forward this mail to s...@monsterindia.com or mark it Spam http://my.monsterindia.com/report_spam.html?folderid=13512253resid=3540940mail_id=iJwbm1 Click herehttp://my.monsterindia.com/email_verify.html?sig=375098ea304107c3dff4b08bce44dd3eraw=savla.kaus...@gmail.comtype=abuseto disable your account if you are not the intended recipient. *Double your chances of getting the right job by keeping your resume updated.* *Update Resume now* http://my.monsterindia.com/login.html?spl=empmailjun19 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Macro - To Combine data from multiple worksheets into one single worksheet
Hi Team, Need your help in creating the macro doing the below:- I am having huge data in different worksheets I am having 10 worksheets in total I want to get the data copied from each worksheet and to combine in one worksheet and name the combined data sheet as Combined Data Note: The biggest challenge I am facing is there is no fix range of the data in each worksheet. Eg in one worksheet there is data upto 200 rows, in another 240 rows, etc. Need your help. Thanks, Kaushik Savla -- 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.
$$Excel-Macros$$ Vba code for pivot table drill down and renaming sheet
Hi All, Need your help in pivot table drill down. I am having huge excel database around 15 rows having whole data of different accounts. I want to create a pivot on it on basis of Account No. and Amount which is located in column K and F respectively. After pivot table is created with above criteria, I want to drill down all the account from pivot table in different sheets and to rename the sheet with the pivot table details extracted ie name of the account no. Pls help with vba macro, since there are above 200 accounts, drilling down each account and renaming it will take 1 day which I do not have since need to get this prepared in 1 hour as per deadline. Pls take any hypothetical example. Thanks in advance for your help. Regards, Kaushik -- 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$$ Vba code for pivot table drill down and renaming sheet
Hi, Please find attached sample file. Instructions:- 1. I want to create Pivot Table based on data in Sheet 1 (range A3 to L1048576 In Row Label : Account In Values : Sum of Amount 2. I want to have drill down of every account one by one in different sheet and to rename the sheet with account accordingly. Eg. 105001, 105100, 105102, etc I am having 205 such accounts for which data need to be extracted in different sheet and to rename accordingly based on account. Please find attached sample solution file. I want vba code to do above instructions. Please let me know if you have any questions. Regards, Kaushik On Mon, May 27, 2013 at 8:03 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: Please attach File, I know how to handle new look. 2013/5/27 KAUSHIK SAVLA savla.kaus...@gmail.com Hi All, Need your help in pivot table drill down. I am having huge excel database around 15 rows having whole data of different accounts. I want to create a pivot on it on basis of Account No. and Amount which is located in column K and F respectively. After pivot table is created with above criteria, I want to drill down all the account from pivot table in different sheets and to rename the sheet with the pivot table details extracted ie name of the account no. Pls help with vba macro, since there are above 200 accounts, drilling down each account and renaming it will take 1 day which I do not have since need to get this prepared in 1 hour as per deadline. Pls take any hypothetical example. Thanks in advance for your help. Regards, Kaushik -- 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. -- *Warm Regards,* *Kaushik Savla* -- 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
Fwd: Re: $$Excel-Macros$$ Vba code for pivot table drill down and renaming sheet
Hi team, Awaiting for response in below query. Appreciate your help in looking into it. Regards, Kaushik -- Forwarded message -- From: KAUSHIK SAVLA savla.kaus...@gmail.com Date: May 27, 2013 8:42 PM Subject: Re: $$Excel-Macros$$ Vba code for pivot table drill down and renaming sheet To: excel-macros@googlegroups.com Hi, Please find attached sample file. Instructions:- 1. I want to create Pivot Table based on data in Sheet 1 (range A3 to L1048576 In Row Label : Account In Values : Sum of Amount 2. I want to have drill down of every account one by one in different sheet and to rename the sheet with account accordingly. Eg. 105001, 105100, 105102, etc I am having 205 such accounts for which data need to be extracted in different sheet and to rename accordingly based on account. Please find attached sample solution file. I want vba code to do above instructions. Please let me know if you have any questions. Regards, Kaushik On Mon, May 27, 2013 at 8:03 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: Please attach File, I know how to handle new look. 2013/5/27 KAUSHIK SAVLA savla.kaus...@gmail.com Hi All, Need your help in pivot table drill down. I am having huge excel database around 15 rows having whole data of different accounts. I want to create a pivot on it on basis of Account No. and Amount which is located in column K and F respectively. After pivot table is created with above criteria, I want to drill down all the account from pivot table in different sheets and to rename the sheet with the pivot table details extracted ie name of the account no. Pls help with vba macro, since there are above 200 accounts, drilling down each account and renaming it will take 1 day which I do not have since need to get this prepared in 1 hour as per deadline. Pls take any hypothetical example. Thanks in advance for your help. Regards, Kaushik -- 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. -- *Warm Regards,* *Kaushik Savla* -- 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
Fwd: $$Excel-Macros$$ Time Tracking Tracker
Hi team, Awaiting ur valuable response on my below email. Regards, Kaushik Savla -- Forwarded message -- From: KAUSHIK SAVLA savla.kaus...@gmail.com Date: Apr 15, 2013 8:21 PM Subject: Fwd: $$Excel-Macros$$ Time Tracking Tracker To: excel-macros@googlegroups.com Hi All, I am getting error message when I am trying to apply the below macro code:- Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim pwd pwd = Test If (Target.Count = 1) Then If (Target.Value X = X) Then If (Target.Column = 5) Or (Target.Column = 6) Then ActiveSheet.Unprotect Password:=pwd ActiveCell.Value = Now() ActiveSheet.Protect DrawingObjects:=True, _ Contents:=True, _ Scenarios:=True, _ AllowFormattingCells:=True, _ AllowFormattingColumns:=True, _ AllowFormattingRows:=True, _ AllowSorting:=True, _ AllowFiltering:=True, _ Password:=pwd End If End If End If End Sub Pls suggest on it. Regards, Kaushik Savla -- Forwarded message -- From: KAUSHIK SAVLA savla.kaus...@gmail.com Date: Sat, Apr 6, 2013 at 1:15 PM Subject: Re: $$Excel-Macros$$ Time Tracking Tracker To: excel-macros@googlegroups.com excel-macros@googlegroups.com Hi Paul, I am able to use your VBA Code properly. Just have one quick question, I need to send this to team members and do not want them to know the Password to unprotect so there will be no tampering of data. In your code you have mentioned pwd = Test in 4th line which can be accessible by anyone. Is there any way I will be only knowing the password to unprotect without getting displayed to all. Regards, Kaushik Savla On Fri, Apr 5, 2013 at 8:41 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Thank You for the help. On Friday, April 5, 2013, Paul Schreiner schreiner_p...@att.net wrote: Here's what I did: In the Sheet module, create a double-click event: Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim pwd pwd = Test If (Target.Count = 1) Then If (Target.Value X = X) Then If (Target.Column = 4) Or (Target.Column = 5) Then ActiveSheet.Unprotect Password:=pwd ActiveCell.Value = Now() ActiveSheet.Protect DrawingObjects:=True, _ Contents:=True, _ Scenarios:=True, _ AllowFormattingCells:=True, _ AllowFormattingColumns:=True, _ AllowFormattingRows:=True, _ AllowSorting:=True, _ AllowFiltering:=True, _ Password:=pwd End If End If End If End Sub --- I changed the display format of columns D-F to display time. In column F, I entered the formula: =IF(AND(D2,E2),E2-D2,) and copied it down the column. I then changed the format of all cells in the sheet to locked and protected the sheet. As you can see in the macro, I used the password test If you use something else, change the value in the macro. hope this helps Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: KAUSHIK SAVLA savla.kaus...@gmail.com To: excel-macros@googlegroups.com Sent: Fri, April 5, 2013 5:25:11 AM Subject: $$Excel-Macros$$ Time Tracking Tracker Hi Team, I need Time Management Tracker which does the following:- If anyone double click in start time column the time of system get capture automatically which cannot be edited , similarly for end time. Need password protected to enable changes my myself. Regards, Kaushik -- 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
Fwd: $$Excel-Macros$$ Time Tracking Tracker
Hi All, I am getting error message when I am trying to apply the below macro code:- Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim pwd pwd = Test If (Target.Count = 1) Then If (Target.Value X = X) Then If (Target.Column = 5) Or (Target.Column = 6) Then ActiveSheet.Unprotect Password:=pwd ActiveCell.Value = Now() ActiveSheet.Protect DrawingObjects:=True, _ Contents:=True, _ Scenarios:=True, _ AllowFormattingCells:=True, _ AllowFormattingColumns:=True, _ AllowFormattingRows:=True, _ AllowSorting:=True, _ AllowFiltering:=True, _ Password:=pwd End If End If End If End Sub Pls suggest on it. Regards, Kaushik Savla -- Forwarded message -- From: KAUSHIK SAVLA savla.kaus...@gmail.com Date: Sat, Apr 6, 2013 at 1:15 PM Subject: Re: $$Excel-Macros$$ Time Tracking Tracker To: excel-macros@googlegroups.com excel-macros@googlegroups.com Hi Paul, I am able to use your VBA Code properly. Just have one quick question, I need to send this to team members and do not want them to know the Password to unprotect so there will be no tampering of data. In your code you have mentioned pwd = Test in 4th line which can be accessible by anyone. Is there any way I will be only knowing the password to unprotect without getting displayed to all. Regards, Kaushik Savla On Fri, Apr 5, 2013 at 8:41 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Thank You for the help. On Friday, April 5, 2013, Paul Schreiner schreiner_p...@att.net wrote: Here's what I did: In the Sheet module, create a double-click event: Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim pwd pwd = Test If (Target.Count = 1) Then If (Target.Value X = X) Then If (Target.Column = 4) Or (Target.Column = 5) Then ActiveSheet.Unprotect Password:=pwd ActiveCell.Value = Now() ActiveSheet.Protect DrawingObjects:=True, _ Contents:=True, _ Scenarios:=True, _ AllowFormattingCells:=True, _ AllowFormattingColumns:=True, _ AllowFormattingRows:=True, _ AllowSorting:=True, _ AllowFiltering:=True, _ Password:=pwd End If End If End If End Sub --- I changed the display format of columns D-F to display time. In column F, I entered the formula: =IF(AND(D2,E2),E2-D2,) and copied it down the column. I then changed the format of all cells in the sheet to locked and protected the sheet. As you can see in the macro, I used the password test If you use something else, change the value in the macro. hope this helps Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: KAUSHIK SAVLA savla.kaus...@gmail.com To: excel-macros@googlegroups.com Sent: Fri, April 5, 2013 5:25:11 AM Subject: $$Excel-Macros$$ Time Tracking Tracker Hi Team, I need Time Management Tracker which does the following:- If anyone double click in start time column the time of system get capture automatically which cannot be edited , similarly for end time. Need password protected to enable changes my myself. Regards, Kaushik -- 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
$$Excel-Macros$$ Help needed
Hi Team, I need a formula to find anything starting from 5 in a cell and to take 6 digit right of the cell starting from 5 as below. Eg. DataDesired Result ABC 500012 XYZ 500012 XYZ500134XYZ 500134 Regards, Kaushik -- 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$$ Help needed
Thank You very much for prompt response! On Thu, Apr 11, 2013 at 10:22 PM, ashish koul koul.ash...@gmail.com wrote: =MID(A1,FIND(5,A1),6) On Thu, Apr 11, 2013 at 10:16 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Hi Team, I need a formula to find anything starting from 5 in a cell and to take 6 digit right of the cell starting from 5 as below. Eg. DataDesired Result ABC 500012 XYZ 500012 XYZ500134XYZ 500134 Regards, Kaushik -- 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* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Warm Regards,* *Kaushik Savla* -- 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.
$$Excel-Macros$$ Time Tracking Tracker
Hi Team, I need Time Management Tracker which does the following:- If anyone double click in start time column the time of system get capture automatically which cannot be edited , similarly for end time. Need password protected to enable changes my myself. Regards, Kaushik -- 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. Time Tracking.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Time Tracking Tracker
Hi Paul, I am able to use your VBA Code properly. Just have one quick question, I need to send this to team members and do not want them to know the Password to unprotect so there will be no tampering of data. In your code you have mentioned pwd = Test in 4th line which can be accessible by anyone. Is there any way I will be only knowing the password to unprotect without getting displayed to all. Regards, Kaushik Savla On Fri, Apr 5, 2013 at 8:41 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Thank You for the help. On Friday, April 5, 2013, Paul Schreiner schreiner_p...@att.net wrote: Here's what I did: In the Sheet module, create a double-click event: Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim pwd pwd = Test If (Target.Count = 1) Then If (Target.Value X = X) Then If (Target.Column = 4) Or (Target.Column = 5) Then ActiveSheet.Unprotect Password:=pwd ActiveCell.Value = Now() ActiveSheet.Protect DrawingObjects:=True, _ Contents:=True, _ Scenarios:=True, _ AllowFormattingCells:=True, _ AllowFormattingColumns:=True, _ AllowFormattingRows:=True, _ AllowSorting:=True, _ AllowFiltering:=True, _ Password:=pwd End If End If End If End Sub --- I changed the display format of columns D-F to display time. In column F, I entered the formula: =IF(AND(D2,E2),E2-D2,) and copied it down the column. I then changed the format of all cells in the sheet to locked and protected the sheet. As you can see in the macro, I used the password test If you use something else, change the value in the macro. hope this helps Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: KAUSHIK SAVLA savla.kaus...@gmail.com To: excel-macros@googlegroups.com Sent: Fri, April 5, 2013 5:25:11 AM Subject: $$Excel-Macros$$ Time Tracking Tracker Hi Team, I need Time Management Tracker which does the following:- If anyone double click in start time column the time of system get capture automatically which cannot be edited , similarly for end time. Need password protected to enable changes my myself. Regards, Kaushik -- 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
Re: $$Excel-Macros$$ Trouble in 2007
On Oct 21, 2012 5:31 PM, SAJID MEMON sajidwi...@hotmail.com wrote: Dear experts, I have done a small project in excel 2003 with some command buttons. when i open my project in excel 2007 then command buttons are not press or working. Why this problem come in 2007? please give me settings or any suggesstion. I have checked micro to enabled and desabled but same promblems is constant. Awaiting your positive responce Regards Sajid Memon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012
Congratulations Noorain. Regards, Kaushik Savla On Sep 2, 2012 10:44 AM, in.vaib...@gmail.com wrote: ** Congrats Noorain.. Rgds Vaibhav -- *From: * Ayush Jain jainayus...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Sun, 2 Sep 2012 10:32:31 +0530 *To: *excel-macrosexcel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Cc: *NOORAIN ANSARInoorain.ans...@gmail.com *Subject: *$$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012 Dear members, Once again, Noorain Ansari has been selected as 'Most Helpful Member' for the month of Aug'12. He has posted 111 posts in August 2012 and helped many forum members through his excel expertise. I truly appreciate his consistency and commitment to the group. He is really doing great job. *Noorain, please find enclosed the award certificate in honour of your contribution.* Thanks to all other folks for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager Microsoft MVP -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Pivot Table Vba Help needed
Hi All, *Need your help to perform the attached task.* * * *What I am doing is as below:=* * * *1. I am having the data in the Data tab of the file* *2. I want to create the Pivot table based on the Data tab with Criteria as Row Labels: Supplier and Values: Sum of Amount.* *3. Then I want to extract the details of each supplier in different tab so as to create an invoice for the individual supplier showing them the transactions during the amount. The extracted data should automatically extract data from pivot for as many supplier available. In the attached file as instance there are 4 suppliers namely A,B,C,D.* *4. The extracted data should automatically rename the worksheet tab containing the name of supplier.* * * *Looking forward for your prompt response.* * * *Regards,* *Kaushik Savla* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Sirish.xlsm Description: Binary data
Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari
Hi Noorain, Congratulations Thanks for helping us always. Regards, Kaushik -- 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$$ Attachments getting deleted in Outlook while replying emails
Hi, Good Morning I am facing problem in MS Outlook. I am receiving emails with attachments but when I reply to that email attachments gets deleted. Please sugegst me the corrective action. Many thanks in anticipation of your assistance. Regards, Kaushik Savla -- 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$$ Attachments getting deleted in Outlook while replying emails
Many thanks Asa for your reply. Regards, Kaushik On Feb 10, 2012 10:57 AM, Asa Rossoff a...@lovetour.info wrote: Does the attachment gets deleted from the original email in your Inbox? I have not heard of that before. If you mean your reply email does not include the attachment that was sent to you: that is normal. If you reply in HTML or Rich Text (only use Rich Text for Outlook to Outlook emails) format, any embedded images and objects in the body of the email will be included in your reply, but file attachments will be excluded. If you want to include attachments sent to you in your reply, Forward the message instead of replying to it. Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Thursday, February 09, 2012 6:15 PM To: excel-macros Subject: $$Excel-Macros$$ Attachments getting deleted in Outlook while replying emails Hi, Good Morning I am facing problem in MS Outlook. I am receiving emails with attachments but when I reply to that email attachments gets deleted. Please sugegst me the corrective action. Many thanks in anticipation of your assistance. Regards, Kaushik Savla -- 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$$ Outlook automation help needed
Hi, I am looking for solution to below:- I receive No. of emails from some people asking for tax advise in Outlook 2003. Then I create tax advice and I attach the file. I need to reply to the email received below:- Hi *Sender*(as per email), As requested, please find attached below payslip showing tax payable. (Attachment file would be here from specific file path) Kindly let me know in case you require further information. Best Regards, Kaushik Savla - Assistant Manager JLT India Pvt Ltd What I want to do - Firstly, I want Sender name to be captured automatically as per email received from sender. Secondly, I want a code which will write the above green highlighted text message automatically. Thirdly, I want the file to be attached automatically. Pleas note I do not want to send mail automatically, i want pop up box after reviewing of which i can send the emails. Please suggest me some solution. Your valuable time is highly appreciated in this matter. Anticipating your assistance on aforesaid matter. Regards, -- 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$$ excell to pdf
Hi Chandra, It is not working in my system Cold you please what you did to get it worked properly? Regards, Kaushik -- 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$$ excell to pdf
Hi Rajan, I am using excel 2007 version. Regards, Kaushik -- 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$$ excell to pdf
Hi Rajan, Problem resolved. Excellent job to help us on this article. Regards, Kaushik -- 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$$ Converting pdf to excel?
Hi Noorain, Unable to find anything as reference in tools option in Acrobat 9. Please suggest. Regards, Kaushik -- 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$$ Converting pdf to excel?
Hi Sam, I have Acrobat 9 installed in my system. Pls suggest. Regards, Kaushik Savla -- 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$$ Converting pdf to excel?
Hi Sam, In your email there is no attachment or print screen. can you please let me know which window you are getting? Regards, Kaushik -- 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$$ Converting pdf to excel?
Thanks for the reply. Mr Excel tip requires a software named as Able2Extract professional. I don't want to use any software/converter. I want VBA Code for conversion. Please help me. Regards, Kaushik Savla -- 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$$ Converting pdf to excel?
That code not working too. Pls suggest. Regards, Kaushik Savla -- 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$$ Smartstream Application
Hi, Does any one uses Smarstream application for uploading Accounting Journal Entries? Best Regards, Kaushik Savla -- 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- Dec'2011
Congrats Rajan. Many thanks for devoting your valuable time daily from your busy schedule. Regards, Kaushik Savla -- 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$$ Happy Birth Day
Happy Birthday Noorain. On Jan 2, 2012 8:36 PM, Kris krishnak...@gmail.com wrote: Happy B'day Noorain ! -- FORUM RULES (934+ 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 (934+ 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$$ Vba Code for Line Spacing to zero in Outlook 2003
Hi, I want a vba code to have line spacing as zero in my signature. Currently when I am creating an email I am getting my signature dispayed as below:- Kaushik Savla Assistant Manager – Jardine Discretionary Trust Accounting JLT India Pvt Ltd Direct Line: +91 022 43377441, Extenstion # 4141 Mobile No. +91 7738 44 9292; +91 932 4855 344 I want it to be dispayed as below:- Kaushik Savla Assistant Manager – Jardine Discretionary Trust Accounting JLT India Pvt Ltd Direct Line: +91 022 43377441, Extenstion # 4141 Mobile No. +91 7738 44 9292; +91 932 4855 344 I am using Outlook 2003. Please help on it. Regards, Kaushik Savla -- FORUM RULES (934+ 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$$ Vba Code for Line Spacing to zero in Outlook 2003
Hi Rajan, Could you please suggest how to do it? Regards, Kaushik Savla On Wed, Dec 28, 2011 at 7:14 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Try to adjust paragraph setting in your signature Option.. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *KAUSHIK SAVLA *Sent:* Dec/Wed/2011 07:09 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Vba Code for Line Spacing to zero in Outlook 2003 ** ** Hi, I want a vba code to have line spacing as zero in my signature. Currently when I am creating an email I am getting my signature dispayed as below:- Kaushik Savla Assistant Manager – Jardine Discretionary Trust Accounting JLT India Pvt Ltd Direct Line: +91 022 43377441, Extenstion # 4141 Mobile No. +91 7738 44 9292; +91 932 4855 344 I want it to be dispayed as below:- Kaushik Savla Assistant Manager – Jardine Discretionary Trust Accounting JLT India Pvt Ltd Direct Line: +91 022 43377441, Extenstion # 4141 Mobile No. +91 7738 44 9292; +91 932 4855 344 I am using Outlook 2003. Please help on it. Regards, Kaushik Savla -- FORUM RULES (934+ 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 (934+ 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 (934+ 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$$ Vba code required
Hi, I am looking for solution to below:- I receive No. of emails from some people asking for tax advise in Outlook 2003. Then I create tax advice and I attach the file. I need to reply to the email received below:- Hi *Sender*(as per email), As requested, please find attached below payslip showing tax payable. (Attachment file would be here) Kindly let me know in case you require further information. Best Regards, Kaushik Savla - Assistant Manager JLT India Pvt Ltd What I want to do - Firstly, I want Sender name to be captured automatically as per email received from sender. Secondly, I want a code which will write the above green highlighted text message automatically. Please suggest me some solution. Your valuable time is highly appreciated in this matter. Anticipating your assistance on aforesaid matter. Regards, Kaushik Savla -- FORUM RULES (934+ 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 - Macro Code required for Outlook
Hi Noorain, Many thanks for the response. I tried but it is not working. Further I don't want any excel spreadsheet to be used. I just want to use only Outlook. Please suggest. Regards, Kaushik Savla -- FORUM RULES (934+ 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 - Macro Code required for Outlook
Hi Noorain, I am using Micorsoft Outlook 2007. Where can I find object library? Secondly I want sender name to automatically displayed as per email received. Regards, Kaushik Savla On Mon, Dec 12, 2011 at 8:28 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Salva, First select *Tools-Reference-Microsoft Outlook 12.0 Object Liberary* Please use below code Sub outlook_mail() Dim olapp As Outlook.Application Dim olitem As MailItem Set olapp = New Outlook.Application Set olitem = olapp.CreateItem(olmailitem) With olitem .To = noorain.ans...@gmail.com .CC = noorain.ans...@gmail.com .Subject = tax advise .Body = Hi Sender(as per email), VBA.Chr(10) VBA.Chr(10) As requested, please find attached below payslip showing tax payable. VBA.Chr(10) VBA.Chr(10) Kindly let me know in case you require further information VBA.Chr(10) VBA.Chr(10) Best Regards, VBA.Chr(10) Kaushik Savla - Assistant Manager VBA.Chr(10) JLT India Pvt Ltd .Send End With Set olitem = Nothing End Sub On Mon, Dec 12, 2011 at 7:31 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Hi Noorain, Many thanks for the response. I tried but it is not working. Further I don't want any excel spreadsheet to be used. I just want to use only Outlook. Please suggest. Regards, Kaushik Savla -- FORUM RULES (934+ 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://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- FORUM RULES (934+ 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 (934+ 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$$ Help on Outlook Vba - Auto reply with name and greetings
Hi Experts, I found the below Vba Code for Inserting name in reply or inserting greeting in reply automatically. Sub InsertNameInReply() Dim Msg As Outlook.MailItem Dim MsgReply AsOutlook.MailItem Dim strGreetName As String Dim lGreetType As Long ' set reference to open/selected mail item On Error Resume Next Select CaseTypeName(Application.ActiveWindow) Case Explorer Set Msg = ActiveExplorer.Selection.item(1) Case Inspector Set Msg = ActiveInspector.CurrentItem Case Else End Select On Error Goto 0 If Msg Is Nothing Then Goto ExitProc ' figure out greeting line On Error Resume Next lGreetType = InputBox(How to greet: vbCr vbCr Type '1' for name, '2' for time of day) On Error Goto 0 If lGreetType = False Then Goto ExitProc If lGreetType = 1 Then strGreetName = Left$(Msg.SenderName, InStr(1, Msg.SenderName, ) - 1) ElseIf lGreetType = 2 Then Select CaseTime Case Is 0.5 strGreetName = Good morning Case 0.5 To 0.75 strGreetName = Good afternoon Case Else strGreetName = Good evening End Select Else ' something else entered?? Goto ExitProc End If Set MsgReply = Msg.Reply WithMsgReply .Subject = RE: Msg.Subject .HTMLBody = span style=font-family : verdana;font-size : 10ptpHello strGreetName ,/p/span .HTMLBody .Display End With ExitProc: Set Msg = Nothing Set MsgReply = Nothing End Sub But actually I am looking for insertion of both ie Name as well as greetings automatically. Please help on it. Regards, Kaushik Savla -- FORUM RULES (934+ 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$$ Fwd: Vba Code for Outlook
Hi Guys, I am waiting for any response on below Vba query in Outlook. Request you to look into it and help me. Regards, Kaushik Savla -- Forwarded message -- From: KAUSHIK SAVLA savla.kaus...@gmail.com Date: Sat, Dec 10, 2011 at 3:58 PM Subject: Vba Code for Outlook To: excel-macros@googlegroups.com Hi All, I am looking for solution to below:- I receive No. of emails from some people asking for tax advise. Then I create tax advice and I attach the file. I need to reply to the email received below:- Hi *Sender*(as per email), As requested, please find attached below payslip showing tax payable. (Attachment file would be here) Kindly let me know in case you require further information. Best Regards, Kaushik Savla - Assistant Manager JLT India Pvt Ltd What I want to do - Firstly, I want a code which will write the above green highlighted text message automatically. Secondly, I want Sender name to be captured automatically as per email received from sender. Please suggest me some solution. Your valuable time is highly appreciated in this matter. Regards, Kaushik Savla Mobile 7738 44 9292 -- FORUM RULES (934+ 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$$ Vba Code for Outlook
Hi All, I am looking for solution to below:- I receive No. of emails from some people asking for tax advise. Then I create tax advice and I attach the file. I need to reply to the email received below:- Hi *Sender*(as per email), As requested, please find attached below payslip showing tax payable. (Attachment file would be here) Kindly let me know in case you require further information. Best Regards, Kaushik Savla - Assistant Manager JLT India Pvt Ltd What I want to do - Firstly, I want a code which will write the above green highlighted text message automatically. Secondly, I want Sender name to be captured automatically as per email received from sender. Please suggest me some solution. Your valuable time is highly appreciated in this matter. Regards, Kaushik Savla Mobile 7738 44 9292 -- FORUM RULES (934+ 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$$ Urgent - Macro Code required for Outlook
Hi All, I am looking for solution to below:- I receive No. of emails from some people asking for tax advise. Then I create tax advice and I attach the file. I need to reply to the email received below:- Hi *Sender*(as per email), As requested, please find attached below payslip showing tax payable. (Attachment file would be here) Kindly let me know in case you require further information. Best Regards, Kaushik Savla - Assistant Manager JLT India Pvt Ltd What I want to do - Firstly, I want a code which will write the above green highlighted text message automatically. Secondly, I want Sender name to be captured automatically as per email received from sender. Please suggest me some solution. Your valuable time is highly appreciated in this matter. Regards, Kaushik Savla Mobile 7738 44 9292 -- FORUM RULES (934+ 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$$ Excel Filter Data Help required
Thanks all for the help Problem got resolved, Regards, Kaushik -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Help required on Importing Data
Hi All, How to import only selected data from another workbook? Please help. Regards, Kaushik -- Sent from Gmail for mobile | mobile.google.com Kaushik Savla -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ unable to run macro properly
Hi All, I am trying to run the below macro code in the attached file. Code is running properly since i am not getting any error message. But i am getting in Row D2 to H2 TRUE and not the calculation value. Option Explicit Sub SumifsFormula() ' ' SumifsFormula Macro ' Sumifs Formula for calculating current month total ' ' Range(D2).Select ActiveCell.FormulaR1C1 = _ SUMIFS(D$3:D$200,$C$3:$C$20, EOMONTH(MAX($D$3:$D$20),-1)) Range(D2).Select Selection.Copy Range(D2:H2).Select ActiveSheet.Paste Application.CutCopyMode = False Calculate End Sub Please help on this macros. Regards, kaushik savla -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Sumifs.xlsm Description: Binary data
Re: $$Excel-Macros$$ Help required on Importing Data
Query on paste link - Should i select each worksheet of workbook and do the paste special value paste link? If so then is there any shortcut to link whole workbook to another workvook. Regards, Kaushik On 8/4/11, XLS S xlst...@gmail.com wrote: Use paste special with paste link.. On Wed, Aug 3, 2011 at 4:47 PM, KAUSHIK SAVLA savla.kaus...@gmail.com wrote: Hi All, How to import only selected data from another workbook? Please help. Regards, Kaushik -- Sent from Gmail for mobile | mobile.google.com Kaushik Savla -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sent from Gmail for mobile | mobile.google.com Kaushik Savla -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Vba Code required to link every cell of workbook to another workbook
It will take a lot of time initially. If there is any code or formula then would be helpful very much. Regards, Kaushik -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ KAUSHIK SAVLA wants to chat
--- KAUSHIK SAVLA wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-f8192d6cd9-72f73129e5-C7TBpa-Kz4A3NYkZ_J1GeRZjtpk You'll need to click this link to be able to chat with KAUSHIK SAVLA. To get Gmail - a free email account from Google with over 2,800 megabytes of storage - and chat with KAUSHIK SAVLA, visit: http://mail.google.com/mail/a-f8192d6cd9-72f73129e5-C7TBpa-Kz4A3NYkZ_J1GeRZjtpk Gmail offers: - Instant messaging right inside Gmail - Powerful spam protection - Built-in search for finding your messages and a helpful way of organizing emails into conversations - No pop-up ads or untargeted banners - just text ads and related information that are relevant to the content of your messages All this, and its yours for free. But wait, there's more! By opening a Gmail account, you also get access to Google Talk, Google's instant messaging service: http://www.google.com/talk/ Google Talk offers: - Web-based chat that you can use anywhere, without a download - A contact list that's synchronized with your Gmail account - Free, high quality PC-to-PC voice calls when you download the Google Talk client We're working hard to add new features and make improvements, so we might also ask for your comments and suggestions periodically. We appreciate your help in making our products even better! Thanks, The Google Team To learn more about Gmail and Google Talk, visit: http://mail.google.com/mail/help/about.html http://www.google.com/talk/about.html (If clicking the URLs in this message does not work, copy and paste them into the address bar of your browser). -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Poem - जोर से बोलो दम लगा के जय, Excel -Macro परिवार.
excellent poem Regards, Kaushik -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ excel function required to sum data on basis of criteria
Hi All, I want excel function which can calculate the total of latest month relating to latest year. Please find attached file for the data. Please help. Regards, Kaushik -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Book2.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ excel function required to sum data on basis of criteria
HI, Answer should come to 10 as per row no. 16 which is latest from the given data (ie May 2011 latest month from available data, and total of May 2011 is 10) But in the attavhed sheet answer is coming as 80 which is incorrect. Regards, Kaushik -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Vba Code required
Thanks Rajan, But Vba is not ending. It is giving me debug required at End If in Vba Code, further the totals are also not tying after Vba Code applying. Please do the needful by looking it again. Regards, Kaushik -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Vba Code required
Thanks Rajan. It works perfectly Regards, Kaushik -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Help Required (Excel Function or VBA Code)
Thanks all. Formula works but counts one less, so i am adding one manually. Regards, Kaushik - On Tue, Jul 26, 2011 at 4:41 PM, Daniel dcolarde...@free.fr wrote: Hi, ** ** =LEN(A1)-LEN(SUBSTITUTE(A1, ,)) ** ** Regards. Daniel ** ** *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *De la part de* KAUSHIK SAVLA *Envoyé :* mardi 26 juillet 2011 06:07 *À :* excel-macros@googlegroups.com *Objet :* $$Excel-Macros$$ Help Required (Excel Function or VBA Code) ** ** Hi All, I want to count the number of spaces in a cell:- Eg In Cell A1 data is 9 7 5 6 I want function which returns answer as 4 count. Please suggest. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Excel Formula Required - Sum data for every month for respective year.
Thanks All. It works excellent. Regards, Kaushik On Wed, Jul 27, 2011 at 1:18 PM, Haseeb Avarakkan haseeb.avarak...@gmail.com wrote: If you need a formula use SUMPRODUCT or SUMIF See the attached. HTH Haseeb For Tips visit; http://www.excelfox.com/forum/forum.php -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Help Required (Excel Function or VBA Code)
Hi All, I want to count the number of spaces in a cell:- Eg In Cell A1 data is 9 7 5 6 I want function which returns answer as 4 count. Please suggest. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Employee Data
Pivot will be useful rather than using macros. Use macros only if excel functions are not there. On 7/25/11, Adam Hamilton adamchamil...@gmail.com wrote: Hello, I need to take employee data, and run a macro that will allow me to populate many different types of conclusions from this data. For example, If I have the resource, project, hours, description, spend, etc, I would like to be able to quickly see the conclusions of resources spend by project, hours, dollars. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sent from Gmail for mobile | mobile.google.com Kaushik Savla -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique
u can use removw duplicate option in excel. Data then available can bw used as data validation range. On 7/24/11, Venkatesan c venkat1@gmail.com wrote: Dear All, I have attached sheet contains my query on Data Validation - Create a drop down list containing only unique -- *Best Regards,* *Venkat* * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sent from Gmail for mobile | mobile.google.com Kaushik Savla -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ HI --help me
It depends upon the mistakes u do. On 7/24/11, vijayajith VA vijayajith...@gmail.com wrote: Hi, I have one questions.Usually while doing reports what are errors you will get ? Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sent from Gmail for mobile | mobile.google.com Kaushik Savla -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Date Time picker on a userform
U can use date function or today function of excel. On 7/24/11, alisha malhotra alisha.malhotr...@gmail.com wrote: Hi, I am using one userform, In that I need Date time Picker in excel 2003. But when I click on Additional controls Nothing Happens. I need to add some reference for this? How can I add the Date time Picker on a userform? I am attaching the file also. Pls help. Thanks Regards, Alisha -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sent from Gmail for mobile | mobile.google.com Kaushik Savla -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Help on Transpose Function based upon criteria
Hi All, I want to transpose certain data from row to column if meets specific criteria: eg Whole data is as below: Claim No. Amount 1 10 2 20 1 30 1 10 2 20 I want as Claim No. 1 10 30 10 I want transpose to happen if meets criteria that it match the claim number, i have 5 records as such. I have attached an spreadsheet as example Please help its urgent. Regards, Kaushik -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Transpose Help reqd.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Formula required
Hi Priya, Please find attachment. Let me know if you need anything else. Thanks Regrds, Kaushik Savla -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts Copy of query1 Reply by VJ.xls Description: MS-Excel spreadsheet