table data extracting

Hello, I'm attempting to put together a Holiday Staffing Planner the returns certain values and hourly counts based on data input and filtering from other worksheets. My workbook has the following worksheets: * Holiday Staffing Planner - (User Input Worksheet) * DD_VALUES - Data Validation...

Hi guys, I have a series of 100 tables in MS Word like this one: <tbody> HD Internet-of-Things (IoT) Market Innovation Producing Immense Growth Potential CR Marketnewsupdates.com; PR Newswire WC 1,601 words PD 28 March 2018 ET 13:45 SN PR Newswire...

I want the brand name to be extracted from a table, in a website in my excel sheet. There's this table which has information about the product's warranty, shipping and brand, which is under one single "div" element. So I'm unable to extract only the brand name, instead it extracts all the data...

I have a small pest control & termite bonding company. We have yearly renewals for the termite bonds. I have a worksheet with 12 (monthly) sheets. Each sheet has the same table with the same headers. I need to combine the worksheets into one master table that automatically updates if we were to...

Hello, I have been trying for hours and am unable to find a solution. Problem: Move row data from multiple tables to 1 table based on the the the cell value in that row. The data: Table Name: Mr. Big Stuff <colgroup><col><col><col><col><col></colgroup><tbody> EMP ID AGENT SUPERVISOR STATUS...

Hi! So I have a table with two axes, the Y-axis is the price of a stock and the X-axis is the number of stocks to be bought. As the number of the stocks bought increases, the price isn't linear, and changes arbitrarily. Basically, this table has all the prices of the various stocks based on...

Hello, I've been struggling with this problem for nearly a week and any help would be fantastic. I have a data source with a large number of columns: <tbody> Ref No Date other1 other2 other3 4 5 6 7 8 9 Scheduled Sent timestamp 000 11/03/17 yes yes 1344 001...

Hello, I am trying to create a macro to loop through a table with 3 columns and create a list of drawing numbers on another sheet based on if the other 2 columns are equal to specific cells. I do not know how to code in VBA but this is what I would expect it to set the steps to be. Sub...

Hello there, Basically, I am trying to create an excel sheet that will take in options for a product and generate dimensions, a description, and possible drawings based on those inputs to have consistancy across all users. I was successful with the dimensions and descriptions but am...

I am trying to use SUMIFS to total criteria in two different tables. These are the two formulas I am using in two different cells. I want to combine the two into only one cell. I am using Excel 2016. =SUMIFS(list_purchases[Grand...

Hello, I am looking for a formula to achieve this and can not be a macro. I have three tables with 3 columns each and different row lengths, need to group all columns by names and make sum of the values on the SUM table like the follow: [/IMG] Is it possible without macro? Thanks in advance...

Hi Everyone and thank you for looking, I tried to find a post with what I need but doesn't gets me anywhere close to what i need... I have a table that is organized as follows: rows (first column) have equipment names i.e. pumps, valves, pipes, etc. columns are the locations where the...

I have a data table on one worksheet. <tbody> Job Title<strike></strike><strike></strike> Department Course1 Course2 Course3 Bagging Supervisor<strike></strike> Packhouse Yes Yes Bin Filler<strike></strike> Yard Yes Yes </tbody> <tbody> Table above is an example of Data sheet but...

Hello, I am trying to create a user friendly Form that preforms three functions: Allows the user to enter their User ID "txtParentId". ******* procedure to use the User ID entered to pull the related field data from the table "cmdSearch" Fill the first column into the first textBox...

My data is like: <tbody> LH LI LJ LK LL LM LN LO LP LQ 50 Table 1 Table2 Table 3 B 53 281.60 284.75 285.00 290.75 A B C D 200 284.75 54 307.30 311.35 312.00 312.90 A B C D 100 55 307.30 311.35 312.00 312.90 A D C B 200 312.90 56 156.30 158.35 158.80 163.20 A B C D 100 57 0.00...

I have 2 separate workbooks used to manage transactions, one is the "out" workbook and the other is the back "in" workbook. Both use tables to add transactions. All the transactions details, name, date, type, etc, are manually entered into the "out" workbook table with a tracking # in column A...

Dear All I have attachment workBook IT has two sheets 1st: Data OT, this has all patients details 2nd: Laboratory results of HCG testing At last Sheet (HCG) we adding the results of blood testing, according the received patient for that we are writing the Patient file ID at column A and...