Hello all : I'm trying to copy from one worksheet to another, information within one row to another worksheet only if it meets certain cryteria.
I have a block of cells (several rows & columns) that I want to copy some of the data to another worksheet only if one cells value is "1".
Exampe:
Rows 1,2,3 all have information in cells in columns A, thru E
IF information in row # 1, in column B = "1"
THEN I need to have information in row 1, column B,C,E copy over to another sheet.
IF cell B1 = #0, then I don't need to any information for that row copied.
I need to repeat this operation several times, with each acuance being based on the information in a "row by row" basis.
The purpose is to let a client select or unselect(thru the use of the #'s "0", &"1") the items they want to purchase from a list of choices, and then copy over to the new worksheet only the information needed to compile an order tally for the items selected, without copying any information from the items that were not selected.
Please help, or let me know what I can do to make it a little clearer. Hopefuly this makes sense.
H.L.
Bookmarks