I have a worksheet which has a pivot table with a list of names. The next worksheet needs to reference the first name. This is done as =PivotTable!B10. The next cell requires to reference as something like =PivotTable!B10+3 because the next text appears after 3 rows.How do we do this? How do we increase the step value for a text? Please helpI'am out of my wits
Bookmarks