clciccarelli
New Member
- Joined
- Jan 20, 2005
- Messages
- 1
Thanks in advance to anyone who has code to do this:
I have this form in Excel format, its the same form it never changes except for the data we capture using it. I have a bunch of these forms in a directory spread out with some other excel files. I need to start in a brand new excel doc, and look through the directory at each excel form I have and copy and paste 5 or 6 cells worth of info on the next empty row on the new worksheet. Then move on to the next found excel file.
The cell contents are known well ahead of time, so I can easily refer to explicit cells for copying if I have a relevant sheet. can anyone help wih a coding snippet....willing to $$$ for the answer.
cLc
I have this form in Excel format, its the same form it never changes except for the data we capture using it. I have a bunch of these forms in a directory spread out with some other excel files. I need to start in a brand new excel doc, and look through the directory at each excel form I have and copy and paste 5 or 6 cells worth of info on the next empty row on the new worksheet. Then move on to the next found excel file.
The cell contents are known well ahead of time, so I can easily refer to explicit cells for copying if I have a relevant sheet. can anyone help wih a coding snippet....willing to $$$ for the answer.
cLc