Conditional Formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is what I want to accomplish:


IF cell value = Expert copy row to sheet 2

IF cell value = Equipment copy row to sheet 3

Is this possible?

Thanks!
 
Not via conditional formatting. You could use a worksheet_change event but
it would need considerably more information and not inconsiderable code

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Sheet 1:
Cell A1
=ROW(K1)
Copy down to A13
Cells B1 to B13
Either "Expert" or "Equipment"
Cells C1 to C13
Any words that go with "Expert" or "Equipment"
Cell D1
=SUMPRODUCT(--($B1=$B$1:$B1))
Copy down to D13
Sheet 2:
Cells A2 to A21
The numbers 1 to 20
Cell B
=SUMPRODUCT(Sheet1!$A$1:$A$13,--(Sheet1!$B$1:$B$13="expert"),--(Sheet1!$D$1:$D$13=Sheet2!A2))
Cell C1
2
Cell C2
=VLOOKUP($B2,Sheet1!$A$1:$C$13,C$1)
Copy down to C21
Cell D1
3
Cell D2
=VLOOKUP($B2,Sheet1!$A$1:$C$13,D$1)
Copy down to D21
Sheet 3 is similar to Sheet 2 except that "Expert" changes to "Equipment" in
Column C.
 
Hi,
I am not sure whether I am understanding the problem correctly. What I
have understood is that you have a spreadsheet where a certain column
contains either 'Expert' or 'Equipment' in its rows, and you are trying to
put the rows where that column contains 'Equipment' in one sheet and the ones
where that column contains 'Expert' in another sheet.
If I am right, a non-programmatic approach to the problem would be to
sort the spreadsheet by the column containing 'Expert'/'Equipment', and then
to copy and paste the Expert and Equipment sections to sheets 2 and 3
respectively.
If you want to restore the rows to their original order, create a
helper column containing a running index, 1,2,3.......n, before sorting and
distributing the info to sheets 2 and 3. Now you can restore sheet 1 to its
original format by sorting by the helper column (and getting rid of the
helper column).
Regards,
B.R.Ramachandran
 
Back
Top