none
VBA - setting preferences RRS feed

  • Question

  • Hi,

    I have a spreadsheet with a macro where i import a report and then I am able to select a managers name and then select different data sets from the import report to populate a table on a custom report for a manager. Everytime I change the manager to a different one and I want to revisit the previous managers info, I have to reselect the columns. Is there a way to write in VBA to save certain preferences for the managers?

    Thanks,

    Monday, July 8, 2013 1:10 PM

All replies

  • No VBA required - just create a custom view for each manager after you have set up their preferences.
    Monday, July 8, 2013 6:47 PM