Hi All,
I have a 100 + workbooks with seperate name...
i need to open each book and copy entire fields to a template and then calculate some metrics....
i have attached the template (demo) for the reference in which yellow highlighted headers are metrics calculated and other headers are copied from input file (as i said 100 + files)
please help me with a macro to automate it
The file you attached doesn't tell us much. We need to know what the format of the 100 workbooks is and how the data maps to the fields in the file you attached.
You may find the solution in this thread helpful.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Also -- Please take a few minutes to re-read the Forum Rules about thread titles, and then amend yours accordingly.
Entia non sunt multiplicanda sine necessitate
Hi 6 string,
I have attached 2 files , input and output where input in the files i extract and output is the template.
i need macro to copy contents from input to output and perform calculations which is highlighted in yellow tabs of output template.
pls help as i have 100 + input files like this...
Please update your title as requested by shg then we can move ahead. As you know from being an active member, we have a rule requiring descriptive titles.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
excelhelpseeker 
Register To Reply
Bookmarks