Search results for query: *

Hi, I have a PivotField(RD) which currently has 58 AlphaNumric values but I need only to filter the ones that start ‘AB’ which this week is 9 instances The total list of RD will vary each week, and new records starting ‘AB’ can appear. Is there a way Within VBA to Filter like this? I recorded...

Hi, not had to bother with pivot tables for years but have a requirement to display data in a pivot. One of the columns in the data is a date column, I will be summing sales with the date field running across the pivot columns. Trouble is I don’t want to see the individual dates, what I’d like...

Hi all, a co-worker has moved on and the ownership of a VBA routine that copies a range of cells with Excel and turns that range into a jpeg to added into an email has been passed to me. The routine loops through a list of managers which changes the data in the range for each new email. The...

Hi, I have a worksheet change event which works fine as is, if new data is pasted into the range. How can it be stopped if the range is cleared or deleted? Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Long Dim rng2 As Long With ActiveSheet rng =...

Hi, I get sent a file each day called 'Daily_Sales_ddmmyy'.xlsb, so todays was called Daily_Sales_140218.xlsb The code below loops though ther open workbooks until it finds the Daily_Sales file, I know to have that file open before I trigger the Procedure which pulls this file into my Master...

Hi, i’ve built a summary worksheet that now has more cells with formulas than I had originally planned. I have an combo box (form control) which a user chooses a value from a list of cities, The selection is linked to a helper sheet which works out the stores within the selected city, which are...

Hi, each day I send out the latest 14 days of sales data. However I am forced to obtain the raw data from a system where you can only filter on month, so I have to filter between 2 months to be sure to get a rolling 14 days. When downloaded to Excel, cols A to H are fixed as these contain...

Hi, following thread68 1763485, I was able to use the Data > Text to columns to split out a DD-MMM-YY HH:MM:SS format into 2 columns, Col A for the date and Col B for the time. This works fine if done manually, following the Fixed Width option and not importing the empty space between the data...

Hi within a file exported as csv from SQL, there is a date field that appears as dd/mm/yyyy hh:mm:ss, so 06/01/2016 13:30:47 or as a general field as 42375.56304. It previously appeared as 06-Jan-16. I don't own the SQL code that creates the table where the data is exported from unfortunately...

Hi carrying on from a thread that I started on the Microsoft Office forum hoping CFs might help. I have a formula that pulls data from a table such as a Team Name and a result figure in order of high to low results, I would like to colour code the result figure so that results greater than or...

Hi carrying on from a thread that I started on the Microsoft Office forum hoping CFs might help. I have a formula that pulls data from a table such as a Team Name and a result figure in order of high to low results, I would like to colour code the result figure so that results greater than or...

Hi, currently I have a data table from which I use a lookup formaulas to list data ranked in highest order Showing the team reference and its percentage result with a text string such as XYX123(99.56%), XYZ456(95.23) The formula that I've used is...

Hi, is it possible to have a date function or formula that will display the date of the most recent Friday, by that I mean if today is Tues 17th Feb, I would like to display last fridays date which was 13/2/15, and if today was a friday, then display todays date. Hope that makes sense.

Hi, I currently have cell values that look like 'AB-HOWDOYOU' however I only need to show the characters after the "-" so in this example that would be "HOWDOYOU" I've been able to get around using a =Right(A2,8) type formula. However I'd like something more robust in case the next load of data...

Hi, I want to automate a daily process of creating a new email, typing subjects and body text and adding an attachment, which I've been able to achieve. However I also copy a range of cells (C11 to O14) and paste into the email body as a picture, and this is where I am struggling. Here's my...

Hi, I have to add some commentary to a set of figures covering 8 weeks of data for 4 business units, so I thought I would create a Line Chart to plot the results over time, and add Linear Trendlines to show visually the positive or negative trends rather than the 'saw tooth' view of the spot...

Hi, I been getting some help over on the VBA forum regarding Conditional Formats, although nobody grumbled, I hold my hand up for my mistake for posting a non VBA question the that forum ;-) The help got me over that hurdle, but I have another similar one now with a Formula I have currently...

Hi all, I've been working on a worksheet that has a combo box which has a list of measures, so you can select one at a time, and then monthly results for that chosen measure are shown on the sheet. Within a row above the data I have the monthly targets. The measure description appears in A4...

Hi, as usual I've inherited a workbook which I have been adding some VBA to, however when trying to add a formula into VBA i'm getting a resultant #NAME? error in the cell ActiveCell.FormaulR1C1 =...

Hi, sorry if this is a real goofy question... I've previously developed a routine within Excel that uploads a file to SharePoint and triggers Outlook to send an email to advise that a new file is available. The trouble is the files can sit there and not be dealt with unless I follow them up...