| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moce cells with some programming
Hi
If date = another date then cell1 = OTY and X cells to the left = OTY and y cell to the right = OTY. How do I do this in excel??? Thanx sunrisa |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Moce cells with some programming
Hi,
This is very vague but this may get you moving in the correct direction. If a1 = b1 Then ' your 2 dates Cells(10, 10) = "OTY" Cells(10, 10).Offset(, 5) = "OTY" Cells(10, 10).Offset(, -5) = "OTY" End If Mike "sunrisa" wrote: Hi If date = another date then cell1 = OTY and X cells to the left = OTY and y cell to the right = OTY. How do I do this in excel??? Thanx sunrisa |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Moce cells with some programming
Hi and thank you for this
This is exactly how I want it to be, but one thing how do I set this up in the workbook (how will the code look like) I have never used VBA so I´m hoping that I can do this without it Regards, Sunrisa "Mike H" wrote: Hi, This is very vague but this may get you moving in the correct direction. If a1 = b1 Then ' your 2 dates Cells(10, 10) = "OTY" Cells(10, 10).Offset(, 5) = "OTY" Cells(10, 10).Offset(, -5) = "OTY" End If Mike "sunrisa" wrote: Hi If date = another date then cell1 = OTY and X cells to the left = OTY and y cell to the right = OTY. How do I do this in excel??? Thanx sunrisa |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Moce cells with some programming
Hi,
Put this in the cells you want to populate with OTY =IF(A1=B1,"OTY","") Mike "sunrisa" wrote: Hi and thank you for this This is exactly how I want it to be, but one thing how do I set this up in the workbook (how will the code look like) I have never used VBA so I´m hoping that I can do this without it Regards, Sunrisa "Mike H" wrote: Hi, This is very vague but this may get you moving in the correct direction. If a1 = b1 Then ' your 2 dates Cells(10, 10) = "OTY" Cells(10, 10).Offset(, 5) = "OTY" Cells(10, 10).Offset(, -5) = "OTY" End If Mike "sunrisa" wrote: Hi If date = another date then cell1 = OTY and X cells to the left = OTY and y cell to the right = OTY. How do I do this in excel??? Thanx sunrisa |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Moce cells with some programming
Ok thanx again
But if I do it like that I need to something like this IF(A1=B1,"OTY" & o13="OTY" & p13="OTY" ..... ,"") But this dosen´t works :( Sunrisa "Mike H" wrote: Hi, Put this in the cells you want to populate with OTY =IF(A1=B1,"OTY","") Mike "sunrisa" wrote: Hi and thank you for this This is exactly how I want it to be, but one thing how do I set this up in the workbook (how will the code look like) I have never used VBA so I´m hoping that I can do this without it Regards, Sunrisa "Mike H" wrote: Hi, This is very vague but this may get you moving in the correct direction. If a1 = b1 Then ' your 2 dates Cells(10, 10) = "OTY" Cells(10, 10).Offset(, 5) = "OTY" Cells(10, 10).Offset(, -5) = "OTY" End If Mike "sunrisa" wrote: Hi If date = another date then cell1 = OTY and X cells to the left = OTY and y cell to the right = OTY. How do I do this in excel??? Thanx sunrisa |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro / Programming to lock cells | Excel Discussion (Misc queries) | |||
| Hide/Unhide cells using VBA programming | Excel Programming | |||
| Programming Cells To Change Colors | Excel Programming | |||
| Programming Line Breaks into Cells | Excel Programming | |||
| Moce rows with N in Col A to a new sheet | Excel Programming | |||
Linear Mode
