| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Code to Copy Data from One Spreadsheet To Another
Hi,
I was wondering if it is possible to copy the values of the same specific cells within multiple spreadsheets and place/copy that into a single seperate spreadsheet? Basically I'm going to have hundreds of spreadsheets that contain all sorts of data but I only need to capture the values within three specific cells - Workbook(Collection00001) thru (Collection99999) - Sheet1 - Cells(H9, H11 & H13) and then I want to place those values into a single spreadsheet - Workbook(Captures) - Sheet1 - Cells(B3, C3 & D3) then (B4, C4 & D4) then (B5, C5 &D5) etc. Is there a way of doing this or am I going to be stuck with constant "Copy and Paste" over and over again? Thank You So Very Much For You Consideration, Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy data to another spreadsheet | New Users to Excel | |||
| copy data from one spreadsheet to another one using value in cell | Excel Worksheet Functions | |||
| How do you copy and past data from one spreadsheet to another? | Excel Discussion (Misc queries) | |||
| How do I copy spreadsheet data as shown to another spreadsheet? | Excel Discussion (Misc queries) | |||
| Copy code to a new spreadsheet | Excel Discussion (Misc queries) | |||
Threaded Mode
