key

I am doing a dictionary check, the code works with loops, but is way to slow. I got it running with dictionary as well, however a problem appears, when the same value is already in my result matrix. Several values in my arrSource are going to appear once or twice and I want to know EVERY time...

Hello All, I have this table below. As you can see in the KEY column, is has the correct answer. In this case it is C. Is there a was to make "WHAT" the correct answer highlight in GREEN? And for the next row it would be D (They're) I would really appreciate it. I have over 100...

Hello all I need an excel guru to solve this one please I have multiple lookup's against a primary key in two work tabs This then brings through the data I need The problem I have is if the source line no longer exist the lookup will wipe out the last data that was in the cell.. I need...

Hello, everyone. I know you can help me on this. What I am trying to do is create a formula in one cell so that when I put the value "Yes" in another cell within the same row it creates a static date (a datestamp, essentially). Now, I want to make sure that the date doesn't change when I update...

Hi, As per title, I have seen a video which had no sound & wasnt clear what he had done BUT he entered a formula into say cell A10 Now he didnt grab the marker in the bottom right corner of that cell and drag to say A123 But used some kind of sortcut / hot key etc When you then looked down the...

sorry for the poor title, but I can't think of a simple way to describe it here are 3 tables that store the history of every transaction made by every user at automated teller machines (atm) ----------------------------------- table name -- transaction fields transaction id -- primary...

I have a sheet containing data in A1:CF5364. This will change each time I run this report, there may be more or fewer rows/columns. I'd like to be able to delete an entire row if column P contains one of 9 key words. In this case, the cell would be an exact match but I don't want to limit this...

Hello all, I am in the process of rewriting several macros authored by several previous authors. The first of three is launched from a button on an Access form. After the first has run, users are asked to paste data into the .xlsx workbook created by the first macro before running the second...

As a short example (I can build off) if a user selects within a cell in a certain column and pushes enter, the enter key instead of its usual function would insert a line break and a bullet point. Is this something there is a function to be able to do? Is it possible to temporarily re-bind a...

Hello all I hope you can help on this, This code currently inserts a column in column "A" and creates a unique key value It then copy all the data with the unique key in a sheet called "Comments" What I need in to copy this data but after the last populate row in "Comments" so it does not...

The data part of the macro I'm trying to create may be better suited for Access but it lays out better in Excel. I have 3 or 4 different data stores or the equivalent of tables. Very small business. Nothing to big. main employee list. A positions list they like to be able to edit. A training...

Bit of a long shot this... but... I have a worksheet, called 'Key'. In column A there are around 12 cells inputted with text, each cell is coloured differently. A1 has texted 'DS', and is yellow. A2 is 'Medical', and is red etc etc. Would it be possible to somehow have a conditional format in...

I have an ActiveX ComboBox and it uses a list to fill the drop down. When the user selects a company from the list, they click on the icon next to the ActiveX field to initiate the search macro. I would like to include code on the ActiveX ComboX so that when it loads, or is displayed, the...

Ok Gang, I have a project with a crazy time crunch and was hoping to have some help on the below. I have a query of data that has a column with my Lookup Value (Variation 1) and a secondary column with an offsetting value that is backwards (Variation 2). If you look at the data in column...

Hi I have a userform with 4 textbox and a function to force users input only number in it. As code below shows, I have to right this function for each textbox keypress event. Now I need to know is this possible to have a loop through userform textboxes to do it? Private Sub...

Would appreciate help with the following. I have a large, unsorted table in one worksheet tab and I need to populate a sorted TOP N list on another worksheet tab where TOP is the largest amount of sales (largest being #1 ) but it has to be only with those of a certain color. I need to return...

I've searched for a solution to this, but can't find anything. There is an old thread I found where someone was having this same issue many years ago, so I thought I'd start a new one and maybe someone can explain this to me. This only happens intermittently. Only sometimes, when I press tab or...

I made a very simple macro. Sub Yellow_Highlight() Selection.Interior.Color = RGB(255, 255, 0) End Sub I then assigned it a shortcut key of CTRL+SHIFT+H When I run the macro using F8 or Visual Basic it works fine. When I try to use the shortcut it does not work. Any suggestions?

Hi folks, Parts of my census is missing, for those missing parts I'm pulling in a data-point based on an identifier having a specific phrase included. The identifier could be "Core Values", "Core Values and Leadership", "Core Values and Key Objectives", "Key Objectives". Basically if one of...

I am looking to make a clustered column chart. I've given some example information below to show what I'm looking for, more or less. I want my x-axis to be non-numerical labels, which I have listed in column A of my spreadsheet. I want my y-axis to be numerical values, which I have listed in...