selct and Copy data from differant rows at the same time

[mrdata]

Is this possible?

Say you had data in row 1 , coloumns A thru G
Thn Row 2 only has data in Columns F and G
That belongs to the data in columns A thru E

You search for a value in column F find it .
Now you want to copy the value you found colum F and G
And the row data columns A thru E

Paste all this to another worksheet on one line

Emp # Name '''''''''' Dept# '''''Shift'''Hire
Date'''''''''Jobcode''''''Jobtitle
121 '''''John Doe'''''' 2525 '''''''''' A''''''07/08/06'''''''' 56254
''''''''''' Job1
''''''''''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''''''''''' 25648 ''''''''''''Job2
''''''''''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''''''''''' 45465 ''''''''''''Job3

So the search string finds the jobcode 45465
The results would be pasted like this to a new sheet

Emp # Name '''''''''' Dept# '''''Shift'''Hire
Date'''''''''Jobcode''''''Jobtitle
121 '''''John Doe'''''' 2525 '''''''''' A''''''07/08/06'''''''' 45465
''''''''''' Job3



Can this be done?

Thanks
Charles

 

[tony h]

The simple answer is "yes".

in trying to give a more complete answer it would be helpfull to have a
better picture of what you are trying to achieve. Including how the data
gets on the first sheet. The answer to this could greatly simplify (or
complicate) the issue

regards

 

[mrdata]

Thanks for responding the attached example will better explain what i a
trying to do.

Thanks
Charle

+-------------------------------------------------------------------
|Filename: Copy of Pre-Bid2.zip
|Download: http://www.excelforum.com/attachment.php?postid=5034
+-------------------------------------------------------------------