MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Moving column info between sheets

Posted by Mike B on May 31, 2001 3:16 PM


I am trying to move all the info that is typed in one column into a column on another sheet.

For example, info typed in A1 through A48 will appear in D1 through D48. This information is text and not numbers so I don't want a pivot table (I think).



Posted by Edd on June 01, 2001 3:18 AM


I assume all you are trying to do is link for example cells D1 to D48 in the same range in column A. This can be done simply by inserting the formula : (=sheetname!a1) into D1 and then autofil down through the range (Highlight d1 and drage down to d48). Hope this is what you meant.