Re: $$Excel-Macros$$ Who to remove hyperlinks
hi Dear pls open this link. *http://www.tech-recipes.com/rx/1323/remove-all-hyperlinks-in-word-or-excel/ * 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. > -- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, "We can't Spell S_ccess without U" Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. -- -- 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: Share Tips and Tricks
Hi Harpreet, Its a good suggestion to have new subject title with a keyword TIP. Dear Group, Please share the tips and tricks in a new email message with the TIP keyword. It really helps. Best regards, Ayush Jain On Mar 24, 8:35 am, Harpreet Singh Gujral wrote: > Hi Ayush, > > Looking at Sudhir's idea, i think it would be great to consolidate all > the tips and tricks. But, i also buy in your point, that it would be > difficult to keep the file updated. > > I have a suggestion, Would it be possible for you or the members of > the group to follow a pattern for forwarding their "Tips and Tricks". > Example: We can make a common subject line "Tip:" or "Daily Tip" and > following this we can write the tip that the user wants to share with > the group. > Eg: "Tip: How to use excel" or "Daily Tip: How to use excel" > > This will help the group in two ways: > 1) Group members receive a each new tip as a new email > 2) Specially those who wish to receive, a summary of emails at the end > of the day, they would come to know through the summary, how many tips > were floated in a day > 3) It will be easy to track a new tip, because, otherwise, if > everybody keeps replying to the same subject line, it would be a long > list of chain mails, and this will make it difficult for the user to > understand, which tip he has read and which is a new one to read. > > I hope i was able to put my point forward > > Harry -- -- 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 to move file from one folder to another
Use FileCopy Option Regards Santosh Bahuguan On Tue, Mar 23, 2010 at 4:45 AM, Amith wrote: > Dear Excel Gurus > > I would greatly appreciate if any of you have a macro for an excel > file with 3 columns > > File_name From_FolderTo_Folder > > I want the macro to verify the file name if there in the From_Folder > and move it to To_Folder. > > Any help will be greatly appreciated. > > regards, > > Amit > > -- > > -- > 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$$ Re: Share Tips and Tricks
Hi Ayush, Looking at Sudhir's idea, i think it would be great to consolidate all the tips and tricks. But, i also buy in your point, that it would be difficult to keep the file updated. I have a suggestion, Would it be possible for you or the members of the group to follow a pattern for forwarding their "Tips and Tricks". Example: We can make a common subject line "Tip:" or "Daily Tip" and following this we can write the tip that the user wants to share with the group. Eg: "Tip: How to use excel" or "Daily Tip: How to use excel" This will help the group in two ways: 1) Group members receive a each new tip as a new email 2) Specially those who wish to receive, a summary of emails at the end of the day, they would come to know through the summary, how many tips were floated in a day 3) It will be easy to track a new tip, because, otherwise, if everybody keeps replying to the same subject line, it would be a long list of chain mails, and this will make it difficult for the user to understand, which tip he has read and which is a new one to read. I hope i was able to put my point forward Harry -- -- 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: VBA code to capture System time
Paul, I think SPS, wants to know, is there a way through which one can capture system time, at the time when the user locks his/her system i.e. in a networking environment, people usually press "Windows Key+L" in order to lock there workstations, before they leave there seat. I think SPS wants to know, how to capture this time. Even i would be keen to learn about it. Thanks Harry On Mar 23, 3:20 pm, paulwillekens wrote: > no need of VBA to see the system time in a spreadsheet... function > NOW() should do the job... > unless you would clarify what you mean with "at the time of locking > the system"... I hope you don't lock the system at all :) > > cu > > 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$$ Navigation Macro..
Sorry, should have checked which version of excel you have. The enable/ disable the option in 2007: 1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box. 2. Click Advanced at the left side of the dialog box. 3. In the Editing Options section, clear the Allow Editing Directly in Cells check box. 4. Click on OK. I haven't actually used the feature in 2007 so hopefully it will function the same as 2003 (I have read that it does, but haven't tested it myself). If you have disabled the option then double- clicking should take you to the first referenced cell in the formula. Going back should be a simple matter of pressing alt+tab once. Cheers, Spud On Mar 23, 9:56 pm, Mark Kim wrote: > Hi Spud > > I mean for example, Cell A1... I have a formula = Sheet2!A3. > > I have a worksheet for for example Feb GST incurred ... (I have lots which > are to caculate for exmpale.. FBT, Deposits.. different types of costs.. ) > > And i also have a workbook (separate file) which summarize all of these > worksheets.. I can not have a absolute value for any of numbers presented > in this summary.. All have to be linked.. > > simply.. All the value cells have a formula such as > =[GST.xls]Feb2010'A3' .. something like this.. > > hm... I think unticking the option edit directly in cell .. will do the > job.. but I really hope to get a macro.. > > well, I'm using 2007.. where is the option? can't seem to be able to locate > it.. ^ ^;; > > I went throught all the options. > > On Tue, Mar 23, 2010 at 10:49 AM, Spud wrote: > > 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 !
$$Excel-Macros$$ VBA Array Statistics (Min, Max, Sum, Avg, StdDev, etc)
I have just begun to work with arrays in Excel VBA and am struggling how to obtain basic statistics about the array. For example Dim Results_Array(1 to 10) As Double I run a loop that calculates 10 numbers and places the results in places 1 - 10 in the array. How can I compute the average, sum, min, max, and standard deviation of the completed array? Is there a way to compute the same statistics for only a portion, say results 5-10? Something like Average(Results_Array(1 to 10)) 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.
RE: $$Excel-Macros$$ VBA VLookup dates
Hi,
Something like:
If Not IsErr(Range("found")) Then
Range("H2:H5").Value = found
Else: Range("H2:H5").ClearContents
End If
Regards - Dave.
> Date: Tue, 23 Mar 2010 07:21:21 -0700
> Subject: Re: $$Excel-Macros$$ VBA VLookup dates
> From: andyr...@hotmail.co.uk
> To: excel-macros@googlegroups.com
>
> Managed to get a bit further. The Lookup part is working perfectly but
> I can't figure out how to turn the #N/A entries into blanks...
>
> 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("G2:G5")
> Set rng = Sheets("Front page").Range("fortnight")
> col = 3
>
> found = Application.vlookup(lookFor.Value, rng, col, 0)
>
> Range("H2:H5").Value = found
>
> 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.
_
Browse profiles for FREE! Meet local singles online.
http://clk.atdmt.com/NMN/go/150855801/direct/01/
--
--
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$$ Abridged summary of excel-macros@googlegroups.com - 20 Messages in 13 Topics
Pls tell me how can v draw chart on excel by taking 2 different series - one independent & another dependent (ie x-axis is independent series n y-axis is dependent on x-axis). x-axis y-axis 100050 1500100 2000 150 3000 250 draw this chart in excel pls -- -- 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 to filter dates using Userform1 & printing
Hi Deepak,
This macro is very very useful. Could you please have its codes reexamined
as it does not give any output if start date ("I2") is greater than A3 i.e
first cell
Thanks and regards
R Singh
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Deepak Rai
Sent: Wednesday, March 17, 2010 7:01 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro to filter dates using Userform1 &
printing
Hi Mel,
Please find the updated file which can be use with Excel 2003.
Regards,
Deepak Rai
On Tue, Mar 16, 2010 at 6:45 PM, Mel wrote:
It looks like this is what I need however, I have Excel version 2003
not 2007 so it does not conver over and work.
any chance you can re-save in 2003 version? thx
Mel
On Mar 14, 5:02 am, Deepak Rai wrote:
> Hi Mel,
>
> I have a sample macro which work like similar as you want. Please find the
> attached.
>
> Hope this will help.
>
> Thanks,
>
> Deepak Rai
>
> On Fri, Mar 12, 2010 at 10:50 AM, Abhishek Jain
wrote:
>
>
>
>
>
> > Mel,
>
> > I did something similar to this (not sorting but filtering) for another
> > project. If you put a sample file of yours, I can help.
>
> > Best,
>
> > AJ
>
> > On Thu, Mar 11, 2010 at 10:22 PM, Mel wrote:
>
> >> I have a speadsheet that has 5 columns.
> >> (Headings are in row 2 and are: Cell A2=Date, B2=Name, C2=Paylist,
> >> D2=Cycle, E2=Action).
> >> Data starts in Row 3 and will go down to row 5000. The dates would
> >> start 01-Jan-2011 and could go up to 31-Dec-2011.
>
> >> Right now I have 2 macro's to sort by date and paylist but what I
> >> also
> >> need is a macro to allow the user to sort by the user inputting a
> >> from
> >> date (I think I can use a calendar to pick from) and a to date
> >> (option
> >> of => and =<) in a form.
>
> >> The next piece is how to display and be able to print this filtered
> >> info.
> >> I am not sure best option. Possibly only these rows be displayed and
> >> the other rows be hidden or maybe copy to a new page and after
> >> filtering the macro moves access to new page.
>
> >> I have also created a macro to open a user form1. So far I have (but
> >> no code yet to run) options to sort by Name, Date, Paylist, cycle and
> >> action.
>
> >> thx
> >> Mel
>
> >> --
>
> >>
---
> >> 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
Re: $$Excel-Macros$$ VBA VLookup dates
Sorry for the extra messages but I decided to delete most of the data in a workbook copy so that I could upload it... http://excel-macros.googlegroups.com/web/2010%2003%2023%20TEST.xls?hl=en&gsc=c-8xyhYAAAB4suMG83bGpxYXyXRb7VtTTCBlxQqdFNTZwwfBwm5u_Q Basically I want the code to stop calculating once it hits an error (#N/A) or at least to show blanks instead. If there is a better way to do this I'm all ears as a lot of data is usually entered into these sheets. -- -- 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
Managed to get a bit further. The Lookup part is working perfectly but
I can't figure out how to turn the #N/A entries into blanks...
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("G2:G5")
Set rng = Sheets("Front page").Range("fortnight")
col = 3
found = Application.vlookup(lookFor.Value, rng, col, 0)
Range("H2:H5").Value = found
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$$ Re: Urgent need some about how can calculate week
Hi, You may use the following formula: ="Week "&WEEKNUM(A2) This would give the week number of the calendar year. Thanks & Regards, Yogesh Kudva On Mar 23, 2:41 pm, prabhakar thakur wrote: > Dear All, > I need Urgent Help, How can calculate week by > formula in excel without vb script, Please find the attachment of data. i > am using but i can't got result > > Thanks, > Prabhakar Thakur > New Delhi +919953736776+919953736776 > > round up function.xlsx > 11KViewDownload -- -- 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$$ Urgent need some about how can calculate week
Dear Sandeep, Thanks for try, but result is wrong. I solved this problem please find the attachment Thanks, Prabhakar Thakur New Delhi +919953736776 On Tue, Mar 23, 2010 at 5:34 PM, Sandeep Kumar Maurya wrote: > May be you want this. > Find the attached file. > > Regards > Sandeep > > -- > > -- > 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. round up function.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: purchase order number
Folks,
Can someone tell on what we are discussing about in this thread, i will be
too interested in learning this as i deal with PO numbers and purchasing.
With Regards,
R Karthikheyan
On Tue, Mar 23, 2010 at 2:23 PM, paulwillekens <
paul.johan.willek...@gmail.com> wrote:
>
> Hi Colvert,
>
> Well, I think you could keep that "last purchase order number (PON)"
> in a (protected) fix cell, e.g. D1
>
> Sub PON()
>
> ActiveCell.Value = Range("D1").Value + 1
> Range("D1").Value = ActiveCell.Value
>
> End Sub
>
> Is that what you're up to?
>
> Greetings
>
> 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.
>
--
--
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$$ Urgent need some about how can calculate week
May be you want this. Find the attached file. Regards Sandeep -- -- 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. round up function-1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Navigation Macro..
Hi Spud I mean for example, Cell A1... I have a formula = Sheet2!A3. I have a worksheet for for example Feb GST incurred ... (I have lots which are to caculate for exmpale.. FBT, Deposits.. different types of costs.. ) And i also have a workbook (separate file) which summarize all of these worksheets.. I can not have a absolute value for any of numbers presented in this summary.. All have to be linked.. simply.. All the value cells have a formula such as =[GST.xls]Feb2010'A3' .. something like this.. hm... I think unticking the option edit directly in cell .. will do the job.. but I really hope to get a macro.. well, I'm using 2007.. where is the option? can't seem to be able to locate it.. ^ ^;; I went throught all the options. On Tue, Mar 23, 2010 at 10:49 AM, Spud wrote: > 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.quickvb
$$Excel-Macros$$ Macro to move file from one folder to another
Dear Excel Gurus I would greatly appreciate if any of you have a macro for an excel file with 3 columns File_name From_FolderTo_Folder I want the macro to verify the file name if there in the From_Folder and move it to To_Folder. Any help will be greatly appreciated. regards, Amit -- -- 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: VBA code to capture System time
no need of VBA to see the system time in a spreadsheet... function NOW() should do the job... unless you would clarify what you mean with "at the time of locking the system"... I hope you don't lock the system at all :) cu 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.
$$Excel-Macros$$ Urgent need some about how can calculate week
Dear All, I need Urgent Help, How can calculate week by formula in excel without vb script, Please find the attachment of data. i am using but i can't got result Thanks, Prabhakar Thakur New Delhi +919953736776 -- -- 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. round up function.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Navigation Macro..
Dear All, I need Urgent Help, How can calculate week by formula in excel without vb script, Please find the attachment of data. i am using but i can't got result Thanks, Prabhakar Thakur New Delhi +919953736776 On Mon, Mar 22, 2010 at 12:27 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. > -- -- 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. round up function.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ purchase order number
Colvert, Try downloading P O Master from the following link: http://www.scribd.com/doc/5443728/PO-Master-06-25-09 You will have to be a member to download. Membership is free. Norman On Mon, Mar 22, 2010 at 5:05 PM, lecolvert wrote: > 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. > -- -- 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: purchase order number
Hi Colvert,
Well, I think you could keep that "last purchase order number (PON)"
in a (protected) fix cell, e.g. D1
Sub PON()
ActiveCell.Value = Range("D1").Value + 1
Range("D1").Value = ActiveCell.Value
End Sub
Is that what you're up to?
Greetings
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.
$$Excel-Macros$$ Re: Navigation Macro..
go for it... maybe you could elaborate further on error handling and appropriate messages, but here's the thing... Sub GaNaar() Dim cCel Dim cNewCel Dim cNewFile Dim cNewSheet Dim cSheet Dim nPos cCel = ActiveCell.Value 'cell e.g. b2 On Error Resume Next Range(cCel).Select cNewCel = ActiveCell.Value If cNewCel = cCel Then 'failed move cSheet = ActiveSheet.Name 'check for other workbook i.e. presence of [aaa] nPos = InStr(1, cCel, "]") If nPos > 0 Then 'reference to e.g. 'g:\paul\[other.xls]first tab'! A13 cNewFile = Replace(Left(cCel, (nPos - 1)), "[", "") cNewSheet = Mid(cCel, (nPos + 1), 999) nPos = InStr(1, cNewSheet, "!") cNewCel = Mid(cNewSheet, (nPos + 1), 99) cNewSheet = Replace(Left(cNewSheet, (nPos - 1)), "'", "") On Error Resume Next If IsObject(Workbooks.Item(cNewFile)) Then Workbooks(cNewFile).Activate On Error Resume Next Workbooks.Open cNewFile On Error Resume Next Worksheets(cNewSheet).Activate On Error Resume Next Range(cNewCel).Select Else nPos = InStr(1, cCel, "!") cNewSheet = Replace(Left(cCel, (nPos - 1)), "'", "") cNewCel = Mid(cCel, (nPos + 1), 99) 'cell in other worksheet e.g. other!b2 On Error Resume Next Worksheets(cNewSheet).Activate On Error Resume Next Range(cNewCel).Select cNewCel = ActiveCell.Value cNewSheet = ActiveSheet.Name End If End If 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$$ Share Tips and Tricks
*** Speed Up Excel Macro *** Poor calculation speed affects productivity and increases user errors. Studies have shown that a user's productivity and ability to focus on a task deteriorate as response time lengthens. Excel has two main calculation modes, which let you control when calculation occurs: * Automatic calculation Formulas are automatically recalculated whenever you make a change. * Manual calculation Formulas are only recalculated when you request it (for example, by pressing F9). ''' If you write the code for VBA & it run slow.There are many cases 1.processor 2.ram 3.loop in code ''' So if it is not possible to upgrade your pc,Then try to switch on manual calculation. You have to first ensure that there is no any bug,error. ''' Sub GoToManual() Dim xlCalc As XlCalculation xlCalc = Application.Calculation Application.Calculation = xlCalculationManual On Error GoTo CalcBack 'YOUR CODE Application.Calculation = xlCalc Exit Sub CalcBack: Application.Calculation = xlCalc End Sub ''' On Thu, Mar 18, 2010 at 7:05 PM, sudhir kumar wrote: > Hi Ayush > > It is better idea. Please add an common file > which will used by every one and time to time > add their tips and then we have single file with lots of > formula's and idea's > > Please everybody download common file, add your > suggetion and formula and upload as reply on the our group > mail. > > Thankx > > > On 3/18/10, Ayush wrote: >> >> Hello Everyone, >> >> I request you all to share any tips or tricks that you have about MS >> Excel in the group. It really helps. >> >> The tip can be anything like formula, most used calculation, excel >> trick, hidden truth or could be anything which you think can be done >> in an easier way. >> >> It can be any bug of excel also. Anything about excel that you >> knowanything >> >> Sharing just increases the knowledge. >> >> Keep Posting... >> >> >> Best regards, >> Ayush Jain >> Group Owner >> >> -- >> >> -- >> 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 > > > -- > Sudhir Verma > Asstt. Mngr. A/c's > 9211219649 > > -- > -- > 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 -- 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 ''
Re: $$Excel-Macros$$ Hi Please Help ME
Hello Dear, I am unable to understand your problem.Please 1'st explain problem. In your attachment,you have not explain your problem. Please Reply So that we can understand your requirements. On Mon, Mar 22, 2010 at 3:27 PM, anil panchal wrote: > 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. > -- 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.
Re: $$Excel-Macros$$ Problems using WorksheetFunction Dec2Hex and Hex2Dec in Excel2003
Hello Dear You can access excel function from vba code. here is the example Syntax : ActiveCell.FormulaR1C1 = "=Here your function,What you want to Access" Example ActiveCell.FormulaR1C1 = "=SUM(R[1]C[1],R[2]C[1],R[3]C[1],R[4]C[1],R[5]C[1])" Hope it Will Help Happy to Help :) Shyam On Tue, Mar 23, 2010 at 1:01 AM, Vinod Menon wrote: > 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. > -- 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.
Re: $$Excel-Macros$$ macro efficiency
Poor calculation speed affects productivity and increases user errors. Studies have shown that a user's productivity and ability to focus on a task deteriorate as response time lengthens. Excel has two main calculation modes, which let you control when calculation occurs: * Automatic calculation Formulas are automatically recalculated whenever you make a change. * Manual calculation Formulas are only recalculated when you request it (for example, by pressing F9). ''' If you write the code for VBA & it run slow.There are many cases 1.processor 2.ram 3.loop in code ''' So if it is not possible to upgrade your pc,Then try to switch on manual calculation. You have to first ensure that there is no any bug,error. ''' Sub GoToManual() Dim xlCalc As XlCalculation xlCalc = Application.Calculation Application.Calculation = xlCalculationManual On Error GoTo CalcBack 'YOUR CODE Application.Calculation = xlCalc Exit Sub CalcBack: Application.Calculation = xlCalc End Sub ''' Hope it will Help Happy to Help :) Shyam On Tue, Mar 23, 2010 at 2:56 AM, scubagirl wrote: > 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. > -- Thanks Regards Sh
Re: $$Excel-Macros$$ Who to remove hyperlinks
Dear All Please have a look on Delete all hyperlink workbook. Hope it Will Help Happy to Help :) Shyam 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. > -- 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. Delete all hyperlink.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Outlook and excel integration
Hello Dear Mail sent macro is already discussed with code. Try to execute that code if expiry date condition fulfill. Hope it will Help Happy to help :) Shyam On Mon, Mar 22, 2010 at 5:12 PM, ~ Z A H E E R ~ wrote: > 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. > -- 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.
Re: $$Excel-Macros$$ Fwd: Hi Please Help ME
Hi Abhishek, Thanks for reply. I want sum of all collom A named but (SB/GB) Specify like sum of SB, Sum Of GB, Thanks & Regards Anil Kumar 9278256426 On Tue, Mar 23, 2010 at 10:32 AM, Abhishek Jain wrote: > Anil, > > You query is not clear. I understand you want sum of some range on the > basis of your criteria (SB/GB) but of what range ? Please elaborate what > exactly you want. > > Krgrds, > > > AJ > > On Mon, Mar 22, 2010 at 4:17 PM, anil panchal wrote: > >> >> >> -- 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. >> > > -- -- 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$$ Wizars not working in MS Access 2003
Can anyone tell me why the wizards in my MS Access 2003 is not working with any solution if they have because i have to do every thing manually. -- -- 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..
Hello Dear, You can use go to reference.Sample sheet with code is attached. I think it will help you. Hope it will Help Happy To Help :) Shyam On Tue, Mar 23, 2010 at 5:19 AM, Spud wrote: > 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. > -- Thanks Regards Shyam Software Engineer
Re: $$Excel-Macros$$ Fwd: Hi Please Help ME
Anil, You query is not clear. I understand you want sum of some range on the basis of your criteria (SB/GB) but of what range ? Please elaborate what exactly you want. Krgrds, AJ On Mon, Mar 22, 2010 at 4:17 PM, anil panchal wrote: > > > -- 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. > -- -- 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.
