Forum Discussion
Need help with an Excel Macro
Hello, I am new to creating Macros and would like to know if there is a way to write a macro to do the following. I would type information into two columns in Excel as follows: Qty La...
Hi,
The best way is to use Get & Transform (aka Power Query) to do that as follows:
Please find the attached file to see the solution.
Try to change the Qty number, then go to:
Fruits Table >> Right-click >> Refresh
and see how it's updated.
Hope that helps