Im trying to read in a form from oracle which is imported into excel. From
this imported form I would like to create a macro that selects values from
this form and pastes them into another worksheet. There are many forms but
will be thrown out from oracle one by one so will be called the same name.
Each form contains customer deatils such as name,age,sex. So i require a
macro that picks the name,age and sex from the form and populates another
workbook with the same information. The problem i am having is that the macro
reads in the first form but when it tackles the 2nd one it overwites what it
read from the 1st.

e.g
oracle form:
name sam
age 22
sex M

transfer info from form to worksheet as
name age sex
sam 22 M

the 2nd form
name julie
age 21
sex F

worksheet shoul;d appear as

name age sex
sam 22 M
julie 21 F

can anyone help?

Your problem appears to be in defining the destination. There are many ways
to define the destination depending on the layout of your data, but you
don't provide anything about the layout of your destination data. For
instance, the line:
Range("A" & Rows.Count).End(xlUp).Offset(1)
designates the blank cell in Column A immediately below the last occupied
cell in Column A.
It is always good to post your code. HTH Otto
"sammy" wrote in message
...
Im trying to read in a form from oracle which is imported into excel. From
this imported form I would like to create a macro that selects values from
this form and pastes them into another worksheet. There are many forms
but
will be thrown out from oracle one by one so will be called the same name.
Each form contains customer deatils such as name,age,sex. So i require a
macro that picks the name,age and sex from the form and populates another
workbook with the same information. The problem i am having is that the
macro
reads in the first form but when it tackles the 2nd one it overwites what
it
read from the 1st.

e.g
oracle form:
name sam
age 22
sex M

transfer info from form to worksheet as
name age sex
sam 22 M

the 2nd form
name julie
age 21
sex F

worksheet shoul;d appear as

name age sex
sam 22 M
julie 21 F

can anyone help?