I tried to prepare the report in Access . But the problem is that the schemes
details do not display vertically as required. They are displayed horizontally.
The number of schemes is about 100 , so horizontal report printing is not
possible not presentable as well. If I try to put scheme details
Thanks sam, The formula is just rightthanks again
On Jan 14, 12:47 am, Sam Mathai Chacko wrote:
> Here's a simplified formula using named ranges
>
> =INDEX($D$4:$O$4,MATCH(MIN(TimeArray),TimeArray,0)),
>
> where TimeArray = =Sheet1!$R4-(Sheet1!$R4>=DateRow)*(DateRow),
> where DateRow =
> =OFF
Dear Rohan
I was trying to do it for me but I could not I am attaching the work sheet
Please do it and please let me know what is the problem Why I could not do
it?
If I am doing it I can see only heading
Please help
Thanks in advanced
Regards
Shrinivas
On Tue, Dec 20, 2011 at 7:11 PM, Shrinivas S
have you checked my previous email . ?
On Mon, Jan 16, 2012 at 5:38 AM, vivek.j.ca wrote:
> By new page I mean for each dealer there should be a different page of
> report...and it should be in access report
> On Jan 16, 2012 5:26 AM, wrote:
>
>> Today's Topic Summary
>>
>> Group: http://gr
I am working on project assignment workbook. I have a PROJECT
worksheet that define project and task, I will get the data from
project managers about the hours per week for the each of the project
tasks.So the worksheet structure like below:
Project Name | Task Name | Jan-12 (hr)|Feb-12(hr)|
Hi All,
I am unable to get the caption in the button in the toolbar.
What is happening that if I keep the cursor on the button then only the
caption is showing.
But I want that the caption words visible in the button.
Hope my question is pretty clear!
I am pasting a sample code. It will be
Dear Vijay,
You can use..
*=SUM(INDEX((MONTH($A$2:$A$28)=1)*($C$2:$C$28="Passed"),0,0))*
See attached sheet..
On Sat, Jan 14, 2012 at 12:30 PM, vijayajith VA wrote:
> Hi Gurus,
>
>
> Please find the attached querY
>
> Thanks in adv.
>
> --
> FORUM RULES (986+ members already BANNED for viola
By new page I mean for each dealer there should be a different page of
report...and it should be in access report
On Jan 16, 2012 5:26 AM, wrote:
> Today's Topic Summary
>
> Group: http://groups.google.com/group/excel-macros/topics
>
>- Delete text only <#134e3cd67b42c55e_group_thread_0> [3
On Jan 16, 2012 5:26 AM, wrote:
> Today's Topic Summary
>
> Group: http://groups.google.com/group/excel-macros/topics
>
>- Delete text only <#134e3cd67b42c55e_group_thread_0> [3 Updates]
>- access query <#134e3cd67b42c55e_group_thread_1> [3 Updates]
>- HELP - Can´t sum the same colu
Did you try this macro?.
Sub Copycolatod_DeleteTextSAS()
Columns("A").Copy Range("D1")
Columns("D").SpecialCells(xlCellTypeConstants, 2).Delete Shift:=xlUp
End Sub
If you do NOT need to keep col A then simply
Sub DeleteTextinColumnA_SAS()
Columns("A").SpecialCells(xlCellTypeConstants, 2).Delete S
Hi Noorain
Can u give a macro for this urgently
On Jan 13, 2012, at 9:55 AM, NOORAIN ANSARI wrote:
> Dear Lokesh,
>
> Please try it..
>
> Sub Copy_and_Delete_Text()
> Dim rng, rng1, rng2 As Range
> Dim i, j As Long
> Set rng = Sheet1.Range("A1:A" & Sheet1.Range("A65536").End(xlUp).Row)
> rng.
Dear Laxman,
Sub Copy_and_Delete_Number()
Dim rng, rng1, rng2 As Range
Dim i, j As Long
Set rng = Sheet1.Range("A1:A" & Sheet1.Range("A65536").End(xlUp).Row)
rng.Copy Sheet1.Range("D1")
Set rng1 = Sheet1.Range("D2:D" & Sheet1.Range("D65536").End(xlUp).Row)
For Each rng2 In rng1
If VBA.IsNumeric(rn
What do you mean by new page? Forget new page, can you at least explain
what do you mean by page? Is it a word document? Is it an excel sheet?
If you cannot explain EXACTLY what you want, WHERE you want and HOW you
want, it will be very difficult for volunteers to help.
Sam
On Sun, Jan 15, 2012
13 matches
Mail list logo
