Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible? Dynamic copy/paste source AND destination?
Hi,
I have a list of data contained in a series of files stored on a network. There is one file for every month, ( file name Jan, feb etc). Each file has 31 sheets (sheet names 1,2,3 etc) to record certain events every day of the month. Some days may be empty and have nothing written. There is then another file which I would like to fill automatically from this series of files per month. This new file, called Summary in which i have 5 sheets (a,b,c,d,e). I would like to find a way of automatically copying data from - Jan/1 cells d12, e12 & m12 to - Summary/a cells f2, g2 & d2 (row 2 to is for 1 Jan) The next day, Jan 2 i need to take the data from the same file (if its the same month) but a different sheet, Jan/2 cells d12, e12 & m12 and copy to summary/a cells f3, g3 & d3 (row 3 is for 2 Jan). Alternatively if its the 31 Jan it copies from Jan/31, the next day it needs to find a different file and sheet, Feb/1. So basically I need a way of searching through a network by date to take data from a certain folder and sheet to copy into a corresponding row by date in another folder. The only static items are the cells to copy from, (source file and sheet change) and the file name and sheet to paste to (cells to paste to increase by one per day. I have looked at Ron de Bruins site but come up blank so far. Is this possible? Thanks LiAD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste names from a source workbook to a destination | Excel Discussion (Misc queries) | |||
Copy every 3rd cell, define destination range for paste | Excel Programming | |||
copy paste values only using destination:= | Excel Programming | |||
how to copy succeeding rows from source workbook to destination w. | Excel Programming | |||
user form to copy and paste from source to destination | Excel Programming |