More help needed on updating summary spreadsheet with data from files
Posted by Alexia on January 04, 2002 1:52 PM
I am writing a macro that will look for new files and extract certain information and place it in a summary workbook. Dank was extremely helpful with providing me with the code to do this.
I find myself stumped, however on how to write for Excel to pull in the values from the new files into the Summary.
For example, I want the values in H9, H15, A22, and H42 on each new file to go into columns A,B,C,& D, respectively. The row would be the next available one(each row constitutes a file).
I was provided with some direction by Scott and Tim but am quite frankly stumped.
Any help would be greatly appreciated.
P.S. I run the macro from within the summary.