selct and Copy data from differant rows at the same time

  • Thread starter Thread starter mrdata
  • Start date Start date
M

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
 
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
 
Back
Top