N0t Y0urs
Board Regular
- Joined
- May 1, 2022
- Messages
- 96
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- Platform
- MacOS
- Mobile
- Web
Not sure if I can explain this adequately but I will try.
This spreadsheet is a smaller version of the larger picture - Learning big file
What I want to do is (if possible) create a formula that references data in columns title FWD. maybe I am over complicating things here but I will enter the value in the field and ideally it will divisible by 250. So in my tables sheet I reference the FWD amount and will do so till I have created 100 different data sets in total.
Currently, the logic is that the asset will be the same for each data set (so I am about to remove the duplicate information and adjust my current formulas to be anchored) but all the other information will be unique to that data set (DS)
So DS1 has a 125 FWD on row 12 therefore DS2 starts calculating on row 13. This is what I want to streamline. Is there a suggestion in the direction I should explore that will basically say start on row 13?
To complicate this if I have a value of 1250 in the FWD column then that will create 5 new DS’s and it’s not only DS1 that has the FWD value.
I’m quite prepared for this to be to complicated and I manually manage it as it is only 99 entries so to speak.
Thanks
This spreadsheet is a smaller version of the larger picture - Learning big file
What I want to do is (if possible) create a formula that references data in columns title FWD. maybe I am over complicating things here but I will enter the value in the field and ideally it will divisible by 250. So in my tables sheet I reference the FWD amount and will do so till I have created 100 different data sets in total.
Currently, the logic is that the asset will be the same for each data set (so I am about to remove the duplicate information and adjust my current formulas to be anchored) but all the other information will be unique to that data set (DS)
So DS1 has a 125 FWD on row 12 therefore DS2 starts calculating on row 13. This is what I want to streamline. Is there a suggestion in the direction I should explore that will basically say start on row 13?
To complicate this if I have a value of 1250 in the FWD column then that will create 5 new DS’s and it’s not only DS1 that has the FWD value.
I’m quite prepared for this to be to complicated and I manually manage it as it is only 99 entries so to speak.
Thanks