• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

Multiple Excel Spreadsheets Help

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
tawathav
Asked:
tawathav
  • 2
  • 2
1 Solution
 
[ fanpages ]IT Services ConsultantCommented:
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
 
Anthony MellorChartered AccountantCommented:
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
 
tawathavAuthor Commented:
Thanks
0
 
Anthony MellorChartered AccountantCommented:
pleasant surprise, thanks you.
0
 
[ fanpages ]IT Services ConsultantCommented:
Yes, a month & a half later I had all but given up on a response to my query.
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now