log

Hi All, I'll try to explain this as simple as possible: I have two excel files/workbooks, 1) Call Log A 2) Call Log B Process: Whenever I receive a phone call, I log information into Call Log B first, which then gives me a Confirmation Number (Unique Identifier). I then have to manually re...

I need some help with a macro in an excel file (active X) to send data to a log file. I have a starting point that worked for a previous version of the file I’m using now. This is a macro I use to update a log that captures specific information from a form I have. It will open the log find the...

I have created a data log in excel that shows all of the changes that have been made in my workbook. How would i create a line graph that just tracks the changes in some of the cells, that also automatically updates when one a change is added to my log? Thanks.

Hi All Please can you help me the best possible way to ensure I capture this I have a workbook that I send out via email to people. In this workbook, in the workbook open code, I keep a log and update another excel file with the userid and timestamp regardless of whether the workbook I sent is...

Hi, I currently have a running invoice log which has the following steps: Paste booking confirmation into Paste tab Invoice log looks up to relevant fields from paste tab to fill in log Pro-forma tab looks up to the invoice log to make an invoice, which I save as a PDF. The invoice log has...

Hi, I wonder if anyone could help me please? I've written the following to export the data in a spreadsheet to Word, and this works fine (albeit slowly!). However, it pastes into Word in a table form and because I then need to copy the Word information into a log in a separate system I need...

Hello Everyone, I am working on a template where we need to show the history of all the changes that have been made to the template. Also, another way to use the Change Log data is for comparison purposes. Anyways, is there a way to have a tab in this template (called 'Change Log') where it...

Having trouble with this formula. In column A of Sheet1 i have a list of Log ID which show up either, MFG010318134515 or PURCH010318164059 which the numbers are time stamp and MFG or PURCH will be added via userform. What im trying to do is take all MFG Log ID and past into Sheet2 column a so...

We had a third party programmer which built us a macro that uploads photos to secure FTPS in a module in Excel VBA. He was using PSCP a putty protocol. When initiating the macro it seems as we are able to connect to the FTPS and we get a CMD window that indicates that the files are being pushed...

Hello I would like to make it so a cell fills in yes or no based on the content of another cell. <tbody> Start Shift End Shift Total Hours 06:00 18:00 12:00 </tbody> Example... <tbody> Start Log End Log Total Hrs on Log Time Diff Shift vs Log Violation? 06:00 18:00 12:00 0:00 No...

Hi I have a loop like below: For i = 2 to Ubound(Unit) m = 0 Do m = m + 1 Loop until Data(m,1) = Unit(i,1) and Data(m,4) = NoC(i,1) 'then do something once you found match Next i However sometimes there is no match and i want it to log on a sheet named error for which Unit(i,1) there was...

I have a Macro code that runs smoothly on my first sheet "RA LOG" once the info is copied and pasted to "RECEIVING LOG" im having trouble getting the macro to cut and paste to "TROUBLESHOOT" sheet. Below is the code i currently have for my "RA log" Option Explicit Public Sub ra_log_execute() '...

I am in need of formatting this macro to my other sheets in my workbook. However, the problem i am encountering is that the second sheet "receiving" that the row data is pasted to has different columns and i need this to cut and paste to the third sheet "troubleshoot" not copy and paste. Option...

i have made a userform to log in ..if user types 3 times incorrect details .. it must quit workbook there is a issue with my file with the "start task manager" if they press quit Microsoft Excel. before Quitting it is asking save,dont save,cancel if user press cancel button they can access my...

Hi all, I have created a form on Excel that once filled in I would like a log with some of the cell values to be populated on a separate worksheet. Does anybody know where I would start with such a thing? I am happy to share the workbook if required... Many thanks,

Hi I would like to seek assistance on how to write the codes to log into the website by inserting my user ID & password automatically. Below is the current HTML codes for the website: Log In to Your Account</p> </div> <div class="clearboth"> </div> <div...

Hi all, I was wondering if there is any way to create a simple log in excel, that logs the date and time of opening and closing of Office files? Do any of you guys have any idea on how to do that? Thank you in advance Best regards

At work we have a paper card stock "form" and a paper log book used as a control whenever a system is opened. Every time someone needs one of these forms we hand fill out one of these cards and make an entry into the log book (well it's time to move into the 21st century). The log book part is...

I am working on a project that I need excel to detect the users log in and automatically select there name from a slider so it only shows data applicable from them can anyone help please