underneath

Hi how can i copy a value and paste it lets say 10 times underneath with vba? Thanks, AAT

Hello, I need a new row if a2<>a3 = insert new row in a4, so the new row should be right underneath a3, for the all data in the a:a column

I have data in columns N to S - starts at row 4 and can go down to row 1000 (number of rows can vary) I want to; - copy columns N to O plus column P to a new tab - copy columns N to O plus Q underneath that data - copy columns N to O plus R underneath that data - copy columns N to O plus S...

Can someone provide me the hlookup formula based up a date? In another words, if the date changes the value underneath will change accordingly in a separate summary tab. Thank you

Hi All,I'm searching for a VBA approach to do a lookup.I want to search for a cell value in a column, and return the next 2 adjacent values (columns B&C) to the right of the search. Some cell values have MULTIPLE matches, and I'm looking to see how I can auto add rows underneath and return all...

Hi, I'm looking for a shortcut to change a date in a cell to the next day. So for instance; i have a cell with 01/Jan/2017 and I want to change the date in that cell to 02/Jan/2017 (not the cell underneath - I know about the drag function which will copy or increase the date in cells...

Hi I am having troubles trying to get a ranking formula to work for more than 1 student easily. I have managed to get it to work for 1 student fine but then looking for a way to copy the formula easily to the students underneath such as in the picture. Any help would be appreciated. For...