extract cell

I have an excel where I need to pull in the total hours for a date range (always start on Monday) in my excel tab called 'Dashboard'. I'll be getting the data from the tab 'Budget' but I only want to pull in the number based on the QuickBooks Code I've identified on B1. So AH3 will equal to...

Good day All, I want to input a set of 3 data inputs and extract the results from a formula. The formula itself is linked with many sheets and other formulas and is restricted to 1 row only for the input and result. From the 3 data inputs of a row, I will receive 2 results that will change...

Sample Address: Dale Cleaners 976 Old Henderson Rd Columbus OH 43220 USA I have over 20,000 of these that I need to extract the state from. What's the best way to do this?

I have the following table ABCDEF2IntervalFHFCDYWYYR332FH 50FC 10DY 15WY 20YR3250101520 Cell A3 has numerous values which i would like to extract and put into the correct column. I am looking for a formula (no macros or VBA) to input into each column (B-F) which will look at column A and...

Hi, I have a a folder with 100 csv files from specific Cells and paste them to a summary excel file. For example- from origin_file_1.csv to the dest_file.xlsm B7-->K2 B8-->L2 B10--> M2 from origin_file_2.csv to the dest_file.xlsm B7-->K3 B8-->L3 B10--> M3 and so forth. Thanks in...

Hello all, i have created a macro to extract the data from A column except 1st word. But i could not find a way to delete those extracted data from A column. Please guide me to acheive that. Thank you. My macro example. Sub DeLeft() Dim i As Long, d As Long Dim Cel As Range Dim Rng As Range...

Hello, I want to input a lot of data from a production batch into Microsoft Excel with version 2019. I want to search for an effective way to do it and to minimize any mistake from inputting at the wrong column, and to make the process a lot faster, because there's a lot of handwritten notes of...

Hello all, i want to extract data in a selected range of cells based on condition. If the 9th character is an alphabet, then the rest of the characters(from 10th) in the cell to be copied to the adjacent cell. If it is not an alphabet then from 9th character in the cell to be copied to the...

I've seen some code, but nothing that matches exactly what I'm looking to accomplish. I posed the question about this using indirect but apparently its not feasible. I have a root folder called "Teachers" and under that folder, hundreds of subfolders for all the schools ( e.g. Teachers\School...

i want to take the data in the range C12:K20 and extract only the green colored cells into a list under A1. https://www.dropbox.com/s/51phis2d5cb36ko/Screenshot%202018-12-19%2001.56.35.png?dl=0