Forum Discussion
Repeat Macro
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
Hi Haytham Amairah,
What im trying to do, is transpone column B and C, Paste column A twice and paste column C aside the value in column B. I need repeat that action in 1500 lines.
| Pozo | mD | Termina Producción | |||||
| Cima | Base | ||||||
| Sam-996 | 962 | 978 | 1 | Sam-996 | 962 | 1 | |
| Iride-725 | 1137 | 1140 | Sam-996 | 978 |
Excuse me if im not being clear :(
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
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.
Hi Angel,
I've updated the attached workbook with the possible solution.
Hope that helps
Thank you so much,
I´m going to try it.
Best wishes.
