We currently export a report from our company file to excel - I would like to have a macro written which will help make the data useful.
First - excel should have the macros enabled always.
Second - once someone hits the appropriate key - all of the zero values in the spread sheet to not display 0 - it should only display a blank field.
and lastly - the macro / VBA should look at the values in a certain row range (this is a constant and unchanging range), if the value of the cell within the range is zero, then that column should be deleted. this would need to be repeated for the entire range on the row. the constant range in the excel spread sheet is $I$12:$FR$12
If you modify the macro so it references the active worksheet instead of Sheet1, then you can store the code in your Personal.xlsm macro workbook. That workbook is stored in the XLSTART folder, and will
Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
Welcome to part one of a multi-part tutorial series, VBScript for Windows System Administrators. The goal of this series is to teach non-programmers how to write useful VBS code to automate their environment, and perform tasks faster, and in a more…
Welcome, welcome! If you are new to the series and haven't been following along, please take a brief moment to review the first three installments:
Part 1 (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/A_266-VBScri…