Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
>
>
>
>
> -Original Message-
> From: Monizri
> Sent: Friday, February 10, 2012 8:15 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Insert a row and subtotal
>
> Hello, does
Hello, does anyone know how to add subtotals once my code has run a
"sum" for both the Par Value and a "sumproduct" for the coupon rate?
I have a code that gathers the data i need but i can't figure out this
last part.
https://www.box.net/shared/0fknh9819pk9t8m7jxz9
Here is the file i'm trying t
Hello, i have this code, i apologize as it is messy. But i am trying
to loop through two columns, i want the loop to read the column on the
right and for eah item on the right i want the second loop to search
through the "database" i have created and create a new tab for it.
Here is the sheet, any
.Row, 5)).Copy wks.Cells(wks.Rows.Count, 2).End(xlUp).Offset(1,
> -1)
> End If
> Set wks = Nothing
> End If
> End If
> Next rngCell
> Worksheets("Data").AutoFilterMode = False
> Application.Goto Worksheets(&qu
t;
> Sub filterandcopy()
> 'for each c in activesheet.usedrange.specialcells(xlce
> For Each c In Range("b2:b21,f2:f21,j2,j21")
> If UCase(c) = "X" Then
> 'MsgBox c.Row
> End If
> Next c
> End Sub
>
> Don Guillett
> SalesAid Software
> dgui
box, and reply to the mail.
>
> OR
>
> Go to box.net, and you can upload your file there, and provide a link here.
>
> Regards,
>
> Sam
>
>
>
>
>
>
>
>
>
> On Sun, Oct 9, 2011 at 12:57 AM, Monizri wrote:
> > Thanks Don, I can try FIND instead
that instead of using a loop you would use FIND (look in vba help)
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
>
>
>
>
> -Original Message-
> From: Monizri
> Sent: Saturday, October 08, 2011 9:01 AM
> To: MS EXCEL AND
I believe the forum is not able to comprehend what 'can i get excel to read
> a menu with selections using "X" in a cell' is trying to convey. Maybe you
> want to rephrase it, or share an example of what you are trying to do.
>
> Sam
>
>
>
>
>
>
>
>
Hi, I have the following code that searches for data based on what i
type in it (in this case it is "FHCX") and posts it in a new sheet.
How can i get excel to read a menu with selections using "X" in a cell
and feed it into the code below to produce results on a new tab?
Sub ServiceReport()
'