drag down

Hello, I have a simple problem that I cannot get to work... Problem I have one list (vertical in one column) with data. I want to create a second list (vertical one column) with a drag down formula that takes only every (for example) 3th value from the 1e list. What did I do to solve it I...

Hi, I have the following formula: =SUMIFS('Future Sales'!$N$2:$N$5000,'Future Sales'!$X$2:$X$5000,"Flight Only",'Future Sales'!$F$2:$F$5000,"Apr-2019") However i would like the date to change when i drag it down... when i drag down, i always get Apr-2019, however i would like May-2019...

Hey all you cool excel-shark out there. I got a sheet, where i like to do a VLOOKUP from a active cell. The thing is that the active cell can change from time to time and I like the VBA-code to make a VLOOKUP from that active cell and then dragging the formula below to a certain row. How...

Hi there, So whenever I've used Excel (2016) in the past, when dragging a handle or doubleclicking the autofill box, the autofill series has been the default option. i.e. dragging the value '1' in cell a1 down would autofill to 1,2,3,4,5 etc. Now when I do it, it automatically copies, down as...

When I try to drag down a formula it is causing excel to crash. I have 400,000 rows of data and the formula contains a vlookup, so this is quite intensive procedure. However, if I write a vba sub which breaks the dragging down into 100 row bitesize pieces, it works fine. Takes a while but no...

Hi, I am using the formula =TEXT(*cell reference*,"dddd") to display the date in the cell reference (in format xx/xx/xxxx) as its corresponding day of the week. It works great when I manually type it in, but when I try to drag down the formula to other cells, it is just displaying the day of the...

Hi all, Having some trouble writing a macro to fill down formulae across several columns. My macro looks like this: Sheets("Arcade").Rows("37:37").Select Selection.Insert Shift:=xlDown Sheets("Arcade").Range("A36:T36").Select Selection.AutoFill Destination:=Range("A36:T38")...

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

Hi there - I am fairly new to VBA, having mainly recorded macros (and tinkered with them a little) in the past. I am now trying to drag formulas in the final row of a worksheet (columns A:R) from the final date in the worksheet to today's date (dates in the A column). However, when I try this...