Thread: Locate all occurrances of a value then transfer to 2nd table on another sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JimP JimP is offline
external usenet poster
  
Posts: 28
Default Locate all occurrances of a value then transfer to 2nd table on another sheet
To All,

I have 2 identical size tables on two seperate worksheets.
I need to locate <only ALL occurances of the value "S4" in 1st table
and then transfer to the exact same location within the 2nd table on
the 2nd sheet, without overwriting any other data in the 2nd table.

Any directiontal thoughts?

Jim Pellechi
Reply With QuoteReply With Quote