modify .csv file to get into format for import to another program.

davesexcel,

thank you. you're right - it's a very good start. I think this is close. I stepped through it using f8 to see what it does and I noticed a couple things.

(a) it looks like when it loops through, it assumes the first transaction is the one that will get deleted and it copies the description in column b to the description of the paired transaction. this is not always the case. if you look at rows 36 and 38 of the "excelforum7" file you can see that for INTC, the transactions are in the opposite order. the impact of this is that the code doesn't modify the column b action but leaves it as whatever it was. any thoughts on how to get around this?

(b) also, it looks like the code is running through indiscriminately. in other words, at some point it deletes the not needed paired transactions (haven't figured out how you did that yet since the code I think is doing this starts with a Columns("F:F") - but that was pretty neat ...). anyway, it's deleting things it doesn't need to delete. as an example, in rows 35 and 37. this particular transaction pair neither needs to be modified or have a not needed transaction deleted. this is my fault for not properly framing the problem. sorry about that.

(c) one more thing I noticed, when I tried to run this on the "raw" .csv file, it didn't seem to work. to test this, I ran the original code I shared in my post with a hard stop at the line that AlphFrog did for me (since you're basically replacing that). then I tried to run your code. if you want to not address this one until we get the above flanged up that's fine. perhaps I'm just missing something so I'll continue to take a look at it.

thank you for all the help. I'm amazed that the assistance this forum provides. I've used it a few times in the past with similar success.

thoughts?

david

Is this how you wanted

Please Login or Register  to view this content.

davesexcel,

have you had a chance to give this any consideration.

jindon - yours doesn't seem to work.

thank you,

david

davesexcel,

so jindon's code didn't work because of a mistake I made. the code that I've asked for is in addition to some that I already had (posted in my original email). as such, to get either yours or jindon's code to run, I need to run the 1st part of my code with a break at the point that the new code comes into play. I had not done this.

I've now run Jindon's code. it seems to be handling the capital gain reinvestments (both short and long term); but not the dividends. it's also more complicated than I have the capability to edit myself. your code had called out each type of transaction, so I was hopeful that when more transactions popped up, I could simply modify the code myself to add any new ones.

thoughts

david

anyone want to take a stab at this? davesexcel made a good start and shared that it would likely need some tweaking; but he's not wanting to get further involved. jindon also made a good start; but has perhaps not seen any of the follow-up posts. since there's been some depth to this thread, should I repost it with the entirety of the issue as well as what the proposed code still doesn't do; rather than expect folks to wander through what's there already?

I don't want to get crossways on the forum rules; and I have not cross post this to any other forums. I do hope to get this solved. I welcome any feedback.

david

If you are talking about the file other than your posted one, just forget it.

jindon,

I'm not referring to anything that I haven't posted. my original post has two files, the one you refer to and a 2nd one. they are both clearly linked in the first post.

suggesting that I "forget it" on a help forum seems a bit inappropriate. if I've asked for something that's too complicated for folks to figure out, then I'm open to someone simply politely telling me that it's too difficult to solve. if I've been unclear, then I'm open to someone simply telling me I've been unclear. I very much understand that it's sometimes difficult to convey what the problem is and what is being asked to solve. I've not violated any forum rules that I'm aware of. I'm simply posting on a help forum for help.

davesexcel - I certainly respect your comment that you're not interested in spending more time on this; and I appreciate your directness despite your comment that the code might need tweaking.

jindon - I'm not sure where you're coming from. your comment seems rude to me. that said, I do very much appreciate the code you provided. I readily admitted that I made a mistake in trying to run it the first time.

for transparency, I'm going to look at other forums and will consider cross posting. If I do cross post; I will certainly honor forum rules and provide a link.

I appreciate and thank you for the help that's been provided.