• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

How to create a template to apply to a dataset on a reocurring basis

I use a web based software that can easily export a .csv file.  Each month I export the same .csv file (updated obviously).

Each month, I open and save it in Excel, sort, summarize, add columns, add formulas, etc to create the exact same report.

Is there some way to build it once in something like a template and just import that .csv file each month rather than having to recreate it every month?

This is a huge amount of time for me.  Any help is appreciated.
0
wlreimer
Asked:
wlreimer
1 Solution
 
dlmilleCommented:
Let's assume you import the CSV file and put into the "Input" sheet tab.

The rest of your workbook would look to the contents of the Input sheet tab to do its work.  How complicated this would be (whether you'd need a macro, some helper columns or perhaps even a pivot table) depends on the structure of the output.  All good design understands the input and the output.  

Can you upload a mock, non-sensitive dataset and report that we can look at?  That would make helping you much, much easier.

Cheers,

Dave
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now