Improve company productivity with a Business Account.Sign Up

x
?
Solved

Multiple Excel Spreadsheets Help

Posted on 2013-05-15
5
Medium Priority
?
226 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
  • 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

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

607 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