Forum Discussion
Automate excel steps for every week sheet
1. I get an excel file every monday for last week billing done which may include 1000 to 1500 rows depending upon sale, but all columns are fixed everytime. 2. Then we apply filters, remove some row...
Get & Transform (aka Power Query) can probably do a lot for you. With the Power Query Editor you can do a bunch of things without coding