Hi,
I am new to macro and would like to get some advices on my excel flow.
I have 2 workbooks: RawDashboard.xlsx & SummaryMatrix.xlsx.
1st workbook is the raw data file with different Project Names. e.g: KIWI, MANGO, APPLE (in row)
Each Project has 4 Gate Types (PDR, IDR, RRR, PRR in column) & status (APPROVED / PENDING in column). With its respective scheduled date.
In this case, I am just concerned for APPROVED status.
2nd workbook is the summary matrix.
Aim is to make sure the scheduled date in RawDashboard.xlsx is updated to SummaryMatrix.xlsx
according to correct project name and its respective gate type.
For those approved project, the date need to be updated in SummaryMatrix.xlsx and stroke with line.
For those project status that couldnt find in RawDashboard, dont need to do anything.
I am stucked at the conditioning part, in terms of updating the schedule according to project name and its gate type.
As well as macro coding on how to enable RawDashboard.xlsx to grab the data and update to SummaryMatrix.
Please help. You help is much appreciated!
Bookmarks