furnitureman
New Member
- Joined
- Dec 13, 2018
- Messages
- 1
Greetings all,
I am very new to VBA and dont really understand how to use it. I am trying to create a running spreadsheet that has two sheets.
Sheet one has columns: Job #| Part #| Part Name | Date/Time Entered | Date/Time Due | Date/ Time Completed | HIT/ LATE
Sheet one is a running log of each of those items, while sheet two I want to make a running countdown timer of whichever product in sheet one that doesn't have a "date completed" entry. So that Sheet two pulls all information from sheet one to countdown until due date until a date completed is entered into sheet one, where after it is completed, the "completed row" disappears off of sheet two. I would like to make it so that when the countdown is 8 hours or less, the cell turns red with white letters to indicate that it's nearing its due time.
Can anyone provide some insight on how to code such a worksheet?
Seriously thank you so much if you can help me wrap my head around VBA
I am very new to VBA and dont really understand how to use it. I am trying to create a running spreadsheet that has two sheets.
Sheet one has columns: Job #| Part #| Part Name | Date/Time Entered | Date/Time Due | Date/ Time Completed | HIT/ LATE
Sheet one is a running log of each of those items, while sheet two I want to make a running countdown timer of whichever product in sheet one that doesn't have a "date completed" entry. So that Sheet two pulls all information from sheet one to countdown until due date until a date completed is entered into sheet one, where after it is completed, the "completed row" disappears off of sheet two. I would like to make it so that when the countdown is 8 hours or less, the cell turns red with white letters to indicate that it's nearing its due time.
Can anyone provide some insight on how to code such a worksheet?
Seriously thank you so much if you can help me wrap my head around VBA
