moving

I have a couple of questions about shapes including counting the specific text in them. I have a code that I was helped with some time ago for moving shapes to specific cells. What I want to do is instead of moving it , when click on I want it to copy and paste it into the cell that I select...

Hey, I can't work this one out and I've looked everywhere but can't wrap my brain around it properly. I'm trying to return a value with 2 criteria and moving past the duplicates, from a standard INDEX MATCH SMALL IF ROW the ROW at the end returns the array of the SMALL but it's not moving past...

I have an issue with the Active X buttons in my workbook. Every time I click on those buttons, the button shifts to the left. I have locked the sheet. I have locked each button. I have changed the button property placement to 3. I have even tried Property placement 1. I have set all the button...

I'm trying to create a moving average so when I enter the values for each month, it averages the last 3 values in that row, even if the value for that month is zero (not blank). I'm not sure how to do this. The 3-Mo average would go in cell A2 and I would update the values in cells B2 through...

I have two tables, side by side. After I enter data in t1, I have to enter data in t2. Table 1: A1:H91 Table 2: J1:k49 As I move downward in table 1, I want table 2 to move with my scroll, so when I need to enter data in that table, it is right there, and I don't have to constantly scroll...

Hi, I am after a bit of code that can copy cells that contain unique values into new cells but in the same sheet. In short I have a table that is produced by scanning items into the sheet, The barcode column (A) is populated by a scanner, which auto fills column B and C. Column C displays a...

I did a presentation yesterday demonstrating a spreadsheet I have designed. It works perfectly on my widescreen monitor. Unfortunately, the presentation had to be done on a projector and the best aspect ratio was 4:3 not 16:9. At first this didn't pose much of an issue as I have code to...

Hi, I'm not very experienced in using PowerPivot but I have come pretty far by using Google. However, this time around Google can't help me. I'm trying to figure out how I can calculate hitrate based on PowerPivot data. I have created a sample data set that looks like the one I'm working on...

Hi, I have create a Power PivotTable (2010) with sales data from each month from 2011 - today. From the PivotTable I have created a PivotChart. I only want to see sales data from the last 13 months in my chart so i have created a report filter for that. However, I would also like to see a 12...

Hi everyone! New coder here, I'm just wondering if I could get some help on some simple code. I'm trying to create a macro that allows me to continuously get the sum of multiple weeks. Each time I run the macro, it adds one additional week. This is the tricky part as I'm not sure what I...

<tbody> I'm so new it hurts...but I'm trying. I just don't see this problem listed in the forum. What am I missing? A B C F G <tbody> TIME NAME AGENT ROLE/NOTES </tbody> </tbody> <tbody>...

I am changing the name of an EXCEL 2007 workbook ('A.xls' to 'AB.xls') and then changing its location to another folder. I then am creating another workbook with the original name ('A.xls) and placing it in the original folder. Very simple and routine. I have a desktop shortcut pointed to the...

Hi All! This is my second question in this great forum - thanks to CircledChicken, my first question was perfectly answered. This question should be easier I guess and it is again about referencing. I have the following table: <tbody> A B C D E 1 =average(B1:B3) 1 2 =average(C2:C4)...

Hello everyone! Imagine I want to get the top-3 "Value" of each period of three days (in this case from 30/4 until 2/5, the top-3 values would be 78, 70, 68), aditionally I want to roll this top-3 over the time, so the second in analysis period would be (1/5 until 3/5), the third (2/5 until...

Hi, I'm looking for help with a 3 week rolling average. I have my spreadsheet set up with Data in columns NY through to OT as below NY NZ OA OB Week 1 Week 2 Week 3...

I am looking for an Excel formula to display on a new cell the max and min values of the trailing year data, assuming the cells are always updated with new data. Below is the example of the table. (Column B=Date, Column C=Time period, Column D=Index, Column E=Price). Rows/Columns B...

Hey MrExcel ! i have a question about replacing over 1700+ rows words.. this is what needs to be done basicly; row1: word1/word2/word3/word4 I want to replace the words in this way, note the numbers; word4/word2/word3 I want to replace word1 with word4, deleting word1 but keeping word4 at...

Hi, I have a file (Doc1.csv) saved down at C:\Documents\ and need to move it to C:\Folder 1\ What is the script I need, to add this to my macro? Many thanks for your help.

Hey everyone, Just looking for some quick help on how to calculate a moving sum: Let’s say that I have 2 years of sales information broken up by months. Is there a way for excel to recognize every time I add a new month’s worth of data and automatically calculate the sum of that cell the...

Hopefully this is an easy one. After I paste an excel graph into powerpoint, is there a way to move it around using the arrow keys instead of dragging? I want more control over the movement that dragging doesn't allow. Images and excel tables can be moved with the arrow keys, but when using...