?
Solved

Multiple Excel Spreadsheets Help

Posted on 2013-05-15
5
Medium Priority
?
215 Views
Last Modified: 2013-07-02
Hello-

I have multiple Excel spreadsheets that all have similar data but not exactly the same. I am looking for a way to have the least amount of manual data entry.

All the Excel spreadsheets are filled out manually monthly by several leaders and takes a considerable amount of time. Most of the time the data is than used to create PowerPoints. Also, some of the spreadsheets track new initiatives and results so its not just numbers are all the time.

I am looking for a way to simplify these tasks. Any suggestions?
0
Comment
Question by:tawathav
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 39170411
Hi,

How similar is the recurring data?  Can some of it be derived or pre-calculated from previously entered data, from the first workbook/worksheet created, or based on the duties/position of the person entering the data?

Can the PowerPoint presentation file(s) creation be automated?  Can the Leaders perform this task, or is the data collated centrally & another person does this?

It is difficult to advise without knowing specific details of your operation.

BFN,

fp.
0
 
LVL 9

Accepted Solution

by:
Anthony Mellor earned 1500 total points
ID: 39170579
is the data mutually exclusive with regards to data in other sheets? i.e. nothing is entered more than once and differently? (If it is then union all ?).. or shared google docs.
0
 

Author Comment

by:tawathav
ID: 39294536
Thanks
0
 
LVL 9

Expert Comment

by:Anthony Mellor
ID: 39294962
pleasant surprise, thanks you.
0
 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 39294990
Yes, a month & a half later I had all but given up on a response to my query.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question