advanced data extraction

  1. H

    data extract between sheets For the value entered

    Hi team, I don't have knowledge in VBA coding but i tired with internet search for the requirement. But unable to find the proper solution for my requirement. Hope, i get a solution from the forum. i have attached the image of the sample data(actual data gets bigger) from the sheet named...
  2. M

    Find text in one cell, select all cells for same person on same date and copy to another sheet

    Hi All, Just had to re-register after 8 years away. I receive a weekly timesheet spreadsheet for a construction project in an area with high rainfall. Each person can charge to 3 or 4 different time codes per day. One of the codes is "inclement weather/rain". When this code appears I need to...
    • Moonriser
    • Thread
    • advanced data extraction advanced filte vba & conditions vba & copy
    • Replies: 0
    • Forum: Excel Questions
  3. S

    VBA code to copy data based on criteria

    Hi There, I am looking for a VBA code that can copy all the rows (Incl Headers) based on criteria in specific column. Scenario :- I have a File with 8 different sheets and different information. Commonly, every sheet has a "Status" column. I want to filter the status column and check for...
    • spvsr999
    • Thread
    • advanced data extraction copy & past rows vba excel new book vba paste vba & copy vba & excel
    • Replies: 12
    • Forum: Excel Questions
  4. C

    Advanced Formula Help - INDEX MATCH MATCH? VLOOKUP? Please help :(

    Hi guys, Wondering if anybody can help me - I have been trying to figure out this formula for 2 days now, with no luck :( I'm trying to figure out how to use Excel to find and return a value. It's quite difficult to explain (sorry, my brain is exhausted after trying to figure this out), so...
  5. D

    Turning Data extraction into an inserted module.

    I am using the following formula to extract data between carrots and it works flawlessly. =MID(B3,FIND("^",B3)+1,FIND("^",B3,FIND("^",B3)+1)-1-FIND("^",B3)) What I would like to do is to be able to bring up VBA and paste code to add this function to my selectable list (such as fuzzyvlookup)...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top