For something like this, there are just too many missing details for someone
to just "write you a macro" to solve the problem.....I think your best bet
would be to turn the Macro Recorder on and perform the steps one time and
turn the Macro Recorder off and then you will have a macro to work with and
edit as needed, and post back here for assistance if needed.

Vaya con Dios,
Chuck, CABGx3




"iontrap" wrote:

I have setup a macro to open another workbook and extract information. The
macro inserts a new line before extracting the information. I keep this sheet
as a raw data sheet. i.e.
Sample Date Result
A 11/30/06 12
B 11/30/06 3

What I am trying to do is to take the newest row of information and copy it
into another sheet, the info for Sample A is copied into a sheet named Sample
A and the same for Sample B.
How can I do this? Is it possible to do this without needing the raw data
sheet?