How do I import data into a custom Excel view?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import data from Excel into Outlook journal 1
Importing data from Excel worksheet into Excel template 2
Importing .txt data into Excel 1
How do I import data from a text file into Excel 2003 2
Importing data from an application to an Excel worksheet 1
Reformat Excel for Access import 1
Importing a space-delimited txt. file right-justified into Excel 2
Copy within a subtotal 1

Back
Top