Solved

Multiple Excel Spreadsheets Help

Posted on 2013-05-15
5
174 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 ]
Comment Utility
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:
anthonymellorfca earned 500 total points
Comment Utility
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
Comment Utility
Thanks
0
 
LVL 9

Expert Comment

by:anthonymellorfca
Comment Utility
pleasant surprise, thanks you.
0
 
LVL 35

Expert Comment

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

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now