View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pablo pablo is offline
external usenet poster
 
Posts: 76
Default Moving data from worksheet to worksheet

I have a worksheet (1) that has a unique value in column A, but that unique
value is repeated based on characteristics in column B, and value for the
characteristic is in column C.

example
123 Cover Ink 4/C
123 Page Count 18
123 Text Color 4/C
....
135 Cover Ink 1/C
135 Page Count 36
135 Binding Saddle
....

In another worksheet (2) I have deduped the records in column A, starting at
row 2 and taken all the characteristics ran them across row 1 (B1:H1).

Now I am not sure how to move the characteristic values from worksheet (1)
to worksheet (2). Any help is greatly appreciated.