record

Hello guys i need your help i want to get only 1 record with a multiple duplicates of dates but im always getting all the Training hours of a duplicate dates. How can i solve this can you please give me a sample formula using Sumproduct. Thanks!

We are considering switching from MS Access to Excel for a simple (??) time logging system Using our access database, when a worker starts a new part of a job they go to the computer, grab the barcode scanner. They scan their name, the process the are embarking on (e.g Bending, or threading)...

I have developed a User Form with VBA that records data in three worksheets in the same workbook. I have coded Search button to search a customer name who is about to pay and Pay Now command button that will record amount payed. Amount to be payed is entered in FeeTextBox in user form...

Very complicated one here so I won't explain why I need this.. I want to create a button that when clicked a pop-up appears saying "Enter URN". When the user enters this info, the record with that URN is updated. It will update by adding a number to the 'CompNo' field which will be Maximum...

thought it might be easier to provide the basic idea with code rather than try to explain it. I am trying to take one record from "Entries" and paste into the "basic" worksheet, print the sheet (one per record , then clear contents for the next record to be copied and printed. End the end I...

Hi, I’m fairly newto generating macros. I’ve been using record macros, but it’s not workingexactly the way I would like it to. 1. On tab “KIT”, select cell “O2” 2. Copy (In the example the text in O2, is “test”) 3. Go to tab “PLAN”, select column “B:B” 4. Find & paste 5. Close Find...

In Excel, you can easily record a macro to create a chart and manipulate it. Alternatively you can write the code from scratch to arrive at the same result. Is it possible to record the actions / write code to automate the actions in Power Pivot / Power BI?

Good morning; I have a data model that connects to about 10 tables Is there a way to create a summary spreadsheet that shows total amounts and record counts for each of the tables? Thanks

I have a table with all my Customer Orders and I'm trying to return a single record for the Earliest OrderPlaced but I cannot for the life of me return the single oldest Order Number according to the CustomerID. I have 2 tables: CustomerOrders Customers OrderNumber (pk) CustomerID (pk)...

Hi all, I have a repetitive process that I am trying to automate which consists of the following steps: 1) Take 5 pieces of data from a record on worksheet A with 200 records and input those pieces of data into worksheet B 2) Take Worksheet B and save the tab as a PDF in a new location 3) Name...

If there is a previous thread for this topic, please direct me to it. I have a large table (both in columns and rows). In each row/record, there are three name fields. The same name could be in any record, in any of the three fields. I need a way to put all of the names from those three fields...

Hello, I have a subform that I want to enter a number each time I enter a new record. I have it working i.e. say on 4098544.02 it will number 01, 02, 02, etc. However if I change to a different record say 30499000-01 then I want it to restart the numbering sequence again from number 01. This...

I've got approximately 200 records, with each record consisting of 12 string fields. I have a two dimensional array. The question is how to declare it and how to load it from the Excel spreadsheet, then how to rewrite the info back to to spreadsheet after the data is changed/manipulated...

I can't believe I have to ask this, but why is COUNTIF treating these two obviously different strings as if they match? I'm attempting to create a unique key for each transaction, which I thought was easy enough. Clearly there's something I'm missing here?? Any insight would be appreciated...

Hello, I have various spreadsheets that can contain mailing addresses with anywhere from 60,000 to 140,000 records. On certain records the street address, which is represented in one cell, is listed as a range of home address numbers, such as 145-150 Smith Rd. The City, State and Zip are also...

I have several different categories of work in a spreadsheet, where not all categories have the same SLA for completion. I've been using this formula for the past few months, and there hasn't been an issue, until last Friday. Essentially, a record came in with a start date of 11/22/18. That...

Hello everyone, I'm having some trouble getting this code to do what I want. I have an excel spreadsheet with a few tabs. On sheet 1, there are record names in Column A. The names are duplicated from Sheet 1 on to Sheet 2. Sheet 2 has a table of the records and headers that outline four steps...

Hi All, I have had a read through other posts can cant find exactly what i am after, i can find script for each individual part but when i try and put them together i can can only get one half to work. I would like to monitor target cells in another sheet and record the value that was in the...

Hi, everyone on of my record in range("b3") is "Copy of Read Only - Personal Loan 20171231~tmp23409752.xlsx", and this record is written by vba code, it's a workbook name. when my vba code wants to find this record in range("B:B"), an error occured, it just cann't find this record. and the...

Hi Everyone, I have a report generated from another program. It's giving me all of the information I need, it just not in a usable table form. I will try to explain. This is what a single employee record looks like. <tbody> A B C D E F G H 1 Name: John Doe 2 Employee ID: 1234...