| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help appreciated
I have 2 workbooks and want to copy values from Book 1 to Book 2
Book 1 has 2 worksheets called CA and DG Book 2 has 4 worksheets called CA A, CA B, DG A and DG B Starting with sheet CA in book 1 I need to Copy from Cell Paste to Sheet Cell b9 CA A o10 c9 CA A o8 d9 CA A q8 b10 CA B o5 c10 CA B o4 This continues down a longer list always copying from CA to CA A or CA B. Once the CA data has been copied I want to be able to repeat the same proceedure substituting DG for CA and DG A & DG B for CA A & CA B. The cell references are always the same. (i.e. copy cell b9 from DG to cell o10 in DG A etc...) Any help in achieving this using vb would be appreciated by a beginner Regards Gazza |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Any Help Appreciated | Excel Worksheet Functions | |||
| Your Help is Appreciated | Charts and Charting in Excel | |||
| Help is much appreciated for- | Excel Discussion (Misc queries) | |||
| Help would be much appreciated! | Excel Worksheet Functions | |||
| Hello, again Help is appreciated | Excel Worksheet Functions | |||
Threaded Mode
