Hello,
I am having some problem with dates
I have 2 workbooks
First workbook name is Test, there in sheet SQL2 in cell H2 I have a date
I want excel to jump to specific column in other workbook (Data) which has same date as my number in cell H2 from Workbook test
All dates in second workbook is in row 4 from AE to NC range
So basically if I enter date 27/06/2023 I want excel to jump to column which has same date
Can you please advice how this is possible?
After moving to that column I need to copy some data from selected cells
I am having some problem with dates
I have 2 workbooks
First workbook name is Test, there in sheet SQL2 in cell H2 I have a date
I want excel to jump to specific column in other workbook (Data) which has same date as my number in cell H2 from Workbook test
All dates in second workbook is in row 4 from AE to NC range
So basically if I enter date 27/06/2023 I want excel to jump to column which has same date
Can you please advice how this is possible?
After moving to that column I need to copy some data from selected cells