advanced data extraction

Dear All, I need your help to come up with a formula where it should pick the Total sales based on two criteria. 1) Month and 2) Customer Name. The total sales row is after every two products within their respective tables. If a new product is added, then in each customer table will have all...

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...

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...

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...

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...

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)...