excel questions

  1. M

    How to automatically change a Module code in multiple protected Visual Basic projects

    Hi everyone, I'm new to Visual Basic. For the past 2 days I've been trying to make functional an automatic code that should process multiple Excels and change one of the modules code from their respective Visual Basic projects. Each VB project is protected. I used this following code to...
  2. R

    Auto filter a table based on the value of a cell

    Hi all I'm using this code that I saw in another thread: Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Range("B2")) Is Nothing Or _ Not Application.Intersect(Target, Range("C2")) Is Nothing Or _ Not Application.Intersect(Target, Range("D2")) Is...
  3. J

    I am new to vba. Can i get some help in writing a small macro code

    i need to create a macro to skip actions if their id matches to the list in another sheet in that excel for example something like : if Actions.setid matches id in sheet2 then I need to skip to next action For Each action In Enable.ConnectActions If Action.setid IN (sheet2)
  4. W

    About Usage of FIND&LEN&RIGHT

    Hi again, As I showed in the image, I have to find 2 numbers right of "L". I have tried this formula,=RIGHT(Data1!J2,2) but I cannot apply other cells. What should I do? I will be waiting for your advice.
  5. T

    Excel Data Organizing - Tough

    The Data I have - extracted (about 80+ columns for different people and about 150 rows for the codes): Contribution Site Codes Person-A Person-B Person-C Person-D 001-5500-000-55 50% 50% 003-6600-000-56 20% 40% 20% 10% 002-8800-000-57 20% 30% 001-0677-000-58 30% 40% 90%...
  6. K

    @ How to match Two condition & show value ???? via formula

    @ How to match Two condition & show value ???? via formula 1 st table to match 2nd table data , Need Both Condition Match (1) Invoice No. (2) CHA , And Get Result After match 1st table
  7. K

    I try to save excel file , but show this error right now.... (Microsoft office 2016)

  8. B

    Very Long (Working) Furmula. Can it be condensed or turned into a Macro?

    Sorry guys, new to Excel and it was hard to make this formula. It is Literally the extent of my knowledge at this point to have even gotten it to work. This formula takes a cell and looks for the persons name in a specific column on a sheet. If the name is found it returns the text in cell B1...
  9. W

    Year-to-Date (YTD) Formula Help

    Can anyone please help me figure out a formula to calculate YTD?? What I am trying to achieve: Sum all months <= current month, ONLY IF months fall within the same year CY (Calendar Year) as the current month As you can see on the screenshot below, Cell B5 indicates the current month. The...
  10. M

    excel event procedure Programmatically created can not triggered at once

    I created a new worksheet's and its 'worksheet_change' event procedure in 'worksheet_change' procedure of a existing worksheet, in its code I also pasted value in the new worksheet created newly, when I ran my code, the new worksheet and its event produce could be created properly, but the...
  11. V

    How to lock ribbon or connections option in excel to view

    Dear All, Pls help , i need to protect my connection or table properties to show any other users. Pls suggest how to lock ribbon to show or how to lock DATA option in excel ribbon. Thanks in adv. Regards Vishan
  12. C

    Excel function Return all row that in the list cell match specific key word

    I wanna make return all item from a list that any cell contain specific key word. If possible in more advanced level, make the return from a range of cell instead of list of row. Thanks.
  13. S

    URGENT Checkbox Code Needed

    I created Checkbox Code that when checked, it brings me to the related worksheet and expands the rows. I want it to ONLY expand the row in the related worksheet and not actually bring me there. What do I have wrong? I am new to VBA so I can't seem to see the error...
  14. F

    Please inform about tool/formulas for analysis data for mega-million

    Please inform about tool/formulas for analysis data for mega-million ; I use excel 2007
  15. F

    Excel question

    Draw ball ball ball ball ball date #1 #2 #3 #4 #5 # 1 2 3 4 5 6 7 ,,, number until 75 11/1/2013 37 35 50 75 39 11/1/2013 17 24 20 65 68 11/1/2013 69 12 49 73 54 11/1/2013 49 35 32 62 67 12/24/2013 26 59 27 2 6...
  16. F

    How find single cell automaticly ...

    How find single cell automatically and write something in it, into spreedsheet excel 2007 ?
  17. V

    Send Access Table Using VBA code by outlook

    Dear All Gurus, I have a access having with table name "Daily_RTO" i want to send it on email "vishan.uk@gmail.com" by access VBA code using outlook email system. Im new to VBA codes, pls suggest me full code of sending Access Tables and Select Queries to given email addess. Thanks & Regards...
  18. V

    text function (seperate using blan)

    Hi Sir, I have the some details like customer name. Vishan Singh Bob Simi i want first name of customer in next column using text furmula. Pls Help Regards Vishan:confused:
  19. V

    Updating in Access 2003

    Dear All, I want to update <0 data as 0 in many column at once mean in 1 query Data is like <table bgcolor="#ffffff" border="1" cellspacing="0"><caption></caption> <thead> <tr> <th bgcolor="#c0c0c0">DECR_01_Mar</th> <th bgcolor="#c0c0c0">DECR_02_Mar</th> <th...
  20. Q

    data sheet in what if analysis.(Excel 2007)

    I just got on data analysis using the “data sheet" function available under "what-if analysis". And it did not work<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I followed all steps of the book (Excel bible 2007), for one cell change format...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back