copy and update problem in mastersheet to other worksheets.

[larvitar]

can anyone help me how to code this pseudocode.

'from mastersheet, adding query to 
'corresponding sheets using checkboxes
'click "done checking" button after every query
--------------------------------------------------------
loop until next row = ""
	if cpu_textbox.value = true then
		copy row to CPU sheet
		CPU_row = CPU_row +1  ' nxt line in CPU sheet
	elseif monitor_textbox.value = true then
		copy row to monitor sheet
		monitor_row = monitor_row + 1  
	...
	end if
	mainsheet_row = mainsheet_row + 1
end loop
--------------------------------------------------------
'update transaction from mastersheet, any 
'changes in cells must appear in other sheets
'click the row then click the update button
--------------------------------------------------------
entirerow.select
open each sheet 
loop for every row in other sheet
	if masterSheet.cell(A,x) = otherSheet.cell(A,row#) Then
		clear the row
		insert updated  row
	end if
end loop

--------------------------------------------------------


i also attach the workbook. please help me..
tnx in advance

-cherry

[arlu1201]

Larvitar,

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-gene...stersheet.html

Thread Closed.