Hi folks,
I am like a lot of other posters on here an absolute novice when it comes to Excel and VBA's, Macro's etc.... but i find myself in a position where i am required to make a easy system for tracking orders. The shown table will be copied hundreds of times in 1 excel sheet and after the table is marked done we will manually cut it out of the sheet and paste it into another folder for archiving purposes so the cell numbers will change. What i am trying to do is make it so that when the other person clicks on the DONE button it inputs the date and time automatically in the cell under the DONE button. But again as the cell numbers will be different in each table i can't assign a cell number for it, is there a way for this to be done. The same is also required for the Delivery and Collect buttons i have on the table. My plan for this would be whichever one is clicked shows up in the cell to the right of the buttons. I hope i explained myself in a somewhat clear manner but if not please let me know. And apologies if this has been shown before, i couldn't find it.
Any help with this would be greatly apprecaited
BB
I am like a lot of other posters on here an absolute novice when it comes to Excel and VBA's, Macro's etc.... but i find myself in a position where i am required to make a easy system for tracking orders. The shown table will be copied hundreds of times in 1 excel sheet and after the table is marked done we will manually cut it out of the sheet and paste it into another folder for archiving purposes so the cell numbers will change. What i am trying to do is make it so that when the other person clicks on the DONE button it inputs the date and time automatically in the cell under the DONE button. But again as the cell numbers will be different in each table i can't assign a cell number for it, is there a way for this to be done. The same is also required for the Delivery and Collect buttons i have on the table. My plan for this would be whichever one is clicked shows up in the cell to the right of the buttons. I hope i explained myself in a somewhat clear manner but if not please let me know. And apologies if this has been shown before, i couldn't find it.
Any help with this would be greatly apprecaited
BB