Posts by jlsprink

Great! Thanks Ger.

Hello,

I need to have an input box or userform come up that prompts the user for a number that will be used as a multiplier. I then need that inputted number to be multiplied by whatever value is already populated in every cell in column I. The results are to be overwritten in those cells in that column. I'm certain I have made this sound more complicated than need be, but I've attached a worksheet that is representative of the data I will be working with.

In the attached, the Return Interest column (I) is what will need to be adjusted on occasion. There will always be a header and the number of rows will vary from day to day. So to reiterate, I need some sort of pop up box to ask for a multiplier, if the user puts 3, then each amount in column I will be multiplied by three and the result will overwrite what is currently populated.

Thanks a bunch for taking a look.

Paid 10% to Ozgrid Transaction ID 64T99994T5175930P

JL

Super! Thank you very much!!

Hello,

Hoping someone can assist me with the following issue. In the attached, I need VBA code to delete the values in Column K that have a "0" value if the value in column C begins with "1111".
First tab is raw data, second tab is desired results.
Attached is a representative spreadsheet, actual spreadsheet can be many thousands of rows.
Thanks for taking a look.

JL

Perfect! Simply amazing. Thank you very much again!
Much respect.
JL

Hi Friends,

Looking at trying to use VBA to put a bottom border on a range of cells. The range could change daily, but there is a constant, being that the range will always be two rows up from the last row populated. The border will always be from columns A thru O.
I've attached a workbook as a reference.

Thanks for taking a look!

JL

Sweet!!! Very nice. Thank you so much. I really appreciate it!
Regards, JL

Hi All,

Looking for a macro to add a number "1" to a string in column A if there are currently only 8 digits in the cell. If there are nine digits in the cell, I need to replace the last one with a "1". I've attached an example workbook with desired results.
Any help is much appreciated.

Thanks for taking a look.

JL

Re: USD 75.00 VBA Automate Pair Off Buy/Sell Inventory solution

Simply amazing! Thanks so much. I really appreciate.
JL

Re: USD 75.00 VBA Automate Pair Off Buy/Sell Inventory solution

Great! Thanks so much. Just sent payment.

Re: USD 75.00 VBA Automate Pair Off Buy/Sell Inventory solution

Awesome! I appreciate it.

Hello,

Need some help from the experts here.

Hopefully this can be done and I can explain what I am trying to do adequately enough so someone can assist if possible.

I get a spreadsheet sent to me that has bond inventory displayed, Buys and Sells. The spreadsheet is segregated in different sections based upon Product Code and Coupon Rate.

The spreadsheet attached shows the raw data that I receive in the “Raw Data” tab.

The Buys are always at the top of each section, there could be more than one row of Buys, or it’s also possible that there are no Buys.

The Sells follow next in each section and the same scenarios could apply.

Now here is what I am trying to automate. I need to pair off the Sells with the Buys.

Here are the steps that I perform manually currently.

I’m pairing off the Buys and the Sells one section at a time. I’m doing this by going to column F (Open Par) and summing the column until the total becomes negative. I do this by just hovering over the top cell in column F in each section, going down one cell at a time and looking at the “SUM:” total in the bottom right corner of the status bar. When I see that it is a negative, I know that is the point where there is enough sells to cover the buys. I then manually adjust the trade amount in column E of that row to offset the remaining Buy total completely.

I then delete the remainder of Sell rows in that section if there are any remaining.

If there are no Buys in the section, then I delete the entire section.

Next thing I need is for a calculation to subtract Sell proceeds from Buy proceeds and put that total adjacent to the last row in each section in column I. Currently I do it with a Sumif statement. It will be clearer in the attachment in the “Final Results” tab.

And lastly, I need to insert a total amount at the end of Column I called “Accrual Total”.

Hopefully the attached will help demonstrate what I am trying to accomplish. My starting point is the “Raw Data” tab, and the end result is the “Final Results” tab.

Not sure if this is possible or if the USD 75.00 is fair. Just let me know. I’m very flexible and open to negotiation. Let me know of any questions you may have.

No real urgency or time crunch.

Thanks for taking a look! JL.

I have paid 10% to Ozgrid. Trans ID 9PW384795A7429257

Re: USD 10.00 VBA Vlookup Next available cell formula fill down

Thanks for your efforts!! Works great!

JL

Re: USD 10.00 VBA Vlookup Next available cell formula fill down

Thanks SMC! Payment just sent.

Re: USD 10.00 VBA Vlookup Next available cell formula fill down

Great. Thanks!!

Hi All,

Looking for a little help automating a spreadsheet. Need some vba that will look for next available cell in Column E and do a vlookup or similar to populate data from second tab in workbook, to last record in column F. Hopefully attachment will make clearer.

Thanks for your time. Let me know if any questions.

I have paid 10% to Ozgrid. Trans ID: 5FN16618PN865853V

JL

Re: USD 30.00 Search Folder for Partial File Name via Prompt and Attach to Email

Simply Amazing! Thanks a bunch S O!!!

Re: USD 30.00 Search Folder for Partial File Name via Prompt and Attach to Email

Thanks so much S O! I'll give it a go tomorrow. Payment sent.

Re: USD 30.00 Search Folder for Partial File Name via Prompt and Attach to Email

Great Thanks! Hmmm, I never thought about doing all in Outlook. That should be just fine. No hurries at all.

Hello,
Looking for VBA code that will search a folder that has dated files and the date is present somewhere in the filename string and then attach those files to an outlook email. The file path is C:\MKFP PDF\ and the files consist of a naming convention like the below for example:
PAYSTMT_20170201_MKFP_XXXX_354.pdf
PAYSTMT_20170201_MKFP_YYYY_408.pdf
PAYSTMT_20170202_MKFP_ZZZZZ_984.pdf
PAYSTMT_20170208_MKFP_RRRRR_604.pdf

I’m envisioning a macro that prompts the user for a date to search for and once the date is entered, the related files are attached to an email ready to be sent in Outlook.
So for example, if a message box were to open up and prompt for a date, and the user would put 20170201, then the first two files in the example above would be attached to an email ready to be sent.

I've sent $3.00 via paypal to ozgrid.

Transaction ID8US17596NW295891F

I’m using Excel 2010 and Outlook 2010.

Not sure if this can be accomplished or not, but thanks for taking the time to look at my request.