My first sheet is data entry from Column A through to AT eg Name Address $ cost Total Charges Etc etc.
Row 1 is Title of event in merged fields & Row 2 is colum titles, Row 3 through to 500 is for data entry.
Some columns have formula's using Lookup - Sum - Count etc.
I would like to be able to place an X or Yes with a colour fill (Yellow) in certain rows (At random) in Column J to trigger a copy of that row from Column A to H & from T to AQ. then paste it to the next vacant row in sheet 4.
At the same instant colour fill the cell in column A of the same line
What is the best method & procedure to arrange this??
Many thanks


[ This Message was edited by: HarryLiaubon on 2002-03-15 11:28 ]

[ This Message was edited by: HarryLiaubon on 2002-03-16 20:53 ]