Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Rebellion34

    consolidation macro excel 2007

    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...
  2. Rebellion34

    code error assistance

    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")...
  3. Rebellion34

    broken code

    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...
  4. Rebellion34

    more assistance required

    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...
  5. Rebellion34

    excel 2007 function required

    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...
  6. Rebellion34

    Code transposition from Excel Formula

    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...
  7. Rebellion34

    sending mail from Excel

    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...
  8. Rebellion34

    creating a scanable barcode in excel

    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...
  9. Rebellion34

    Macro Assistance

    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...
  10. Rebellion34

    Macro Assistance

    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...

Part and Inventory Search

Back
Top