• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel

N

npoe1

Senior member
Ok, I know that this is a very dumb question, but I?m not an expert in Excel and need to do this.

I have a very large collection of data, actually times in which 40 takes to make something, I need to make a report every month, actually every week, We use like 6 different average times at day, to make a report I need to get the values of everyone of the employees for each time, every day of the month, obviously this take a lot of formulas and I need to that, I?m doing the report taking the formulas and changing the sheets and cells, but this take a lot of time I have 31 sheets to paste the info that come from the main application and then I have a sheet in which I get the data for the 6 times in the 31 days and that means that is 31*6*40 that is a lot of change and work, after that I need a weekly report from the 6 times and a monthly one, I?m using vlook to get the values, but changing every column take too much time and is a very tedious work, do any one of you have a better suggestion?
 
well the way that's done is with 2 parts: a combibnation of a RDBMS and a report writer.

the popular RDBMS is MySQL

the popular reoport writer is Crystal Reports
You'd want the "Standard Edition."

There are other brands of relational database management systems and of report writers, but those are the ones to use ftw, beacuse of the huge community of users, online resources for help, etc.

It's some work learning both, it takes a while, maybe a couple of months to become reliably productive using those 2 tools.

Database classes are taught in community colleges. Maybe you could take a couple with tuition reimbursement from your employer.

You may find Crystal Reports training at a community college, or online.

Promises promises...
 
you should be using a database....ms access or whatever

but you could make a macro in excel to do what you are currently doing by hand....try the record macro function and go from there
 
Thanks for the macro thing and I'm familiar with Crystal Reports.

Sorry for the incoherence, but I was trying to get help, the macro thing seems that will work fine, thank you very much.
 
"the macro thing" probably sounds appealing because it'd allow you to continue using Excel which you know, so that won't rattle your comfort zone.

but Excel is NOT the right tool for that job. Didn't you ever read Zap comics? Mr. Natural says, "Get the right tool for the job!"

the job you describe belongs on a relational database system. VBA macros will only make commands happen faster, but on Excel it'll still remain a big mess.

Good luck!
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top