raw

Can I get raw data from 2 differences sheet onto a dashboard with only using 1 slicer.

Hi Team: I have assigned a macro to a slicer object, but when I click on the slicer button, the macro executes but the slicer doesn't work. To keep it simple, the slicer only has a msgbox("Slicer clicked") My intention is to use slicers to run - and to then filter the raw data spreadsheet...

Hello, Can someone please help me with a vba code to filter a tab called "Raw Data" with the multiple dynamic values I enter in another sheet? ie. Sheet 1 cell L2 "LE", cells L2:O2 is where I would enter the values for LE, corresponding column in the "Raw Data" tab is A cell L3 "RU", cells...

Hye Excel Experts, I have this part of the macros that actually merge multiple workbooks in a folder. There are certain items need to be filtered in the raw file first before it copies the final one into the master workbook. However, the raw file contributors sometimes park the wrong file...

Hi Folks, Looking for some help and advice, please. Difficult one to explain, Essentially I have 2 worksheets. For simplistic sense, let's call one Raw Data that gets updated daily and the other live reporting. Raw data contains lots of information and is updated with new people every day...

Hi all, Apologies if this is a really simple one, but cannot think where to start googling and i'm going round in circles. I have a worksheet with raw data in that I use to record the number of letter drops I am sending for my business. An example of the simple worksheet is below: Now in...

I have a simple graph based on a pivot table. Raw Data ID,Software,Date Purchased,Type,Age1,Access,5/9/2018,Database, 1 2,Excel,5/7/2018,Spreadsheet, 2 3,Access,5/3/2018,Database, 6 4,Minecraft,4/14/2018,Game, 25 5,SQL Server,4/28/2018,Database, 11 6,Excel,5/6/2018,Spreadsheet,3 7,SQL...

Hello Everyone, I recently opened up a retail store. Transactions are completed in a POS system that allows me to download reports. They are however not sufficient for me to do the analysis I need - hence I need excel help please! I am trying to create a dashboard to measure individual and...

I'm extremely new to Macro's and I'm looking to pull multiple columns from one sheet to paste in another sheet. I've looked at other post but none really stuck out to me. sheets are Raw Data and want to copy and past to sheet Inventory. I will be pulling columns from raw data A range 2:900 and...

Hi there. I'm trying to get drag down to do the work for me and auto-populate what I need it to do. I have a COUNTIFS function set up to count how many people in my database: 1. Own a specific product 2. Date of purchase for that product 3. Double opt in for marketing As follows...

Good morning, I have a workbook which I dump raw data into. I have pivots set up on numerous tabs (named by company) this sorts the raw data into its relevant tabs. I would like to know if there is a macro that could then email each tab to a corresponding recipient for that company? I hope...

=SUMIFS('Transaction Raw Data'!$J$3:$J$5009,'Transaction Raw Data'!$G$3:$G$5009,"XYZ",'Transaction Raw Data'!$G$3:$G$5009,"ABC",'Transaction Raw Data'!$H$3:$H$5009,"Operating Expense") I want to sum column J if it meets the 3 criteria - 2 criteria from column G and one criteria from column H...

I currently use: =IFERROR(INDEX('Risk Raw Data'!$A$1:$BJ$600,MATCH($B7,'Risk Raw Data'!$AN$1:$AN$600,0),MATCH(F$5,'Risk Raw Data'!$A$1:$BJ$1,0)),"") which works fine. However I want to make this as dynamic as possible and as easy as possible for the user to amend with no knowledge of the...

I have a workbook with 2 worksheets. One shows the report (Output) the other has the raw data (Raw Data). I want the user to be able to easily amend the formulas (without having to understand them) if the structure of the raw data changes, e.g. new column added. I have a header row on the...

I am looking for a formula that will give me a list of results based on a text. This is what I would like to achieve. <colgroup><col><col><col span="2"><col><col></colgroup><tbody> Equipment Unit # Find CONV EVENFLOW FEED 1 BELT PCB0849 EVENFLOW TILT BELT PCB0850A Results DISCH...

Struggling with this one - I have a matrix/grid type setup for an entire product ranges' bills of materials. What I want to do is return every named instance of an individual raw material, based on matching a part number. In addition, it needs to return said raw material name only if the usage...

I'm trying to find the best way to create (and constantly re-create) a dashboard on a monthly basis, for 20 clients each month. Currently I have one excel 'template' with vba code which filters the raw data (over 5x sheets) into pivots and tables to produce the client-specific data for a...

HiEveryone, I Hope this is clear, trying to move data around to get monthly data? So In pull my raw data in one big list in sheet "raw data" Columns A to H Columns A to E are Customer data, Column F is the Month, Column G the Category Column H the Amount So heres what I want In Tab "Sorted...

Hello. I just tried posting this but got an error. Apologies for any possible double post. I want to achieve the following. User selects the item they want in A1 (dropdown menu), called ITEM1 In the second sheet, there are tables with the following properties such as ITEMS MATERIALS...

Hi all, I have two tabs in excel. One called Defects, the second called RawData. When i extract the data from a system, and copy it to the Raw Data, I want my first tab (Defects) search for where in the Raw Data the first row contains a specific text e.g. Issue Number then copy the...