Re: $$Excel-Macros$$ Navigation Macro..
Can you post an example showing how the format of the cell values (you mention that the cell value can be a workbook and a cell: does it show the path correctly for the workbook? Unless you know the correct path for the workbook, or they're all in the same path/folder, then it would be impossible to open the correct workbook). If by cell value you actually mean formula (ie. in cell A1 you have the formula =Sheet 2!A3) then you could just go into tools>options and untick edit directly in cell, and then when you double click in cell A1 it will take you to Sheet 2!A3. This will also open up the workbook if the formula is ='[Book1.xls]Sheet 2'!$A$3. Unticking edit directly in cell will mean you can't edit formula's in the cell, you have to do it in the formula bar. Cheers, Spud On Mar 22, 10:34 pm, Mark Kim wrote: > The problem is then I need a create hyperlink manually.. > > Then I need to create hundreds hyperlink.. > > Also, everytime I click the cell, it takes me to the reference cell, which I > don't want to. I want to go to the reference cell when I want to. > > That's why I don't think Hyperlink is a solution. > > Due to system problems, I am doing Reconcilation manually with thousands > data. Creating a hyerlink for every cell I need to link is too much time > consuming. > > I don't think it will be a complicated macro.. > > Get the value from a cell... > > if the value is workbook.;.. open the workbook and go to the reference cell > > if the value is a cell, go to the cell > > well, I think this logic will work.. I just don't know how to write this.. > > Anyone please? ^ ^ > > On Mon, Mar 22, 2010 at 5:57 PM, Yahya wrote: > > Dear Mark > > > I think you can do it by just using a Hyperlink. No need for macros. > > Please see the attached file > > > Yahya > > > On Mon, Mar 22, 2010 at 2:37 AM, Markkim wrote: > > >> Hi > > >> I am wondering if anyone can help me creating a macro for the > >> following.. > >> Get a reference from the selected cell and take me there . > >> For example, A1 contains C4. The macro will take me to C4. This is a > >> very simple one. > >> A1 contains a reference Sheet2!C4. I’d like the macro to take me > >> sheet2 C4. > >> And if A1 contains a location of the other file. Let’s say… A1 > >> contains Sheet ‘sales’ C4 in the file named ‘Sales’. Then I want the > >> excel to open the file and take me to C4 in a sheet called ‘sales’. > >> I want a button to get back to where I was. > > >> Can you create a macro like this? > > >> -- > > >> -- > >> 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. -- -- 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: Conditional Formatting of empty colored cells
easy piece... Sub Kleur() Dim oCel For Each oCel In Selection If oCel.Interior.ColorIndex = 36 Or oCel.Interior.ColorIndex = 38 Then oCel.Value = "N" End If Next End Sub enjoy ... Paul Willekens -- -- 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
Thanks for your suggestions/help. I checked to make sure that all of the loops use "Exit For" when appropriate. I am using Excel 2007 which *could* be causing some of the slowdown, but Excel only really comes in at the end for result output, it could explain why my speed tests are so slow (I've been outputting the time for some functions to complete to Excel). The following function seems to be taking up a good chunk of the time: 'create a list of tasks that are eligible to run Private Function GetEligibleTasks() As Collection Dim eligible_tasks As New Collection Dim t As cTask For Each t In tasklist 'make sure the task hasn't been started yet If t.Status = 0 Then t.StartDate = tracker.CurrentDate 'make sure it can be started If t.ReadyToStart() Then eligible_tasks.Add t eligible_tasks.item(eligible_tasks.count).EligibleTaskIndex = eligible_tasks.count End If End If Next t Set GetEligibleTasks = eligible_tasks End Function 'determine if a task is ready to start by checking 'whether its predecessors have completed Public Function ReadyToStart() As Boolean Dim pred As Tasks Dim j As Integer Dim start As Date Dim p As task Set pred = ActiveProject.Tasks(Index).PredecessorTasks 'get a list of the preceeding tasks 'if the task has no predecessors, it's ready to run If pred.count = 0 Then ReadyToStart = True Exit Function End If For Each p In pred Dim test As Date test = p.Finish 'if a predecessor hasn't been completed, this task isn't ready to run If tasklist.item(p.ID).Status <> 2 Then ReadyToStart = False Exit Function Else ReadyToStart = True End If Next End Function In this case tasklist is a Collection. To me, it doesn't look like this could get much more efficient - any suggestions? (I can't post the whole project because it's company protected information) -- -- 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$$ purchase order number
Good Morning all, I want to create a macro that can generate purchase order number automatically after the last saving. Thanks for your help Colvert Port-au-Prince,Haiti -- -- 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$$ Problems using WorksheetFunction Dec2Hex and Hex2Dec in Excel2003
Hello, I am able to use these functions in the worksheet itself, but not able to use them in a VBA macro in the same. I get an error that Object doesn't support this property or method. This method, however, seems to work on Excel2007. Does Excel2003 not support using this from VBA ? Is there any other step needed to ensure that the WorksheetFunctions that can be used in the worksheets can also be called from VBA functions? u0 = WorksheetFunction.Dec2Hex(WorksheetFunction.Hex2Dec(u), 3) This above line works in the same macro used on Excel2007. But not on Excel2003. Any help is greatly appreciated. -Vinod -- -- 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$$ A link to a collection of videos and tutorials on MS excel:Data mining Add-in.
A link to a collection of videos and tutorials on MS excel:Data mining Add-in. Tutorials:http://www.dataminingtools.net/browsetutorials.php? tag=msexcel Videos: http://www.dataminingtools.net/videos.php?id=11 Follow DataminingTools at: Twitter: http://twitter.com/DataMiningTools Blog: http://dataminingtools.net/blog/ -- -- 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$$ Who to remove hyperlinks
sub a() selection.hyperlinks.delete end sub On Mon, Mar 22, 2010 at 10:22 PM, Sandeep Kumar Maurya < sandymau...@gmail.com> wrote: > Hi, > > write 1 in a blank cell and then copy it and use multiply option in 'paste > special'. > It also put 0 in blank selected cells. > > Regards > Sandeep > > > On Mon, Mar 22, 2010 at 9:13 PM, Nani Ram <06n...@gmail.com> wrote: > >> Hi Members, >> >> i have huge data with hyperlinks. >> Is there any shortcut key or formula to remove all hyperlinks at once. >> >> >> Thanks, >> >> Naniram >> >> -- >> >> -- >> 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. > -- -- 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$$ Who to remove hyperlinks
Hi, write 1 in a blank cell and then copy it and use multiply option in 'paste special'. It also put 0 in blank selected cells. Regards Sandeep On Mon, Mar 22, 2010 at 9:13 PM, Nani Ram <06n...@gmail.com> wrote: > Hi Members, > > i have huge data with hyperlinks. > Is there any shortcut key or formula to remove all hyperlinks at once. > > > Thanks, > > Naniram > > -- > > -- > 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.
$$Excel-Macros$$ Who to remove hyperlinks
Hi Members, i have huge data with hyperlinks. Is there any shortcut key or formula to remove all hyperlinks at once. Thanks, Naniram -- -- 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$$ Conditional Formatting of empty colored cells
I am wondering if there is a way to use conditional formatting for cells that have color. For example: I select a range of cells in a row...I want to say, if there is a cell in this grouping that is red or yellow, place a "N" in this cell. can this be done using 2003? Thank you 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 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$$ Need procedure to allow VBA code by users during runt-time?
That was GOLD, Chris! Thanks! The scripting object evaluates user code input and avoids BOTH problems: 1. The really weird problem (all other user functions outputting #NAME? after any code-writing function is entered) is gone - users can specify code in some cell that is in turn specified as the argument of a code-writing procedure and every time the code is changed, the functions reflect the new code. 2. Even the other problem (untrappable syntax errors) is solved - syntax errors encounted in the new script object just come back to the calling functiong as trappable errors. Brilliant! Here's the simple version of the code I used (I entered this function several times in a spreadsheet, with each instance pointing to a cell containing code to evaluate (i.e. "100 * 2") , each instance returns the value of the cell contents run as code (or returns the error message if the code is not executable)): Function Func2(inp As String) Dim Script As ScriptControl Set Script = New ScriptControl Script.Language = "VBScript" On Error GoTo whoops Func2 = Script.Eval(inp) Exit Function whoops: Func2 = Err.Description End Function -- -- 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$$ Help Me Expert
Dear All Experts Help Me, Please Check the Attachment. I have bigcardtext But he not Work Properley, When we convert the Number For Example 600 he Convert the Amount the in Million Please help me i want to convert the this amount in Rupees Sixty Lac. -- 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. Sub BigCardText.docx Description: application/vnd.openxmlformats-officedocument.wordprocessingml.document
$$Excel-Macros$$ Re: Outlook and excel integration
Sorry, Plz read as Is it possible to integrate MS Outlook 2007 and MS Excel 2007. On Mon, Mar 22, 2010 at 12:39 PM, ~ Z A H E E R ~ wrote: > Dear Members, > > Is it possible to integrate MS Office 2007 and MS Excel 2007. > > For Eg. > I have 1 excel file contains Employee ID, Employee Name, CID #, CID Expiry > date, Passport #, Passport Expiry date, email > > My requirement : > > Whenever any employees CID or Passport is near to expiry date, outlook will > send an email automatically to respective person notifying him to renew his > CID or Passport or both. > > Regards, > > > -- -- 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$$ Navigation Macro..
The problem is then I need a create hyperlink manually.. Then I need to create hundreds hyperlink.. Also, everytime I click the cell, it takes me to the reference cell, which I don't want to. I want to go to the reference cell when I want to. That's why I don't think Hyperlink is a solution. Due to system problems, I am doing Reconcilation manually with thousands data. Creating a hyerlink for every cell I need to link is too much time consuming. I don't think it will be a complicated macro.. Get the value from a cell... if the value is workbook.;.. open the workbook and go to the reference cell if the value is a cell, go to the cell well, I think this logic will work.. I just don't know how to write this.. Anyone please? ^ ^ On Mon, Mar 22, 2010 at 5:57 PM, Yahya wrote: > Dear Mark > > I think you can do it by just using a Hyperlink. No need for macros. > Please see the attached file > > Yahya > > > > On Mon, Mar 22, 2010 at 2:37 AM, Markkim wrote: > >> Hi >> >> I am wondering if anyone can help me creating a macro for the >> following.. >> Get a reference from the selected cell and take me there . >> For example, A1 contains C4. The macro will take me to C4. This is a >> very simple one. >> A1 contains a reference Sheet2!C4. I’d like the macro to take me >> sheet2 C4. >> And if A1 contains a location of the other file. Let’s say… A1 >> contains Sheet ‘sales’ C4 in the file named ‘Sales’. Then I want the >> excel to open the file and take me to C4 in a sheet called ‘sales’. >> I want a button to get back to where I was. >> >> Can you create a macro like this? >> >> -- >> >> -- >> 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$$ VBA VLookup dates
Heya, Thanks for the reply! At the moment the file is a bit too large to attach. The dates I'm trying to match are in column C of the Access Data sheet, which are checked with dates on the Front Page sheet (fortnight range) and a number is looked up from these and placed into column H of the Access Data sheet. Hopefully this is a bit clearer, if not I'll try to trim the workbook a little and upload it. Cheers. On Mar 20, 1:36 am, Dave Bonallack wrote: > 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$$ Excel Solution for "To Do" List
Excel Gurus I am in search of a Excel Template, which simulates and gives user a "To do" List kind of feelings. Main details I wish to have is, 1. Worksheet -which lists All tasks to do 2. By running a Macro - I can derive list of Task for certain period (possible with 2 Input fields and filter data and put it on new worksheet) 3. Overdue tasks 4. Completed Task etc. if someone has it in use, ( I am sure someone would have this !) n if they dont mind sharing it to group, it would be much appreciated. It saves me from "Re"inventing wheel and possible few more questions to post to group to fine tune macros !! Cheers Kamal -- -- 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$$ Fwd: Hi Please Help ME
-- Forwarded message -- From: anil panchal Date: Mon, Mar 22, 2010 at 3:27 PM Subject: Hi Please Help ME To: excel-macros@googlegroups.com Hi All A NB MTRL NB Width Extra NB Height Extra A NB MTRL Extra CNB Width CNB Height A CNB MTRL sum OF SB sum OF GB 0 0 0 0 0 0 48 72 24 SB 10.22 GB 0 0 0 0 72 20 10 SB 20.236111 GB 0 0 0 0 64 30 13.33 SB 23.291667 GB 0 0 0 0 130 35 31.597222 SB 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Please help me -- -- 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. problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Hi Please Help ME
Hi All A NB MTRL NB Width Extra NB Height Extra A NB MTRL Extra CNB Width CNB Height A CNB MTRL sum OF SB sum OF GB 0 0 0 0 0 0 48 72 24 SB 10.22 GB 0 0 0 0 72 20 10 SB 20.236111 GB 0 0 0 0 64 30 13.33 SB 23.291667 GB 0 0 0 0 130 35 31.597222 SB 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Please help me -- -- 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. problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Outlook and excel integration
Dear Members, Is it possible to integrate MS Office 2007 and MS Excel 2007. For Eg. I have 1 excel file contains Employee ID, Employee Name, CID #, CID Expiry date, Passport #, Passport Expiry date, email My requirement : Whenever any employees CID or Passport is near to expiry date, outlook will send an email automatically to respective person notifying him to renew his CID or Passport or both. Regards, -- -- 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$$ Navigation Macro..
Dear Mark I think you can do it by just using a Hyperlink. No need for macros. Please see the attached file Yahya On Mon, Mar 22, 2010 at 2:37 AM, Markkim wrote: > Hi > > I am wondering if anyone can help me creating a macro for the > following.. > Get a reference from the selected cell and take me there . > For example, A1 contains C4. The macro will take me to C4. This is a > very simple one. > A1 contains a reference Sheet2!C4. I’d like the macro to take me > sheet2 C4. > And if A1 contains a location of the other file. Let’s say… A1 > contains Sheet ‘sales’ C4 in the file named ‘Sales’. Then I want the > excel to open the file and take me to C4 in a sheet called ‘sales’. > I want a button to get back to where I was. > > Can you create a macro like this? > > -- > > -- > 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. Makkim.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Best Group
Thanks, Its a best VBA Group. i got the best thing here which i seach many times in net, like un- protech sheet & un-protect VBA code. this is best thing 4 me. i am working as a MIS exective. i need vba 4 my daily work. can any one give me vba tutorials of vba which cover all the part like how to create & what use of Class, formula , add-in , all member details use in module, how to connect with Access & SQL. i learned almost with net help and i used vba daily but i learn advance level & step by step. i am working at 15k now. if u need mis am avilable (4 delhi & Gurgoan). my mail id is naharwal@gmail.com i need workbook cracker also. Thanks again 4 best thing. -- -- 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.