rayoconnell
05-11-2007, 07:04 AM
hey all,
i am trying to create a form to auto complete a spreadsheet.
the problem i am having is this.
if "Y"appears in column "H" then apply "vessel" to column "C"
if "Y"appears in column "I" then apply "FERM" to column "C"
if "Y"appears in column "J" then apply "WASTE_SYS" to column "C"
i have this part done, however the problem i have is "Y" sometimes appears in column "H" and "I" and/or "J" or a mixture of these.
in this situation i want to copy and paste that line to bottom of the spreadsheet. if it happens to occur in all 3 columns then i need to copy and paste it twice.
im not even sure this is possable, im new to this vba.
i have been trying to do it in excel but not having any luck,
any help would be greatly appreciated!!!:dunno
Cross-posted:
http://mrexcel.com/board2/viewtopic.php?t=272472 (http://mrexcel.com/board2/viewtopic.php?t=272472)
http://mrexcel.com/board2/viewtopic.php?t=272226 (http://mrexcel.com/board2/viewtopic.php?t=272226)
Edited 16-May-07 by geekgirlau. Reason: insert links to cross-post(s)
i am trying to create a form to auto complete a spreadsheet.
the problem i am having is this.
if "Y"appears in column "H" then apply "vessel" to column "C"
if "Y"appears in column "I" then apply "FERM" to column "C"
if "Y"appears in column "J" then apply "WASTE_SYS" to column "C"
i have this part done, however the problem i have is "Y" sometimes appears in column "H" and "I" and/or "J" or a mixture of these.
in this situation i want to copy and paste that line to bottom of the spreadsheet. if it happens to occur in all 3 columns then i need to copy and paste it twice.
im not even sure this is possable, im new to this vba.
i have been trying to do it in excel but not having any luck,
any help would be greatly appreciated!!!:dunno
Cross-posted:
http://mrexcel.com/board2/viewtopic.php?t=272472 (http://mrexcel.com/board2/viewtopic.php?t=272472)
http://mrexcel.com/board2/viewtopic.php?t=272226 (http://mrexcel.com/board2/viewtopic.php?t=272226)
Edited 16-May-07 by geekgirlau. Reason: insert links to cross-post(s)