How To Get Rid Of Duplicated Shortcuts On Right-click
May 17, 2009
I've created a calendar in VB following the instructions in this link - [url]
The calendar works fine but the problem I've got is I've got unwanted copies of the shortcut when I right-click. If you scroll down the URL, right at the bottom in blue is a paragraph that describes the problem and how to get rid of it. I've tried this numerous times but the duplicate entries keep re-appearing.
I've attached my workbook in the hope that any of you experts would be so kind as to take a look and offer any help or advice on how to fix this problem?
I have a routine that by clicking one button, that calls a macro, that currently opens Excel, or Word, or WordPerfect. The following macro uses a Case Statement looking at what the extension is, such as for Excel . . . xls
I have added a case statement for a shortcut . . . exe
Some expert users can unhide a sheet in a worksheet which is protected by password. But I don't want to place a button in the worksheet for everyone to see and wonder what it's for. I can record a macro and assign a keyboard shortcut but I can't do it it with existing macros ?
I currently have a navigation menu with 9 options however these options are based on Range names that I have set up.
The concern is that if someone deletes the cell that contains the range name, obviously that option in the navigation won't work, nor would you want it to.
However if someone re-enters a cell that you would want linked up with the navigation there's a lot more action involved.
What i'm looking for is a macro that can be used through a button, Idealy i'd like the macro to search through column "B" and look for key labels (ex: "Ground Floor", "1st Floor" "2nd Floor" etc.) and have each button set up for it's respective search data (ex. Ground button searches only "Ground Floor")
Transferring Multiple Data from separate worksheet without duplicating"
As you can see i am looking for information in column d (Letter) and getting the result to show from column B (number) using the formula in Column G (result 1).
The problem i am having is that if i try to copy or drag the formula down into Result 2 i just get the same answer.
Is there any way for the next cell down to ignore the previous result?
Example: i can have the same number repeated in column C & the same number repeated in column D But numbers in both column can not be repeated on the same row Values are added in columns C & D sheet2 by userform combobox . i am looking or a messagebox warning when = cell values in both column are found.
I seem to having a problem with my spreadsheet using Vlookup. It's mainly because on the 1st column, there are items which have duplicates and are differentiated only by the 3rd and 4th column.
example:
1st column: Bob Jane John Bob
3rd column: Red Orange Purple Blue
4th Column 1 2 3 4
Basically I'm doing a vlookup and but i want to combine (or sum) the 4th column values of Bob (Red) and Bob (Blue). I know I could use the SUMIF function in order to do what I want but I was wondering if I could nest that function within the vlookup so that it would do it automatically?
I have a workbook that consists of three sheets. One is the "Master", which is were all raw data is entered. The second is a "Criteria" sheet that has a series of dates, which is later reference in my SUMPRODUCT formula and the last is a "Summary" sheet; this sheet basically summarizes all the employee data with multiple criteria. This is the sheet references both the MASTER and the CRITERIA sheets. BTW, I posted a similar thread about this here: Summarize Totals from Multiple Worksheets. I took the advice and started fresh....
My issue is that on the master, there will some employee names that are almost identical which causes problems with my SUMPRODUCT formula. This is the formula I'm using. =SUMPRODUCT((LNAME=$A6)*(DATE_CHK>=Criteria!B$5)*(DATE_CHK<=Criteria!C$5)*(SUM_RNG))
Obviously, there are named ranges. As you can see the first item in the formula references the name (LNAME). This uses the employees last name. The problem is that we have many employees with the same last name so my totals are off. I've attached a sample to better grasp what I'm working with.
I've created Keyboard Shortcuts to run Macros in "Workbook A". Problem is, if I have "Workbook B" open in the same Excel instance/process as "Workbook A" the Keyboard Shortcuts will run the Macros in "Workbook A".
Is there a way to restrict the Keyboard Shortcuts to only run the Macro if Workbook A is active?
Or is there a way to code the Macro to run its procedures only if Workbook A is active?
I have an application that generate an excel sheet for me. In this sheet I have multiple rows with duplicated dates and text. With VBA I need to clear the content of all the cells that contain duplicated date and keep just the first row.
I have about 800 records and the the unique identifier are the names. Some owners are repeated several times and they have different values for the EDU column in my project. I need to remove any duplicated owners but I need to add up the values of each record that had value so I can get a combined value for one owner instead of a repeated owner with smaller values. How would I go by doing that? A formula or is there a tool in excel? I am lost on this one. I uploaded a sample file so you can see what I trying to do.
BTW i found if the values are the same for the EDU then I can not add them since it is also duplicated. I can only add up the unique values for the EDU.
I have two sheets. One of them has a long list of numbers and the other one has a shorter list, all of which are also on the first sheet. How can I automatically delete the second sheets numbers from the first sheet?
Basically I have an export which I need to manipulate so I can do a mail merge. I've managed to find a solution to remove the data I don't need and also managed to create the mail merge (even fixing the weird American date issue)
The data that is left looks a bit like this
Staff ID Name week ending week ending 1 Bob Smith 02/03/14
[Code]...
basically what i need the macro to do is to see theres two Bob Smiths (or 2 Staff Id's "1") and put the second instance in column 4
e.g.
Staff ID Name week ending week ending 1 Bob Smith 02/03/14 09/03/14
[Code]...
in some instances there could be 20+ week ending dates to go into the row.
also I don't need to have the dates all in seperate boxes, I just need the information in a row so the mail merge reads and sends out one message rather than 20 messages to the same person asking for each week by itself.
I've manually moved the dates into the boxes up to now and everything else is working
I have a worksheet with that I need to delete both rows if the data in one of the columns is the same. I know how to delete the duplicate row, but I need both rows deleted..........
From the example above I would want Rows 1,2 and 10,11 and 12,13 deleted based on the data in column D
I manage messaging server farm that keeps mailboxes and their replicas on different servers for resilience. I need a way to check the replication status. I try to do it by comparing their sizes. I got all mailboxes and replicas incl their sizes imported into excel (2010) and I need a way to compare them.
Like this: name size
John Smith 10
Mary Westwood 20
[Code] ......
My idea was to find matching pair (two records of John Smith) and compare size. If the size differs more than specific value (5% or 2MB for example) the result is true/value/colour by conditional formatting etc.
I have a spreadsheet that contains thousands of rows and I need to highlight all the duplicates in Column B.
What I need though is one group o duplicates to be colored one color and then the next group of duplicates be colored a different color. I need just a 2 color banding.
My need for 2 colors is that the cells contain 9 digit numbers and there can be duplicate groups right next to each other and for the eye to distinguish a different grouping of cells I need that 2 color banding.
I have the below code that colors everything in one color. Can I be modified or a completely new code to do 2 colors?
Code: Sub Dups() Dim Rng As Range Dim CL As Range
Set Rng = Range(Range("B1"), Range("B" & Rows.Count).End(xlUp))
For Each CL In Rng If WorksheetFunction.CountIf(Rng, CL.Value) > 1 Then CL.Interior.ColorIndex = 6 End If Next CL End Sub