Sorting Data Using Cell references

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I do research for mailings and find that if I can create my lists in Excel, I can readily import them into Outlook to make mailing labels.

I created a list of addresses and telephone numbers in Excel, and they are listed in in the range A1:A209

Format is as follow
Nam
Addres
City State Zi
Phon
Blank ro
Repeat Name..

I'd like to know how if I can sort this data from one column into four columns (Name, Address, Location, Phone). Someone told me that it can be done using cell references, but the concept escapes me. I've tried to create a macro for it, but I'm not very knowlegable in Visual Basic to get it right. Thanks for your help. - SJ
 
Hi
try the following (assumption: there are always 4 data row and on blank
row the data is on sheet1 and starts in A1)
- enter the following formula in cell A1 on sheet2
=OFFSET('sheet1'!$A$1,COLUMN()-1+(ROW()-1)*5,0)
copy this formula to the right (4 columns) and down

- after this select this data range and copy this range (CTRL+C)
- now goto 'Edit - Paste Special' and choose 'Values' to insert the
data (and removing the formulas)
 
Back
Top