can you email you file to excel-macros@googlegroups.com and attach the
workbook
On Mon, May 23, 2011 at 9:58 PM, Robert Jacobs wrote:
> Well after a bit of searching, it's looking like the Report
> filters are not dependent. No matter what you select in one report
> filter, every record
Any suggestions on how to write this macro? I'm kinda new to macros.
Thanks in advance!
On May 23, 1:47 am, "STDEV(i)" wrote:
> when you type a data ( event a dot ) in a cell,
> the old data (incl. FORMULA) in the cell will be removed
> and replaced with the new data.
>
> with macro you can "auto
Well after a bit of searching, it's looking like the Report
filters are not dependent. No matter what you select in one report
filter, every record is still listed in the other filters, even if
they won't show any data when selected. Apparently there's no real
way to do this, other than upgra
I access this from Google Groups... don't see an attach option. Email
possibly?
I have found the PivotTableSelectionChange() event, I just don't know
what to add here. I've tried the refresh pivot table code, but it
doesn't refresh the selection list. Again, my data's not actually
changing, I j
The column "difference" highlighted in green is calculated as the difference
between the two cells to its left.Then %difference is the percentage in
their difference and abs difference is their absolute difference.
How to code such that if i pass the formula these three fields are
calculated for r
hi ,
I need your help. Below are my requirements
I have 3 different spreadsheets. month.xls & Checklist.xls & Master.xls
a.Master.xls has 5 diff sheets, I need to filter & extract details
from each sheet & paste it in new spreadsheet.I need to extract the
details of employee with designation "A
Amended..
Function Ratio2(*ParamArray* arr()) As String
For i = 0 To UBound(arr)
Ratio2 = Ratio2 & arr(i) / WorksheetFunction.Gcd(arr) & ":"
Next
Ratio2 = Left(Ratio2, Len(Ratio2) - 1)
End Function
On Mon, May 23, 2011 at 8:16 PM, rajan verma wrote:
> *Try thi
*Try this Function*
Function Ratio2(*ParamArray* arr()) As String
Dim Arr2(1) As Integer
For i = 0 To UBound(arr)
Ratio2 = Ratio2 & arr(i) / WorksheetFunction.Gcd(arr) & ":"
Next
Ratio2 = Left(Ratio2, Len(Ratio2) - 1)
End Function
On Mon, May 23, 2011 at 12:35
Dear Noorain,
I will be thankful for your effort on my request.
Regards,
Saroj.
On Fri, May 20, 2011 at 10:39 PM, NOORAIN ANSARI
wrote:
> Pls try it
>
> =CONCATENATE(A1,":",B1)
>
> On Fri, May 20, 2011 at 5:08 PM, Kabir:-) wrote:
>
>> Dear Gurus,
>>
>> I need a formula for calculat
Dear Kaushik,
I am having a small doubt pertaining to your solution given for transpose
formula. When i look into the sheet, the claim no. 1 shows the Amount of 10,
10, 50 & 20 was been given. But as per your formula, the Amount of 10, 30 &
20 has got transpose to the Claim NO.1. Where as Amount R
Dear Rajan,
Thanks for your formulait works. But I want to know, will there be any
macro or VBA code for the query like this. Kindly help me if anything
available like such.
Thank you all...
Regards,
Saroj.
On Sat, May 21, 2011 at 10:00 AM, Rajan_Verma wrote:
> Hi Kabir,
>
> See
Hi,
This I tried but still I could not able to recover the file. Let me know is
there any other way to recover file.
Thanks,
Chandra Shekar B
On Sat, May 21, 2011 at 10:11 AM, ashish koul wrote:
>
> http://office.microsoft.com/en-us/excel-help/repairing-corrupted-files-in-excel-HA001034656.as
12 matches
Mail list logo