Sykovampyr
Board Regular
- Joined
- Nov 3, 2006
- Messages
- 71
Hi Guys and Gals! A good two part question! If any one could help i would be in debted! I am looking to create a button to copy the values from one set of cells from all sheets in a work book to another set of cells in the same workbook. For example copy the values from E4-E39 from sheets 1-15 and place just the Vaules in cells B4-B39 in the respective sheets. Once it has paste the values i would then like it to clear the cells E4-E39 of Values.
Thean in addition to this i would like to create another button that copies from G4-G39 to B4-b3- and clears C4-C39...............
any ideas or can someone point me in the right Direction??
Thean in addition to this i would like to create another button that copies from G4-G39 to B4-b3- and clears C4-C39...............
any ideas or can someone point me in the right Direction??