Hi,
I am new at this and I am trying to figure out how to merge data from many excel 2007 workbooks (Win 7), in one folder, into one worksheet. Each workbook has 3 worksheets, all worksheets are protected by password (all have same password) all I need is the data from the first worksheet. The worksheet names may be 2-A, 2-B, 2-C, ETC. I need row data where cell C# (#=row number) has a value of “true”. For each row merged I need data in cell D2, D3, F2 AND F3 listed first in the row. I need the results of the formulas merged not the formulas. Each file may have a different length.
Would it be better to separate the worksheets by type and then merge them by type?
Thank you in advance for all of your help.
I am new at this and I am trying to figure out how to merge data from many excel 2007 workbooks (Win 7), in one folder, into one worksheet. Each workbook has 3 worksheets, all worksheets are protected by password (all have same password) all I need is the data from the first worksheet. The worksheet names may be 2-A, 2-B, 2-C, ETC. I need row data where cell C# (#=row number) has a value of “true”. For each row merged I need data in cell D2, D3, F2 AND F3 listed first in the row. I need the results of the formulas merged not the formulas. Each file may have a different length.
Would it be better to separate the worksheets by type and then merge them by type?
Thank you in advance for all of your help.
