date:20110515

Re: $$Excel-Macros$$ Re: no of days in the month ?

2011-05-15 Thread STDEV(i)

i like this cool formula

=32-DAY(A1-DAY(A1)+32)

last day in a month / number of days in a month
based on a date.



On Sun, May 15, 2011 at 8:53 AM, Armando  wrote:

> Try these:
> =DAY(EOMONTH(A1,0))
> =32-DAY(A1-DAY(A1)+32)
>
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Excel filtered data selection

2011-05-15 Thread STDEV(i)

you should visit
http://www.rondebruin.nl/merge.htm


On Mon, May 16, 2011 at 12:44 AM, Prathima R  wrote:

> Hi All,
>
> i have excel data in five differrent workbooks which i will consolidate
> into one workbook and apply filter and select data by category Xin
> particular column and if yes need to be moved to another sheet and rename as
> In active..
>
> Please advise themacro or  code to be used to select data by filtering the
> excel sheet and select only X category in particular specified column.
>
> Thanks,
> Prathima
>
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ u asked abt macros rit

2011-05-15 Thread ░☻Rajesh Kumar ☻░

go and join that group


daily they will send


u wil learn easily da

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Excel Macro Request!

2011-05-15 Thread Mahesh parab

Hi
Try

Sub fillUp()
Dim lLastRow As Long
Dim lCounter As Long
Dim sThisCust As String
lLastRow = Cells(Rows.Count, "B").End(xlUp).Row
sThisCust = Cells(1, "B")
For lCounter = 2 To lLastRow
If Trim((Cells(lCounter, "B")) = "") Then
Cells(lCounter, "B") = sThisCust
Else
sThisCust = Cells(lCounter, "B")
End If
Next
End Sub


On Sun, May 15, 2011 at 10:12 PM, ashish koul  wrote:

> try this
>
> http://www.contextures.com/xlDataEntry02.html
>
> Fill Blank Cells From Above
> http://www.contextures.com/Excel-Videos-Data-Entry.html#FillBlanks
>
>
> On Sun, May 15, 2011 at 11:34 AM, Prabhu  wrote:
>
>> Hi friends,
>>
>> I need a macro for a selected column to fill previous cell
>> automatically where ever blank cell in the sheet.This Macro should
>> copy the previous cell content.I.e. B2 has "xxx" B3 and B4 is blank
>> means when we run the macro from B2 to B4 should show "xxx".
>>
>> Request. Filling must be column wise not row wise.
>>
>> Regards,
>>
>> Prabhu
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Calculate Due dates

2011-05-15 Thread Mr excel

It is the same worksheet bhayya which i had attched previously.Just need to
change the formula or add a routine for my requirement.
Thanks in advance.

On Sun, May 15, 2011 at 9:43 AM, ashish koul  wrote:

> can you attach the sample sheet
>
> On Sat, May 14, 2011 at 6:20 PM, Mr excel  wrote:
>
>> Thanks ashish bhayya for that great formula.Upon drilling deep into the
>> formula & the result,i feel we are into the logical error.To make it clear,
>> for Supplier A, if the transaction date is *12/05/2001*.the formula
>> should return the previous month just like, *05-Apr'2011   TO
>> 04-May'2011.Kindly update the formula.
>> Thanks in advance.
>> *
>> On Thu, May 12, 2011 at 9:41 AM, Anil Bhange <
>> anil.bha...@tatacommunications.com> wrote:
>>
>>> I think Ashish is right use this,
>>>
>>>
>>>
>>> Still try with this
>>>
>>>
>>>
>>> “mmm'”
>>>
>>>
>>>
>>>
>>>
>>> Regards,Anil Bhange
>>>
>>> IP Phone - 512320 | Mobile - 90290 32123
>>>
>>>
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *Mr excel
>>> *Sent:* Wednesday, May 11, 2011 8:37 PM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ Calculate Due dates
>>>
>>>
>>>
>>> what i meant is instead of the period,the formula is showing as a result
>>> the formula should return only the month with the year.
>>> For example,*05-Apr-2011   TO  04-May-2011*.
>>> should return apr'2011.
>>>
>>> hope this is not confusing you...ashish...
>>>
>>> On Sat, May 7, 2011 at 1:25 PM, ashish koul 
>>> wrote:
>>>
>>>
>>> change
>>> "dd-mmm-" to
>>>
>>> "dd-mmm'" in formula
>>>
>>>
>>>
>>> On Sat, May 7, 2011 at 7:47 AM, Mr excel  wrote:
>>>
>>> dear ashish,,
>>>
>>>That is excellent & great.Thanks a lot .The formula u provided is
>>> very nearer to the solution i wanted.everthing is same except in the month
>>> column of the sheet.Name of the month should be printed like April'2011
>>> instead of *05-Apr-2011   TO  04-May-2011*.
>>>
>>> the above formula also is very helpful to me in another scenario..
>>>
>>> Really my joy knew no boundaries..
>>>
>>>
>>>
>>> On Fri, May 6, 2011 at 6:46 AM, ashish koul 
>>> wrote:
>>>
>>> try  this one
>>>
>>>
>>>
>>> On Thu, May 5, 2011 at 9:11 PM, ashish koul 
>>> wrote:
>>>
>>> see if it helps
>>>
>>>
>>>
>>> On Thu, May 5, 2011 at 7:23 AM, Mr excel  wrote:
>>>
>>> For example,
>>> The billing cycle for supplier A is 5th of this month to 4th next
>>> so all the transactions pertaining to Supplier "A" will be billed in this
>>> period.
>>> Here in this example, there is only one transaction related to "A" and
>>> the billing is done for the month of jan'2011 so in the month column
>>> Jan'2011 should be displayed as this single transaction is done between
>>> 5th of Jan'2011-4th Feb'2011
>>> Likewise for all the other suppliers…
>>> Hope I had made it clear.
>>>
>>>
>>>
>>> On Wed, May 4, 2011 at 9:57 PM, ashish koul 
>>> wrote:
>>>
>>> can you expaln with some example in workbook
>>>
>>>
>>>
>>> On Tue, May 3, 2011 at 8:30 PM, keechak  wrote:
>>>
>>> Hi forum,
>>>
>>> Thanks very much for creating such a wonderful forum.
>>>
>>> I had a problem in calculating the due dates for different customers.
>>>
>>> Col A contains suppliers with the dates they supply the raw material &
>>> amount of the material supplied in the next columns B & C Respectively.
>>>
>>> I need a formula or a vba routine which can calculate the due dates for
>>> all the suppliers who supply the material.
>>>
>>> There are certain cut-off dates for each supplier in calculating the due
>>> dates in the billing cycle table.
>>>
>>> I want to print the months in Column D basing upon the supply date for
>>> each supplier and the cut-off dates in the right side table(Billing Cycle
>>> -table).
>>>
>>> Please help me
>>>
>>> WebRep
>>>
>>> Overall rating
>>>
>>>
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>>
>>>
>>> --
>>>
>>> *Regards*
>>>
>>> * *
>>>
>>> *Ashish Koul*
>>>
>>> *akoul*.*blogspot*.com 
>>>
>>> *akoul*.wordpress.com 
>>>
>>> My Linkedin Profile 
>>>
>>>
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> --

$$Excel-Macros$$ Freeze/Unalterable Cells

2011-05-15 Thread Vinod Narayanan

Hi Team,

Request you to help me creating an assessment sheet wherein the person
taking the test, once chooses the  option given in column C, the particular
cell should freeze...

If the question is given B3 cell and the corresponding answers in C3 (either
drop down or need to key in ... depending upon the question)
Sample sheet is attached... the movement the option is chosen by the person,
the cell c3 should freeze and make it unalterable

-- 
Thanks and Regards

Vinod Narayanan

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Freeze Cells.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Excel filtered data selection

2011-05-15 Thread Prathima R

Hi All,

i have excel data in five differrent workbooks which i will consolidate into
one workbook and apply filter and select data by category Xin particular
column and if yes need to be moved to another sheet and rename as In
active..

Please advise themacro or  code to be used to select data by filtering the
excel sheet and select only X category in particular specified column.

Thanks,
Prathima

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Arbitrage Formula

2011-05-15 Thread qcan

Hi,

I am looking for a couple of formulas that can be used to calculate an
arbitrage in sports wagering.

Example 1.

An even split based on a 1000 dollar total wager divded between both
sides.

- Side 1 odds = +110
- Side 2 odds = +150

I know that one would have to wager $ 543.48 on side 1, in order to
get a return $ 1141.31
I also know that a wager of $ 456.52 on side two in order to get a
retrun of $ 1141.30

In other words a 14.13 % profit would be generated evenly no matter
which side won.

Example 2.

The same as example 1 except I want to maximize side 1 while breaking
even on side 2. To clarify - this would mean that all the profit would
go to side 1 should side 1 win. If side 2 wins - I would break even.

Using 1000 dollars again (actually 1140 dollars so that it's even),
with the same odds as the first exmaple - I know that

-  $ 684.00 would have to be wagered on side 1 and $ 456.00 would have
to be wagered on side 2.

If side 1 wins - I would get back a total of  $1436.40 (meaning a  $
296.40 profit)
If side 2 wins - I would get back exactly the total money wagered on
both sides (1140 dollars) and break even.

I have no idea how to express these two examples into a formula.
Further, the formula(s) might be different when the favorite is
actually below -100.

I hope I made some sense. I will try and clarify should there be any
questions.

Anyone ?

Thanks !!

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Help with Budget - Formula

2011-05-15 Thread Ashish Pradhan


Hello All

Please see attached an excel file.

I need a formula to automatically reduce the closing balance from the 
proper "Funds" wherever there are instances of the "funds" being utilised.


The attached excel file will give more clarity. Please let me know if 
you need any more clarity.



Thanks in advance.


Ashish

--
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


sample.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ help me

2011-05-15 Thread Rajesh Naharwal

Hi Dear,

Use this formula,

=roundup(5284/12,1)

*Rajesh Naharwal



On 15 May 2011 19:27, memonkavi  wrote:

>
> Dear Sir
>
> This is my problem
>
> one cartoon 12  boxes
> I have 440 cartoon 4 boxes
>cartoon  440x12=5280
>boxes4
>
>   5284/12=440.33   this is excel result
>
>I need result-440.4
>
>pls help me
>how can i?
>regards
>kavi
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ converting COUNTIFS formula to macro

2011-05-15 Thread ashish koul

check the attachement see if it helps
On Sun, May 15, 2011 at 1:22 PM, gemmamckinley  wrote:

> Hi all
>
>  I am trying to add a countifs formula to a running macro, but so far I
> have not had much success and wonder if anyone could help pleas. I have
> posted my query on another website without reply, and I will make sure I
> post this link on there so people are aware I have asked on more than one
> website. I am sure it is something simple I am missing but it is starting to
> get frustrating so need some help.
>
> This is the formula I have set up, but as it is on many cells it is slowing
> the workbook down.
> [code]*
>
>  =COUNTIFS('g2 graded'!$G$1:$G$2, C2, 'g2 graded'!$D$1:$D$2, 1)
>
> *[/code]
> *
> I tried this, which is similar to my countif formulas in the macro but it
> doesnt work.*
>
> [code]
> *
>
>  Cells(x, 20).Value = Application.WorksheetFunction.CountIfs(Sheets("g2 
> graded").Range("g1:g3"), Cells(x, 3), Sheets("g2 
> graded").Range("d1:d3"), "1""")
>
> *[/code]
>
> My full running macro is:
>
> [code]
> *
>
> Sub UpdateValues()
> Application.ScreenUpdating = False
> Dim cell As Range
> For x = 2 To 1 'loop through rows from row 2 to the last row
> 'If cell isn't blue then macro assumes it doesn't need to continue (because 
> it has reached the end of the blue cells)
> If Cells(x, 18).Interior.ColorIndex <> 37 Then
> End
> Else
> 'insert value for column U (G2 Graded May).
> 'note that we don't calculate value for columns R & S until last because they 
> depend on the calculated values of other columns
> Cells(x, 21).Value = Application.WorksheetFunction.CountIf(Sheets("g2 
> graded").Range("G1:G1"), Cells(x, 3).Value) 'x refers to the current row 
> in the loop and 21 is the column number
> 'insert value for column V (G2 Graded May).
> Cells(x, 22).Value = Application.WorksheetFunction.SumIf(Sheets("g2 
> graded").Range("G1:G1"), Cells(x, 3).Value, Sheets("g2 
> graded").Range("N1:N1"))
> 'insert value for column W (G2 GradedTotal).
> Cells(x, 23).Value = Application.WorksheetFunction.CountIf(Sheets("g2 graded 
> april ").Range("H1:H1"), Cells(x, 3).Value) + Cells(x, 21).Value 'x 
> refers to the current row in the loop and 21 is the column number
> 'insert value for column X (G2 GradedTotal).
> Cells(x, 24).Value = Application.WorksheetFunction.SumIf(Sheets("g2 graded 
> april ").Range("H1:H1"), Cells(x, 3).Value, Sheets("g2 graded april 
> ").Range("O1:O1")) + Cells(x, 22).Value
> 'insert value for column Z (G2 Claim May).
> Cells(x, 26).Value = Application.WorksheetFunction.CountIf(Sheets("g2 
> claiming").Range("F1:F1"), Cells(x, 3).Value)
> 'insert value for column AA (G2 Claim May).
> Cells(x, 27).Value = Application.WorksheetFunction.SumIf(Sheets("g2 
> claiming").Range("F1:F1"), Cells(x, 3).Value, Sheets("g2 
> claiming").Range("AA1:AA1"))
> 'insert value for column AB (G2 Claim Total).
> Cells(x, 28).Value = Application.WorksheetFunction.CountIf(Sheets("g2 
> claiming april").Range("G1:G1"), Cells(x, 3).Value)
> 'insert value for column AC (G2 Claim Total).
> Cells(x, 29).Value = Application.WorksheetFunction.SumIf(Sheets("g2 claiming 
> april").Range("G1:G1"), Cells(x, 3).Value, Sheets("g2 claiming 
> april").Range("AB1:AB1"))
> 'insert value for column R (Graded Total).
> Cells(x, 18).Value = Cells(x, 23).Value + Cells(x, 28).Value
> 'insert value for column S (Claiming Total).
> Cells(x, 19).Value = Cells(x, 24).Value + Cells(x, 29).Value
> End If
> Next
> Application.ScreenUpdating = True
> End Sub
>
> *
> [/code]
>
> The webpage it is on is
> http://www.excelforum.com/excel-worksheet-functions/776036-converting-countifs-formula-to-macro.html
>
> Any help would be greatly appreciated.
>
> Regards
> Gemma
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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/gro

Re: $$Excel-Macros$$ Excel Macro Request!

2011-05-15 Thread ashish koul

try this

http://www.contextures.com/xlDataEntry02.html

Fill Blank Cells From Above
http://www.contextures.com/Excel-Videos-Data-Entry.html#FillBlanks

On Sun, May 15, 2011 at 11:34 AM, Prabhu  wrote:

> Hi friends,
>
> I need a macro for a selected column to fill previous cell
> automatically where ever blank cell in the sheet.This Macro should
> copy the previous cell content.I.e. B2 has "xxx" B3 and B4 is blank
> means when we run the macro from B2 to B4 should show "xxx".
>
> Request. Filling must be column wise not row wise.
>
> Regards,
>
> Prabhu
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ help me

2011-05-15 Thread rajan verma

Use minus Sign before your formula...

On Sun, May 15, 2011 at 7:27 PM, memonkavi  wrote:

>
> Dear Sir
>
> This is my problem
>
> one cartoon 12  boxes
> I have 440 cartoon 4 boxes
>cartoon  440x12=5280
>boxes4
>
>   5284/12=440.33   this is excel result
>
>I need result-440.4
>
>pls help me
>how can i?
>regards
>kavi
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards
Rajan verma
+91 9158998701

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Consolidate data

2011-05-15 Thread Sixthsense

Hi Rajesh,

Find herewith the attachment for deriving result by using single cell
formula.

Guys don't use / suggest helper column / array formula unnecessarily.

Hope that make sense.

---
*Sixthsense
**:) Man of Extreme & Innovative Thoughts :)*



On Wed, May 11, 2011 at 2:08 AM, Rajesh K R wrote:

> Hi Experts
> Pls check the attached file and tell me how to consolidate date month wise.
>
> Regards
>
> Rajesh Kainikkara
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Sum Data by Multi Criteria.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Problem regarding rank formula

2011-05-15 Thread Sixthsense

Hi Rajesh,

Find my solution in Column-J of attached excel.

Hope that helps.

---
*Sixthsense
**:) Man of Extreme & Innovative Thoughts :)*

On Sat, May 14, 2011 at 8:49 PM, Rajesh K R wrote:

> Hi experts,
> pls check the attached file and solve my issue regarding ranking the
> rooms according they are used for rent. In column "H" I given the
> formula for rank it,  but it shows  wrong values, the answer required
> given in column"i".
>
> Regards
> Rajesh Kainikkara
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Ranking-Solution.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ help me

2011-05-15 Thread memonkavi


Dear Sir

This is my problem

one cartoon 12  boxes
I have 440 cartoon 4 boxes
cartoon  440x12=5280
boxes4

   5284/12=440.33   this is excel result

I need result-440.4

pls help me
how can i?
regards
kavi

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Need Help

2011-05-15 Thread Anvesh Bhopatkar

Thanks for helping.




On Sun, May 8, 2011 at 6:31 AM, STDEV(i)  wrote:

> Sub ExpandTable()
>' by siti Vi / jakarta, 8 may 2011
>Dim SrcRng As Range, ResRng As Range, pDate As Date
>Dim i As Long, r As Long, u As Integer
>
>Set SrcRng = Cells(1).CurrentRegion
>Worksheets.Add After:=Sheets(Sheets.Count)
>Set ResRng = ActiveSheet.Cells(1)
>
>For i = 1 To SrcRng.Rows.Count
>   If IsDate(SrcRng(i, 3)) And IsDate(SrcRng(i, 4)) _
>   Then pDate = IIf(SrcRng(i, 3) < SrcRng(i, 4), SrcRng(i, 4), SrcRng(i,
> 3))
>   If SrcRng(i, 2).Value - Int(SrcRng(i, 2).Value) > 0 Then
>  For u = 1 To 2
> r = r + 1
> ResRng(r, 1) = SrcRng(i, 1)
> If u = 1 Then ResRng(r, 2) = Int(SrcRng(i, 2))
> If u = 2 Then ResRng(r, 2) = SrcRng(i, 2) - Int(SrcRng(i, 2))
> ResRng(r, 3) = IIf(pDate = 0, SrcRng(i, 3), pDate)
> ResRng(r, 4) = IIf(pDate = 0, SrcRng(i, 4), pDate)
>  Next u
>   End If
>Next i
>ResRng.CurrentRegion.Offset(0, 2).Columns.AutoFit
> End Sub
>
>
> On Sat, May 7, 2011 at 1:03 PM, anvesh.gw...@gmail.com <
> anvesh.gw...@gmail.com> wrote:
>
>> Hi,
>>
>> I need help in VBA code.
>> I have excel sheet on which data is write as below mention
>>
>>
>> Input
>>
>>  A   BC D
>> 1   X1  1.511/11/2008   01/11/2010
>> 2   X2  2.511/12/2009   01/11/2010
>> 3   X3  3.511/01/2010   01/11/2010
>>
>> I want Output in another sheet as given below
>>
>> Output
>>
>>A   BC D
>> 1   X1  1.011/11/2008   01/11/2010
>> 1   X1  0.511/11/2008   01/11/2010
>> 2   X2  2.011/12/2009   01/11/2010
>> 2   X2  0.511/12/2009   01/11/2010
>> 3   X3  3.011/01/2010   01/01/2010
>> 3   X3  0.511/01/2010   01/01/2010
>>
>>
>> Procedure
>> 1. Check column B if it contain decimal than separate integer and
>> decimal i.e if value is 1.5 than
>> insert row and split  as mention above in output
>> 2. Check C and D for date if "C" column Date is less than "D" Column
>> than pick Date of "D" column other wise pick date of  "C" Column.
>>
>> Can any body help me in this.
>>
>> Thanks in advance
>> Anvesh
>
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ insert new row if column is missing date....

2011-05-15 Thread Stuart

Hi all

I hope someone can help with this.

My data is in columns A to F with the short date being in column B.

The data is sorted in date order and the first date that appears in
column B is 23/12/2002 and the next row contains the date 14/01/2002.
What I need is for a macro to look at the first date in the cell that
I have selected and then look at the next date and fill in the missing
dates until it reaches today.  The data can go down in an unlimited
amount of rows.

So basically the macro would insert a new row with the date is column
B as 24/12/2002, 25/12/2002, 26/12/2002 and so on and so forth.

I hope this makes sense to someone

Best 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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ converting COUNTIFS formula to macro

2011-05-15 Thread gemmamckinley

Hi all

 I am trying to add a countifs formula to a running macro, but so far I have 
not had much success and wonder if anyone could help pleas. I have posted my 
query on another website without reply, and I will make sure I post this 
link on there so people are aware I have asked on more than one website. I 
am sure it is something simple I am missing but it is starting to get 
frustrating so need some help.

This is the formula I have set up, but as it is on many cells it is slowing 
the workbook down.
[code]*

 =COUNTIFS('g2 graded'!$G$1:$G$2, C2, 'g2 graded'!$D$1:$D$2, 1)

*[/code]
*
I tried this, which is similar to my countif formulas in the macro but it 
doesnt work.*

[code]
*

 Cells(x, 20).Value = Application.WorksheetFunction.CountIfs(Sheets("g2 
graded").Range("g1:g3"), Cells(x, 3), Sheets("g2 
graded").Range("d1:d3"), "1""")

*[/code]

My full running macro is:

[code]
*

Sub UpdateValues()
Application.ScreenUpdating = False
Dim cell As Range
For x = 2 To 1 'loop through rows from row 2 to the last row
'If cell isn't blue then macro assumes it doesn't need to continue (because it 
has reached the end of the blue cells)
If Cells(x, 18).Interior.ColorIndex <> 37 Then
End
Else
'insert value for column U (G2 Graded May).
'note that we don't calculate value for columns R & S until last because they 
depend on the calculated values of other columns
Cells(x, 21).Value = Application.WorksheetFunction.CountIf(Sheets("g2 
graded").Range("G1:G1"), Cells(x, 3).Value) 'x refers to the current row in 
the loop and 21 is the column number
'insert value for column V (G2 Graded May).
Cells(x, 22).Value = Application.WorksheetFunction.SumIf(Sheets("g2 
graded").Range("G1:G1"), Cells(x, 3).Value, Sheets("g2 
graded").Range("N1:N1"))
'insert value for column W (G2 GradedTotal).
Cells(x, 23).Value = Application.WorksheetFunction.CountIf(Sheets("g2 graded 
april ").Range("H1:H1"), Cells(x, 3).Value) + Cells(x, 21).Value 'x refers 
to the current row in the loop and 21 is the column number
'insert value for column X (G2 GradedTotal).
Cells(x, 24).Value = Application.WorksheetFunction.SumIf(Sheets("g2 graded 
april ").Range("H1:H1"), Cells(x, 3).Value, Sheets("g2 graded april 
").Range("O1:O1")) + Cells(x, 22).Value
'insert value for column Z (G2 Claim May).
Cells(x, 26).Value = Application.WorksheetFunction.CountIf(Sheets("g2 
claiming").Range("F1:F1"), Cells(x, 3).Value)
'insert value for column AA (G2 Claim May).
Cells(x, 27).Value = Application.WorksheetFunction.SumIf(Sheets("g2 
claiming").Range("F1:F1"), Cells(x, 3).Value, Sheets("g2 
claiming").Range("AA1:AA1"))
'insert value for column AB (G2 Claim Total).
Cells(x, 28).Value = Application.WorksheetFunction.CountIf(Sheets("g2 claiming 
april").Range("G1:G1"), Cells(x, 3).Value)
'insert value for column AC (G2 Claim Total).
Cells(x, 29).Value = Application.WorksheetFunction.SumIf(Sheets("g2 claiming 
april").Range("G1:G1"), Cells(x, 3).Value, Sheets("g2 claiming 
april").Range("AB1:AB1"))
'insert value for column R (Graded Total).
Cells(x, 18).Value = Cells(x, 23).Value + Cells(x, 28).Value
'insert value for column S (Claiming Total).
Cells(x, 19).Value = Cells(x, 24).Value + Cells(x, 29).Value
End If
Next
Application.ScreenUpdating = True
End Sub

*
[/code]

The webpage it is on is 
http://www.excelforum.com/excel-worksheet-functions/776036-converting-countifs-formula-to-macro.html

Any help would be greatly appreciated.

Regards
Gemma

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How to remove space in excel cell

2011-05-15 Thread rajan verma

use =Trim(Your_Text)

On Sun, May 15, 2011 at 11:18 AM, Prabhu  wrote:

> Hi friends,
>
> How to remove spaces(bugs) in a particular cell either will be as
> prefix or suffix before or after  number or text.
>
> Regards,
>
> Prabhu
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards
Rajan verma
+91 9158998701

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Please help to make my project good.

2011-05-15 Thread Zafar Iqbal

Dear Mr. Fabio Lemos,

 

I replaced ; with , and got the result. Thanks for this short formula.
Please discard my previous e-mail for sample file. Thanks

 

Regards,

ZAFAR IQBAL

From: Zafar Iqbal [mailto:ziqba...@gmail.com] 
Sent: Sunday, May 15, 2011 10:15 AM
To: 'Fabio Lemos'
Cc: 'excel-macros@googlegroups.com'
Subject: $$Excel-Macros$$ Please help to make my project good.

 

Dear Mr. Fabio Lemos,

 

Thanks for your interest. 

I tried to apply your below mentioned formula. I am getting error message. 

Can you please send me sample file with formula. Thanks a lot for this
kindness.

 

Regards,

ZAFAR IQBAL

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Fabio Lemos
Sent: Saturday, May 14, 2011 7:03 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help to make my project good.

 

You also could simplify the formula by inserting the following in the E2
cell:

 

=OFFSET(INDIRECT("'"&$A$2&"'!$A$1";TRUE);$C$21+ROW(E2)-2;0)

 

And tham just copy to the other

 

2011/5/13 Zafar Iqbal 

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Please help to make my project good.

2011-05-15 Thread Zafar Iqbal

Dear Mr. Fabio Lemos,

 

Thanks for your interest. 

I tried to apply your below mentioned formula. I am getting error message. 

Can you please send me sample file with formula. Thanks a lot for this
kindness.

 

Regards,

ZAFAR IQBAL

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Fabio Lemos
Sent: Saturday, May 14, 2011 7:03 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help to make my project good.

 

You also could simplify the formula by inserting the following in the E2
cell:

 

=OFFSET(INDIRECT("'"&$A$2&"'!$A$1";TRUE);$C$21+ROW(E2)-2;0)

 

And tham just copy to the other

 

2011/5/13 Zafar Iqbal 

Dear, With due respect to your effort, I tried with a simplified formula and
got the same result. Please find the attached file with both formulas.
Thanks

Regards,

ZAFAR IQBAL

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of §»VIPER«§
Sent: Thursday, May 12, 2011 8:36 AM

To: excel-macros@googlegroups.com

Subject: Re: $$Excel-Macros$$ Please help to make my project good.

pfa

On Thu, May 12, 2011 at 12:31 AM, Mahesh parab  wrote:

Hi

check whether attach file helps.

On Wed, May 11, 2011 at 3:51 PM, karan 1237  wrote:

Respected Sirs/Mam,

I need your help making my project good.  Please find attachment. I will be
very obliged if someone can help me as earlier as possible.

--
Basically I have to do that when I click on drop down list & select another
career i.e. Building and Construction so In sub career list data should
comes from the Building and construction's sheet and If I select another
career i.e. Catering and Hospitality so data should comes from its list
(Catering and Hospitality) and scroll bar should work with the same. I have
16 careers so please tell me how can I 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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How to remove space in excel cell

2011-05-15 Thread ashish koul

= trim(a1)
On Sun, May 15, 2011 at 11:18 AM, Prabhu  wrote:

> Hi friends,
>
> How to remove spaces(bugs) in a particular cell either will be as
> prefix or suffix before or after  number or text.
>
> Regards,
>
> Prabhu
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Excel Macro Request!

2011-05-15 Thread Prabhu

Hi friends,

I need a macro for a selected column to fill previous cell
automatically where ever blank cell in the sheet.This Macro should
copy the previous cell content.I.e. B2 has "xxx" B3 and B4 is blank
means when we run the macro from B2 to B4 should show "xxx".

Request. Filling must be column wise not row wise.

Regards,

Prabhu

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ How to remove space in excel cell

2011-05-15 Thread Prabhu

Hi friends,

How to remove spaces(bugs) in a particular cell either will be as
prefix or suffix before or after  number or text.

Regards,

Prabhu

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ no of days in the month ?

2011-05-15 Thread jmothilal

Thanks for  Sending formulas.


J.Mothilal


On Sun, May 15, 2011 at 5:20 AM, STDEV(i)  wrote:

> thanks to mr verma, with his formula
> =DAY(DATE(YEAR(TODAY()),MONTH(*(B2&1)*)+1,1)-1)
>
> how about
> =DAY(DATE(YEAR(TODAY()),MONTH((B2&1))+1,*0*))
>
> The *last day of this month*  is = the  *0*th day of the Next Month !!
>
>
>
> On Sat, May 14, 2011 at 7:03 PM, rajan verma 
> wrote:
> > find attached Sheet
> >
>
> > On Sat, May 14, 2011 at 3:36 PM, jmothilal  wrote:
> >> Dear Friends
> >> i want find total no days in the month
> >> i.e   January   = 31 days
> >>   Feb   = 29 days
> >>   march   = 30 days like
> >> --
> >> J.Mohilal
> >> Universal Computer Systems
> >> # 16, Brindavan Complex
> >> Otteri, Vellore-2
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Re: no of days in the month ?

2011-05-15 Thread Armando

Try these:
=DAY(EOMONTH(A1,0))
=32-DAY(A1-DAY(A1)+32)

On May 14, 4:06 am, jmothilal  wrote:
> Dear Friends
>
> i want find total no days in the month
>
> i.e   January   = 31 days
>       Feb               = 29 days
>       march           = 30 days like
>
> --
> J.Mohilal
> Universal Computer Systems
> # 16, Brindavan Complex
> Otteri, Vellore-2

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: no of days in the month ?

Re: $$Excel-Macros$$ Excel filtered data selection

$$Excel-Macros$$ u asked abt macros rit

Re: $$Excel-Macros$$ Excel Macro Request!

Re: $$Excel-Macros$$ Calculate Due dates

$$Excel-Macros$$ Freeze/Unalterable Cells

$$Excel-Macros$$ Excel filtered data selection

$$Excel-Macros$$ Arbitrage Formula

$$Excel-Macros$$ Help with Budget - Formula

Re: $$Excel-Macros$$ help me

Re: $$Excel-Macros$$ converting COUNTIFS formula to macro

Re: $$Excel-Macros$$ Excel Macro Request!

Re: $$Excel-Macros$$ help me

Re: $$Excel-Macros$$ Consolidate data

Re: $$Excel-Macros$$ Problem regarding rank formula

$$Excel-Macros$$ help me

Re: $$Excel-Macros$$ Need Help

$$Excel-Macros$$ insert new row if column is missing date....

$$Excel-Macros$$ converting COUNTIFS formula to macro

Re: $$Excel-Macros$$ How to remove space in excel cell

$$Excel-Macros$$ Please help to make my project good.

$$Excel-Macros$$ Please help to make my project good.

Re: $$Excel-Macros$$ How to remove space in excel cell

$$Excel-Macros$$ Excel Macro Request!

$$Excel-Macros$$ How to remove space in excel cell

Re: $$Excel-Macros$$ no of days in the month ?

$$Excel-Macros$$ Re: no of days in the month ?

27 matches

Site Navigation

Mail list logo

Footer information