View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeremy Jeremy is offline
external usenet poster
 
Posts: 184
Default Pulling data from one sheet to another

In excel I have two sheets that I am using and want certain data to be pulled
from Sheet 1 to sheet two when a certain criteria is met. The criteria is in
colum A of sheet 1. Below is an example of what I need.

Thanks

Sheet 1

A B C

1 01/64 48.95 15
2 02/48 46.29 28


Sheet Two
A B C D

1 01/64 42 48.95 15
2
3
4 02/48 15 46.29 28