Search results

Thanks Luke M... works perfectly, you are a wizard

Sheet-1 Column-A has various text that looks somewhat like this... .0051 Total Runout to -A- -B- [Actual] 1-3H12-39 Each field has a left square bracket as shown above to the left of the word Actual, I've been trying to create a macro that will remove everything to the right of that bracket...

Prefect, works great... thanks to all

SM... pretty slick, works very good but there is one glitch. Lets say A4, A5, A6, A7, A8, A9, A20, A21 all have [lastModified] in them... the macro deletes A4, A6, A8, A20, so what’s happening is if two adjoining rows have [lastModified] in them it deletes the first and skips over the next.

A1:A1000 has various text information in each cell, there are several cells that start with [lastModified]= followed by a date and time which may or may not be different from cell to cell… one example would look like this [lastModified]=05/24/11 17:58:04. I’m looking for a macro to locate each...

Luke M… amazing, works like magic, I can’t tell you enough how much I appreciate the help… you guys are awesome

Narayan... works great, thanks for the detailed explanation, you guys are awesome

I really appreciate your help with this and I did try it but I might be missing something here. I have a table with 10 YEAR columns and 12 MONTH rows so the very first cell houses only the Jan 2013 count, next cell down houses Feb 2013 and so on. Based on what you provided my formula looks like...

Thanks for the help, if can beleive it we're still using Excel 2003, do I have any other options?

Sorry, type error, the formual is as shown below and does not work, it returns #NAME? =COUNTIFS('List of Items'!A2:'List of Items'!A2000,">="&DATE(2014,1,1),'List of Items'!A2:'List of Items'!A2000,"<="&DATE(2014,1,31))

Thank you for your reply, I will not be able to put dates in D1 & E1 because I actualy have a table with 120 fields that covers a ten year period. I'm looking for something like the formual below which I have not been able to get to work, any ideas on this kind of approach? This would be the...

A1 thru A100 have dates, I'm looking for a formula that will count the number of dates that are between and including 01/01/14 thru 01/31/14... thank-you

Thanks guys, guess I'll have to go to plan "B" as soon as I figure out what that is... thanks again

I’m using the macro shown below that works great on Excel 2003 but not so good on 2007. The way this should work is... a comment is created which includes the text “Employee No.: ”, the curser is automatically positioned at the end of that text which allows the user to type in their employee...

Thanks guys... greatly appreciated

I have many control toolbar checkboxes on a spreadsheet but need for only one to be checked at any given time. I’d like to be able to click any single checkbox and have it uncheck all checkboxes before actually checking the one I’m currently clicking on. I'm think that adding code to the...

Faseeh, you make that look too easy, thanks for doing your magic, it works perfectly... best regards...Dennis

Cell A1 has this in it… XZY: 12-345-678-900. I want to use the =SUBSTITUTE function in cell B2 to output the same text as A1 but without dashes and spaces XZY:12345678900. I have been able to eliminate the space and dash individually but have not figured out how to do both in a single formula…...

Narayan... works great, thanks for your all help

Hey NARAYANK991... you saved me, thanks. One last thing, what do I change to have the hyperlink open in a maxinum window?

I'd appreciate any help if someone has a solution to this... I’m using XP and Excel 2003 In cell B5 is this text... H:PublicEngineeringCustomer's FilesSiemens EnergyDocument LinksP0001813700 DocLink.xls In cell C5 is... =HYPERLINK(B5) If I click cell C5 it hyperlinks to the document...

I appreciate any help with this; it's my second round attempt to seek a solution... I’m using XP and Excel 2003 In cell B5 is this text... H:PublicEngineeringCustomer's FilesSiemens EnergyDocument LinksP0001813700 DocLink.xls In cell C5 is... =HYPERLINK(B5) If I click cell C5 it hyperlinks...

Thanks guys... I should have told you that I'm using XP and Excel 2003 so if I right click the Control Toolbox Command Button that is on the spreadsheet I do not get an option to choose "Hyperlink". What I'm looking for is code that will trigger cell C5. Also, the path in B5 changes from...

In cell B5 is... H:PublicEngineeringCustomer's FilesSiemens EnergyDocument LinksP0001813700 DocLink.xls In cell C5 is... =HYPERLINK(B5) If I click cell C5 it hyperlinks to the document specified in cell B5 I want to use a Command Button to spark the hyperlink in C5, can you tell me what...

Hello there Marc L... you are a wizard, works great, thank you so much