How do i refer to every other column in another spreadsheet
for example i want sheet1 A1,B1,C1 to come from sheet 2 B1,D1,F1.
In A1: =Sheet2!B1, etc.
---
Ben Van Johnson
In cell Sheet1!A1 use something like:
Cheers,=INDEX(Sheet2!1:1,1,COLUMN()*2)
“To sin by silence when they should protest makes cowards of men.” ~ Abraham Lincoln
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks