ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Indirect and Address in Reference to other sheets (https://www.excelbanter.com/excel-worksheet-functions/40056-indirect-address-reference-other-sheets.html)

MikeDH

Indirect and Address in Reference to other sheets
 
I need to have a column auto-updating from every-other column of a row on a
different worksheet - literal example:

'ValleyResultsVsBadDay' column A is identical to Column (B,D,F,H,J,L, etc. -
all the even-indexed ones) Row 5 of 'ValleyLots'.

Is there a way to use Indirect and Address to refer to a different worksheet
like that, or is there a simpler, quicker way to make a function for that
task?


All times are GMT +1. The time now is 02:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com