Re: $$Excel-Macros$$ Excel Formula Required
Hi, Can u explain me what is ur query i did some this pls have a look On Thu, Mar 18, 2010 at 2:31 PM, Venkatesan c venkat1@gmail.com wrote: Dear All, Any one can Assist me attached file query It's something like reverse Lookup -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. query.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ autofill vba
Hi All, I'm trying to fill C6 with value of 1 then selecting that and filling the cell below it with series until the last row of B, my code is not working. whats wrong? thanks Sub Fillnumber() ActiveSheet.Unprotect curr_row = Range(C6).Row curr_col = Range(C6).Column last_row = Range(B65336).End(xlUp).Row 'last_col = Range(anchor_cell).Offset(0, 1).End(xlToRight).Column Range(C6).Select On Error Resume Next Range(C6).FormulaR1C1 = 1 Range(C6).Select Selection.AutoFill Destination:=Range(C6:C last_row), Type:=xlFillSeries Range(C6).Select ActiveSheet.Protect End Sub -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
$$Excel-Macros$$ Delete blank row through macro
Dear Masters, I want to create a macro through which i want to move a copy of active sheet and after that i want to run my macro in duplicate sheet. Macro will delete the row based on following criteria. 1. Blank column A: If in column A the cell is blank macro will delete the entire row. 2. Specific Name for example Manish, if in column ‘A’ name Manish is appeared than macro will delete the row. Hope my text is self explanatory and it’s possible to set two criteria to delete row. Please help me, this will save my lot of time and will make easy my daily activity. Thanks in advance. - Manish Pansari -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
$$Excel-Macros$$ Multiple Row Filters in Same Sheet
*I was working on my data sheet and countered with one problem **I required filters in two row ranges on being specific I want first filter to be placed for data range from Row no. 1 to 200 and second one I want for Row no. 210 to 350. So I try to do it with filter options that are available in Excel 2007 Excel 2010 Beta but not getting it but whenever I put filter on second range first filter goes disappear so with the help of search on various options I got the answer for this problem. And it is here for help of our group members also this we can do without macros. First Go to Insert ribbon in MS Excel 2007 Click on Table Create Table Window will open * *Select the data range* *Mark My Table has headers option * *And repeat same function for another range you will get the desired results. * *Regards Hemant* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
Re: $$Excel-Macros$$ hi all
How to use that, its not working for me? what is the use of that sheet? On Fri, Mar 19, 2010 at 11:54 AM, ashish koul koul.ash...@gmail.com wrote: just find it on goole see if it useful to u -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+ unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- Putta -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
Re: $$Excel-Macros$$ macro efficiency
It's the without looking at the code part that makes it difficult !!! There are LOTS of ways to speed up loops, but everything doesn't always apply! first of all, what version of Excel are you using? Excel2007 has a way of dropping to a lower priority after several seconds, thus causing long running macros to run even longer! To elaborate on what Ayush mentioned: When you're looking for something, why is it always in the last place you look? because once you find it, you stop looking! In Loops, sometimes we forget to stop looking once we find it. Something else. Let's say you're loading an array with data. Then, you're using several loops to look through the array. This can be very cpu-intensive. In true databases, it is possible to create an index. then, your search uses the index, the index returns the record number (or numbers) that matches your search criteria. what i have done is created an index using the Dictionary Object. (or several Objects) I have a spreadsheet of 91,400 rows and 74 columns. the combination the first two columns constitute the unique Record (they are Requisition # and line item#) see this: Sub timetest() Dim tStart, tStop, Dict_Data, R, nRows, TGORitem, stat tStart = Now() Set Dict_Data = CreateObject(Scripting.Dictionary) stat = Dict_Data.RemoveAll nRows = Application.WorksheetFunction.CountA(Sheets(data).Range(A1:a10)) For R = 2 To nRows TGORitem = Sheets(Data).Cells(R, 1).Value . Sheets(Data).Cells(R, 2).Value If (Dict_Data.exists(TGORitem)) Then Dict_Data.Item(TGORitem) = Dict_Data.Item(TGORitem) , R Else Dict_Data.Add TGORitem, R End If Next R tStop = Now() MsgBox DateDiff(s, tStart, tStop) Chr(13) tStart Chr(13) tStop End Sub It takes approximately 3 seconds to load the dictionary. but if I wanted to find the record(s) for Requision: 3000819624.10 it doesn't matter if it is the first record, or in this case record #90162 it finds it instantaneously. And I can have multiple custom indexes. for instance: Dict_Create could be the date a requisition was created. The value of the index would be a comma-separated list of row numbers. I could instead make the index the year-month it was created, or even the Quarter or simply the year. As you can imagine, putting a =VLookup formula in 90,000 rows would cause the file to calculate VERY slowly. But instead, I can create a dictionary index and do the VLookup quickly. if you'd like to send me your code, I would be glad to look it over and see if I see any potentials for improvement!!! Paul From: scubagirl jill.brya...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Thu, March 18, 2010 10:00:34 PM Subject: $$Excel-Macros$$ macro efficiency I have a fairly large VBA project for work - it runs a Monte Carlo simulation on some data that is grabbed from MS Project. It takes longer than I'd like to run - about 4 minutes for 1000 iterations, not including writing out to Excel. I have done everything I can think of to make it efficient: using For Each loops, declaring variables by type, using early binding and Option Explicit... I know that it's not going to be super-speedy given the nature of the project (lots of nested loops, 20x1000 arrays, etc.), but I feel like it should run faster than it does. I've tried timing sections of it, and with a small number of iterations, the speed is not always bad (subsections can take .3 and 1.1 seconds to run), but as I increase the number of iterations, it always seems to run at the worst case (e.g., the aforementioned subsections always take 1.1 seconds to run). Without looking at the code, does anyone have any suggestions for things I can look into to speed up runtime? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our
Re: $$Excel-Macros$$ Real popup without command bar
I would suggest creating a userform. If you already have a button, then you can use it to show the userform. you could even create click-events on the elements of the userform so that it closes/hides the userform when an item is selected. From: Erwin Ahlers eahlers.del...@freenet.de To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Thu, March 18, 2010 4:09:56 PM Subject: $$Excel-Macros$$ Real popup without command bar Hello, it seems not to be possible to program a real popup menu without the usage of a command bar. Is this true? I would like to create a button and when someone click on it a popup (like on the right click on items) is shown at the position of the button. With the command bars I have to create a bar and this is (normally) always visible and on a fixed position, may be even in the higher menu area together with the other bars. Does anyone know if it's possible to make real popups and if yes, give me a hint how to do? Thanks Erwin -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
Re: $$Excel-Macros$$ autofill vba
Hello Dear Attached is the sample sheet, Perhaps it can help you to print achieve suitable result. Hope It Will Help Happy To Help :) Shyam On Fri, Mar 19, 2010 at 12:52 PM, OSAVentures Calamba osav...@gmail.com wrote: Hi All, I'm trying to fill C6 with value of 1 then selecting that and filling the cell below it with series until the last row of B, my code is not working. whats wrong? thanks Sub Fillnumber() ActiveSheet.Unprotect curr_row = Range(C6).Row curr_col = Range(C6).Column last_row = Range(B65336).End(xlUp).Row 'last_col = Range(anchor_cell).Offset(0, 1).End(xlToRight).Column Range(C6).Select On Error Resume Next Range(C6).FormulaR1C1 = 1 Range(C6).Select Selection.AutoFill Destination:=Range(C6:C last_row), Type:=xlFillSeries Range(C6).Select ActiveSheet.Protect End Sub -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- Thanks Regards Shyam Software Engineer '' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '' -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. Loop In Printing After Specific Row.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ hi all
what is it supposed to do? On Fri, Mar 19, 2010 at 9:49 AM, Puttaswamy puttu...@gmail.com wrote: How to use that, its not working for me? what is the use of that sheet? On Fri, Mar 19, 2010 at 11:54 AM, ashish koul koul.ash...@gmail.comwrote: just find it on goole see if it useful to u -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+ unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- Putta -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+ unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
$$Excel-Macros$$ VBA VLookup dates
Hey all, I'm trying to cut down on loading times by converting a load of formulae to code. I'm stuck on this particular formula - =IF(ISERROR(VLOOKUP((C3),fortnight,3,FALSE)),,VLOOKUP((C3),fortnight, 3,FALSE)) The main problem I seem to be having is how to amend the code to properly detect when date fields match. This is what I have so far for the VBA - Private Sub Worksheet_Change(ByVal Target As Range) Dim lookFor As Range Dim rng As Range Dim col As Integer Dim found As Variant Set lookFor = Sheets(Access Data).Range(E2) Set rng = Sheets(Front page).Range(fortnight) col = 3 On Error Resume Next found = Application.vlookup(lookFor.Value, rng, col, 0) If IsError(found) Then MsgBox lookFor not found Else: MsgBox The look-up value of lookFor is found in column col End If On Error GoTo 0 End Sub -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
$$Excel-Macros$$ VBA code to capture System time
Hi All, Could you please provide me the VBA to caputre the system time in an excel spread at the time of locking the system. Kind Regards SPS -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
$$Excel-Macros$$ Re: Cannot 'Break' broken link
Where does it tell you which cell contains the link? I've run a search on the entire workbook and I don't think the link actually exists. On Mar 18, 12:08 pm, Michael michaelmug...@gmail.com wrote: It should tell you which cell contains the link. Go to it and delete it. You will need to hard code the data. On Mar 17, 3:31 pm, ~slacker~ mbarl...@gmail.com wrote: I need help in breaking data links to other excel workbooks. The excel workbook I am using (excel 2007) has links to other workbooks that can been seen by going to Data - Edit Links One of the links listed here does not point to a valid workbook and I would like to break the link to get rid of the Continue or Edit Links prompt that occurs when opening this workbook. Using the Break Link button does not work as the link does not appear to have a valid location. Is there another way to break links in a workbook? thanks in advance- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
$$Excel-Macros$$ Inserting new Sheet condition based
Could anyone suggest the manner i could to the following ; 1. Add an event in excel macro to insert particular Sheet of an Workbook depending upon count in a column 2. Name of the new worksheet will be content of column. Example: In Workbook named DATA, Sheet 1,C1 to C3 contain A,B C respectively. So , i want to have macro to 1. Insert 3 times DATASheet in the workbook (bcoz Count of C1 to C3 is 3) 2. New name of the inserted sheet will be A,B and C. Regards, Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
$$Excel-Macros$$ Re: Cannot 'Break' broken link
Here a picture http://groups.google.com/group/excel-macros/web/link%20error.JPG searching for the broken link 'array1031table' doesn't exist anywhere in the workbook. also the location is blank where on a valid link this would be the file path. changing the source doesn't keep. as soon as you close the dialog box it goes back to what it was. On Mar 18, 12:08 pm, Michael michaelmug...@gmail.com wrote: It should tell you which cell contains the link. Go to it and delete it. You will need to hard code the data. On Mar 17, 3:31 pm, ~slacker~ mbarl...@gmail.com wrote: I need help in breaking data links to other excel workbooks. The excel workbook I am using (excel 2007) has links to other workbooks that can been seen by going to Data - Edit Links One of the links listed here does not point to a valid workbook and I would like to break the link to get rid of the Continue or Edit Links prompt that occurs when opening this workbook. Using the Break Link button does not work as the link does not appear to have a valid location. Is there another way to break links in a workbook? thanks in advance- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
$$Excel-Macros$$
Dear All, I have a big card text but he not wrok properly when we convert the amount suppose that 100 he gives the reults Million but we net Indian Rupes i want to say he convet the amount in indian Rupess. -- Thanks For Mail. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
$$Excel-Macros$$ Re: Inserting new Sheet condition based
Try something like this: Sub Macro1() Dim sheetnames As Variant sheetnames = Range(C1:C10).Value For i = 1 To UBound(sheetnames) If sheetnames(i, 1) Then Sheets.Add After:=Sheets(Sheets.Count) ActiveSheet.Name = sheetnames(i, 1) End If Next i End Sub On Mar 19, 9:41 am, C.G.Kumar kumar.bemlmum...@gmail.com wrote: Could anyone suggest the manner i could to the following ; 1. Add an event in excel macro to insert particular Sheet of an Workbook depending upon count in a column 2. Name of the new worksheet will be content of column. Example: In Workbook named DATA, Sheet 1,C1 to C3 contain A,B C respectively. So , i want to have macro to 1. Insert 3 times DATASheet in the workbook (bcoz Count of C1 to C3 is 3) 2. New name of the inserted sheet will be A,B and C. Regards, Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
$$Excel-Macros$$ need help
Hi, Do we have any tools to automate financial reports? -- Regards, Shilpa -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
RE: $$Excel-Macros$$ VBA VLookup dates
Hi Andy, Not quite sure what date fields you want to match to what. Is it possible to attach the worbook? Regards - Dave. Hey all, I'm trying to cut down on loading times by converting a load of formulae to code. I'm stuck on this particular formula - =IF(ISERROR(VLOOKUP((C3),fortnight,3,FALSE)),,VLOOKUP((C3),fortnight, 3,FALSE)) The main problem I seem to be having is how to amend the code to properly detect when date fields match. _ Link all your email accounts and social updates with Hotmail. Find out now. http://windowslive.ninemsn.com.au/oneinbox?ocid=T162MSN05A0710G -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
$$Excel-Macros$$ replace code changes blanks cells
I have this code that replaces a - in a column. It does just that, but when I link that workbook to Access and use a is not null filter in a query the ones that are blank come up in the query. Thus my code is doing something to each cell to make Access think the cell is not blank (whent it appears to be) Any ideas??? before code is run Cell A1...A100 = test-me cell A101...A65000 = blank Access query brings up one row, A1 after code is run Cell A1...A100 = testme cell A101...A65000 = blank Access query brings up 100 rows (that also appear blank) Code: Dim er As Double er = Range(o65000).End(xlUp).Row Range(o2).Select Do Until ActiveCell.Row - 1 = er ActiveCell.Value = Replace(ActiveCell.Value, -, ) ActiveCell.Offset(1, 0).Select Loop -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
Re: $$Excel-Macros$$ create email when value in cell changes
Mahesh: Why do I need code in module 1 and module 2? Does it work in hand with the sub procedure in sheet1? On Mar 19, 6:59 am, Mahesh parab mahes...@gmail.com wrote: Hi Kevin Please find attach sheet, hope this is what u want. Right Click on sheet1 tab view code change this as per your requirement Private Sub Worksheet_Change(ByVal Target As Range) If Not (Application.Intersect(Worksheets(Sheet1).Range(B:B), Target) Is Nothing) Then DoSort End If End Sub Private Sub DoSort() Worksheets(Sheet1).Range(A:Z).Sort Key1:=Worksheets(Sheet1).Range(B1), Order1:=xlDescending, Header:=xlYes End Sub On Fri, Mar 19, 2010 at 7:43 AM, KevinM kmiy...@gmail.com wrote: I want to create an email when the value in column A changes. In column A I have the email addresses of managers. When the email address changes I want the VBA to compose the email and get the employees names in column B assoicated to that email address. I don't want it 1 for 1. I want to take only that one email address and bring in that range of employees in to the email. So in the example below I want to email manag...@domain.com and have employees 1,2,and 3 in the body of the email. I don't want seperate emails for each employee going to the manager. Thanks Example: Column A Column B manag...@domain.com employee1 manag...@domain.com employee2 manag...@domain.com employee3 manag...@domain.com employee4 manag...@domain.com employee5 -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+ unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. sample file.xls 70KViewDownload- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
