drag & drop

  1. N

    IFNA VLOOKUP with multiple repeating table arrays with filter

    Hi all, I have an interesting issue I have been searching far and wide for a solution to no avail. I have 3 employees who are assigned tasks every week. They rotate tasks every week. There are about 30 tasks, but they change every week so one week tasks A, J L K need to be assigned and the next...
  2. G

    Charts, shapes, and buttons, duplicating when dragged.

    This behavior has been going on for some time now, and I have not found anything on any thread or forum that can help. If I simply drag a figure, button, or shape, Excel acts as if I were holding control and duplicates the object at the dragged location. However, it does not act exactly as when...
  3. P

    VBA - Using cell value as a part of a range and dragging and dropping.

    Hi there, I am a bit of a newb when it comes to VBA. I've tried many different options and nothing worked. I cannot think of a way to get this to work. Would appreciate any help: Aim: I wish to paste a sum formula in Sheet1, Column R starting in Row 2. which sums the previous 4 columns (simple...
  4. G

    Rearrange column headers using listbox

    I'm looking for a way to move line items in a listbox to rearrange the order of my table headers. So maybe a click and drag approach where I click and hold one line item in my listbox and drag it to a different position in the listbox so that it changes the table header location. Or maybe...
  5. S

    How to get Values Based on the pictures drag into a cell

    hi all, I had created a drag and drop excel sheet whereby there are a total of 5 picture. The user is able to drag around the picture and put them into cell B1 to B3 respectively. After each picture had been drop into the cell, the name of the picture will be display at M5 to M7 respectively...
  6. Hrishi

    Locking reference of "columns of TABLE" in formula

    Hello, in order to drag formula we lock the cell reference by putting $ sign. like =+COUNTIFS($A$5:$A$50,AI$10,$D$5:$D$50,$B11) If my data in in "TABLE" then above formulate appears like =+COUNTIFS(Table134[Building],AI$10,Table134[Type of Sale],$B11) If I drag this horizontally, reference...
  7. P

    Drag Drop From TreeView to ListView ActiveX Controls

    Trying to drag a child node only from a ActiveX TreeView Control to an ActiveX ListView control in VBA for Excel. It works occasionally, but something is wrong. I'm unable to consistently get the drag event to fire (sometimes it works, sometimes not) or, when it does, determine what was selected...
  8. H

    State of play - Macro enabled spreadsheet as web page

    I am looking at deploying a Excel VBA solution to a client. The solution works extremely well in Excel, but now we need to deploy it to 150+ sites, where each will need to be installed on the local network. I would prefer to deploy the solution as a browser version instead. The snippets of...
  9. A

    Apply formula to an entire column

    This is the formula list : <tbody> PV001/10/14 PV002/10/14 PV003/10/14 </tbody> The next sequence should be PV004/10/14. Currently, when i drag, the number will turn up PV003/10/15 instead of PV004/10/14. Is there any specific formula for the above - for me just to drag down the box...
  10. K

    Sort a list by drag and drop using VBA event handlers

    Hello All, I have built a sheet that allows the user to sort a table of data. Rather than using sort values, I am replicating a drag-and-drop with a single click to select the row and another to insert it at another place in the table. The best way I can come up with uses...
  11. Jaafar Tribak

    Can we disable the AutoFill functionality on certain cells only ?

    Hi. I want to prevent copying onto some specific cells when holding and dragging adjacent cells . In other words not to allow AutoFilling should those specific cells come within range of the autofill area. Disabling the AutoFill functionality via ( Tools>Options>Edit>Allow Cell Drag and Drop...
  12. G

    Stop auto-refresh on Pivot Tables

    Hello, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Does anyone know how to stop a pivot table automatically refreshing when you drag & drop options in from the navigation panel?? :confused: Is this a setting in the OLAP cube that needs to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back