denesh3560
New Member
- Joined
- Sep 21, 2020
- Messages
- 3
- Office Version
- 2010
- Platform
- Windows
Hi everyone,
My main excel file has a series of dates in one row.The column part will be my different type of project. Under each dates, i will fill up names, process, quantity in one cell at its specific dates at specific project.
Is there a way in excel where when i enter the 3 data in the cell, it will automatically link the 3 datas and its specific date to another worksheet where it will tabulate the data in 4 columns where it will consist of the specific date, name, process, quantity.
Note: Some projects will not have any progress on that day thus the cell will be blank. The blank cell shouldnt be include in the table.
Thank you
My main excel file has a series of dates in one row.The column part will be my different type of project. Under each dates, i will fill up names, process, quantity in one cell at its specific dates at specific project.
Is there a way in excel where when i enter the 3 data in the cell, it will automatically link the 3 datas and its specific date to another worksheet where it will tabulate the data in 4 columns where it will consist of the specific date, name, process, quantity.
Note: Some projects will not have any progress on that day thus the cell will be blank. The blank cell shouldnt be include in the table.
Thank you