Copying different worksheets data & updating

Closed
Brazilian Fernando - Nov 19, 2009 at 08:21 AM
 Blocked Profile - Nov 22, 2009 at 04:20 AM
Hello,

I am looking for a Macro that can help me with the following:

I create several worksheets in the same document everyday. Every worksheet has the same structure, with entries of stock prices that I manually write down. Each worksheet has a cell (A2) with date, a cell with time (A5) and a cell with the brazilian market variation (A8). For example, my newest worksheet has this cells as 19/11/2009; 11:40; -0,49%.

I would like to copy this 3 cells, from all my worksheets, into the first worksheet of my worksheet. Then I would know this 3 information of all the worksheets I have. I also would like the macro to update data looking for new worksheets, as I am always creating them (I can place a button in this first worksheet to play the macro, but I don't know how to copy data from different worksheets and how to write a macro to look and copy data from worksheets to be created).

Can anyone help me?

Regards,

Fernando
Related:

1 response

Blocked Profile
Nov 22, 2009 at 04:20 AM
Dear Sir,

Please find the solution within the below FAQ article:

https://ccm.net/faq/4696-excel-a-macro-to-copy-paste-a-selected-range

Thanks.
0