$$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$$ 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$$ 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$$ Cannot 'Break' broken link
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 -- -- 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
$$Excel-Macros$$ Re: Formatting of datas
Your example is somewhat confusing but if you just want to copy formats have you tried right click - paste special - formats? or the 'Format Painter' which in excel 2007 is on the Home ribbon near cut/copy/paste buttons On Apr 9, 6:09 pm, KARTHIKEYAN B karthinat...@gmail.com wrote: Hi, Can you help me on this file asap. Its urgent from my end. The sample file contains the raw datas and it should be formatted as like the format available with the Header to be sent to Vendor in the prescribed format. Can it be possible to send them in a single excel file? Kindly update this as it is very urgent and also secret. Help the needy with SIMPLE and SAFE(LY)TY LIFE Karthikeyan.B sample.xls 39KViewDownload Format.xls 69KViewDownload --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Increment Column
This seems like it should be fairly straight forward but i can't seem to find an easy solution. Can any one help? I want to create a macro or hot key that will take the formula in the currently selected cell, copy it to the cell below and adjust the formula 3 columns to the right. ex. if the selected cell formula =A1 after running the macro the cell below it would have the formula =D1 If the formula in the cell is unknown, and more complicated then the example above, trying to use the split function becomes difficult. Is there a better way? Thanks in advance --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---