1
I am an advanced novice at using Excel and I have a problem.
I am using 2 worksheets and want to refer cells from sheet1 to sheet2.
In sheet1 (named "Aktuel") I have a list of all my costumers' information such as name, address, phone number, etc. In sheet 2 I want to rearrange the information so it is a little easier on the eyes when printing out a list of customers.
I've arranged it so that the first customer uses rows 1-7 and columns A-G instead of a single row.
Right now part of worksheet2 looks like this:
A1: Text
A2: =Aktuel!G3
A3: =Aktuel!C3
A4: =Aktuel!F3
A5: Text
A6: Text
A7: Text
My problem is that when I select the cells and drag with the autofill option, the cells referring to the "Aktuel"-sheet jumps.
After Autofill it looks like this:
A8: Text
A9: =Aktuel!G10
A10: =Aktuel!C10
A11: =Aktuel!F10
A12: Text
A13: Text
A14: Text
where I instead want it to look like this:
A8: Text
A9: =Aktuel!G4
A10: =Aktuel!C4
A11: =Aktuel!F4
A12: Text
A13: Text
A14: Text
and then continue onward with:
A15: Text
A16: =Aktuel!G5
A17: =Aktuel!C5
A18: =Aktuel!F5
A19: Text
A20: Text
A21: Text
Is there a way to do this?
I'm sorry for the confusing way of explaining the problem. I don't quite have a rich Excel-vocabulary.
PS. I'm using Excel 2010 edition.