How to extract excel data to another worksheet

Associate
Joined
18 Oct 2002
Posts
1,639
Location
The Moon
Afternoon, how easy is it to extract data from certain cells, then automatically place the data in a new worksheet?

I have an excel document that works out figures for me by me entering in the data in the necessary cells, then pushing a button to do the working out, I then want to be able to push another button to extract data from certain cells and put them in another worksheet under certain columns. I want to be able to keep doing this so that its adds the next data in the next line underneath.

Easy enough?
 
Back
Top Bottom