Hi All,
I am trying to re-organize information from one sheet to another. However, when I try and autofill once I've put in a few formulas, the autofill will skip a number of cells from the first sheet. It looks something like this -
='Sheet1'!K2&" "&'Sheet1'!L2
='Sheet1'!K2&" "&'Sheet1'!L2
='Sheet1'!K3&" "&'Sheet1'!L3
='Sheet1'!K3&" "&'Sheet1'!L3
Then when I try and auto fill down it will jump to:
='Sheet1'!K6&" "&'Sheet1'!L6
='Sheet1'!K6&" "&'Sheet1'!L6
='Sheet1'!K7&" "&'Sheet1'!L7
='Sheet1'!K7&" "&'Sheet1'!L7
How can I get it to consistently copy down so that it is K2, K2, K3, K3, K4, K4 and not skip some of those cells? Any help would be hugely appreciated!
Bookmarks