drag & drop

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...