log

Still trying to get my head round VBA, would appreciate the help hear If Worksheet Call Log, cell F has Mitch entered Copy and paste to next blank row Worksheet Bid Log, Cell C = Worksheet Call Log cell D Cell D = Worksheet Call Log cell E Cell E = Worksheet Call Log cell F Cell F = Worksheet...

Hello All, I have made two previous codes that copy cells from one sheet that is a form and paste them in the next blank cell on another sheet that is a Log sheet. They looked something like this: If COStatus = "INITIATED" Then InitiatedDate = ActiveSheet.Range("F3") 'Copies Values...

Hi All I have Log In Security within a Workbook which is activated by Clicking a button [CommandButton2]. However, what I need is, if a User clicks the other button [CommandButton1] then it will open the workbook and all sheets [except Admin & Lists] so they can view the content. I cannot work...

Hello all. on Sheet LOG i have a column (AD) with Peoples names and this would be the column where I want another Sheet "Summaries" that has a Table of A1 to D53, Col A has the peoples names (on Summaries sheet), Col B has number of flights and col C has Flight times. I would like the tables...

Hello, I am trying to have a certain cell on a form be populated at all times of a currency value on another sheet that is log. Basically, I need it to look up the Last value/cell that has a value in it in Column E on the Log Sheet.1. Do I use Lookup or Vlookup to tackle this? 2. Would I Call...

Help needed, Goal - Move cells data from one worksheet to next blank row to cells in another worksheet when criteria from first sheet is met. Entry worksheet named 2018 Call Log, copy data and paste to worksheet Sales Log next blank row Criteria to be met in worksheet 2018 Call Log column L is...

Help needed, Goal - Move cells data from one worksheet to next blank row to cells in another worksheet when criteria from first sheet is met. Entry worksheet named 2018 Call Log, copy data and paste to worksheet Sales Log next blank row Criteria to be met in worksheet 2018 Call Log column L is...

I just spent about 30 mins on a post and when I went to submit it I got a message saying I had been logged out and had to log in again. As a result, I lost my post. >> Why did it log me out !!!

Hi All I have a spreadsheet where I have inserted Hyperlinks to make it easier to get to certain websites Is there anyway of also getting these to auto log in when clicking on them. This way to save having to log in also Thanks

Hi, I have a worksheet in Excel that is a log of transactions (after we run a process, we paste the log information at the bottom to maintain all history) What I would like to be able to find out and include in a separate worksheet in the same workbook file, is how many Unique end users did we...

I am receiving an "unable to get the log property of the worksheet function class" error on the line immediately below. I've traced the error back to the construction of "TempSample". When I hover my mouse pointer over counter variables "oo" and "rr" I read "36" which is outside of the range...

I know. I know. I've seen this on here a million times, but I've tried several codes, altered them with my info, and they just don't work. I have a project log where multiple users update their progress on certain tasks. When a task is completed I'd like the row with that task cut and pasted...

Hello, I'm not sure how to explain my question, as I'm not familiar with the Excel Lingo, but here goes. I have created a calculator for position sizing of stocks. It's very basic. Just a few inputs and the other data are calculated - brilliant. Now, as time passes, I'd like to keep a log of...

Hi, I am looking for a login and logout time tracker for my team. Below is what i have in my mind any better ideas are much appreciated. 1.When User Enter the Employee ID in Sheet 1 Page, it should fetch the name from "Sheet 2"(Data). More people will be added later 2. When LOGIN Button is...

I’m not sure if I’m posting this to the right place but any advice I can get will be appreciate. I want to Automate the downloading of files from 2 websites using Excel VBA. The first website Log on page has name’s and id’s for the Log on elements. The problem with the first website is that...

I posted this in the excel board asking about the old get data from web menu which was out with PQ, but i guess it is more relevant to PQ I have created a query that returns competition scores from various web pages within the How did i do web site (golf scores). On my old laptop, which has...

Hi, I am trying to convert all my SUMIF formulas to SUMPRODUCT so that the referenced workbook does not need to be open. I have tried myself but cannot seem to get it to work. Here is an example of the formula: =SUMIFS('[Mileage Log 2018.xlsm]Advisors'!$D$4:$D$15,'[Mileage Log...

Hi there! On an Access report, I'd like to add the total hours worked based on 4 fields that produce the following times: 1. initial daily log in, 2. log out for lunch, 3. back in from lunch, and 4. End of Day logout. Can I use the Expression Builder (Design View>Property Sheet>Data...

Hi All, Hoping someone could help me with a VLOOKUP formula. I'm trying to match the value of the cells in column E with the cell values in column A and C and if there is a match, add the values of their corresponding (neighboring columns) counts in column F. Here is a snippet of data. I've...

Every quarter, I have to do bonus statements for our sales rep. Part of that includes giving them the detail that make up their sales for the quarter. I have a master spreadsheet that contains all of the information for all of the reps. Normally I filter that for each rep, copy and paste their...