Hi , I'm new to VBA excel still learning.
Problem:: In excel if u press CTRL+F , the find and replace window pop up rite.
FOR EXample : you open, Find and replace --> click option---> set within: sheet , set search:rows , set Look in: Formulas--->then, in Find what : u enter some data and you click find all.
Imagine,In the results ,you have many data... E.g 10 cells.
Now i want that 5th cells or particular cells to copied and paste on to other sheet .
How to do that automatically ???
Excel 2010 file attachment below, pls reply
Thank u
Bookmarks