JuicyHMouse
New Member
- Joined
- Sep 22, 2018
- Messages
- 2
Hi all -- this is my first post here although these forums have taught me much of what I know about Excel over the years. Many late nights spent searching here, and I am very grateful. 
However, for this project I am seeing fragments of what I need and was able to construct only partial code using my limited VBA. I hope it's ok to post hypotheticals as the work is confidential, but here is an example version of what I have:
- 1 workbook
In case you were wondering, the rest I can take care of with formulas, and those are already written. Due to the complex nature of the actual data, a pivot table or consolidation would be insufficient for this purpose. The formula I tried to write for this exceeded the number of nested functions allowed, and I feel that even if written more efficiently it was too clunky for team usage.
Any ideas to help pretty up my messy, messy "master" sheet?
Thanks in advance, gurus!
However, for this project I am seeing fragments of what I need and was able to construct only partial code using my limited VBA. I hope it's ok to post hypotheticals as the work is confidential, but here is an example version of what I have:
- 1 workbook
- 3 worksheets (say, 2019!, 2020!, 2021!), not yet populated, with varying lengths/different amounts of observations
- In all worksheets, the number of observations would be determined by the length of the same column (say, $A).
- 1 worksheet (say, 3YRS!), with a column (say, $B) dedicated to each observation in the workbook. I.e., one row for each observation, should be contiguous and dynamic with respect to length of worksheets.
- Column B could then populate with the name of the worksheet it references, such as "2019", or some other string unique to a worksheet.
In case you were wondering, the rest I can take care of with formulas, and those are already written. Due to the complex nature of the actual data, a pivot table or consolidation would be insufficient for this purpose. The formula I tried to write for this exceeded the number of nested functions allowed, and I feel that even if written more efficiently it was too clunky for team usage.
Any ideas to help pretty up my messy, messy "master" sheet?
Thanks in advance, gurus!
I have read your explanation twce and I have no idea what your question is. Your post is a description without telling us what you want. 
