How do I import data into a custom Excel view?

A

Adam

I create the same ad hoc report weekly and am looking for a way to import the
data in as xls or txt and auto format the data into a subtotalled landscape
worksheet with conditional formatting. Thoughts?
 
D

Dave Peterson

Record a macro when you do it manually. Then try to generalize that code.

Then when you have to do it next week, just execute that macro.

If you need help tweaking your recorded code, post back with your specific
questions.
 
Top