overlapping data

Hi Guys, I am really hoping somebody can help me with this as I have tried everything but still cannot find a viable solution. My goal is to be able to identify overlapping mileage (miles and yards) from within my excel file. Please see below an example of the data... (Please ignore the...

Hello, I created pivot charts through power query and every month I add new info to the database and the charts update. They are line charts comparing two values. The problem is: when the charts are updated with new values, sometimes the data labels overlap... is there some vba code to prevent...

Hi; I did see this question asked before, but I couldn't find a thread with a posted answer. I'm mostly frustrated because I'm 90% sure it's a stupid simple fix, but I can't seem to get it... I'm trying to copy a graph format from previous reports so that it's consistent. I've got a stacked...

Hi guys, I try to filter data that I have in Macro file in DataSheet ('DS'). I need to take filtered data only (w/o header row) & copy it into different workbook/sheet 'SFDCReport', where there is a Table (Header row on line 12, 1 data row on 13). With this code, I received some Error 1004 -...

Hi experts I have a set of velocity speeds for soils and rocks and I'm using an index and match formula for these speeds for data I'm importing. The formula is =INDEX(H28:H45,SUMPRODUCT(--(I28:I45<=D7)*(J28:J45>=D7),ROW(I28:I45))-ROW(28:28)+1) The reference table H28-J45 is shown below...

We send out a newsletter and I'd like to find out how the recipients of the newsletter overlap with our customer lists - to find out how many who receive the newsletter have never become customers. In Column A, I have a list of all newsletter subscribers and in Column B I have a list of all of...

I'm quite new to Excel, but need to use it heavily for my new job. To make matters worse, I am using Excel 2003, which I am less familiar with. There are two specific problems I am encountering. 1) This is hopefully easy -- if I have a number of cells in a column, and I want to divide them...