Repeat Macro

Hi, I want to perform this action. Pozo mD Termina Producción Cima Base Sam-996 962 978 1 Sam-996 962 1 Iride-725 1137 1140 Sam-996 ...

Macros & VBA

Tutorial

Haytham Amairah
Apr 30, 2018
Hi,

This can be done by using Power Query which is also known as (Get & Transform Data in Excel 2016), and if you don't have Excel 2016, then you have to download and install https://www.microsoft.com/en-us/download/details.aspx?id=39379.

The Power Query is much easier than Macros and VBA.

Please find the attached file and try to update the left table, then right-click on the right table and select Refresh to see how it will be updated.

Regards
Data.xlsx17 KB

Angel Villela

Copper Contributor

May 02, 2018

Hi Haytham Amairah,

On monday i received your help, but i have an incovinient in the example provided one column is missing and i´ve been trying to change the arrangement without success.

In the image, there is a better explanation.

In advance, thanks for yur help.