Forum Discussion
Automatically cut and paste data from one date column to the next
Add details and clarify the problem you’re solving. This will help others answer the question. You can https://stackoverflow.com/posts/66321914/edit or https://stackoverflow.com/help/how-to-ask.
Closed yesterday.
(Private feedback for you)
I went back and played around with this and have a better understanding now. I created a name for all of my dates stretched across my excel columns
_Date_Range
I created an excel if formula below
=(IF(_Date_Range>=A7,('B747-800IF Loan'!L24:EI29),0))
A7 = 08/01/2021 start date
'B747-800IF Loan'!L24:EI29 = Financial data from loan spreadsheet
Ex: [Loan 1][1]
This has allowed me to zero out all of the data before 08/01/2021 but it does not give me all of my transposed data from the loan calculation spreadsheet. I lose the first 8 months of my financial data (See below - Loan 2 Jpeg Link)
https://i.stack.imgur.com/ofwfV.jpg
I cannot figure out how to get the financial data to start from the beginning on my desired start date.
I hope this provides more clarity
1 Reply
- Excel community is here:
https://techcommunity.microsoft.com/t5/excel/ct-p/Excel_Cat
also i don't think the first part of your post is necessary, it's coming from Stackexchange site where they closed your post for lack of clarity. it's not closed here
