Hi
I've completely forgot how to do this, I have a spreadsheet with a set of data, its for recording weekly takings. The way the sheet was set up you highlighted a specific cell by using keys clt + n this would copy the cells and put a new lot of blank cells directly under the previous one with all the formula/s in tact.
I.va attached what I think it looks like
Thanks
toddp
sample.xlsx
I've been looking and its a macro but when I click on the cell rather than creating the next set of cells it creates a new worksheet
Bookmarks