I have Office XP. In one excel file I went to find to find a certain entry
and found about 301 cells. How can I copy all these cells and paste in a new
file?
Sol

Well it depends on if you need the whole row that coincides with those cells.
The easiest way I found was to filter for the data then highlight the rows by
clicking on the row number hold down the shift key and click on the bottom
row, then ctrl C go to new sheet/file and ctrl V

"S1L1Y1" wrote:

I have Office XP. In one excel file I went to find to find a certain entry
and found about 301 cells. How can I copy all these cells and paste in a new
file?
Sol

Thank You for your help.The problem is that each row has the beginning are
all the same but they all end different.
Sol
"SSG QuarterMaster" .(donotspam) wrote in message
...
Well it depends on if you need the whole row that coincides with those
cells.
The easiest way I found was to filter for the data then highlight the rows
by
clicking on the row number hold down the shift key and click on the bottom
row, then ctrl C go to new sheet/file and ctrl V

"S1L1Y1" wrote:

I have Office XP. In one excel file I went to find to find a certain
entry
and found about 301 cells. How can I copy all these cells and paste in a
new
file?
Sol