View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stefan Stefan is offline
external usenet poster
 
Posts: 27
Default Calculate data from different sheets

Hi,

I´m looking for a formula that will transfer certain data to different sheets.

For example:
Data in sheet 1
If cell a1=usk data in cell a2,a3...
Transfer data to sheet 2
If cell a1=ssk data in cell a2, a3...
Transfer data to sheet 3

The easiest way would be to make another column but this will make the sheet
to big to handle.

Regards
Stefan