farnuckl
Board Regular
- Joined
- Dec 16, 2003
- Messages
- 127
i have a sheet where i am tracking data. the first column is the date and has job volumes in it. the next column is the hold column: if the job isn't done i put an "x" for that job and it is not summed in the date column(using sumif). next to that i have the completed column. here i put the date the job is completed. so there is three columns for each work day in the month.
i would like to have the corresponding job volume be summed into the total for the date specified in the completed column.
i wouldn't mind being able to combine the hold and completed columns if possible.
i have no VBA experience but wouldn't mind an excuse to learn if necessary.
anything to even get me in the right direction would be appreciated.
thanks.
i would like to have the corresponding job volume be summed into the total for the date specified in the completed column.
i wouldn't mind being able to combine the hold and completed columns if possible.
i have no VBA experience but wouldn't mind an excuse to learn if necessary.
anything to even get me in the right direction would be appreciated.
thanks.