Re: $$Excel-Macros$$ If then elseif on same sheet not looping

2014-11-10 Thread Paul Schreiner
“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: JenIT >To: excel-macros@googlegroups.com >Sent: M

$$Excel-Macros$$ If then elseif on same sheet not looping

2014-11-10 Thread JenIT
Hello, I'm sure the answer to this is out there, but I am not searching correctly to find it. I have code to past the result of an if/then/elseif statement from column B into column A. It works for line one and I am drawing a mind blank and I can't get it to run through the whole sheet (variab

Re: $$Excel-Macros$$ If then

2014-06-16 Thread Paul Schreiner
the people you can, As long as ever you can.” - John Wesley - From: deanalt via MS EXCEL AND VBA MACROS >To: excel-macros@googlegroups.com >Sent: Monday, June 16, 2014 2:43 PM >Subject: $$Excel-Macros$$ If then > > > >I've be

$$Excel-Macros$$ If then

2014-06-16 Thread deanalt via MS EXCEL AND VBA MACROS
I've been gone for a long while and forgot some of what little I knew about proper VBA syntax. This is an easy one, I'm sure, so would someone kindly help me with the proper syntax on the if and goto statements? I'm getting things about end ifs without block ifs, etc. Thanks much, Dean. I wa

Re: $$Excel-Macros$$ if then code in macro doesn't work

2013-11-15 Thread pankaj sangotra
f cells(I,14)>25 then > > Cells(i,16)=5 > > Endif > > next > > > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *dewitha.partore...@gmail.com > *Sent:* Thursday, November 14, 2013 8:10 PM >

RE: $$Excel-Macros$$ if then code in macro doesn't work

2013-11-15 Thread Ravinder
[mailto:excel-macros@googlegroups.com] On Behalf Of dewitha.partore...@gmail.com Sent: Thursday, November 14, 2013 8:10 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ if then code in macro doesn't work Hi, i hope someone can help me. Im new to working with macro'

$$Excel-Macros$$ if then code in macro doesn't work

2013-11-14 Thread dewitha . partoredjo
Hi, i hope someone can help me. Im new to working with macro's but with some help i usually understand a lot of the codes used. However, now that im actually trying something myself it doesnt quite work as i want it. I have this macro in which i have price and delivery costs. What i want is that

Re: $$Excel-Macros$$ if then formula - help needed

2010-01-27 Thread Dilip Pandey
Dear TAIgo, Attached file had the circular reference error, now resolved. Please get back in case of any queries. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jan 27, 2010 at 12:35 AM,

Re: $$Excel-Macros$$ if then formula - help needed

2010-01-26 Thread ankur
hi taigo for uploading file just reply this mail with attaching file On 27/01/2010, TAlgo wrote: > I cant upload the file so emailing you..if you know how to upload > please go ahead... > > Thanks again > > Dilip Pandey wrote: >> Hi TAIgo, >> >> According to me you should be getting circular ref

Re: $$Excel-Macros$$ if then formula - help needed

2010-01-26 Thread TAlgo
I cant upload the file so emailing you..if you know how to upload please go ahead... Thanks again Dilip Pandey wrote: > Hi TAIgo, > > According to me you should be getting circular reference error because you > are Adding B1+A2 being in Cell A2. Try uploading a sample file so that we > can help

Re: $$Excel-Macros$$ if then formula - help needed

2010-01-26 Thread TAlgo
Yes, I am getting cicrular reference error. Any idea how to resolve it? I have uploaded file 'if...then.xls in Upload section.. thanks in advance.. Dilip Pandey wrote: > Hi TAIgo, > > According to me you should be getting circular reference error because you > are Adding B1+A2 being in Cell A2

Re: $$Excel-Macros$$ if then formula - help needed

2010-01-26 Thread Dilip Pandey
Hi TAIgo, According to me you should be getting circular reference error because you are Adding B1+A2 being in Cell A2. Try uploading a sample file so that we can help you better. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan.

$$Excel-Macros$$ if then formula - help needed

2010-01-26 Thread TAlgo
A2 =IF(A1="buy",(B1+A2),A2) if A1 is buy then add value in (B1+A2) or else keep value of A2.. A3 = IF(A1="sell",(B1+A3,A3) if A1 is sell then add value in (B1+A3) or else keep value of A3 cant get it work..above formula... thanks -- ---

$$Excel-Macros$$ If Then Copy Paste

2009-06-12 Thread Sugarmagnolia
I would like to reformat imported csv data into a custom report. The imported data has a unique record in each row. There is one column that has a value for 'fabric' of S, F or L for each record. I would like to create a macro that would take all of the records with a fabric type of S and copy

$$Excel-Macros$$ IF-THEN macro

2009-01-14 Thread Thunderwhelmed
Hi all, I have a worksheet that contains a column of 8 dropdown lists (combo- boxes) from a range in a different sheet. I have the (numerical) results of each selection set up to display in a hidden column. In another cell, I used the COUNTIF function to count the results of all selections >0 (0=