Excel

  • Thread starter Thread starter Paul Rimmer
  • Start date Start date
P

Paul Rimmer

I'm using Office 2003. I'm trying to search for a name on 1 work sheet & when
this is found, I want to copy this & the following data in the next few
columns onto a seperate work sheet. Is this possible as a formula or will it
have to be VBA??

For Example:

I search for John Smith in column A & when this has been found, the
information in column A to column J needs to be copied on a seperate
worksheet.

Thanks in advance for the assistance

Paul
 
Yes, it's going to have some specific details that need to be moved or copied
seperately for data protection. It looks like I'm going to have to do this
through a macro or manually search through all the details.
 
They are to be copied onto the on sheet. It's an Time in motion spreadsheet
for a few departments where I work, & they want to keep the details seperate
for the department, so What I would like to do is find the staff in that
perticular department & move the details over for the management. I can then
use the same process for other area's.
 
Back
Top