drag and fill

Just found that when I drag cells in a series the number that used to show in the bottom right corner to show what number/date etc you had dragged to has disappeared - the number/date etc updates in the name box - just annoying to keep looking in the top left of the spreadsheet as I drag - any...

I am trying to figure out a way to drag my formulas vertically, but have them increase their reference by one column. For instance, the first image shows the main table where the formulas would be located (summary). Group A's data is in the second figure. I would like to average all the values...

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

Hello everyone, i need help I want to autofill drag down data from other sheet but skip every 1 row I.e On Sheet1 D5 = Sheet2!B2 D6 = Skip D7 = Sheet2!B3 D8 = Skip D9 = Sheet2!B4 On sheet2 B2 B3 B4 B5 Thank you

Hey guys. I will try and explain this in as much detail as I can and hope you understand! So effectively i have a data set of around 370,000 rows of data, one row (price) for every minute of the year. However, there are many minutes that are missing and thus i need to flag them as missing by...

Hi guys when i drag and fill, i want skip 2 rows and force not filling 2 rows (2 rows are in every page and i can't insert any formula beacuse in my workbook, all cells filling with a formula) anyway ignore this 2 rows in every page when i drag and fill? (for example i drag and fill 34 cell in...