Macro: Changing the value of a Cell

[Costafrank]

Hello,


How can I change the value of one cell if another cell has a string.

ex:

Row 1 Colum 7(G1) Has the value of "TEST" (or anyother string) now I would like to change row 1 colum 2 (b1) to "TEST" if it is empty, I would like to do an autofill from the cell above.

thanks
Frank

 

[Greg Truby]

...if it is empty... do an autofill from the cell above...

<ul>[*]If what is empty? B1 or G1?[*]What cell is "above"? You're in row 1.[/list]

 

[Costafrank]

Greg,

If G1 is empty. I would like it to fill from above because I will always have one row at the top, with a valid formula.

I choose ROW 1 and COLUM 1 just as an example.

you can make it ROW 2 COLUM 2 (B2) & ROW 2 COLUM 7 (G2).

also, it needs to check on a range of cells so G2-G500 and update the appropiate cell in range (b2-b500)


thanks
Frank

 

[Greg Truby]

If I've understood you accurately, the easiest way to do this would be to just use an IF() function to test for blanks. One certainly could quite literally make so that column G was checked for a value and copy a formula down in col B, but that would involve the use of VB and why make life more complicated than need be? Note, to keep the HTML shorter, I used col C as the column to test here, just change that to G and copy down as far as you need to.

HTH

Book1
	A	B	C	D
1	DummyData	IfcolCisempty,multiplyA*5	ColtoCheck	Comments
2	1	5	Hello
3	2	10	3.141592654
4	3	15	9-Feb-04
5	4			<--Blank
6	5	25	0	<--Zero(notblank)
Sheet1