Hi all,
I wish to copy a formula across in excel leaving 2 blank columns after every set of data.
For Instance: in Sheet1 column A1 i have a value
'' '' B1 i have a different value
Now I wish to copy in Sheet2 in column A1 the value =Sheet!A1
'' '' '' D1 the value = Sheet!B1
I wish for such a formula to drag across. I have read other posts but in those they have wished for data to skipped rather than allocated to a different column. I have also left 2 columns intentionally blank and dragged but excel has failed to notice the pattern.
Any help would be appreciated.
Bookmarks