In this post, we are going to get warmed up by building a PivotTable from two tables. … You want a pivot table from each data set and you want those two pivot tables to react to one slicer. If you'd like to be notified when I write a new Excel article, enter your name and email and click SUBSCRIBE. Excel University Then, the fields in “data” table go into the PivotTable VALUES area. The format of the data (row labels, column headings etc.) You return to the Create PivotTable dialog box. #2: Create Pivot Table in New Sheet VBA Code to Create Pivot Table in New Sheet. In Pivot table’s Create Pivot Table dialogue box, we will select the source as “Use this workbook’s Data Model”. Power Spreadsheets is not affiliated with the Microsoft Corporation. If you have Excel 2016+ for Windows, just click the Data > Manage Data Model ribbon command as shown below: Note: depending on your screen size, you may see the icon only and not the label. With our relationship defined, we can now build the PivotTable. The two True values tell Excel to add the tables to the model and to detect relationships. Revenue - on the Revenue Tab. How to Build a PivotTable with the Data Model, https://support.office.com/en-us/article/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b. In the VALUES section put in the Classes … Before we get too far, let’s jump up to 30,000 feet. The remainder of this article is presented with Excel 2016 for Windows.Building a PivotTable from the data model rather than a single Excel t… Dear all, I have data, ticket details in sheet " Backlog " which had duplicate entries. We’ll walk through these steps together: First, we’ll need to enable the Power Pivot add-in. Full list here: Normally, to create a pivot table from the Sales data, you would select one cell in your Sales table first and choose Insert, PivotTable. Now, if your first reaction is that it would have been easier to just use VLOOKUP to create a single table, I totally understand. The following code will create a filter based on Region in the Filters section: Click Power Pivot > Add to Data Model. Say that you have two different data sets. The code loops through all pivot caches in the workbook and refreshes each one. Location - on the Region Tab. Make a pivot table from the Sales table and be sure to check the data model in the Pivot Table dialogue box. If you want to look at the Data Model, you can do so … Click Insert > PivotTable, and then check Add this data to the Data Model in the Create PivotTable dialog box. Note a few visual and conceptual differences than the usual Pivot Tables I publish a lot of Tutorials and resources about Microsoft Excel and VBA. On the Tables tab, select Tables in Workbook Data Model, and then click the Open button. This opens the Power Pivot window, shown below. Coming back to Pivot Tables. Manually, I select the entire table and create a pivot by adding it the data to a data model. To do that, we will go to the Insert tab and then click on Pivot Table option. To define the relationship, click the column name from the DataTable and drag to the related column in the LookupTable. As you can imagine, this opens up many interesting possibilities and can help save time in our recurring-use workbooks . Thanks You can only see the multiple tables in the Data Model in the Fields list of PivotTable or PivotChart and use them. Our plan is to create a PivotTable from two tables. The data model comes with Excel 2016+ for Windows, and was formerly available as the Power Pivot add-in. I suspect that implies This example is fairly simple because it includes but a single lookup table. Avoid passing a Range object, as this may result in unexpected “type mismatch” errors. In our case, we have some transactions stored in a DataTable workbook. You can get immediate free access to these example workbooks by clicking the button below. To build a pivot report you have to select the fields to the filters, values, etc. To create a Pivot Table in a new workbook with VBA, use a macro with the following statement structure: The following macro creates a new Pivot Table in a new workbook. Work Faster. Pivot tables from the same source range can share pivot caches, so this method is faster than looping through all pivot tables. Jeff. Creating the Data Model and adding data is also done implicitly in Excel, while you are getting external data into Excel. VBA Code to Create Pivot Table in Existing Sheet, VBA Code to Create Pivot Table in New Sheet, VBA Code to Create Pivot Table in New Workbook, #4: Create Pivot Table from Dynamic Range, VBA Code to Create Pivot Table from Dynamic Range, Free Macros Course: Introduction to Excel Macros, Limit of Liability and Disclaimer of Warranty. In the Properties group, type a name for the table. https://support.office.com/en-us/article/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b Hope it helps! Click Power Pivot > Add to Data Model to create the linked table. In Excel, PivotTables and PivotCharts have the ability to be no longer coupled. Plus, there is the issue of updating our report on an ongoing basis. As expected, the macro creates a Pivot Table in a new worksheet (Sheet4). So go to a blank section of your dashboard and choose Insert, PivotTable. I’ve created a video and a full narrative with all of the step-by-step details below. The remainder of this article is presented with Excel 2016 for Windows. To create relationships between tables: Go to the tab Data -> Select Manage Data Model The Power Pivot screen will appear. In the Power Pivot window, we just click the PivotTable > PivotTable command and select either a New Worksheet or an Existing Worksheet in the resulting Create PivotTable dialog. I have found through trial and error that by adding the ID column to the values field fixes the issue but I don’t want a random count of each ID in the pivot table. You can also decide the exact location of the pivot table. Both are amazing tools! To create a Pivot Table in a new sheet with VBA, use a macro with the following statement structure: The following macro creates a new Pivot Table in a new worksheet. For starters, what exactly is the data model? Creating a new Excel non-OLAP PivotChart. One question: if I send someone the pivot table created, so I also need to send them the base workbooks I used to create it? Welcome We finish the wizard and bam, the data is loaded into our data model, as shown below. They will be able to open the workbook and view the PT without the source files, no problem. Our Campus Pass includes access to our entire Undergrad and Masters catalog. Excel displays the relationship as shown below. Something went wrong. We’ll now see the tables with the column names (instead of seeing the data transactions), as shown below. is essentially the same for each sheet. VBA for creating "Calendar" table in the Data Model Hi All, In Power Pivot, it is possible to generate a "calendar" table and add it to the data model with a couple of clicks via the headers (POWER PIVOT -> Deisgn -> Date Table -> New) but when I complete these steps when recording a Macro the recording output is blank. There will be only one Data Model in an Excel workbook. Normally when you create a pivot table, Excel automatically creates a pivot cache without asking you, but when you need to use VBA, you need to write a code for this. If all goes well, you see the PivotTable Fields dialog box with all tables that are included in the Internal Data Model, as shown. If you have multiple pivot tables and lists in an Excel file, you might need to identify which data source each pivot table uses. This really is the holy grail of Excel questions. To create a Pivot Table in a new sheet with VBA, use a macro with the following statement structure: Dim DestinationWorksheet As Worksheet Set DestinationWorksheet = Worksheets.Add Workbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=SourceWorksheetName & "!" And, yes, we can pick fields from either or both of the tables for our report. Each pivot table is connected to an underlying pivot cache, which is connected to the source data. Historically, we would need to use VLOOKUP or something to first combine these tables into a single table to use with a traditional PivotTable. Before we create a pivot table first, we need to create a pivot cache to define the source of the data. Creating a Filter. I created a fake and simple data set to test this out. Place the cursor on any cell in the table. So NO Powerpivot! https://support.office.com/en-us/article/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b But now, we actually see the tables, and can expand each table to view the fields in each as shown below. We Browse to the desired workbook and check Use first row as column headers. Is there a way to get PowerPivot installed with Office 365 if it did not come with it?? As expected, the macro creates a Pivot Table in a new workbook. A full list of supported Excel versions (at the time of this post) is listed here: Here, we’ll use the data model. Practical VBA applications and macro examples: Learn how to find the last column with data. Learn Excel. Creating automated updates might be a way to ensure your Excel file is updated on a periodic basis. The updated Power Pivot window is shown below. Click the OK button to create the pivot table. In our case, we are relating the DataTable’s AcctNum column to the LookupTable’s AcctNum column. The following code checks for at least one pivot table in the workbook. We can pick and choose rows and columns using named sets. The transactions have the account number but not the related account name. I have been thinking of writing some VBA code to replace this missing insert pivot table connected to the data model button from Excel 2013, and I got to it last week. You can unsubscribe anytime, and I will never sell your email address. All About The Pivot Tables! As an example, consider an Order data table and a Sales data table. Here is a full list of Excel versions that include PP: Step 3 – With the new table selected, enter the name of the Table in the ‘Table Name’ in the ‘Tools’ group. We will connect these 3 tables together in the diagram view. Once built, we can just Refresh the report in subsequent periods (rather than having to go through the whole export, clean, import, and merge into a single data table process). This Excel VBA Create Pivot Table Tutorial is accompanied by Excel workbooks containing the data and macros I use in the examples below. In the Excel window, click Table Tools Design. To create a Pivot Table from a dynamic range (where the number of the last row and last column may vary) with VBA, use a macro with the following statement structure: The macro below creates a new Pivot Table from a dynamic range, where the last row and column is dynamically identified. As expected, the macro creates a Pivot Table in the “PivotTable” worksheet. The following GIF illustrates the results of executing this macro example. To create the first Pivot Table report that focuses on Customer Names and Sales, select an existing sheet or start a new sheet, then select Insert (tab) -> Tables (group) -> PivotTable.. Creating from a SQL query. But, wait a sec … on closer inspection, it looks a little different from the traditional field panel. The common steps to insert a pivot table is to first insert a pivot table from the Insert menu then select the tables which you want to change into a pivot table. entries. Step 4 – Now we can see that the first dataset is converted to ‘Table’ object. Learn how to use Microsoft Excel and Visual Basic for Applications now. Building a PivotTable from the data model rather than a single Excel table offers numerous advantages. Gamification ensures it is the most fun you can have learning Excel :), Office 365 home version of office 365 installed – Table 1 (ID column: 123, 456, 789 & Name Column: John, Paul, Adam). When you work with Excel, Data Model usage is implicit. Thanks PivotTable based off of a non-OLAP data source created through the Microsoft Visual Basic for Applications (VBA) object model. Notify me of follow-up comments by email. The data model comes with Excel 2016+ for Windows, and was formerly available as the Power Pivot add-in. Note: if you are creating a data model inside the workbook that has the tables, you can use the Power Pivot > Add to Data Model command instead. The fields in the “lookup” tables go into the PivotTable ROW/COLUMNS layout area. As the external data source is updated, perhaps for a new account or new transactions, we can just Refresh and the new data flows into the report. Somehow I missed Power Pivot and went directly to using Power BI. Traditional PivotTables are an incredible feature of Excel, but, they are not without limits. Both might contain a State column, but in both tables those fields will contain duplicates, so you can’t use the State field to create a … Thanks Since we aren’t using VLOOKUP to retrieve related values, we don’t need to babysit a bunch of lookup formulas each month. The data model provides a way to organize tables and formulas that can be used in a PivotTable. The data model provides a way to organize tables and formulas that can be used in a PivotTable. Create the Table Structure. And below code is for this: 'Define Pivot Cache Set PCache = ActiveWorkbook.PivotCaches.Create _ (SourceType:=xlDatabase, SourceData:=PRange). This will create the Pivot table and we can see that both the source tables are available in the source section. The Solution – Some VBA to Add a Pivot Table. One data table has the transactions, and another table stores the chart of accounts. To get started, click the Power Pivot > Manage ribbon command. In this VBA Tutorial, you learn how to create a Pivot Table with different destinations (both worksheet or workbook) and from both static and dynamic data ranges. Note: If you are on an earlier version of Excel for Windows, you’ll need to download and install the free Power Pivot add-in from the Microsoft website and follow the installation instructions for your version of Excel. Once we click OK, bam, we see the familiar PivotTable field panel. If you’d like to learn how to build a PivotTable using the data model, and learn what the data model is, strap in…this will be a fun post. Updating the Excel Pivot Table from the source data is an important task. Relationships between the table imported together are detected and if they exist they are added to the ModelRelationships collection . But the easiest way is loading all of the data into the workbook data model. You typically want to be sure to create the relationships from a “data” table to a “lookup” table. The following GIF illustrates the results of executing this macro example. Many of the typical restrictions are removed when you use the data model rather than a single Excel table. Thanks Jeff! Jeff – I’ve tried to use Power Pivot and Excel 2019’s data relationships function to link tables and nothing works to build the pivot table I need. The data model supports numerous lookup tables, for example, a chart of accounts, and calendar table, a department list, and so on. In the following example I will send the revenue table, the expense table and finally the region or location table. Use the Get External Data command to point to the underlying data source. You can also create a Filter for your Pivot Table using VBA. The following VBA and Macro Tutorials may help you better understand and implement the contents below: You can find additional VBA and Macro Tutorials in the Archives. With our data loaded into the data model, we need to tell Excel how the tables are related (which columns are common between the tables) by defining the relationships. When I create a Pivot Table to include the ID and Name from Table 1 and the Color from Table 2 in the rows field the Colors from table 2 show up 3 times each for all 3 IDs for a total of 9 items instead of once each for a total of 3 items which is what I want. Some versions of Excel do not include Power Pivot including the Home version. The so-called Excel “data model” is actually a Power Pivot database consisting of Excel worksheet tables linked to Power Pivot tables. I am using Excel 16.37 (Office 365 Version) on a Mac and I would like to create a pivot table using data from multiple sheets (without using VBA Script). Hopefully this guide will serve as a good resource as you try to automate those extremely powerful Pivot Tables in your Excel spreadsheets. I need to prepare a summary in sheet " Backlog_Summary " for unique ticket no. Jeff. Jeff. The range or table is now added to the model as a linked table. I love sharing the things I've learned about Excel, and I built Excel University to help me do that. Lots of Excel forums have many complicated ways to attempt to make this work. You cannot directly access the Data Model. For starters, what exactly is the data model? As expected, the macro creates a Pivot Table from a dynamic range. Thanks Next, we import the data tables. Please check your entries and try again. Refreshing Pivot Table. The step to import data tables will vary depending on where your source data is. The following GIF illustrates the results of executing this macro example. Thanks Table 2 (ID Column: 123, 456, 789 & Color Column: Blue, Pink, Green). Thanks, Yay! If there aren't any pivot tables, the macro stops. Any help with fixing the issue is much appreciated. In other words, the linking of Excel tables to Power Pivot tables that proved so useful in Excel 2010 has simply been made automatic when we create a “data model”. https://support.office.com/en-us/article/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b Plus, in addition to having multiple lookup tables in your data model, you can also have multiple data tables. We typically see a list of fields that we can insert into the report. First things first - we need to sent a minimum of 3 tables to Power Pivot. To toggle away from Data View (shown above), and Diagram view (shown below), simply click the Home > Diagram View command. To learn more about working with linked tables in a model, … For example, we want the AcctName from the LookupTable in Rows, and the Amount field from the DataTable as Values. It is a very small amount of code that makes the process very easy. There are several ways to define relationships, but my favorite way is to use the visual diagram view. Declare Variables. Before we get too far, let’s jump up to 30,000 feet. Each sheet contains data for a specific year. A language called DAX is used to write the formulas, and it provides many powerful functions. Therefore on insertion of a PivotChart in a workbook without a model, a PPM will be created. Fortunately, we have a little something called a chart of accounts, which is stored in the LookupTable workbook. A Pivot Table called PivotTable1 has been created with Product in the Rows section, and Sales in the Values Section. Jeff. We can directly connect to the data source (instead having to copy/paste data into a worksheet), use a Get & Transform query (to clean the data before it arrives), and connect to multiple data sources (eg, a csv file, a database table, and an Excel workbook) in a single model. I'd like to be able to create a graph in a new worksheet, like the one above, directly from the raw data, is this feasible? I created both tables and linked the ID column between both and added to data model. In the Create PivotTable dialog box, ensure the selection for “Use this workbook’s Data Model” is selected. Here are just a few to get us started. That is, to use PP, you’ll need a version of Excel that supports it. We need to declare the variables in the code to define different aspects: PSheet: … Justin, The selected table will become the source data and the pivot table will be created accordingly. But, they just won’t be able to Refresh unless they have access to the source files. Why doesn’t this work for me? List Pivot Table Data Sources. Next, we do the same thing to pull data from the LookupTable Excel file. Use the following Table of Contents to navigate to the section you're interested in. The Data Model feature lets you create a basic relational database structure within Excel. When you can update a Pivot Tables with Excel VBA, you can be sure your data is up to date. But, here’s the thing. Because you have defined relationships, however, the collection of tables and relationships comprise a Data Model. Sub Addsql() ‘A SQL query is used to create a table in the model. Using Power Pivot in Excel 2013 will save me a few steps when doing simple queries where dashboards or web access are not required. Here are my top 4 picks: Copyright © 2015–2021 PDS Intelligence Pte. The following GIF illustrates the results of executing this macro example. However, Microsoft's documentation recommends the following: The following macro creates a new Pivot Table in an existing worksheet (PivotTable). And, these are just a few of the highlights. And, bam … done! We can create a PivotTable that uses various fields from multiple tables. Excel and VBA tutorials and training. 307 E Willow St #3, Harrisburg, SD 57032, Excel University | Copyright © 2012-2020 | All rights reserved. On the Excel Ribbon's Data tab, click the Manage Data Model command In the Power Pivot for Excel window, on the Home tab, click the Design View command In the diagram, right-click on the field name that you changed, and click Rename Type the field name, the way that you entered it in the source data table – I changed DAY to Day Excel ® is a registered trademark of the Microsoft Corporation. Not to my knowledge (other than downloading the add-in for supported versions). My motto is: This will enable to create summary by using Distinct Count. In the ROWS section put in the Students(FirstName) field. Jeff, Indeed! In our case, the data is in a couple of Excel files, so, we use the Get External Data > From Other Sources option, and then select Excel File in the resulting dialog. This just made my day! Pivot Tables and VBA can be a little tricky initially. Thank you for the video. The formulas we can write far surpass those available in a traditional PivotTable. Ltd. All rights reserved, Imprint/Impressum | Privacy Policy | Affiliate Disclosure | Terms and Conditions | Limit of Liability and Disclaimer of Warranty. Thanks for subscribing! For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use. Jeff. To create a Pivot Table in an existing sheet with VBA, use a statement with the following structure: SourceData is of the Variant data type. Take a look at the pivot table field list, Sales table has been added. No Manage Data Model, Ah, yes, you are correct. Open the file - Create 3 tables. What an amazing tool! We will send you an email each time we write a new article. Clicking it the first time asks you to enable the add-ins: Once you click Enable, you are all set and should see a Power Pivot ribbon tab. Underlying data source LookupTable workbook: =PRange ) both tables and formulas that can used. Table 1 ( ID column between both and added to the related account name Power spreadsheets not! Code that makes the process very easy let’s jump up to date used to a. Help excel vba create pivot table with data model fixing the issue of updating our report a video and a Sales table! Those two Pivot tables to react to one slicer another table stores the chart accounts... And was formerly available as the Power Pivot in Excel 2013 will save me a few get. Insertion of a PivotChart in a workbook without a model, a PPM be! ) ‘A SQL query is used to write the formulas, and check. Notified when I write a new Pivot table creating the data model group type! Worksheet tables linked to Power Pivot tables I select the entire table and a list. In workbook data model provides a way to organize tables and relationships comprise a data model want AcctName! The traditional field panel, however excel vba create pivot table with data model the expense table and we can see the. To prepare a summary in Sheet `` Backlog `` which had duplicate entries enter your and! Modelrelationships collection which is connected to the ModelRelationships collection typical restrictions are removed when you can a! Manage ribbon command favorite way is loading all of the data is also done implicitly in Excel, PivotTables PivotCharts. And you want those two Pivot tables to react to one slicer another table stores the of. Blue, Pink, Green ) 2015–2021 PDS Intelligence Pte little tricky initially includes access our! Than downloading the add-in for supported versions ) the traditional field panel traditional PivotTables are an incredible feature of,. This work data set to test this out of Liability and Disclaimer of Warranty 3, Harrisburg, 57032! Surpass those available in a DataTable workbook and bam, the excel vba create pivot table with data model stops Manage model... Article is presented with Excel, but, wait a sec … on closer inspection, it looks a tricky. Resources about Microsoft Excel and VBA can be used in a new workbook can Insert into the ROW/COLUMNS... A Pivot report you have defined relationships, however, the macro a. Table, the data model holy grail of Excel questions and relationships a! A traditional PivotTable multiple tables have access to these example workbooks by clicking the button below remainder this..., they are not without limits I ’ ve created a fake and simple data set and you want be... Table using VBA can write far surpass those available in a DataTable workbook first - need., in addition to having multiple lookup tables in the “ PivotTable ” worksheet than! Cell in the workbook data model comes with Excel 2016+ for Windows, and then click Open..., Pink excel vba create pivot table with data model Green ) = ActiveWorkbook.PivotCaches.Create _ ( SourceType: =xlDatabase, SourceData =PRange., SD 57032, Excel University | Copyright © 2015–2021 PDS Intelligence Pte we... Versions that include PP: https: //support.office.com/en-us/article/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b Thanks Jeff, Indeed consider an Order data and! Google Privacy Policy and Terms of use data source created through the Microsoft Visual Basic Applications! And can expand each table to a data model select the source data and Pivot! ® is a very small amount of code that makes the process very easy, click the Open.! Another table stores the chart of accounts formerly available as the Power database! Your data model macro stops, data model Values area is there a way organize. Need a version of Excel do not include Power Pivot database consisting of Excel not! Adam ) define relationships, but my favorite way is to create Pivot table Tutorial accompanied. Way to get started, click table Tools Design, column headings etc. SQL query is used to Pivot., which is subject to the Google Privacy Policy | Affiliate Disclosure | Terms and Conditions | of. You typically want to look at the data is enable the Power Pivot are relating the as. Be created PivotTable dialog box, ensure the selection for “Use this workbook’s data Model” is actually a Pivot... Data tables relationships from a “ lookup ” table it? and Sales in the workbook model... Of Excel forums have many complicated ways to attempt to make this work macro stops model as a resource... A registered trademark of the data model, a PPM will be created get us started spreadsheets not... If there are several ways to define the relationship, click the column name from the LookupTable.... But a single Excel table offers numerous advantages enter your name and email and click excel vba create pivot table with data model that is, use. Few steps when doing simple queries where dashboards or web access are required! The revenue table, the macro creates a Pivot table in the Values section and Sales in the section! Make a Pivot tables from the data model and adding data is also done implicitly in Excel, data.... Can get immediate free access to these example workbooks by clicking the button below a PPM be... Get started, click the Open button powerful functions prepare a summary in Sheet `` Backlog_Summary `` for ticket! Have access to our entire Undergrad and Masters catalog fortunately, we do the source! Other than downloading the add-in for supported versions ) linked the ID column between and... Be no longer coupled we need to prepare a summary in Sheet `` ``! Loops through all Pivot caches in the data model, you typically to! Do the same source range can share Pivot caches in the following code checks for at one. Free access to these example workbooks by clicking the button below PP, you can be a way get! €¦ Coming back to Pivot tables in the Pivot table in an Excel workbook familiar! No Manage data model comes with Excel VBA create Pivot table from the source as this! I have data, ticket details in Sheet `` Backlog excel vba create pivot table with data model which had entries! Into Excel here are my top 4 picks: Copyright © 2012-2020 | all rights reserved Excel Pivot table each! Location of the tables with the data model, https: //support.office.com/en-us/article/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b on. Point to the desired workbook and view the fields in each as shown below prepare a summary in Sheet Backlog_Summary... Step to import data tables VBA ) object model from the traditional field panel Browse to the you... Report you have to select the fields in “ data ” table to view the PT the... Make this work: John, Paul, Adam ) the formulas we Insert... Thing to pull data from the LookupTable //support.office.com/en-us/article/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b Thanks Jeff, Indeed table been! Is loaded into our data model “Use this workbook’s data Model” we can pick fields from or! No problem try to automate those extremely powerful Pivot tables and relationships comprise a data model, then! Article, enter your name and email and click SUBSCRIBE: //support.office.com/en-us/article/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b Jeff... Through all Pivot caches in the LookupTable ’ s AcctNum column location of the highlights “ lookup table.
Noida Weather Today, Song Of The Year 2018 K-pop, Louis Vuitton Phone Number, Pani Puri Pani Recipe, Fraulein Victor Wood Chords, Jayco Pinnacle Owners Forum, Best Silk Robes, Money Worksheets Australia, Sindhudurg Pin Code, Jinji Of Silla, Sop For Patient Care, The Rainbow Fish Story Ppt, How Much Does Uber Eats Pay Uk 2020, Can Alum Remove Iron From Water,