Automatically cut and paste data from one date column to the next

%3CLINGO-SUB%20id%3D%22lingo-sub-2162707%22%20slang%3D%22en-US%22%3EAutomatically%20cut%20and%20paste%20data%20from%20one%20date%20column%20to%20the%20next%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2162707%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CDIV%20class%3D%22grid%20fd-column%20fw-nowrap%22%3E%3CDIV%20class%3D%22grid%20fw-nowrap%22%3E%3CDIV%20class%3D%22grid--cell%20wmn0%20fl1%20lh-lg%22%3E%3CDIV%20class%3D%22grid--cell%20fl1%20lh-lg%22%3E%3CSTRONG%3EClosed%3C%2FSTRONG%3E.%20This%20question%20needs%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fhelp%2Fclosed-questions%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Edetails%20or%20clarity%3C%2FA%3E.%20It%20is%20not%20currently%20accepting%20answers.%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CHR%20%2F%3E%3CDIV%20class%3D%22grid%20fw-nowrap%20fc-black-600%22%3E%3CDIV%20class%3D%22grid--cell%20mr8%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22grid--cell%20lh-md%22%3E%3CP%20class%3D%22mb0%22%3EAdd%20details%20and%20clarify%20the%20problem%20you%E2%80%99re%20solving.%20This%20will%20help%20others%20answer%20the%20question.%20You%20can%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fposts%2F66321914%2Fedit%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Eedit%20the%20question%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eor%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fhelp%2Fhow-to-ask%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Epost%20a%20new%20one%3C%2FA%3E.%3C%2FP%3E%3CP%20class%3D%22mb0%20mt6%22%3EClosed%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22relativetime%22%3Eyesterday%3C%2FSPAN%3E.%3C%2FP%3E%3CP%20class%3D%22mb0%20mt6%20fs-fine%20fc-black-500%22%3E(Private%20feedback%20for%20you)%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22mt24%20grid%20gsx%20gs8%22%3E%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fposts%2F66321914%2Fedit%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EEdit%20question%3C%2FA%3EDelete%20question%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3EI%20went%20back%20and%20played%20around%20with%20this%20and%20have%20a%20better%20understanding%20now.%20I%20created%20a%20name%20for%20all%20of%20my%20dates%20stretched%20across%20my%20excel%20columns%3C%2FP%3E%3CPRE%3E_Date_Range%3C%2FPRE%3E%3CP%3EI%20created%20an%20excel%20if%20formula%20below%3C%2FP%3E%3CPRE%3E%3D(IF(_Date_Range%26gt%3B%3DA7%2C('B747-800IF%20Loan'!L24%3AEI29)%2C0))%0AA7%20%3D%2008%2F01%2F2021%20start%20date%0A'B747-800IF%20Loan'!L24%3AEI29%20%3D%20Financial%20data%20from%20loan%20spreadsheet%0AEx%3A%20%5BLoan%201%5D%5B1%5D%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Loan%20Data.jpg%22%20style%3D%22width%3A%20624px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F257407i9BD91AA0CC62A37A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Loan%20Data.jpg%22%20alt%3D%22Loan%20Data.jpg%22%20%2F%3E%3C%2FSPAN%3E%0A%3C%2FPRE%3E%3CP%3EThis%20has%20allowed%20me%20to%20zero%20out%20all%20of%20the%20data%20before%2008%2F01%2F2021%20but%20it%20does%20not%20give%20me%20all%20of%20my%20transposed%20data%20from%20the%20loan%20calculation%20spreadsheet.%20I%20lose%20the%20first%208%20months%20of%20my%20financial%20data%20(See%20below%20-%20Loan%202%20Jpeg%20Link)%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fi.stack.imgur.com%2FofwfV.jpg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ELoan%202%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Loan%20Data%202.jpg%22%20style%3D%22width%3A%20624px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F257406i5F3D2E6975ED11D3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Loan%20Data%202.jpg%22%20alt%3D%22Loan%20Data%202.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20cannot%20figure%20out%20how%20to%20get%20the%20financial%20data%20to%20start%20from%20the%20beginning%20on%20my%20desired%20start%20date.%3C%2FP%3E%3CP%3EI%20hope%20this%20provides%20more%20clarity%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2162707%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECommunity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
Closed. This question needs details or clarity. It is not currently accepting answers.

 

Add details and clarify the problem you’re solving. This will help others answer the question. You can edit the question or post a new one.

Closed yesterday.

(Private feedback for you)

Edit questionDelete question

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]
Loan Data.jpg

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)

Loan 2

Loan Data 2.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