| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if cell has null value, move data from one cell to another
I have Owner1, Owner2, Owner3, OwnerAddress
I want to query Owner3 and IF null (blank), move value of Owner2 to OwnerAddress. Is this enough info to give me a push in the right direction? I understand functions can't move data? So I need to use some code like: Sub MyMacro1() ' ' MyMacro1 Macro ' ' Range("I3").Select Selection.Cut Range("K3").Select ActiveSheet.Paste End Sub Can someone help with a routine to look for null and if so execute some code to move (cut and paste) values from one cell to another? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show a row of data in a different sheet if cell isn't null | Excel Discussion (Misc queries) | |||
| Cut some of the data in a cell and move to the neext cell | Excel Discussion (Misc queries) | |||
| Move cell data to another worksheet cell automatically. | New Users to Excel | |||
| cell value based on null/not null in another cell | Excel Worksheet Functions | |||
| cell shows 0 when referenced cell is null | Excel Worksheet Functions | |||
Threaded Mode
