drag

1. Jump 3 Cells + AVERAGE -> DRAG

Good afternoon all, I'm having trouble dealing with a sheet I'm doing. Basically I have 3 shift's per day. What I need is data compilation, were the shifts turn to days. Ex. - What I have (Sheet1) Day 1 A1 - 1.5 A2 - 1.4 A3 - 1.6 Day 2 A4 - 1.5 A5 - 1.5 A6 - 1.6 - What I need (Sheet2)...
2. Drag the sum value question??

Hello Guys, I have a question to drag sum value. P1 P1 P1 P1 P2 P2 P2 P2 P3 P3 P3 P3............Pn 2 2 2 2 3 3 3 3 4 4 4 4................. From the above table, I want to get the sum value into a small table (below one) P1 Total P2 Total P3 Total ....................Pn Total...
3. Paste Formula but skip 2 columns

Hello, I have a question in term of pasting formula, but want to skip 2 columns. For example: FY16 FY16 FY16 FY17 FY17 FY17 Q1 Q2 Q3 Q1 Q2 Q3 Row 1 1 1 1 1 1 1 Row 2 1 1 1 1 1 1 Row 3 1 1 1 1 1 1 Row 4 1 1 1 1 1 1 (Total) Q1 Q2 Q3 Total ? ...
4. Drag formula but skip reference cells!

I'm making a budget and i am trying to have a page with expenses for every month and then on a seperate page i want to have the total of each category of expenses (i.e. gas, loans, entertainment, etc.) in the expenses worksheet i have three columns for each month: 1st column: date of purchase...
5. drag down formula that finds maximum in a column y and corresponding x in an other column

Hello! I have in the cells I4:I23 the variable y, and in the B4:B23 the variable x. I want to put in the cell L4 the maximum value of the I4:I23 and in the cell M4 the variable x that corresponds to that maximum(so if my maximum value was at cell I6 I want to appear in the cell M4 the value of...
6. Drag down formula tha skips 48 cells

Hello! I want to put in cell I3 the value from cell C1, to I4 the value of C49 and so on. How can I do it? Thanks
7. Complex Dragging of cells

I am looking for a way to drag down a table so that the table repeats with links to diffrent sheet. But when I drag the cells down they repeat but jump. For instance If I draged the cells bellow. It would make links to sheet2 a5 rather than a3. It will take me a life time to do this manually...
8. How to create mouse-interactive ChartObject?

Hello, I have created some charts (probability distribution models) as embedded ChartObjects on a worksheet with VBA, and would like to enable events so that I can click and drag the mouse over the chart(s) to change the parameters of the distribution model... How do I enable events for...
9. Drag formula across with source from sheets

It is the first time I post here. I've done a quick search on my question and haven't found anything... So my question is: On Excel, say I have data on ten years of international trade, organized such as each tab is one year. I want to create in a new tab a simple table with the total trade...
10. Draggable Command Button on UserForm

I am dynamically populating a userform with command buttons: Set ctrl = Me.Controls.Add(bstrProgID:="Forms.CommandButton.1", name:="mybutton", Visible:=True)I would like to be able to have the user drag these buttons around the screen, to reorder them if they want. Then I could capture the...
11. drag or copy formula as dynamic formula

This is probably a simple question but I'm puzzled by the fact that this formula won't drag/copy as a dynamic formula should.. it remains stagnant as if i were useing \$ on column and row refs. In this example, row 22 is the only specific reference...
12. Drag down matrix function

Dear all, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I have a matrix function and I need to use the same function all the time. Just one cell in the formula should change. Excel does not recognize that only this one cell is changing when I just drag...
13. Skip X cells when dragging a simple formula

Hi Lovely all, I'm trying to drag a formula but would like to skip two columns. I have 2 sheets. Sheet 1 with results and the other with column A originals, B actuals, C difference. Sheet 2 has only originals. So if I drag it goes: ='Sheet 1'A2, ='Sheet 1'B2, ='Sheet 1'C2, etc... What I...
14. Tranposing Data

Hello, <TABLE style="WIDTH: 656pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=874><COLGROUP><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" width=106><COL style="WIDTH: 48pt" span=12 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD...
15. Drag formula across merged rows issue

Hi all, I need to drag a formula e.g. =Database!A1 down across a set of merged rows. I wish the formula to automatically update by one row at a time as I drag it down e.g. A2, A3 etc but instead it naturally references the number of merged rows (10 in all) it has been dragged over. Is...
16. Preventing moving of cells

Hi, Is it possible to stop cells being moved, i.e. disable cut/paste and dragging of cells, but still allow copy/paste? I have a large worksheet into which users enter data, and there are formulae that directly reference the cells. So as soon as anyone drags a cell to a new place, or uses...
17. Dragging multiple columns at a time in Pivot Wizard?

Is there any easier way to drag multiple columns at one time. For Ex. If I have 5 years of data by month and If I had to drag 2 years of data I would have to drag 24 times. Is there any easy way to drag all 24 months in 1 go ? Sorry I did not add that this is while using the Pivot Wizard to...
18. Quick shortcut Question

Hello, You know how if you have a formula in a cell you can copy it to the bottom of the data in the column preceeding it by double clikcing hte little dot in the bottom right hand corner when you get a black + cursor. Is there a way to do this via keyboard without having to double click...

This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
• Listbox Header
Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
• Complex Heat Map using conditional formatting
Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
• Conditional formatting
Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...