So first I will choose the source file. Say I want to enter a name from the given sample. Then, I want to take all the amount and purpose under that name and paste it to the corresponding cells in the worksheet where i'm running vba. I dont know how to modify the code. Any help or leads on how I will start? Thanks in advance.
hi zoenightshade,
i don't understand what you're trying to accomplish? this code looks like it's working fine (in fact i learned a few things while reading it). in what way are you trying to modify it?
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
hi! thank you for responding. If you havent noticed, for example, in column C, i have multiple Rose Dix. However, the values of amount and purpose of each Rose Dix varies in every row. I want to get the other two values of amount and purpose and paste it in the corresponding cells instead of just the first one.
ah! i missed that. looks like you'll need the findall function from our good friend Chip Pearson (who's website seems to be down, or perhaps my company firewall is blocking it otherwise i'd post the link... google chip pearson findall for his site and description of the code)
paste this into module 1:
then you have to make just a few tweaks to your original code, this seems to be working:
Please Login or Register to view this content.
couple things i'm noticing - there doesn't appear to be any place to store the invoice #, date or person approved for the subsequent instances of Rose Dix... this code is currently capturing the last instance... is that ok?Please Login or Register to view this content.
no, sir! it's definitely fine! all i need is the subsequent amount and purpose. im gonna try it later. thank you so much sir!
Last edited by zoenightshade; 05-09-2015 at 01:54 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks