Excel 2007 + VBA + Need help!


New Member
Jul 22, 2010
Dear VBA-county,

I know from a little bit with the VBA programming, but not otherwise come to my current problem. Therefore, I would try if I might help in this way someone can. (I use MS Excel 2007)

I have the following case:

E: \ versuch3 \ Write.xlsm

E: \ versuch3 \ Data1 \ Read_AAA.xlsx
E: \ versuch3 \ Data2 \ Read_BBB.xlsx
E: \ versuch3 \ data3 \ Read_CCC.xlsx

The file 'Write.xlsx' serves as the master. Proceeding from this, I would like to choose different files 'Read_XY.xlsx' for values that are subject to two conditions - namely 'Symbol' and 'Date'.

Here's an example:
Cell D2: Assignment (AAA)
Cell E2: Symbol (e.g. ABC.DE)
Cell F1: Date (e.g., 07/22/2010)

Column A: Abbreviation (e.g. ABC.DE)
Column B: Date (e.g., 07/22/2010)
Column C: value (34.3)

The following function I have yet to determine the appropriate value from a 'Read_XY.xlsx' file and the file 'Write.xlsx' transfer:

Wert_F2 = IF (SUM ((A: A & B: B = E2 & F1) * 1), INDEX (C: C, MATCH (E2 &F1; A: A & B: B; ));"")

The resulting figure to me so I could transfer the file 'Write.xlsx'.

Now it is so that the evaluation of such files have reached levels that this form of data collection with very onerous.
Therefore I am looking for a way to simplify the process.

It would be really great if someone a code (or at least be a part of it) that I could use for the following:

1st Step: search for the file containing the mapping in the file name (in this case: AAA)
2nd Step: Open the file ('Read_AAA.xlsx')
3rd Step: reading the desired value in dependence of the two conditions (for 'Read_AAA.xlsx')
4th Step: reading the desired value (in 'Write.xlsx')

I hope that I have clearly described and someone is found who would help me with this problem and can.

Thank you in advance!

Your Christine:)

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Latest member
KPH Akron

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...