drag cells autofill

I want to be able to retain data validation input messages when dragging the value of one dv cell to another with a different input message. To do this I'm trying to establish a collection of input messages before any edits to the sheet are made so that when I drag a dv cell's value to another a...

Hi, is there a way to avoid dragging the entire contents other than cell value of a data validation cell (validation type, settings, message, etc.) into an adjacent cell with or without its own validation so that only the cell value gets copied over, but the target cell(s) keep their data...

I have a formula that I am using (after you paste it press "Enter+Ctrl+Shift" to run it as it has an array inside of it): =INDEX('[Database_IRR 200-2S.xlsm]HE 171'!$F:$F,SMALL(IF('Operation base Q'!$H$5='[Database_IRR 200-2S.xlsm]HE 171'!$A:$A,ROW('[Database_IRR 200-2S.xlsm]HE...

I am relatively new to excel vba and trying to teach myself as I go. I am working with 2016. I have a spreadsheet that has a large bordered cell (frame, maybe?). On another program I generate pie charts which I copy and paste to my spreadsheet. The names of the pasted charts are always randomly...

In column say column A If have put a drop down list from which the values may be selected If anyone types some thing the entry gets rejected, but if some one simply drags the value from above sells it works. How do I prevent this and force the person to select from the drop down list