data across sheets

Hi, I'm trying to make a sheet that will import data from another sheet when you type the "Run" of a product. So for instance, in row B4 I type ATTCL it then pulls from the data sheet the name from column D, density spec from column H and sizes from column K for Length, N for Width and Q for...

All, I am creating an Excel workbook with a tab for each topic I'm tracking. One tab for Water, another for Calories another for Exercise. Based on the data in the table, I have charts tracking my progress. I want to share this with family & friends. However, I'm concerned the tables will...

I built this sheet years ago for a colleague. However, human error seems to be the main issue. I need to be able to push the data from the Daily Sheets and push it to Well Summary. The sheets are going to be dynamic in the sense that we don't know when or how long a run will last, so it almost...

Hi, I am new into de forum and kind of new into VBA. I have written this code(with some support of youtube videos etc) to copy a specific Sheet from one worksheet to another. Sub CopytoWorkbook() Dim x As Workbook, y As Workbook Dim ws1 As Worksheet, ws2 As Worksheet Dim LastRow As Long Dim...

Hi all, I'm chasing a VBA macro urgently but don't know how to go about it. Thanks in advance, please see below: There are 3 documents, I have links to them below: Doc_1: Loading Google Sheets Doc_2: Doc_2.xlsm Doc_3: Loading Google Sheets What I require is a VBA macro in "Doc_3" which when...

Need help to create a macro to extract the following data (highlighted in green) from Multiple Worksheets onto the Summary sheet: Month of Report onto E1 Date of Report onto E2 Carpark ID on column D Carpark ID + Lane ID onto column E Percentages for Hourly, Season Parking and Total on column...

Howdy all, I just received a very extensive date sheet and I would like to pull only the lines of data pertaining to 2022 entries. There is a specific column which shows 2022 creation date. So, what I need to do is run a query or a sum= type of statement which pulls only those rows where 2022...

Hi everyone, I am relatively new to excel and am basically have been assigned this task where I have to 4K+ different serial numbers, as well as data sheets for these serial numbers. For these serial numbers, I have to go through each and every one of them and copy the range of data that these...

Hello All, I created a Excel Workbook to enter and track quotes for something I am working on.. It works good to enter data, calculate additional charges ect and hold the quotes in a seperate sheet. The sheet has a macro to copy from the input sheet to a sheet called database to hold all of...

I have a workbook with a tab for each of the different sites I manage with all the information about the compliance actions taken across the year. Date, notification number, name, action taken etc. Then the first tab is a brief overview of them all grouped by site so that if someone needs basic...