Solved

Multiple Excel Spreadsheets Help

Posted on 2013-05-15
5
191 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 500 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
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 …
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

813 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

14 Experts available now in Live!

Get 1:1 Help Now