Search results

Thank you for your help.

Hi Chihiro, thanks for you help but I cannot view the code. The code tag button doesn't seem to take me to the code. Please let me know how to view it. Thanks.

Here is a sample of my data. Of course, I have about 1000 lines. I need to populate the destination worksheet using the source worksheet. Thanks for your help.

Thanks. I already have a vba code that is using my source worksheet to populate my destination worksheet but since the source worksheet doesn't have that "Transaction Number" field, I would much rather incorporate a code in my existing vba to do it for me. Is there a way or do I have to...

I need help to write a code in excel VBA to have my spreadsheet generate a Transaction number down column A. The transaction number should start with 1 and each row below should be 1+ the previous row’s number. Thanks.

Happy holiday to all. I need help to have my excel vba copy a number and then paste it as a negative number in another cell. Can someone please let me know the code to do this? Thanks so much.

Hi everyone, hope all is well. I need some help once again so I'm reaching out to my favorite site that always come true for me. I need to write this formula in VBA but for some reason, I just cannot get it. Can someone help, pretty Please...

I have a simple file that will potentially get a lot less simple. For now, my file has two worksheets, namely: 1. Form 2. Schedule I need to write a macro that will take the info from the Schedule and populate the necessary fields in the Form once in input the CODE field in the Form. I...

Oh I see, thank you so much SirJB7..u did all the hard work and leave with a piece of cake...u r the best..BIG THANKS..:-)

Oh, and yes, I also sorry for the unconventional worksheet..it's what I was given to work with and couldn't really change the setup.

Thanks for answering SirJB7. I downloaded the link for the fixed file and it is the same as the one I sent. Sorry for the bother but can you please take a look and let me know. Thank you soo much for all your help.

Hi Hui..Thanks for responding to my post. I'm not sure I understand..i'm not good at this at all.:(. Please take a look at my file and as you will see, if I insert/delete column and everything shift, I will be picking up the incorrectt column. Can you please let me know how to fix this...

If Val(sh1.Cells(i, 22)) > 0 Then The above statement in my loop works great but if I insert/delete columns, I cannot use the fixed number of 22. The number will change depends on how many columns inserted/deleted. How can I use fix this. Please help! Thanks.

Thanks. Yes, I did solve it..couldn't have done it without you.. I will be back:-).

This worked great with Excel 2010... Is there a way to convert it to work in Excel 2003? Thanks

thank you soo much. I will try this

Here is a copy of my file. Please take a look and let me know if you can help. Thanks. http://www49.zippyshare.com/v/65383803/file.html

Thanks, but this didn't work. Please let me know how i can upload my file. Thanks.

Int period start_date = 5/1/2001 end_date = 7/31/2012 Between the start_date and end_date, there are multiple interest rates. Sheet2 shows all interest rates and their interval. I need help in writing a macro that will calculate interest for the entire period (5/1/2001-7/31/2012)...