jason

  1. J

    Macro to disabe a macro

    Hello Can I have a macro to disable another macro Thanks Jason
  2. J

    Hide headings in all worksheets

    No doubt this has been covered before is there a VBA to hide the headings in all worksheets Thanks everyone Regards Jason Bing
  3. J

    Returning Home

    Is there a way to get a workbook to activate a certain worksheet, say Sheet1 "A1" after a set period of inactivity? Thanks Jason Bing EDIT: I know you can get a workbook to save and close after inactive time. But I need it to return to a home page?
  4. Z

    Formula - Creating A Sublist from a master list

    I have a master list of clients in a sheet (Client List)- the list is broken down into 3 columns - client code, client name, AT Member 1. On a separate sheet, I am trying to create a formula that will auto-populate under the correct AT Members name. ex: Client List! TSM Toyota of Southern...
  5. N

    Calculating two separate cells properly

    =SUM(COUNTIFS($B$3:$B$53,E57&"*",$U$3:$U$53,{"AFF","ENL"}&"*")) So first let me say thank you to whom ever is willing to help out it is greatly appreciated. Above is my formula for counting one cell if another cell meets the either requirement. The problem that I am having is, is that, the...
  6. H

    Need help with macro

    I am defiantly new to macros. i have learned a lot from this forum but cant seem to figure out how to write this macro. I am trying to take 3 player from each weekly results based on the previous week. For example, the first week the top 3 players would qualify. In the second week if any of the...
  7. O

    VBA: Find 2 cell values in the same row and display contents in listbox

    I have a userform that has a txtZip, Listbox1, & ComboBox1, cmdGetCity Short Story: I want to search for the Zipcode (txtZip) and State (ComboBox1) columns - and if they match the row of data, display the name(s) of the Cit(y)(ies) of that row (Column D) in Listbox1. Long Story: I want a...
  8. O

    VBA: Need to find 2 cell values in the same row and display in listbox

    I have a userform that has a txtZip, Listbox1, & ComboBox1, cmdGetCity I want a function that whenever cmdGetCity is clicked, it will search the B2:B81832 range for a zipcode that matches txtZip (entered by user) and, also, search E2:E81832 for data that the users selects in the Combobox 1...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top