![]() |
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