LinkBack URL
About LinkBacks
Try this...
Let's assume the data is on Sheet1 in the range A1:A10.
Enter this formula in cell A10 of the other sheet and copy across to J10:
=INDEX(Sheet1!$A1:$A10,COLUMNS($A10:A10))
Try this...
Let's assume the data is on Sheet1 in the range A1:A10.
Enter this formula in cell A10 of the other sheet and copy across to J10:
=INDEX(Sheet1!$A1:$A10,COLUMNS($A10:A10))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks