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. ![Thumbs up :beerchug: :beerchug:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f44d.png)
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!
![Thumbs up :beerchug: :beerchug:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f44d.png)
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!