•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Doing the same steps over and over to an excel doc downloaded from salesforce - how to simplify?
hi, i download an excel file from salesforce multiple times per day and do the same formatting/functions with it over and over. i know that there must be an easier way than doing this manually.
i basically download the excel file from salesforce, do some formatting (make the rows all the same height, format numbers to be $0.00, filter by a column to remove zeros, then subtotal by a specific column). how can i do this quicker. macro?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#financial modeling with spreadsheets
#Excel
#formatting
#Salesforce
#functions
#number formatting
#macro
#automation
#simplification
#download
#filter
#data processing
#rows
#subtotal
#repetitive tasks
#output format