Posts by jlsprink


Hello,
I'm looking for a macro to highlight cells based off of the highlighted cells of another sheet.
In this specific case the numbers in columns in B and H in the first tab may be highlighted in maroon or red.
If they are, I need a macro to change the corresponding numbers in tab 2 to the same highlighted shade.
There may be more than one of the same number throughout the spreadsheet, but only one number and corresponding description exist in the spreadsheet.
The descriptions are adjacent to the numbers in columns C and I.
Hope this makes sense. I've attached an example workbook. Tab 1 is the original template, Tab two will be the spreadsheet where the highlights need to be changed. Tab three is what I would like the final output to look like after the macro is run.
10% Prepayment sent




Hello,
I'm looking to create some subtotals via VBA at the end of a current routine. Basically I need a couple of Sum if formulas at the end of two columns, then a summation of those two numbers, and then corresponding labels in the first column. The number of rows may change each day but i need the subtotals a two cells below the last record in column N and column O. I'm sure I've made this sound more complicated than necessary, but the attached shows what I am looking for. The final tab has the desired results highlighted in yellow in row 76 through 79 in this instance. I'd like the summation line to be there as well. The results in reality should not be highlighted. Thanks for your time!
I have sent 10% to Ozgrid.
Transaction ID8H519900T0320023G




Hi All,
Here's my issue today. I've got a spreadsheet template that I receive where I need to extract data from 6 different columns and have the results in one cell in a new column. I've tried using concatenation with spacing, but couldn't some up with a universal formula that fits my needs.
The data in each column has to start in a particular position in the new cell. Hopefully the attached spreadsheet explains what I need more clearly. Not sure if this can be done with a formula, VBA, or maybe not at all, but I'm spinning my wheels and thought I'd ask for the experts help.
Offering up $20 but if a more complex solution/programming is needed, that is negotiable.Sent 10% to Oz. Transaction ID 9DV743169J592954U
Thanks for taking a look!

Perfect! Thanks so much!!


Hi All,
Looking to delete rows in a spreadsheet based off of values that are present in three different columns.
In layman's terms, here is what I'm trying to accomplish.If Column B does not have a value of "BONY01" and values in Column O = 0 and Column P = 0, then delete that row.
In other words, I only want to view records of BONY01 that have a value other than 0 in either Column O or P or both. Everything else should be deleted.
Spreadsheet may have several thousand rows.
I've attached a spreadsheet with an original tab and a desired results tab for clarification as well.
Sent 10% to Oz..... Transaction ID 4N645467MA471815X Thanks in advance for the assist.




Hi All,
Need help with getting data from a source spreadsheet into another sheet based on four different scenarios. Each scenario results in two rows of output. The final output will be placed in the tab called Acct_Genex and will be sent to my Accounting team.
The scenarios can be broken up into “Fee” or non fee transactions, and whether or not the “Amount” value in the Source tab is positive or negative.
I have the Criteria/Logic laid out in the attached workbook in the Criteria tab. Hopefully that will explain better what I am looking to accomplish.
I have example data in the “Source” tab as well as the anticipated results will look like in the “Example Output” tab.
I envision a click of the button approach where on a daily basis, I copy the Source data into the “Source”tab, and once the macro is run, it will populate the “Acct_Genex” tab with the required results.
Again there should be two rows of data in the “AcctGenex” tab to every row of data in the “Source” sheet.
Not sure how much work this is, so I am flexible to the rate. Just let me know if the starting fee is not fair.
I hope this all makes sense. Please ask if you have any questions.
Thanks for taking a look!Jeff
Paid 10% to Oz....
Transaction ID
7SG35431BJ0951126 
Indeed it did! Thank you very much for the assist. I really appreciate it.

Hi All,
I get a data dump into an excel spreadsheet. In that spreadsheet I get a date in the format of mm/dd/yy. I need to get that date into another cell in mmddyy format. I was able to use a SumProduct formula to get a close result, but missing the leading zero for single digit months. I need the leading zero to be present. Formula approach or VBA, no preference for me. Hopefully this is clear and someone can assist. It would truly be appreciated. I have attached the worksheet with the data I am working with, as well as my SumProduct attempt. Thank you very much for taking a look.
JL 
Awesome!! I really appreciate it. Great work. Just sent payment.
Kind regards, JL