| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert row on diff sheet IF
On sheet "NF", IF C2=2 and C3=1, then I would like a blank row inserted on
sheet "BK" at row 39. If those two conditions are not met, then Do Nothing. IF the conditions are met and the row is inserted, then I would like C39 on "BK" to have "DCD" entered into it and "RN" placed in cell G39. Thanks in advance! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert row on diff sheet IF
Hope this helps-
Sheets("NF").Activate If Range("C2").Value = 2 And Range("C3").Value = 1 Then Sheets("BK").Activate Range("A39").Insert xlDown Range("C39").Value = "DCD" Range("G39").Value = "RN" End If -- Pranav Vaidya VBA Developer PN, MH-India "Tom" wrote: On sheet "NF", IF C2=2 and C3=1, then I would like a blank row inserted on sheet "BK" at row 39. If those two conditions are not met, then Do Nothing. IF the conditions are met and the row is inserted, then I would like C39 on "BK" to have "DCD" entered into it and "RN" placed in cell G39. Thanks in advance! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert row on diff sheet IF
Thanks Pranav!
"Pranav Vaidya" wrote: Hope this helps- Sheets("NF").Activate If Range("C2").Value = 2 And Range("C3").Value = 1 Then Sheets("BK").Activate Range("A39").Insert xlDown Range("C39").Value = "DCD" Range("G39").Value = "RN" End If -- Pranav Vaidya VBA Developer PN, MH-India "Tom" wrote: On sheet "NF", IF C2=2 and C3=1, then I would like a blank row inserted on sheet "BK" at row 39. If those two conditions are not met, then Do Nothing. IF the conditions are met and the row is inserted, then I would like C39 on "BK" to have "DCD" entered into it and "RN" placed in cell G39. Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make formula look at diff sheet | Excel Discussion (Misc queries) | |||
| plotting column chart whch colors the bars diff for diff comm | Charts and Charting in Excel | |||
| SUMIF formula required to search for 2 diff values in 2 diff colum | Excel Worksheet Functions | |||
| how you make links between diff. cells on diff. work sheets | Excel Worksheet Functions | |||
Hybrid Mode
