Search results for query: *

Hi, I am trying to find a way to consolidate data from 3 fields and remove duplictaes in the process but am having no luck.Here is what I need to happen: I have 3 fields of datain cells A:B and need to sum cells C:C per conditions from A:A and B:B. eg, A | B | C | H001 | 10001 | 30...

all, I have a code that worked until I added an exception to it the code is: Sub Macro4() ' ' Macro4 Macro ' ' Range("I3:I43").Select Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _ "=if(LEN(TRIM(I3))>0"-if(I:I,"order")-if(I:I,"dialogue")...

Ok I am calling on the services of the code GURU's once again. I have written a formula for a project I am doing but have now hit a small roadblock. the code is: IF(A2<"V111V9H7001E290",A2,CONCATENATE("",CODE("a")-87,MID(A2,3,1))),SUBSTITUTE("a","10a","10/") the purpose of this code is to pick...

Hi, I need some assistnce on an ongoing project that once again I have been thrown a curve ball and need to alter a formula that I set up per your great advice. the scenario is this below code works great for what it was intended Sub gig1400() ' ' gig1400 Macro ' ' Range("B3").Select...

Hi I am trying to add the value of 2 cells say D1,E1 and display the result in A1 but need it to only add these values if the time is less that 13:00 in cell B1 and has a specific word in cell F1 say "BLUE"is there a function entry that will allow this or a VB code? e.g. A1 B1...

All, I created a formula in Excel to allow me to scan in tracking numbers from FedEx and UPS that will display only the 12 digit tracking # from Fedex from the 36 digits created by the barcode but will leave the UPS style to display as is which works as long as I use 2 cells to make this...

Hi, Can anyone assist me with an issue I am having am trying to automate an email of a spreadsheet from Excel. I have the code pretty much figured out and can get the email to generate as predicted, but then I get the pop up window asking if I wish to send the mail. Is there a way to turn this...

Hi can someone help me to create a code that will allow a chosen field to change typed text into code39 barcode text and contain the pre and post asterixes ie I type in Columb A 9g547fd and it is auto changed to *9g547fd* and changes to font Code39? any help would be gratefuly received thanks...

Hi all, I am new to VB scrpiting and I am trying to set up a worksheet that will auto Caps certain Columbs and auto date Columb D. I have been succseful in doing this seperately fron eachother but have a name conflict when trying to have both run on the same spreadsheet. I also need to auto...

Hi all, I am new to VB scrpiting and I am trying to set up a worksheet that will auto Caps certain Columbs and auto date Columb D. I have been succseful in doing this seperately fron eachother but have a name conflict when trying to have both run on the same spreadsheet. I also need to auto...