This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
In Excel; I have a labor distribution sheet that i need to auto populate when the actual hours from the time clock are pasted in another sheet, I could do this with V LOOKUP, but I also want it to subtract time they may have spent in 2 other departments, each department has it's own range on the main sheet. I'm wondering if VBA would be a good option and how to go about that. Or is there a better option?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
We need to see your (sample) file.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community
Andreas.