Repost- have attached the workbook correctly this time
Hey Guys
I have a question about index or offset style referencing over multiple tabs.
i have explained my question is this short video https://youtu.be/BB6_2Moj8lU
any help greatly appreciated.
Dax
1. Your file contains links to external workbooks that we do not have.
2. Explanations via YouTube is generally not very popular here. Written words are easier to refer back to when one gets confused,
3. Your file contains NO expected results, making 2) even harder to follow.
4. Please amend your sample file.
>>>ALSO<<<
Is your forum profile showing the Excel PRODUCT that you need this request to work with?
The best solutions often rely on knowing WHICH Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date. If you aren't sure, in Excel go to File/Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.
The three most recent Excel PRODUCTS are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the Version number in your profile (e.g. MS365 (PC) Version 2211). The version number is in the About Excel section further down the Account page.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks for the reply Glenn,
Try the attached workbook instead.
I used a video as I couldn't work out how to explain that effectively in written text.
Have updated my profile also. current version os MS 365 version 2301 PC
Thanks in advance
Ta. I think I follow. I deleted the expected results from B&D down to row 18.
For the B columns:
=TRANSPOSE(Hull!O44:U44)
for the D columns:
=TRANSPOSE(Hull!O6:U6)
Is that what you had in mind??
That looks pretty good Glenn. I have not come across the "Transpose" function before, that looks to be interesting.
it would be great if your formula used something the "formulatext function so i could have 1 reference cell for each tab.
I made a short video explaining better here https://capture.dropbox.com/E67IYobklx8Fhcsp
I'm sitting in a clearing on an island on a rainy day in SW Thailand. My www connection is not good. I cannot see the video. Explain in writing.
I saw bits of it...
WHY?
In your sample, the data always start on row 6 (col B) and row 44 (col d)...
Because I have many more cells to reference that are not yet part of that workbookOriginally Posted by Glenn Kennedy
You will have to explain in words (not videos) what on earth formulatext has to do with anything!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks