Posts by jlsprink

Re: USD $25.00 Delete Rows Based Off of Multiple Criteria Via VBA

Whoops! Sorry. I must have attached before I saved my final version. See new attachment. Yes there could be multiple occurrences of "Off". Thanks again!

Re: USD $25.00 Delete Rows Based Off of Multiple Criteria Via VBA

Thanks! I really appreciate it.

Hello,

I’m looking to delete rows in a spreadsheet dump based on multiple criteria using VBA. I’ve attached a spreadsheet that shows the raw data and another tab that shows the desired results.

Here’s what I’m trying to accomplish:

If column AH has a value of “OFF”, then I need to delete not only that row, but any other row that has the same SYS # in column AF as that record.

So, in the attached, rows 6, 14, 15, and 22 would all need to be deleted.

Hope this is clear enough.

Let me know if you have any questions and thanks in advance for any help provided.

Regards,

JL

Re: Formula to populate value in cell based on two prior cells values.

Awesome! Thank you very, very much! (Yep, sorry for the typo)
Best Regards, JL

Hi Friends,

Need assistance in creating a difference formula based upon two preceding cells. Basically if Cell in Column A begins with a specific three characters, and the adjacent cell in column B = a deterimined value, then I want to calculate the difference of cells C and D in cell E. I know that's not a very good description but looking at my example should clear up what I'm trying to do. Really appreciate it.

Re: Delete unhighlighted rows based on criteria in row immediately above $20.00

Thanks Wigi!! You nailed it! Impressive. Really appreciate it. Let me know your paypal info and I'll send payment right away.
Thanks again for your assistance.

Kind Regards,
Jeff

Re: Delete unhighlighted rows based on criteria in row immediately above $20.00

Yes, the yellow colour will already be part of the file when this macro needs to be run.

Re: Delete unhighlighted rows based on criteria in row immediately above $20.00

Great! Thanks for taking a look! No hurries or worries.
Kind regards, JL

Hello Friends,

I've got a spreadsheet with several rows of data. I need to delete extraneous rows that are not necessary. I need a vba solution that will accomplish this. I've attached a spreadsheet that shows an example of my original data and a FinalResults tab that shows where I need to get to. Basically I need to delete any rows that are not highlighted that do not have the same value in column C (Cusip) directly above it. No highlighted rows should be deleted. Probably a better way to phrase it but hopefully with the example, it makes sense and can be accomplished. I really appreciate the help. Let me know if any questions.

Regards,

JL

Re: Delete all records where subtotal is greater than 0 $10.00

Perfect! Thanks so much! Send me your paypal info and I'll send payment right away.
Thanks again, great job.

Best Regards,
JL

Hello,

I've got a spreadsheet with several records that have been subtotaled. I need to delete all the records where the subtotal is greater than or equal to 0. I need the "Total" row deleted as well as the records that make up the total row. Looking for a vba macro that will accomplish this. Actual spreadsheet will have up to 5000 rows. I've attached as sample spreadsheet with sample data on sheet 1 and the desired results on sheet 2.

Thanks for looking.

JL

Re: Copy specific cells in all tabs of workbook and paste in one summary sheet.

Thanks PCI,
Works great. Just PM'd you for your paypal info. (I had an outdated email address in my profile) Thanks again!
JL

Re: Copy specific cells in all tabs of workbook and paste in one summary sheet.

Perfect. Thanks PCI. Let me know how to pay you and I'll Pay right away.
Thanks again! Kind regards, JL

Hello,

I'm looking to copy all informaton from every sheet in a workbook into a summary sheet. The information I need copied is in the same two cells in each worksheet. (H:11 and J:11) My workbook contains many sheets but my sample workbook shows three different sheets to give you an idea of what I need.

I need a way to cycle through every sheet and copy the pertinent information into the summary sheet. Please see attached to see my desired results in the Summary tab.

I can pay $10.00 via paypal if someone can come up with a solution for me.

Kind regards,

JL

Re: Disable Advanced Filter

Hello,

Take off the "s" on Filter and it works for me.

Change "&Filters" to "&Filter".

Kind regards,

JL

Re: Convert Cells In General Format To Date Values

Hi Wigi,

Absolutely outstanding! Thank you very much for your help!!
I really appreciate it.

Regards,
JL

Hello,

I get a spreadsheet every day that has a column of numbers that contains dates that are not in a date format. Is there a way to convert these numbers to a date format? The numbers come from an outside source so I can't modify on the front end. Please look at the attached spreadsheet with representative data of what I'm trying to accomplish. Thanks for taking the time to look at my question.

Kind Regards,

JL

Re: Calculate Various Lengths Of Time

Hello,

One way,
Format cells as [m]:ss
Then include leading 0 when inputting values. i.e 0:02:43
(Idea from below)
http://www.cpearson.com/excel/datearith.htm

HTH

JL

Re: Sumif A Cell Matches Text When The Text Contains Math Symbols

Hello,

Not sure why the math symbols are not recognized. How about as a work around, use the asterisk as a wildcard.

i.e
SUMIF( 'Raw Data Export'!D:D,"* No Project *",'Raw Data Export'!G:G)

HTH

JL

Re: Hide Rows Based On Multiple Criteria

Thanks so much VBA Noob. That helped out alot! I was having trouble figuring out how to account for the fact that the rows would vary from day to day, but this seems to work for the variance.

Sub HideRows()
     
    Rows("2:11").EntireRow.Hidden = _
    IIf(Range("Z65536").End(xlUp).Value = Range("AJ65536").End(xlUp).Value, True, False)
End Sub

Thanks again for the assist.

JL