$$Excel-Macros$$ Fwd: hi
hi friends i need small help from you guys. i have attached the excel sheet, in which at the end of the sentence i want to add the Month and year of the next coming month. please help me out -- Sidhu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 date.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ How to see the ascii code of a text withing a field
use code() function in the worksheet or use the following function to get the ascii value of each character seperated by a space Public Function GetAscii(Var) Dim Cd As String For x = 1 To Len(Var) Cd = Cd & IIf(Cd = "", Trim(Str(Asc(Mid(Var, x, 1, " " & Trim(Str(Asc(Mid(Var, x, 1) Next x GetAscii = Cd End Function On 7/28/10, galsaba wrote: > Is there a way to see what the ascii code is for each character in a > chosen field? > The reason is, I got a file from China that contain some characters > that on xls they look as "space", but when I do "replace space by > nothing" this "space" is still there. so I assume it is not really a > space character, but a character that I cannot see. > > Thanks > > galsaba > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 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 > -- Regards Vasant -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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
Re: $$Excel-Macros$$ Re: Urgent help Invoice Macro modification
Hi Team,
The password is correct "STPIInvoices" in this up to STPII is CAPS letter
nvoices is small latters.
Please let me know if you have any questions on this.Thanks in advance.
*Private Sub cmdPrint_Click()
Set objDataSheet = Me.Parent.Sheets("Data")
objDataSheet.Unprotect "STPIInvoices"
Me.Unprotect "STPIInvoices"
PrintAllInvoices
objDataSheet.Protect "STPIInvoices", , , , , True, True, True, , True, ,
, True, True, True, True
Me.Protect "STPIInvoices", , , , , True, True, True
Set objDataSheet = Nothing
End Sub
*
On Wed, Jul 28, 2010 at 12:37 PM, Kishan Reddy, K <
kishanreddy.kethire...@gmail.com> wrote:
> Code is not opening, The password might be wrong.
>
> Kishan Reddy, K
>
> On Jul 27, 10:21 am, Nagendra Modupalli wrote:
> > Hi Team,
> >
> > I have Invoices printing macro.It is printing row wise.I want to modify
> > customer wise.Can you please help me.Thanks in advance.
> >
> > And also i have attached my macro file.
> >
> > For example if it is two columns same customer it has to print one
> invoice
> > and in this two column only it will change Invoice number and amt and i
> have
> > attached Example file.
> >
> > Password is STPIInvoices
> >
> > --
> > Thanks&Regards
> > Nagendra.M
> > Tel#91 9900516251
> >
> > --
> > Thanks&Regards
> > Nagendra.M
> >
> > "Beautiful photos are developed by negatives in a dark room, so if U see
> > darkness in Ur life believe that God is making a beautiful future for U
> !!!
> >
> > Macro_STPI Invoice(Annexures).zip
> > 1495KViewDownload
> >
> > Example.xls
> > 38KViewDownload
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 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
Nagendra.M
"Beautiful photos are developed by negatives in a dark room, so if U see
darkness in Ur life believe that God is making a beautiful future for U !!!
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 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
RE: $$Excel-Macros$$ Help: Creating formula using VBA
Hi, In H4 enter: =IF(G4=0,"",D4/G4) And similarly for other cells that contain a division operator Basically we are saying, if the denominator = 0 then nothing, otherwise, do the math. Regards - Dave. Date: Wed, 28 Jul 2010 21:08:00 +0300 Subject: $$Excel-Macros$$ Help: Creating formula using VBA From: janetdicks...@gmail.com To: excel-macros@googlegroups.com Hi Team, I have a challenge, how can I create a formula using VBA?! Attached file show details, but i don't want to see #DIV/0! error in case columns used in division does not have any data!! column E - F = column G (sometimes column E - F does not have any data, so i don't want to see 0 in column G column (G/D) = column H (sometimes column G or D does not have any data, so i don't want to see #DIV/0! error Jen D -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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
RE: $$Excel-Macros$$ Re: dont understand sintax...newbie!
Hi, My guess is that PROCV is a formula saved by that name. Check out: Insert | Name | Define Regards - Dave. > Date: Wed, 28 Jul 2010 16:41:04 -0700 > Subject: $$Excel-Macros$$ Re: dont understand sintax...newbie! > From: dlanm...@att.net > To: excel-macros@googlegroups.com > > Hi, > > I have never heard of PROCV, so I am interested in this too. > > David > > On Jul 28, 4:18 am, x-plicit wrote: > > Hello All, > > > > I do not understand this sintax: > > > > =PROCV(sumproduct(max(($B$3:$B$13152=B3)*($C$3:$C$13152=C3)*($D$3:$D > > $13152)));$K$1:$L$6;2;true) > > > > Could someone help me out? > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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
RE: $$Excel-Macros$$ How to see the ascii code of a text withing a field
Hi, =CODE(MID(A2,3,1)) Where cell A2 has your data, and you want to examine the 3rd character. Regards - Dave. > Date: Wed, 28 Jul 2010 10:48:35 -0700 > Subject: $$Excel-Macros$$ How to see the ascii code of a text withing a field > From: gals...@aol.com > To: excel-macros@googlegroups.com > CC: a...@haieramerica.com > > Is there a way to see what the ascii code is for each character in a > chosen field? > The reason is, I got a file from China that contain some characters > that on xls they look as "space", but when I do "replace space by > nothing" this "space" is still there. so I assume it is not really a > space character, but a character that I cannot see. > > Thanks > > galsaba > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: dont understand sintax...newbie!
Hi, I have never heard of PROCV, so I am interested in this too. David On Jul 28, 4:18 am, x-plicit wrote: > Hello All, > > I do not understand this sintax: > > =PROCV(sumproduct(max(($B$3:$B$13152=B3)*($C$3:$C$13152=C3)*($D$3:$D > $13152)));$K$1:$L$6;2;true) > > Could someone help me out? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ How to see the ascii code of a text withing a field
Is there a way to see what the ascii code is for each character in a chosen field? The reason is, I got a file from China that contain some characters that on xls they look as "space", but when I do "replace space by nothing" this "space" is still there. so I assume it is not really a space character, but a character that I cannot see. Thanks galsaba -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Userform locks Excel
I have an Excel workbook w/ a VBA menu to pops up a userform to write values back to a worksheet in the workbook. Sometimes, the userform locks Excel and it has to be abended. I suspect its due to users have other workbooks open and copying and pasting between them. Can I specify a specific instance in the VBA code for the userform? Is the userform independent of the workbook and could write back to whatever instance is active? Can I specify a window handle? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: dont understand sintax...newbie!
On Jul 28, 7:18 am, x-plicit wrote: > Hello All, > > I do not understand this sintax: > > =PROCV(sumproduct(max(($B$3:$B$13152=B3)*($C$3:$C$13152=C3)*($D$3:$D > $13152)));$K$1:$L$6;2;true) > > Could someone help me out? Google implies you've got a Portuguese version with =procv() being either vlookup or hlookup. Standard layout is VLOOKUP (lookup_value, table_array; col_index_num; range_lookup) so you've got =provc( lookup value; sumproduct(max(($B$3:$B$13152=B3)*($C$3:$C$13152=C3)*($D$3:$D $13152)) ) );$K$1:$L$6;2;true = VLOOKUP (0.1, A2: C10, 2, TRUE) Using an approximate match, searches for the value 0.1 in column A. How 0.1 is smaller than the smallest value in column A, an error is returned (# N / D) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Help creating chart
Thanks Kishan for your reply. However, it's not exactly what I'm looking for. If you take a look at the worksheet I downloaded, "Net Sales Chart.xls", I would like to do the following: 1. Under the "Select the period to plot" drop down menu, I'd like to select the appropriate month rather than the FY which I now have set up in the first menu box. 2. Once the month is selected from the drop down menu, the graph should automatically be updated with the current information from the table shown below the graph based on both the FY selected and the chosen month. 3. I would like to repeat steps 1 and 2 for the quarter and also the YTD. Any additional thoughts or comments are appreciated. Steve On Jul 28, 2:28 am, "Kishan Reddy, K" wrote: > Hello, > > Obviously you will have a data sheet on which you have created the > graph. > > Just right clik on the graph and select source data > > It will show the data on which graph is drawn. > > Just reselect the range that you want and press OK > > done. > > Bye > Kishan Reddy, K. > > On Jul 28, 4:43 am, Steve wrote: > > > > > I need help! > > > I am trying to adapt a neat little spreadsheet for my use in graphing > > monthly, quarterly, and year-to-date sales for the current year and a > > comparison to the same period in the prior year. What I have so far > > has been downloaded. > > > How can I select the appropriate period to plot i.e. month, quarter, > > or year-to-date? > > > Thank you in advance for your help. > > > Steve- Hide quoted text - > > - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Help: Creating formula using VBA
Hi Team, I have a challenge, how can I create a formula using VBA?! Attached file show details, but i don't want to see *#DIV/0! *error in case columns used in division does not have any data!! column E - F = column G (sometimes column E - F does not have any data, so i don't want to see 0 in column G column (G/D) = column H (sometimes column G or D does not have any data, so i don't want to see *#DIV/0! *error Jen D -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 Formula.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: dont understand sintax...newbie!
Using an approximate match, find the largest value in (B3 * C3 * each cell in D3:D13152) located in range(K1:K6) and return the corresponding value in range(L1:L6) google indicates you've got a Portugese version of Excel, with =procv() being either =vlookup(). standard layout is VLOOKUP (lookup_value, table_array; col_index_num; range_lookup) so breaking your formula down: =procv( lookup value =sumproduct(max(($B$3:$B$13152=B3)*($C$3:$C $13152=C3)*($D$3:$D$13152))) table array: $k$1:$L$6 col_index_num = 2 range_lookup = true) Sumproduct multiplies the corresponding components in the given arrays then adds them together. Max returns the single largest value within a range sumproduct(max(array1 * array2 * array3)) where array1 = ($B$3:$B$13152=B3) = an array of values in $B$3:$B $13152 matching the value in B3 array2 = ($C$3:$C$13152=C3) = an array of values in C3:C13152 matching the value in C3 array3 = ($D$3:$D$13152)= an array of all the values in D3:D13152 which finds the single largest value in (B3 * C3 * each cell in D3:D13152) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Need Formula
Dear All, Please find attach the sheet wherein I need the Data from "Tracking Sheet" should go the each individual sheets the data. Please see attach file for more understanding. Waiting for your ideas and suggestions... -- Ahmed Bawazir -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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 Need Help.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Excel macro - extract subjectline from outlook
Hi experts, We have macro to extract the subject line from outlook mail folders.. It used to work ok..But for some reason now it errors out on this line: *Set ns = Application.Session* iGrandRow = 2 Set wsCsd = wb.Worksheets(Tabnum1) And here is the error messege: “Object doesn’t support this property or method (Error 438)” We have only this refrences : Visual basic for application Ms Excel 11:0 Object library OLE Automation Ms Office 11:0 object library Outlook 11:00 object library.. Please let me know if we are missing any other object.. Thanks in advance. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ dont understand sintax...newbie!
Hello All, I do not understand this sintax: =PROCV(sumproduct(max(($B$3:$B$13152=B3)*($C$3:$C$13152=C3)*($D$3:$D $13152)));$K$1:$L$6;2;true) Could someone help me out? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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
Re: $$Excel-Macros$$ Need help
Yes sir Sent on my BlackBerry® from Vodafone -Original Message- From: Vasant Sender: excel-macros@googlegroups.com Date: Wed, 28 Jul 2010 15:27:53 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help Do u want the data in ms-word as a paragraph ? On 7/28/10, madha...@yahoo.com wrote: > Dear expert > I have some data stored in excel sheet and I wanted to convert the same in > paragraph form can I know how can I convert the same in paragraph form. > > Warm regards > > Madhav Vyas > Sent on my BlackBerry® from Vodafone > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 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 > -- Regards Vasant -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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
Re: $$Excel-Macros$$ Need help
Do u want the data in ms-word as a paragraph ? On 7/28/10, madha...@yahoo.com wrote: > Dear expert > I have some data stored in excel sheet and I wanted to convert the same in > paragraph form can I know how can I convert the same in paragraph form. > > Warm regards > > Madhav Vyas > Sent on my BlackBerry® from Vodafone > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 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 > -- Regards Vasant -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Help creating chart
The spreadsheet can be found in the files section and is titled "Net Sales Chart.xls". Steve On Jul 27, 7:43 pm, Steve wrote: > I need help! > > I am trying to adapt a neat little spreadsheet for my use in graphing > monthly, quarterly, and year-to-date sales for the current year and a > comparison to the same period in the prior year. What I have so far > has been downloaded. > > How can I select the appropriate period to plot i.e. month, quarter, > or year-to-date? > > Thank you in advance for your help. > > Steve -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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
RE: $$Excel-Macros$$ trouble with multiple formulas
You're welcome. Regards - Dave. > Date: Wed, 28 Jul 2010 00:05:02 -0700 > Subject: Re: $$Excel-Macros$$ trouble with multiple formulas > From: nkmorri...@hotmail.com > To: excel-macros@googlegroups.com > > Hi Dave, > > THANK-YOU so much, you formula works a treat. It's taking a little > while like you said, but it's worth it. > > Kind Regards, > Narelle > > On Jul 27, 6:55 pm, Dave Bonallack wrote: > > Hi, > > > > Have a look at the attached to see if it does what you need. > > > > If you have 170,000 rows, that means 170,000 formulas, which may take a > > while for XL to calculate. > > > > Regards - Dave. > > > > > > > > > Date: Mon, 26 Jul 2010 22:29:05 -0700 > > > Subject: $$Excel-Macros$$ trouble with multiple formulas > > > From: nkmorri...@hotmail.com > > > To: excel-macros@googlegroups.com > > > > > Can anyone provide me the formula/s for below query? I have four > > > columns. Company, Product, Date and Weight. What I need to do is add > > > up the monthly volumes per Customer/Product for each month. I have > > > over 170,000 records that I need to sort. I've tried multiple formulas > > > but I can't seem to work it out.Please help! > > > > > Company Product Date Weight SHOULD EQUAL > > > ABC OW 2006/07 0.2 0.2 > > > ABC OW 2006/08 0.15 0.15 > > > ABC OW 2006/09 0.2 - > > > ABC OW 2006/09 0.1 0.3 > > > ABC OC 2006/10 0.1 - > > > ABC OC 2006/10 0.1 0.2 > > > ABC OC 2006/11 0.3 0.3 > > > ABC OC 2006/12 0.2 0.2 > > > ABC OC 2007/01 0.1 - > > > ABC OC 2007/01 0.2 0.3 > > > ABC PL 2006/07 0.2 0.2 > > > ABC PL 2006/08 0.2 0.2 > > > ABC DD 2006/08 0.2 0.2 > > > ABC PL 2007/04 0.2 - > > > ABC PL 2007/04 0.15 0.35 > > > ABC PL 2007/05 0.1 0.1 > > > HEALTH OW 2007/05 0.2 0.2 > > > HEALTH OW 2007/06 0.2 - > > > HEALTH OW 2007/06 0.2 0.4 > > > HEALTH OW 2007/07 0.2 - > > > HEALTH OW 2007/07 0.1 0.3 > > > HEALTH OW 2007/08 0.2 - > > > HEALTH OW 2007/08 0.2 - > > > HEALTH OW 2007/08 0.2 0.6 > > > HEALTH OW 2007/09 0.2 0.2 > > > HEALTH PL 2007/10 0.2 - > > > HEALTH PL 2007/10 0.2 0.4 > > > HEALTH PL 2007/11 0.3 - > > > HEALTH PL 2007/11 0.2 0.5 > > > DENTAL OC 2007/12 0.2 - > > > DENTAL OC 2007/12 0.2 0.3 > > > DENTAL OW 2008/01 0.15 0.15 > > > DENTAL PL 2008/01 0.2 0.2 > > > DENTAL DD 2008/02 0.1 - > > > DENTAL DD 2008/02 0.2 0.3 > > > DENTAL DD 2008/03 0.2 - > > > DENTAL DD 2008/03 0.2 0.4 > > > DENTAL DD 2008/04 0.1 0.1 > > > > > -- > > > ------ > > > Some important links for excel users: > > > 1. Follow us on TWITTER for tips tricks and links > > > :http://twitter.com/exceldailytip > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > 3. Excel tutorials 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 7000 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 > > > athttp://groups.google.com/group/excel-macros/subscribe > > > > > > > > Book1.xls > > 34KViewDownload- Hide quoted text - > > > > - Show quoted text - > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support fr
RE: $$Excel-Macros$$ Remove selected cell contents
Hi, The cells in currency format will most likely be numeric. So if your data starts in cell A2, place the following formula in B2, then copy down: =If(ISNUMBER(A2)=TRUE,A2,"") Regards - Dave. > Date: Tue, 27 Jul 2010 09:42:17 -0700 > Subject: $$Excel-Macros$$ Remove selected cell contents > From: flebber.c...@gmail.com > To: excel-macros@googlegroups.com > > I have a column containing cells which house several delimited values > and a dollar value. I want to be able to remove the delimited values > and leave the dollar value in the cell in currency format. > > the cells contain information similar to > > 22-7-4-7 $22400.10 > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Urgent help Invoice Macro modification
Code is not opening, The password might be wrong. Kishan Reddy, K On Jul 27, 10:21 am, Nagendra Modupalli wrote: > Hi Team, > > I have Invoices printing macro.It is printing row wise.I want to modify > customer wise.Can you please help me.Thanks in advance. > > And also i have attached my macro file. > > For example if it is two columns same customer it has to print one invoice > and in this two column only it will change Invoice number and amt and i have > attached Example file. > > Password is STPIInvoices > > -- > Thanks&Regards > Nagendra.M > Tel#91 9900516251 > > -- > Thanks&Regards > Nagendra.M > > "Beautiful photos are developed by negatives in a dark room, so if U see > darkness in Ur life believe that God is making a beautiful future for U !!! > > Macro_STPI Invoice(Annexures).zip > 1495KViewDownload > > Example.xls > 38KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Remove selected cell contents
use the following formula in adjucant cell.
for example if your data is in column B2 then in C2 copy and paste the
following formula.
=RIGHT(B2,LEN(B2)-FIND("$",B2)+1)
once you got all the values in column C
1. copy the contents in column C
2. use Edit -> Paste special - values to paste them back in column B
Simple.
Bye
Kishan Reddy, K.
On Jul 27, 9:42 pm, flebber wrote:
> I have a column containing cells which house several delimited values
> and a dollar value. I want to be able to remove the delimited values
> and leave the dollar value in the cell in currency format.
>
> the cells contain information similar to
>
> 22-7-4-7 $22400.10
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 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
Re: $$Excel-Macros$$ trouble with multiple formulas
Hi Dave, THANK-YOU so much, you formula works a treat. It's taking a little while like you said, but it's worth it. Kind Regards, Narelle On Jul 27, 6:55 pm, Dave Bonallack wrote: > Hi, > > Have a look at the attached to see if it does what you need. > > If you have 170,000 rows, that means 170,000 formulas, which may take a while > for XL to calculate. > > Regards - Dave. > > > > > Date: Mon, 26 Jul 2010 22:29:05 -0700 > > Subject: $$Excel-Macros$$ trouble with multiple formulas > > From: nkmorri...@hotmail.com > > To: excel-macros@googlegroups.com > > > Can anyone provide me the formula/s for below query? I have four > > columns. Company, Product, Date and Weight. What I need to do is add > > up the monthly volumes per Customer/Product for each month. I have > > over 170,000 records that I need to sort. I've tried multiple formulas > > but I can't seem to work it out.Please help! > > > Company Product Date Weight SHOULD EQUAL > > ABC OW 2006/07 0.2 0.2 > > ABC OW 2006/08 0.15 0.15 > > ABC OW 2006/09 0.2 - > > ABC OW 2006/09 0.1 0.3 > > ABC OC 2006/10 0.1 - > > ABC OC 2006/10 0.1 0.2 > > ABC OC 2006/11 0.3 0.3 > > ABC OC 2006/12 0.2 0.2 > > ABC OC 2007/01 0.1 - > > ABC OC 2007/01 0.2 0.3 > > ABC PL 2006/07 0.2 0.2 > > ABC PL 2006/08 0.2 0.2 > > ABC DD 2006/08 0.2 0.2 > > ABC PL 2007/04 0.2 - > > ABC PL 2007/04 0.15 0.35 > > ABC PL 2007/05 0.1 0.1 > > HEALTH OW 2007/05 0.2 0.2 > > HEALTH OW 2007/06 0.2 - > > HEALTH OW 2007/06 0.2 0.4 > > HEALTH OW 2007/07 0.2 - > > HEALTH OW 2007/07 0.1 0.3 > > HEALTH OW 2007/08 0.2 - > > HEALTH OW 2007/08 0.2 - > > HEALTH OW 2007/08 0.2 0.6 > > HEALTH OW 2007/09 0.2 0.2 > > HEALTH PL 2007/10 0.2 - > > HEALTH PL 2007/10 0.2 0.4 > > HEALTH PL 2007/11 0.3 - > > HEALTH PL 2007/11 0.2 0.5 > > DENTAL OC 2007/12 0.2 - > > DENTAL OC 2007/12 0.2 0.3 > > DENTAL OW 2008/01 0.15 0.15 > > DENTAL PL 2008/01 0.2 0.2 > > DENTAL DD 2008/02 0.1 - > > DENTAL DD 2008/02 0.2 0.3 > > DENTAL DD 2008/03 0.2 - > > DENTAL DD 2008/03 0.2 0.4 > > DENTAL DD 2008/04 0.1 0.1 > > > -- > > ------ > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links > > :http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials 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 7000 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 > > athttp://groups.google.com/group/excel-macros/subscribe > > > > Book1.xls > 34KViewDownload- Hide quoted text - > > - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: trouble with multiple formulas
Why can't you use pivot table or subtotals commands instead of formulas Regards, Kishan Reddy, K. On Jul 27, 10:29 am, "nkmorri...@hotmail.com" wrote: > Can anyone provide me the formula/s for below query? I have four > columns. Company, Product, Date and Weight. What I need to do is add > up the monthly volumes per Customer/Product for each month. I have > over 170,000 records that I need to sort. I've tried multiple formulas > but I can't seem to work it out.Please help! > > Company Product Date Weight SHOULD EQUAL > ABC OW 2006/07 0.2 0.2 > ABC OW 2006/08 0.15 0.15 > ABC OW 2006/09 0.2 - > ABC OW 2006/09 0.1 0.3 > ABC OC 2006/10 0.1 - > ABC OC 2006/10 0.1 0.2 > ABC OC 2006/11 0.3 0.3 > ABC OC 2006/12 0.2 0.2 > ABC OC 2007/01 0.1 - > ABC OC 2007/01 0.2 0.3 > ABC PL 2006/07 0.2 0.2 > ABC PL 2006/08 0.2 0.2 > ABC DD 2006/08 0.2 0.2 > ABC PL 2007/04 0.2 - > ABC PL 2007/04 0.15 0.35 > ABC PL 2007/05 0.1 0.1 > HEALTH OW 2007/05 0.2 0.2 > HEALTH OW 2007/06 0.2 - > HEALTH OW 2007/06 0.2 0.4 > HEALTH OW 2007/07 0.2 - > HEALTH OW 2007/07 0.1 0.3 > HEALTH OW 2007/08 0.2 - > HEALTH OW 2007/08 0.2 - > HEALTH OW 2007/08 0.2 0.6 > HEALTH OW 2007/09 0.2 0.2 > HEALTH PL 2007/10 0.2 - > HEALTH PL 2007/10 0.2 0.4 > HEALTH PL 2007/11 0.3 - > HEALTH PL 2007/11 0.2 0.5 > DENTAL OC 2007/12 0.2 - > DENTAL OC 2007/12 0.2 0.3 > DENTAL OW 2008/01 0.15 0.15 > DENTAL PL 2008/01 0.2 0.2 > DENTAL DD 2008/02 0.1 - > DENTAL DD 2008/02 0.2 0.3 > DENTAL DD 2008/03 0.2 - > DENTAL DD 2008/03 0.2 0.4 > DENTAL DD 2008/04 0.1 0.1 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Problem In Macro Recording (URGENT Plz ! )
Instead of storing the macro in personal macro workbook, select this workbook. There may a problem with the personal work book. Regards, Kishan Reddy, K On Jul 27, 1:10 pm, Rehan Baig wrote: > Dear Members > > I have some problem with macro recording, > > after entering macro name, shortkut key and Store macro in : Personal Macro > Workbook > > Message appears *Personal Macro Workbook must be open in startup folder* > ** > Some time this message appears and some times not, > > Kindly help me, in this regard. > > REHAN BAIG -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Delete rows from sheet1 with matches in sheet2
Just use sort command, vlookup function & filter commands, done sort the data in sheet2 on id. add another column besides ID. and place 1 in the columns in sheet 1, Add another column (Example in D) to sheet1 and name it as index (assuming data is in columns A B C) use the following formula in D vlookup(A2, SHEET2!$A$2:$B$10,2,FALSE) Here you will get 1 in column D Use filter command and fiter for 1's and delete them. Bye, Kishan Reddy, K. On Jul 28, 12:40 am, calibansfolly wrote: > I need to delete rows from one sheet that match an id in another > sheet. Here's an example: > > sheet1: > id fname lname > 3 Brian Johnson > 17 Ben Johnson > 42 Mary Greene > 100 Joe Brown > > sheet2: > id > 17 > 42 > > Result: > id fname lname > 3 Brian Johnson > 100 Joe Brown > > Any ideas about how to do this? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Help creating chart
Hello, Obviously you will have a data sheet on which you have created the graph. Just right clik on the graph and select source data It will show the data on which graph is drawn. Just reselect the range that you want and press OK done. Bye Kishan Reddy, K. On Jul 28, 4:43 am, Steve wrote: > I need help! > > I am trying to adapt a neat little spreadsheet for my use in graphing > monthly, quarterly, and year-to-date sales for the current year and a > comparison to the same period in the prior year. What I have so far > has been downloaded. > > How can I select the appropriate period to plot i.e. month, quarter, > or year-to-date? > > Thank you in advance for your help. > > Steve -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Remove selected cell contents
flebber wrote:
> I have a column containing cells which house several delimited values
> and a dollar value. I want to be able to remove the delimited values
> and leave the dollar value in the cell in currency format.
>
> the cells contain information similar to
>
> 22-7-4-7 $22400.10
If this text is in cell A1, you can enter the following formula into
some other cell and retrieve the dollar value from A1. Then you can
format the new cell as currency manually (you can do this for lots of
cells in one go).
=RIGHT(A1,LEN(A1) - FIND("$",A1))
Regards,
Stuart
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Need help
Dear expert I have some data stored in excel sheet and I wanted to convert the same in paragraph form can I know how can I convert the same in paragraph form. Warm regards Madhav Vyas Sent on my BlackBerry® from Vodafone -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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
