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?
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?