Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy cell query
I have a worksheet that has loads of data. How do I select a certain cell say A1 as a start point and then copy the cells 51 cells across and 9 cells down. I then want to paste this data into a second workbook on say sheet 1 cell A1. I then want to return to the original file and worksheet and copy from cell J1 and copy the cells 51 cells across and 9 cells down and then paste this into sheet 2 cell A1 of the second work book. All told I want to copy the same sized chunks of data from the original file (from different starting points) a total of 70 times into 70 seperate worksheets in the second workbook (the cell reference will always be the same on the seventy worksheets in book 2) - would some form of loop be required? i also want the code to be in a module on the file the data is being pasted into. Any help appreciated Cheers Gazza |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro copy query One | Excel Discussion (Misc queries) | |||
Copy Text from cell to paste on New Web Query | Excel Discussion (Misc queries) | |||
Query, copy & paste | Excel Discussion (Misc queries) | |||
Copy web query across sheets | Excel Programming | |||
Copy Value to a Row with Date that is specified Query | Excel Programming |