Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy if adjacent Cell has data
I need to copy text into a cell "A2" if there is any data in "B2". B2
contains a formula but will appear blank if its source has nothing. Any ideas? Jeff |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy if adjacent Cell has data
In Cell A2
=B2 If this post helps click Yes --------------- Jacob Skaria "Jeff Gross" wrote: I need to copy text into a cell "A2" if there is any data in "B2". B2 contains a formula but will appear blank if its source has nothing. Any ideas? Jeff |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy if adjacent Cell has data
OR may be
Range("A2").value=Range("b2").value -- If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: In Cell A2 =B2 If this post helps click Yes --------------- Jacob Skaria "Jeff Gross" wrote: I need to copy text into a cell "A2" if there is any data in "B2". B2 contains a formula but will appear blank if its source has nothing. Any ideas? Jeff |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy if adjacent Cell has data
if Range("B2").Value <"" then Range("A2")=Range("B2").Value
"Jeff Gross" wrote in message ... I need to copy text into a cell "A2" if there is any data in "B2". B2 contains a formula but will appear blank if its source has nothing. Any ideas? Jeff |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy if adjacent Cell has data
Sorry but I didn't make myself clear. I am copying from a different
worksheet into A2 if there is any data in B2. Jeff. "Patrick Molloy" wrote: if Range("B2").Value <"" then Range("A2")=Range("B2").Value "Jeff Gross" wrote in message ... I need to copy text into a cell "A2" if there is any data in "B2". B2 contains a formula but will appear blank if its source has nothing. Any ideas? Jeff |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy if adjacent Cell has data
Add extension if the workbook is saved....
Workbooks("book1").Sheets("Sheet1").Range("A2") = Workbooks("book2").Sheets("Sheet1").Range("B2") If this post helps click Yes --------------- Jacob Skaria "Jeff Gross" wrote: Sorry but I didn't make myself clear. I am copying from a different worksheet into A2 if there is any data in B2. Jeff. "Patrick Molloy" wrote: if Range("B2").Value <"" then Range("A2")=Range("B2").Value "Jeff Gross" wrote in message ... I need to copy text into a cell "A2" if there is any data in "B2". B2 contains a formula but will appear blank if its source has nothing. Any ideas? Jeff |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy if adjacent Cell has data
I also need this code to cycle through all cells down to row 300.
"Jeff Gross" wrote: Sorry but I didn't make myself clear. I am copying from a different worksheet into A2 if there is any data in B2. Jeff. "Patrick Molloy" wrote: if Range("B2").Value <"" then Range("A2")=Range("B2").Value "Jeff Gross" wrote in message ... I need to copy text into a cell "A2" if there is any data in "B2". B2 contains a formula but will appear blank if its source has nothing. Any ideas? Jeff |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy if adjacent Cell has data
You also need to FULLY state your question the FIRST time.
-- Don Guillett Microsoft MVP Excel SalesAid Software "Jeff Gross" wrote in message ... I also need this code to cycle through all cells down to row 300. "Jeff Gross" wrote: Sorry but I didn't make myself clear. I am copying from a different worksheet into A2 if there is any data in B2. Jeff. "Patrick Molloy" wrote: if Range("B2").Value <"" then Range("A2")=Range("B2").Value "Jeff Gross" wrote in message ... I need to copy text into a cell "A2" if there is any data in "B2". B2 contains a formula but will appear blank if its source has nothing. Any ideas? Jeff |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy if adjacent Cell has data
the following copies a range from one worksheet to another. it copies empy
cells, but does that make any difference? worksheets("sheet2").Range("B1:B300").Value = worksheets("sheet1").Range("B1:B300").Value "Don Guillett" wrote in message ... You also need to FULLY state your question the FIRST time. -- Don Guillett Microsoft MVP Excel SalesAid Software "Jeff Gross" wrote in message ... I also need this code to cycle through all cells down to row 300. "Jeff Gross" wrote: Sorry but I didn't make myself clear. I am copying from a different worksheet into A2 if there is any data in B2. Jeff. "Patrick Molloy" wrote: if Range("B2").Value <"" then Range("A2")=Range("B2").Value "Jeff Gross" wrote in message ... I need to copy text into a cell "A2" if there is any data in "B2". B2 contains a formula but will appear blank if its source has nothing. Any ideas? Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare two text and if equal copy adjacent data | Excel Worksheet Functions | |||
conditional formatting Copy colour of adjacent cell | Excel Programming | |||
When data match, copy adjacent value to adjacent column | Excel Worksheet Functions | |||
Find Cell and Copy adjacent value to another location | Excel Programming | |||
Copy/paste based on adjacent cell contents | Excel Programming |