I would like to have excel omit values from a calcultion using the strikethrough botton (not always SUM) but the code I found on this site did not seem to work,and besides I believe it only a...
I have 2 wokbook with 2 worksheets
Each of the worksheets have 2 columns. Column A is owner number and Column B is shop number.
Worksheet 1 has all the possible combinations of owner nu...
I have attached my file. In the file is a Pivot and the pivot's data file.
If you look at the pivot, I have Product 1, Product 2, Product 3, Product 4 and Unknown in the first column.
I...
So I know how to sort by columns but here is what I am atttempting to do:
Column A has 100 rows where there are a total of 4 types of responses in that row to include:
Direct Manager Stren...
In one of my sheets, I have a "legend" of values like this:
Sheet1:
Quarter Days
Q1 3
Q2 5
Q3 7 ...
My workbook contains upwards of 25 worksheets (1 of them with hundreds of cells containing conditional formatting and at least 6 of them dependent on data from each other), 1200 named ranges a...
Hi,
This formula was created here at E-E:
=SUMPRODUCT(SUBTOTAL(103,OFFSET($B$1,ROW($B:$B)-1,0))*($B:$B="Yes"))
It calculates the number of instances of "Yes" in column B and will adju...
Hello,
Could someone please look at this code. I think I'm doing something wrong and its hanging.. Thanks
Sub Publish()
XPath = "C:\2 - Palliative\Q108\"&Range("F12").Value&".xls"
...
I need a macro that will highlight the rows in a selection of cells if any single cell in that selection is blank. I would like to highlight the selected rows in red. Thanks in advance.
My current code works fine as presently designed but will like to modify it further such that the ROW HEIGHTS for will alway remain as designed when code creates the excel file to be saved to ...
Hi. I am trying to copy the formatting from the ActiveCell in my VSTO managed spreadsheet to another
spreadsheet but the following code fails on the last line
Globals.T...
I would like to pass a parameter, txtProjectName, to a UserForm named ABC
How can I do that?
see snippet code
Hi Expert
Need to re-arrange the following fromula (as shown below)
=(('Pricing Demand'!$F145 *
(1-'Shipping BOG'!$F145))
*
'Modelling (Vol)'!$F145)
to
=((...
I have an Excel 2003 worksheet with Macros. When opening the worksheet, I enable the Macros, which is set to medium, but after making changes to the worksheet & clicking save, I get the mess...
Friends,
Please, does anybody know how to avoid looping using Target within Worksheet_Change?
Example:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Rang...
I have a UserForm to input information of a Unit inspection on a sheet call Errors. In same workbook different sheet I made a summary of ERROS columns count, averages, etc. well this made my f...
Here is what I'm looking to do in relation to the attached sheet:
If RGDEAL column i falls in date range relating ro RG column c, put RGDEAL i into RG Column E
Best Regards,
Fraser
Here's what I'm looking to do:
If RGFuture column P = < 0 in a given month, take that negative number and transfer to outgoing projections (make number +ve), adding to existing number in co...
The code below is pulling the name from a text file that is open when this macro is running in another open workbook. I need to limit the name to only the first 3 or 4 letters, or anything be...
Hi All,
In the attached file in Cell C3 I need the following sum:
Any nominal code in Sage Data worksheet which = 40001, add the quantity in stock figures together. This will let me kno...
Dear Expert,
I would like to combine Excel files in a folder.
I have a "master" folder called Companies. In this folder I have many subfolders. The subfolders have names like GM, Ford, Toyo...
Is there a function that would highlight which cells contain spelling mistakes. I don't actually need the function to run the actual spell check procedure but just show which cells contain the...
I am new to Pivot tables. I am trying to run the wizard to create a pivot table (Data, Pivot table or Pivot Chart report, etc...) but I believe I need to have a "header row" before I can do t...
Can anybody see why this variable isnt working?
I get an error message:
Run Time error 424; object required
Upon Debugging the following section of the code seems to be the problem
...
Guys
I have some code which formats my data into appropiate columns the only thing is I could do with this modifying and I am not sure where to start. The code was taken from experts echang...
