J
John Smith
Hi,
I hope someone can help with this, as I've tried to solve it myself &
failed.
I have a spreadsheet with a (sorted) list in sheet1 (the number of
rows will vary from time to time but would have a maximum of 8,000). I
want to copy the entire row to another sheet in the workbook if the
data in row “b” a certain value.
For example row b could have “Value1”, “Value2”, “Value3” etc. (Max of
20 different values) and I would like to copy the row with the
matching value to sheets names “Value1”, Value2”.
I hope I have explained everything & thanks in advance for all
assistance.
Regards
John
I hope someone can help with this, as I've tried to solve it myself &
failed.
I have a spreadsheet with a (sorted) list in sheet1 (the number of
rows will vary from time to time but would have a maximum of 8,000). I
want to copy the entire row to another sheet in the workbook if the
data in row “b” a certain value.
For example row b could have “Value1”, “Value2”, “Value3” etc. (Max of
20 different values) and I would like to copy the row with the
matching value to sheets names “Value1”, Value2”.
I hope I have explained everything & thanks in advance for all
assistance.
Regards
John