excel code needed

Hello, i have a VBA code that sends data from excel to one of three access databases. Table1 and Table2 work great. but the data for Table3 is sent to a TempTable. From here, the all the data in TempTable is linked with 5 columns in Table1 in an Append Query. Up until here everything works...

Hi All, First post here, everyday i have someone go around and record the hours on a machine kms or machine hours worked (SMU) i need to build a service register. for example i have a lighting plant that needs a service every 250hrs and every 1000hrs a more indepth service, i currently have...

How can I create a code that will compare sheets and replace another column when there is a unique identifier found. Sheet 1 and 2, column A will contain a unique ID but they wont be in the same order. Sheet 1 and 2 will have column B containing non-unique data. I need for sheet 1 column B to...

Hi Guys, I need help regarding calculating and setting values of hours for the dates as shown in figure. in the Excel spread sheet. For example A B C D E F G H I J...

Hi Guys, I need help regarding calculating and setting values of hours for the dates as shown in figure. in the Excel spread sheet. For example E F G H I J K L M Round Est. Time StartDate Weeks 8/18 8/25 9/1 9/8...

I have value XXXXX that I am trying to have updated the value in Cell C$ in several sheets. I would like to create a template for simple updating products ID. -- removed inline image --- Can you help?!?! Is this possible?

Need Help, need a code to randomly mix cells I have a list of 5000 names and would like to mix up the names and place them into another column or page. Is there a code that would make the mix of the names different every time? Do not want to have same outcome every time. Please help, thanks...