tracking

I've been tasked with a project that requires something more robust and secure than Excel macros. In the distant past, I wrote projects like this using Visual Basic. Since Visual Basic has gone the way of the Pony Express, it's not an option. I was thinking about using Visual Studio, but...

Hello Newbie here! Need some help on how to exclude some sheets from tracking (Note: vba was used already to track any changes in the workbook). I had a code and i can post if it is needed. Any help would be much appreciated. Thank you in advance

Production Sheet dropbox link: https://www.dropbox.com/s/vi2zpdo86euia3d/Production%20sheet%20%28TEST%29.xlsm?dl=0 Extrusion Tracking Dropbox link: https://www.dropbox.com/s/5rn7wcsy62bupcl/Extrusion%20Tracking%20TEST.xlsx?dl=0 On the Production Sheet, cells K3 through K5 will contain scrap...

Production Sheet : Dropbox - Production sheet (TEST).xlsm Extrusion Tracking: Dropbox - Extrusion Tracking TEST.xlsx Need the SCRAP totals from K3:L5 of the Production Sheet to be added to the existing totals in Column P of the Extrusion Tracking spreadsheet, into the corresponding row...

I'm attempting to write a macro that will capture the values on the production sheet and disperse them onto the Rewinder Tracking sheet in the appropriate column/row. Capture from Production Sheet Cell Add to Existing totals on Tracking Sheet in Column F5...

Greetings All! I'm looking to make an excel document that would track our team, and their availability down to the hour (or maybe even half hour) for any given week. I will be starting just with a general schedule, a table of each volunteer showing their certifications and what hours they're...

So, I dont know exactly how to explain this.. I am building a database with a query function that looks at a table and lists every reason that is text and not a number... That was easier to explain than I thought... It needs to ignore 0s and ignore reasons its already used.

Hello Everyone, I need a way to calculate the hours and minutes worked on a file. So Cell A2 would have hours and minutes worked. Cell B2 has a drop down called Started. So i want excel to start recording the hours and minutes worked once someone selects started in B2. B2 also has Hold and...

Currently have a material tracking workbook which uses a table for organizing. I am hoping someone can help me with producing a code in marco which will insert a new row to "cancel" a specific item by showing the negative value underneath...

I am tracking hours and calculating paid leave based on the total hours worked from the beginning of the year. Looking for an automated way to calculate accumulated totals from a continuously changing input from a different sheet (or same sheet). I have a "Clear All" button to clear all input...

Good morning, I am using excel 2010 and I have 2 sheets that I work with regularly. One is a list of staff, both current and past. This sheet is set up to filter out 'current' and other employees based on their employment status. The other is a sheet that I use to track all of the training...

I hope I can explain this clearly in words as it is in my mind!:) Lets say I have C2, D2 and E2 as my cells for vendor costs, IT costs, Employee costs (or whatever, the actual table has a lot more components) B2 is just summing these up. So B2= sum(C2:E2) in this case. The thing is as I get...

I have a spread sheet that I use to track various employees hours on various design projects. Each employee creates one tab for each month. In addition to the total hours that I can easily sum at the end of the month, I'd like to be able to see how many hours per week the person does. The...

Hi i need help building a Simple work sheet for 6 fleet vehicles, its needs to set up in a way, where i can update oil level on a daily basis and when it comes below 2 bars, it highlights in a different colour, please help in building this sheet, i have seen it done , i just cant figure out how...

Hi there, I'm trying to modify some code on a file that has about 30 different modules without any descriptions. Is there a way I can track back to see which module has the code assigned to populate the cells I want the code modified for? Kind of like "find connections" in excel? Many thanks!!

I'm looking for help with an excel function/macro that could use a barcode scanner to first scan the ID badge and then next an "activity" barcode (ex, shipping, packing, etc..). When the ID is initially scanned I would like the current time to be automatically entered. Next, when the barcode...

I'm trying to write a macro to pull up a webpage with a tracking number, return the delivered date, then move to the next tracking code to do the same. I want that to continue down the spreadsheet until there are no more tracking numbers. This can't start at a particular cell every time because...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I've searched the threads and do not find one that fits what I am trying to accomplish. I am trying to set up a worksheet that will track sick and personal leave. Here is the...

Hi, Im trying to make a spreadsheet in which I can choose the date from a dropdown menu and fill in data for that date. so far my sheet looks like this: month is a dropdown choice at top of page, which automatically adjusts the columns down the "A" to populate with correct dates and days for...

Hello All, I have a schedule setup where the D column is the starting time and the E column is the finish time for a shift, Now I am trying to figure out how many people are scheduled within a certain hour. Each employee has their own row starting with 4 and going down to 60. D is the start...