Find All Results

Good afternoon clarabelle

Once completing a 'Find All' is it at all possible to move this information to a new worksheet?

No, it isn't. This sort of thing can be achieved using a macro, but if you want to go down that route, you're going to have to procide a lot more information.

DominicB

Hi clarabelle

Just spell out exactly what you’re trying to do.

Once you’ve found a cell you want to copy the cell / the whole row (?) to a new / old (?) sheet / workbook (?).
Where abouts in the (new) sheet / workbook (?)
Any gaps to be filled in? Are you copying formulae / text /numbers (?)
If formulae, do you want them copied across as numbers or formulae?

Just any extra information that someone who helps you might need to know about really. Saves time all round …

DominicB

Hi clarabelle

Something like this will work for you :

Please Login or Register  to view this content.

Before you run it select the whole of column E and this will copy any line where column E contains the word "citrix" into Sheet2. It will start at row 1 and move down after each "paste".

HTH

DominicB