Trial and Error
New Member
- Joined
- Jan 26, 2012
- Messages
- 3
Hello,
I am working on this spreadsheet for a while and can't get it working...any help is appreciated
On the first worksheet "transactions" a row contains a financial transaction. With another macro new transactions are imported when available in another file. For a new transaction on a row only the columns A till M are filled with data after being imported in the "transactions" worksheet.
"Old" transactions have been checked, which is showed by a "v" in column N (column label "check"). For newly imported transactions column N is empty.
...
With the Macro I try to write I want to check for all rows that don't contain a "v" in column N if column G (label "eigenaar") contains a word that matches with one of the unique words in colum D of the table in worksheet "historie".
...
-- removed inline image ---
A row of the "transactions" worksheet stays empty when it has a check "v" in column N, although there is a match with one of the unique words in the table on the "historie" worksheet.
I did many attempts to write a macro using For...next, If...then and If Instr() ...then procedures, but didn't get it working.
Does anyone has a solution tot the problem above?
Any help is welcome and appreciated highly!
PS. I tried to insert some pictures on the where there are ... now. Still trying, but need to post them somewhere first.
I am working on this spreadsheet for a while and can't get it working...any help is appreciated
On the first worksheet "transactions" a row contains a financial transaction. With another macro new transactions are imported when available in another file. For a new transaction on a row only the columns A till M are filled with data after being imported in the "transactions" worksheet.
"Old" transactions have been checked, which is showed by a "v" in column N (column label "check"). For newly imported transactions column N is empty.
...
With the Macro I try to write I want to check for all rows that don't contain a "v" in column N if column G (label "eigenaar") contains a word that matches with one of the unique words in colum D of the table in worksheet "historie".
...
-- removed inline image ---
A row of the "transactions" worksheet stays empty when it has a check "v" in column N, although there is a match with one of the unique words in the table on the "historie" worksheet.
I did many attempts to write a macro using For...next, If...then and If Instr() ...then procedures, but didn't get it working.
Does anyone has a solution tot the problem above?
Any help is welcome and appreciated highly!
PS. I tried to insert some pictures on the where there are ... now. Still trying, but need to post them somewhere first.
