Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 02-20-2020, 06:07 AM
DJ0691 DJ0691 is offline Drag and Drop into an input range results in #REF! error Windows 10 Drag and Drop into an input range results in #REF! error Office 2013
Novice
Drag and Drop into an input range results in #REF! error
 
Join Date: Jan 2020
Posts: 18
DJ0691 is on a distinguished road
Default

Appreciate the responses!

I was attempting to help speed up data entry for my users by allowing them to select a small range of cells in an unstructured area and simply dragging them over to input fields where the formulas do their thing (data validation).

Its probably almost just as quick to do a Ctrl+C and Ctrl+V but since they will be doing this multiple times, thought it would be nice to allow simple drag and drop. In researching this, appears to be an Excel limitation.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Drag & Drop of pictures Brigitte11 OneNote 0 10-25-2017 09:29 AM
Drag and Drop into an input range results in #REF! error automating drag & drop rob171171 Excel 9 04-23-2016 07:09 AM
Drag and Drop into an input range results in #REF! error Drag and drop macro Amanoo PowerPoint 2 06-15-2012 04:01 AM
Drop and drag macro Jamtart PowerPoint 3 04-15-2012 11:05 PM
Error Copying file or folder - Drag-N-Drop--> Network Shared Kris.Fulgham Outlook 1 10-17-2005 09:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft