Merging data
Answering RichR's question I've made this example.
You choose the person and all data about it from every sheet appears below.
The formula I used is:
=INDIRECT(ADDRESS(The_One+1,COLUMN(),,,$A5))
Attachment | Size |
---|---|
Example mr. AAA.xls | 27 KB |
Recent comments
6 years 7 weeks ago
6 years 45 weeks ago
7 years 5 weeks ago
7 years 8 weeks ago
7 years 9 weeks ago
7 years 14 weeks ago
7 years 22 weeks ago
7 years 23 weeks ago
7 years 23 weeks ago
7 years 23 weeks ago