Forum Discussion
Extract specific data from numerous sheets to populate one.
How would I go about transferring data from numerous sheets, and condensing it on another sheet depending on whether (on the original sheets) the data has a certain text in a specific column.
Here's an example (See attached). So here I have Sheet1, Sheet2 and Sheet3 and in the column titled 'Suppliers' I have two different sup - Jewsons and Harveys. Now, I want the data from the first three sheets to populate the 'Jewsons' sheetpliers IF the data has 'Jewsons' in its suppliers column. So for example,
In Sheet1 Jewsons supply 12 'timber' at location S in week 1 - So this data should go across to the Jewsons tab. However, the paper in Sheet1 is being supplied by Harveys and therefore should not be shown in the Jewsons tab.
EXTRA: In Sheet1 and Sheet2 timber is being supplied by Jewsons, and its in the same lovcation and week, how would i then go about adding the quantity in the Jewsons tab.
Many thanks!
Bailey100
Hi,
This is can be done using Get & Transform (aka Power Query).
Please check out the solution in the attached file.
Hope that helps
6 Replies
Hi,
This is can be done using Get & Transform (aka Power Query).
Please check out the solution in the attached file.
Hope that helps
Haytham Amairah Thankyou! But I don't have this add-on and therefore power query isn't available to me. Is there any other way of solving my problem without the add-on.
Hi Bailey100,
If you have Excel 2016 or later, you don't need the add-in because it's now built in Excel as (Get and Transform Data) as the below screenshot and you can find it in the Data tab.
If you have an earlier version of Excel, you can download the Power Query Add-in from https://www.microsoft.com/en-us/download/details.aspx?id=39379&CorrelationId=5adf6c76-579e-4bd4-9efe-58c3ddc8a774.
Without the Power Query, the solution could be difficult.
