transfering data from one work sheet to another 
Author Message
 transfering data from one work sheet to another

hello
I have one work sheet that looks like this
sheet 1
     a                b      c        d      e
1  02/01/03     5      6        4      55
2  03/01/03      2      8        5      25
3  04/02/03      18    4         9      44
4  05/02/03     21      2        5       8
and so on

the second sheet  looks like this
sheet 2
     a                b      c        d      e
1  02/01/03
2  03/01/03
3  04/02/03
4 week total
5  05/02/03
6  06/02/03
what i wanto to do is press a button and the data from sheet one goes to
corresponding cells on sheet 2
 i have tried a formula but it slows down excel
is there any way i can do it by a macro

aneurin



Sun, 10 Jul 2005 04:55:49 GMT  
 transfering data from one work sheet to another
If you just want to get the week totals then:
 - add an extra column with the week number function WEEKNUM
 - use a pivot table to get the totals for each weekl.

Tim


Quote:
> hello
> I have one work sheet that looks like this
> sheet 1
>      a                b      c        d      e
> 1  02/01/03     5      6        4      55
> 2  03/01/03      2      8        5      25
> 3  04/02/03      18    4         9      44
> 4  05/02/03     21      2        5       8
> and so on

> the second sheet  looks like this
> sheet 2
>      a                b      c        d      e
> 1  02/01/03
> 2  03/01/03
> 3  04/02/03
> 4 week total
> 5  05/02/03
> 6  06/02/03
> what i wanto to do is press a button and the data from sheet one goes to
> corresponding cells on sheet 2
>  i have tried a formula but it slows down excel
> is there any way i can do it by a macro

> aneurin



Sun, 10 Jul 2005 06:59:48 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. transfering data from one sheet to another

2. Transfering Data from DATA Sheet

3. Transfering from one sheet

4. Request for help transfering data between sheets

5. How to use data fron one sheet to print forms created in another sheet

6. automaticly copying data from one sheet into another sheet using VBA

7. Inserting data on one sheet from another sheet

8. HELP! Summarize sheet data on one sheet

9. formulas on one sheet affecting data on other sheets

10. using data from one sheet to populate multiple sheets


 
Powered by phpBB® Forum Software © phpBB Group