View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gcotterl[_2_] gcotterl[_2_] is offline
external usenet poster
 
Posts: 83
Default Cells with the same contents

My spreadsheet has":

"Section 1": AN1.18513
"Section 2": O1.AC4841

If the contents of the cells in Col O match the contents of the cells
in Col A, I need to keep all of the cells in the "Section 1" and all
of the cells in the "Section 2".

The result would be:

One "section" containing the cells from COL A thru N and
One "section" containing the cells from COL O thru AC.

How can I that?