Hi Noorain,
Thanks for your help.
I've used your logic and implemented it accordingly, thanks again.
Here is the code.
SalesCount = 8
For K3 = 21 To 5000
If Cells(K3, 1).Value = "ABC" And Cells(K3 + 1, 2) = "XYZ" Then
ColC = "C" & K3 + 2 & ":C" & K3 + 1 + SalesCount
End
Thanks Sam.. I also used pivot but it take lot of time..but I want as per my
final report sheet...if possible
Sent from my Nokia phone
-Original Message-
From: Sam Mathai Chacko
Sent: 24-01-2012 7:57:41 pm
Subject: Re: $$Excel-Macros$$ Micro
I'd recommend Pivot to do this. Sure it
Dear Selva,
Can you share a sample with Excel Macro Group.
On Wed, Jan 25, 2012 at 10:53 AM, LearnExcel wrote:
> Hi team, i wanted to import data set from two files and consolidate
> the data into a master file.
>
> I need something in VBA, currently i run a marco that goes through
> each sheet
Thank you sirji. I will try on it.
On Tue, Jan 24, 2012 at 8:40 PM, Sam Mathai Chacko wrote:
> I have just shown an example for the name. I am sure you can replicate it
> for all your other fields.
>
> 'The strNewLine is optional. It is used as a character that will force to
> go to the next line
Hi team, i wanted to import data set from two files and consolidate
the data into a master file.
I need something in VBA, currently i run a marco that goes through
each sheet and copies them into the marco but for some reason it takes
some time im sure theres a better way..
let me know if you nee
Thank you so much for helping. its really useful solution.
On Tue, Jan 24, 2012 at 8:18 PM, Sam Mathai Chacko wrote:
> Regards,
> Sam Mathai Chacko
>
>
> On Tue, Jan 24, 2012 at 11:26 AM, yasir_shahjee
> wrote:
>
>> Respected Group Members.
>>
>> Kindly check attached file.
>>
>> I need automati
Thank You So much for helping.
On Tue, Jan 24, 2012 at 6:55 PM, Sam Mathai Chacko wrote:
> Put in C3 and drag down
>
> =SUMPRODUCT(IF(A3&B3=A2&B2,C2,IF(B3=B2,C2+1,1)))
>
> Regards,
> Sam Mathai Chacko
>
>
> On Tue, Jan 24, 2012 at 5:03 PM, yasir_shahjee wrote:
>
>> Still waiting
>>
>>
>> On Tue,
Dear Mansoor,
short-cut key sequence for paste special value
Alt+E+S+V
or
Writing a subroutine in Personal.xls and giving it a shortcut key like:
VBA:
Sub PasteValues()
Selection.Formula=Selection.Value
End Sub
--
Thanks & regards,
Noorain Ansari
*http://excelmacroworld.blogspot.
Sheets("Sheet1").UsedRange.Value = Sheets("Sheet1").UsedRange.Value
Don Guillett
SalesAid Software
dguille...@gmail.com
From: danial mansoor
Sent: Tuesday, January 24, 2012 8:25 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ paste special dialogue box
is there an easy way t
is there an easy way to paste special values or using vba get paste special
dialogue box.?
hope i get best solution
> From: dguille...@gmail.com
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)
> Date: Tue, 24 Jan 2012 07:35
change source to your sheetname or define a namedrange
=INDEX(source!J:J,SUMPRODUCT(MAX((source!E2:E22=B2)*ROW(E2:E22
Don Guillett
SalesAid Software
dguille...@gmail.com
From: hemal shah
Sent: Tuesday, January 24, 2012 8:34 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Hi
Sam
Thanks for the solution
but I want something different.
Please see my attached file, which give you more idea regarding my query
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need H
=INDEX(OFFSET('dia 28 en8 bgt'!$A$1:$A$15,0,MATCH(summary!$B$1,'dia 28 en8
bgt'!$A$1:$J$1,0)-1),MATCH(9E+300,OFFSET('dia 28 en8
bgt'!$A$1:$A$15,0,MATCH(summary!$B$1,'dia 28 en8 bgt'!$A$1:$J$1,0)-1),1))
Regards,
Sam Mathai Chacko
On Tue, Jan 24, 2012 at 4:56 PM, hemal shah wrote:
> hi
> all mast
It would be nice if you would give details such as
source cell or column___ goes wherewhy_
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: ashjain2...@yahoo.co.in
Sent: Tuesday, January 24, 2012 5:05 AM
To: excel-macros@googlegroups.com
S
Put in C3 and drag down
=SUMPRODUCT(IF(A3&B3=A2&B2,C2,IF(B3=B2,C2+1,1)))
Regards,
Sam Mathai Chacko
On Tue, Jan 24, 2012 at 5:03 PM, yasir_shahjee wrote:
> Still waiting
>
>
> On Tue, Jan 24, 2012 at 4:06 PM, Shaik Waheed wrote:
>
>> Hi, can u tell how u r getting the SR#
>>
>>
>> On Tue, Jan 2
Try this. Make sure you do not have any line breaks
Option Explicit
Sub CopyShtwitoutdecimals()
Dim i As Long
Dim lr As Long
Dim lc As Long
Dim mf As Range
For i = 1 To Sheets.Count
With Sheets(i)
lr = .Cells.Find("*", Cells(Rows.Count, Columns.Count) _
, , , xlByRows, xlPrevious).Row
lc = .Cel
Still waiting
On Tue, Jan 24, 2012 at 4:06 PM, Shaik Waheed wrote:
> Hi, can u tell how u r getting the SR#
>
>
> On Tue, Jan 24, 2012 at 1:58 PM, yasir_shahjee wrote:
>
>> Thanks but i need on sheet no in pivot table.
>>
>>
>> On Tue, Jan 24, 2012 at 12:01 PM, PrIyAnKa wrote:
>>
>>> Dear Yasir
hi
all masters
I have work on fifo in very simple way in excel.
now in summary sheet i require , while i type GRN, i should get latest
balance .
I have attached file for your reference.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
Hi, can u tell how u r getting the SR#
On Tue, Jan 24, 2012 at 1:58 PM, yasir_shahjee wrote:
> Thanks but i need on sheet no in pivot table.
>
>
> On Tue, Jan 24, 2012 at 12:01 PM, PrIyAnKa wrote:
>
>> Dear Yasir
>>
>> Simply u can do it with Pivot Tabe option ,
>>
>> Kindly find the attached fi
Pls provide solution for this problem.
-- Forwarded message --
From: Shankar Bheema
Date: Mon, Jan 23, 2012 at 1:28 PM
Subject: Saving the form data charaterwise in excel sheet
To: excel-macros@googlegroups.com
Dear Experts
I attached a VBA form. How to save the data in charate
Thank you very much.
On Mon, Jan 23, 2012 at 11:13 PM, Sam Mathai Chacko wrote:
> And for printing
>
> Private Sub CommandButton2_Click()
>
> Worksheets("Page1").PrintOut
> Worksheets("Page2").PrintOut
>
> End Sub
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Mon, Jan 23, 2012 at 6:44 PM, N
Actually for calculation of salary, as per Government orders have to
calculated 30 days per month whether it is Feb or Apr or Aug
and thank you very much for providing solution for my query
On Mon, Jan 23, 2012 at 7:22 PM, Sam Mathai Chacko wrote:
> You will have to enter 01-05-2012, or you will
thank you very much
On Mon, Jan 23, 2012 at 6:24 PM, NOORAIN ANSARI wrote:
> Dear Shankar,
>
> Please use..
>
> Private Sub txtto_Exit(ByVal Cancel As MSForms.ReturnBoolean)
> txtdays.Value = VBA.DateDiff("D", txtfrom.Value, txtto.Value)
> End Sub
> See attached sheet.
>
> -
> Thanks & regards,
>
thank you very much.
On Mon, Jan 23, 2012 at 6:16 PM, NOORAIN ANSARI wrote:
> Dear Shankar,
>
> See attached sheet...Hope your query has been solved.
>
>
> On Mon, Jan 23, 2012 at 1:36 PM, Shankar Bheema wrote:
>
>> Dear Experts
>>
>> In an excel book, each sheet is named with the designation of t
no 1 was there in group to solve my query
On Tue, Jan 24, 2012 at 2:06 PM, Dhartikumar Sahu wrote:
>
> any solution of my query..
>
>
> On Tue, Jan 24, 2012 at 12:47 PM, Dhartikumar Sahu
> wrote:
>
>> thanks priyanka
>>
>> but i need another way
>>
>> when i type manual
any solution of my query..
On Tue, Jan 24, 2012 at 12:47 PM, Dhartikumar Sahu wrote:
> thanks priyanka
>
> but i need another way
>
> when i type manually on particular cell , auto pickup related that value.
> (e.g. if i type *choc *and click on drop down arrow it will display the
>
Thanks but i need on sheet no in pivot table.
On Tue, Jan 24, 2012 at 12:01 PM, PrIyAnKa wrote:
> Dear Yasir
>
> Simply u can do it with Pivot Tabe option ,
>
> Kindly find the attached file for the same
>
>
> On Tue, Jan 24, 2012 at 10:28 AM, yasir_shahjee
> wrote:
>
>> Respected Members.
>>
>
27 matches
Mail list logo